Споймал новую ошибку.
MYSQL QUERY ERROR REPORT
- 14/11/2009 16:11:07
---------------------------------------
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 'MAX_DISPLAY_NEWSDESK_NEWS' at line 1
select p.newsdesk_id, pd.language_id, pd.newsdesk_article_name, pd.newsdesk_article_description, pd.newsdesk_image_text, pd.newsdesk_image_text_two, pd.newsdesk_image_text_three, pd.newsdesk_article_shorttext, pd.newsdesk_article_url, p.newsdesk_image, p.newsdesk_image_two, p.newsdesk_image_three, p.newsdesk_date_added, p.newsdesk_last_modified, pd.newsdesk_article_viewed, p.newsdesk_date_available, p.newsdesk_status from newsdesk p, newsdesk_description pd WHERE pd.newsdesk_id = p.newsdesk_id and pd.language_id = "1" and newsdesk_status = 1 and p.newsdesk_sticky = 1 ORDER BY newsdesk_date_added DESC LIMIT MAX_DISPLAY_NEWSDESK_NEWS
---------------------------------------
Server Name : .....
Remote Address: .......
Referer :
Requested : /
Trace Back : index.php:418(includearray(1) {; [0]=>; string(72) "includes/modules/newsdesk.php"; }; ) => includes/modules/newsdesk.php:13(tep_db_queryarray(1) {; [0]=>; &string(640) "select p.newsdesk_id, pd.language_id, pd.newsdesk_article_name, pd.newsdesk_article_description, pd.newsdesk_image_text, pd.newsdesk_image_text_two, pd.newsdesk_image_text_three, pd.newsdesk_article_shorttext, pd.newsdesk_article_url, p.newsdesk_image, p.newsdesk_image_two, p.newsdesk_image_three, p.newsdesk_date_added, p.newsdesk_last_modified, pd.newsdesk_article_viewed, p.newsdesk_date_available, p.newsdesk_status from newsdesk p, newsdesk_description pd WHERE pd.newsdesk_id = p.newsdesk_id and pd.language_id = "1" and newsdesk_status = 1 and p.newsdesk_sticky = 1 ORDER BY newsdesk_date_added DESC LIMIT MAX_DISPLAY_NEWSDESK_NEWS"; }; ) => includes/functions/database.php:101(tep_db_errorarray(3) {; [0]=>; &string(640) "select p.newsdesk_id, pd.language_id, pd.newsdesk_article_na
me, pd.newsdesk_article_description, pd.newsdesk_image_text, pd.newsdesk_image_text_two, pd.newsdesk_image_text_three, pd.newsdesk_article_shorttext, pd.newsdesk_article_url, p.newsdesk_image, p.newsdesk_image_two, p.newsdesk_image_three, p.newsdesk_date_added, p.newsdesk_last_modified, pd.newsdesk_article_viewed, p.newsdesk_date_available, p.newsdesk_status from newsdesk p, newsdesk_description pd WHERE pd.newsdesk_id = p.newsdesk_id and pd.language_id = "1" and newsdesk_status = 1 and p.newsdesk_sticky = 1 ORDER BY newsdesk_date_added DESC LIMIT MAX_DISPLAY_NEWSDESK_NEWS"; [1]=>; &int(1064); [2]=>; &string(171) "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 'MAX_DISPLAY_NEWSDESK_NEWS' at line 1"; }; )
При включении блока новости и переносе блока в правый бокс - вылетаем с ошибкой. На главной странице пишется - тех работы. И пока базу не откатим - не работает. Даже если убрать изменения из админки обратно. Хелп.