Hallo Welt,
mein Webhosting Provider hat mich zum Umzug einer Webseite "gezwungen".
Im neuen Webhosting bekomme ich für meine Joomla 1.5.26 Seite im Debugging-Modus den Fehler 500, Query 1064 angezeigt.
Erwähnenswert ist dabei, dass im neuen Webhosting "nur" PHP 5.6 als Minimalversion einzustellen war.
Wie kann ich das weiter Debuggen?
Danke für Eure Hilfe.
Code
JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups, u.email as author_email, cc.title AS category, s.title AS section, s.ord' at line 1 SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email as author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count FROM meike_content AS a INNER JOIN meike_content_frontpage AS f ON f.content_id = a.id LEFT JOIN meike_categories AS cc ON cc.id = a.catid LEFT JOIN meike_sections AS s ON s.id = a.sectionid LEFT JOIN meike_users AS u ON u.id = a.created_by LEFT JOIN meike_groups AS g ON a.access = g.id LEFT JOIN meike_content_rating AS v ON a.id = v.content_id WHERE 1 AND a.access <= 0 AND a.state = 1 AND (( cc.published = 1 AND s.published = 1 ) OR ( a.catid = 0 AND a.sectionid = 0 ) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-13 09:26:38' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-13 09:26:38' ) ORDER BY a.created DESC LIMIT 0, 8| Call stack | ||
| # | Function | Location |
| 1 | JSite->dispatch() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/index.php:68 |
| 2 | JComponentHelper->renderComponent() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/includes/application.php:124 |
| 3 | require_once() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/application/component/helper.php:162 |
| 4 | JController->execute() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/components/com_content/content.php:35 |
| 5 | ContentController->display() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/application/component/controller.php:236 |
| 6 | JController->display() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/components/com_content/controller.php:55 |
| 7 | JCacheView->get() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/application/component/controller.php:308 |
| 8 | ContentViewFrontpage->display() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/cache/handler/view.php:98 |
| 9 | JView->get() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/components/com_content/views/frontpage/view.html.php:60 |
| 10 | ContentModelFrontpage->getData() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/application/component/view.php:364 |
| 11 | ContentModelFrontpage->_loadData() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/components/com_content/models/frontpage.php:53 |
| 12 | JModel->_getList() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/components/com_content/models/frontpage.php:99 |
| 13 | JDatabaseMySQLi->loadObjectList() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/application/component/model.php:284 |
| 14 | JDatabaseMySQLi->query() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/database/database/mysqli.php:474 |
| 15 | JError->raiseError() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/database/database/mysqli.php:247 |
| 16 | JError->raise() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/error/error.php:171 |
| 17 | JException->__construct() | /var/www/vhosts/hosting197256.ae91b.netcup.net/meikekrebs.de/httpdocs/libraries/joomla/error/error.php:136 |
