Hi There,
I have just installed the latest version of Joomla: Joomla_1.5.15-Stable-Full_Package
The problem I have faced is:
In the Front Page Manager when I click on one of the items listed there.. let's say 'Joomla! Community Portal' to edit it then the following SQL error is dropped by the MySQL when I want to save the changes or want to close this article:
500 - An error has occurred!
DB function failed with error number 1028
Sort aborted SQL=SELECT c.*, g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c LEFT JOIN jos_categories AS cc ON cc.id = c.catid LEFT JOIN jos_sections AS s ON s.id = c.sectionid LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state != -2 ORDER BY section_name , section_name, cc.title, c.ordering LIMIT 0, 20
What i found in this query is that after the ORDER by the 'section_name' is used twice.
Then I have ran the query above in a standalone SQL editor againist the same MySQL database -which is used by the Joomla- and the same error has occured. But when I removed either 'section_name' from the query the SQL ran without any problems.
I Did a quick search under the Joomla folder on the webserver to see which module is responsible for putting the query together and found that controller.php might be the one.
Does anybody else have any similar problems with it?
Thanks
Regards
Attila
Discuss: Joomla 1.5.15 Released
-
- Joomla! Fledgling
- Posts: 1
- Joined: Fri Dec 04, 2009 7:49 pm
-
- Joomla! Enthusiast
- Posts: 214
- Joined: Mon Nov 19, 2007 10:33 pm
Re: Discuss: Joomla 1.5.15 Released
I plan to add also a sitemap soon...Can you please tell me witch one you use ? Xmap ? Joomap ? Other ?Lever wrote:The .htaccess update, to block direct access to XML files, is quite brutal because I've noticed it stops Google from spidering my XML sitemaps.
Does anybody know how to write an exception for the "fix" to allow access to specified filenames e.g. sitemap.xml, news-sitemap.xml etc?
The bad point with a specific htaccess exception added for any addons who need direct xml access that he can be removed by addon update process... So each time update are made is necessary to check this point for be sure htaccess are not removed or altered...Another solution for who have shell access to their host is to apply "chattr" command to the xml file for render the file immutable... See here for more info...
http://en.wikipedia.org/wiki/Chattr
Here an example of command I use for make immutable some files on my server:
chattr +ai /home/username/public_html/path/to/addons/my_xml_file.xml (command for enable)
chattr -ai /home/username/public_html/path/to/addons/my_xml_file.xml (command for disable)
If no shell access are available you can probably ask your provider to do that for you...
-
- Joomla! Enthusiast
- Posts: 159
- Joined: Thu Sep 15, 2005 1:15 am
Re: Discuss: Joomla 1.5.15 Released
Use Xmap - it does not create XML files, it renders XML on demand (see example url bellow).
XML can be rendered by any dynamic script, the same way as Joomla creates html pages. Recent .htaccess changes block only direct access to XML filetype, not to XML pages rendered by scripts like Xmap.
You don't need sitemap.xml - to make Google aware of your dynamic sitemap, submit it via Google webmasters tools, for all robots (including Google) put it in robots.txt like this:
Sitemap: http://www.yoursite.com/index.php?optio ... 1&view=xml
XML can be rendered by any dynamic script, the same way as Joomla creates html pages. Recent .htaccess changes block only direct access to XML filetype, not to XML pages rendered by scripts like Xmap.
You don't need sitemap.xml - to make Google aware of your dynamic sitemap, submit it via Google webmasters tools, for all robots (including Google) put it in robots.txt like this:
Sitemap: http://www.yoursite.com/index.php?optio ... 1&view=xml
Wanna know something Joomla? Hit the Joogpot! http://joogpot.eu
The LanternFish - translations manager for Joomla http://joogpot.eu/lanternfish
The LanternFish - translations manager for Joomla http://joogpot.eu/lanternfish
-
- Joomla! Apprentice
- Posts: 37
- Joined: Tue May 27, 2008 12:32 am
Re: Discuss: Joomla 1.5.15 Released
I replaced my 1.5.15 caption.js file with an older 1.5.10 caption.js file and captions wrap properly.frodo2021 wrote:So far, I've seen where the error comes up in the gallery in the new update from 1.5.14 to 1.5.15. In the folder media / system / js / caption.js. To leave the man on the 1.5.14 version works perfectly.
greetings
Kind of jerry rigged.
- infograf768
- Joomla! Master
- Posts: 19133
- Joined: Fri Aug 12, 2005 3:47 pm
- Location: **Translation Matters**
Joomla 1.5.15 Released-caption.js issues
Concerning caption.js issues, please seePCPablo wrote:I replaced my 1.5.15 caption.js file with an older 1.5.10 caption.js file and captions wrap properly.frodo2021 wrote:So far, I've seen where the error comes up in the gallery in the new update from 1.5.14 to 1.5.15. In the folder media / system / js / caption.js. To leave the man on the 1.5.14 version works perfectly.
greetings
Kind of jerry rigged.
http://joomlacode.org/gf/project/joomla ... m_id=19405
Jean-Marie Simonet / infograf
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group
- Mandrex
- Joomla! Apprentice
- Posts: 6
- Joined: Sun Nov 02, 2008 10:04 pm
- Contact:
Re: Discuss: Joomla 1.5.15 Released
HI pe7er
How to new release version ?
since nov 2009 today apr not new version.
How to new release version ?
since nov 2009 today apr not new version.
Mandrex ¡¡
- mandville
- Joomla! Master
- Posts: 15153
- Joined: Mon Mar 20, 2006 1:56 am
- Location: The Girly Side of Joomla in Sussex
Re: Discuss: Joomla 1.5.15 Released
if i may answer that one, a new version will be released when it is needed.Mandrex wrote:HI pe7er
How to new release version ?
since nov 2009 today apr not new version.
HU2HY- Poor questions = Poor answer
Un requested Help PM's will be reported, added to the foe list and possibly just deleted
{VEL Team Leader}{TM Auditor }{ Showcase & Security forums Moderator}
Un requested Help PM's will be reported, added to the foe list and possibly just deleted
{VEL Team Leader}{TM Auditor }{ Showcase & Security forums Moderator}
- Mandrex
- Joomla! Apprentice
- Posts: 6
- Joined: Sun Nov 02, 2008 10:04 pm
- Contact:
Re: Discuss: Joomla 1.5.15 Released
dear mandville, thank you for your response, but, how we have new version?
Mandrex ¡¡