Forums / Cotonti / Support / Updating error(sql error)

fedai
#1 2009-10-20 16:13
0.0.3 to 0.6.4 updating error message:
Fatal error : SQL error : 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 'i' at line 5

Help please
"peace in the homeland, peace in the world" K.ATATÜRK

personal blog:
http://www.sametbal.net
SunChase
#2 2009-10-20 19:35
have you done all of the changes(sql update,config.php and ect) ?
[url=http://ka13.orgfree.com]KA13[/url] - The essence of creativity
Kilandor
#3 2009-10-21 07:58
Go into config.php find define('SED_DEBUG', FALSE); and set it to define('SED_DEBUG', TRUE);

Then Return to the page where you got the error, and copy back what it reports.
fedai
#4 2009-10-21 15:27
#0  sed_diefatal(SQL error : 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 'i' at line 5) called at [D:\AppServ\www\tsnet\system\database.mysql.php:219]
#1  sed_sql_query(SELECT p.*, u.user_name, user_avatar FROM sed_pages AS p
    LEFT JOIN sed_users AS u ON u.user_id=p.page_ownerid
    WHERE page_state=0 AND page_cat NOT LIKE 'system'
    AND	page_begin<'1256110768' AND page_expire>'1256110768'
    AND page_cat IN ('v') ORDER BY page_  LIMIT 0, i) called at [D:\AppServ\www\tsnet\plugins\news\inc\news.functions.php:37]
#2  sed_get_news(v, news.v, INDEX_NEWS_V, i, 0) called at [D:\AppServ\www\tsnet\plugins\news\news.php:69]
#3  include_once(D:\AppServ\www\tsnet\plugins\news\news.php) called at [D:\AppServ\www\tsnet\system\core\index\index.inc.php:44]
#4  require_once(D:\AppServ\www\tsnet\system\core\index\index.inc.php) called at [D:\AppServ\www\tsnet\index.php:20]
"peace in the homeland, peace in the world" K.ATATÜRK

personal blog:
http://www.sametbal.net
Kilandor
#5 2009-10-21 16:56
In your news configuration, what do you have for "News category codes"