FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » upgrade problems
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
upgrade problems [message #166337] Thu, 17 November 2011 11:24 Go to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
upgrade went well.. but now i get:


Fatal error: Uncaught exception 'Exception' with message '(/homepages/35/d196178364/htdocs/huntohio/index.php:116<br /> /homepages/35/d196178364/htdocs/huntohio/index.php:219<br /> /homepages/35/d196178364/htdocs/huntohio/theme/TEST/index.php:172<br /> /homepages/35/d196178364/htdocs/huntohio/index.php:1335<br /> ) 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 'WHERE sc.cache_age>1321539805' at line 1<br /> Query: SELECT sc.*,m.subject AS last_msg_subject, u.alias AS last_user_alias FROM fud26_stats_cache sc INNER JOIN fud26_users u ON u.id=sc.last_user_id LEFT JOIN fud26_msg m ON m.id= WHERE sc.cache_age&gt;1321539805<br /> Database version: 5.0.91-log<br /> ' in /homepages/35/d196178364/htdocs/huntfud/include/core.inc:256 Stack trace: #0 /homepages/35/d196178364/htdocs/huntohio/index.php(116): fud_sql_error_handler('SELECT sc.*,m.s...', 'You have an err...', 1064, '5.0.91-log') #1 /homepages/35/d196178364/htdocs/huntohio/index.php(219): q('SELECT sc.*,m.s...') #2 /homepages/35/d196178364/htdocs/huntohio/theme/TEST/index.php(172): db_sab('SELECT sc.*,m.s...') #3 /homepages/35/d196178364/htdocs/huntohio/index.php(1335): require('/homepages/35/d...') #4 {main} thrown in /homepages/35/d196178364/htdocs/huntfud/include/core.inc on line 256
Re: upgrade problems [message #166338 is a reply to message #166337] Sat, 19 November 2011 13:52 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
You need to run the consistency checker after the upgrade as per the on-screen instructions.
Re: upgrade problems [message #166459 is a reply to message #166338] Wed, 14 December 2011 23:36 Go to previous messageGo to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
i do, this is what I get after Smile
Re: upgrade problems [message #166460 is a reply to message #166459] Wed, 14 December 2011 23:51 Go to previous messageGo to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
just redid it...

index.php?t=getfile&id=6227&private=0

index.php?t=getfile&id=6228&private=0

index.php?t=getfile&id=6229&private=0
Re: upgrade problems [message #166461 is a reply to message #166460] Wed, 14 December 2011 23:52 Go to previous messageGo to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
when i click on click here, im returned with:


Fatal error: Uncaught exception 'Exception' with message '(/homepages/35/d196178364/htdocs/huntohio/index.php:116<br /> /homepages/35/d196178364/htdocs/huntohio/index.php:219<br /> /homepages/35/d196178364/htdocs/huntohio/theme/TEST/index.php:172<br /> /homepages/35/d196178364/htdocs/huntohio/index.php:1335<br /> ) 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 'WHERE sc.cache_age>1323917292' at line 1<br /> Query: SELECT sc.*,m.subject AS last_msg_subject, u.alias AS last_user_alias FROM fud26_stats_cache sc INNER JOIN fud26_users u ON u.id=sc.last_user_id LEFT JOIN fud26_msg m ON m.id= WHERE sc.cache_age&gt;1323917292<br /> _GET: array ( 'S' =&gt; '', )<br /> Database version: 5.0.91-log<br /> [Referring Page] http://www.huntohio.net/upgrade.php<br /> ' in /homepages/35/d196178364/htdocs/huntfud/include/core.inc:256 Stack trace: #0 /homepages/35/d196178364/htdocs/huntohio/index.php(116): fud_sql_error_handler('SELECT sc.*,m.s...', 'You have an err...', 1064, '5.0.91-log') #1 /homepages/35/d196178364/htdocs/huntohio/index.php(219): q('SELECT sc.*,m.s...') #2 /homepages/35/d196178364/htdocs/huntohio/theme/TEST/index.php(172): db_sab('SELECT sc.*,m.s...') #3 /homepages/35/d196178364/htdocs/huntohio/index.php(1335): require('/homepages/35/d...') #4 {main} thrown in /homepages/35/d196178364/htdocs/huntfud/include/core.inc on line 256
Re: upgrade problems [message #166481 is a reply to message #166461] Wed, 21 December 2011 09:18 Go to previous messageGo to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
anyone?
Re: upgrade problems [message #166486 is a reply to message #166481] Wed, 21 December 2011 22:37 Go to previous message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
switched to default theme, ran the upgrade and poof
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: SQL Error
Next Topic: Report of searches performed?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 13:47:01 GMT 2024

Total time taken to generate the page: 0.02575 seconds