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

Home » FUDforum » FUDforum Installation Issues » upgrade.php from 2.6.7 to 3.0.0 - parse error
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
upgrade.php from 2.6.7 to 3.0.0 - parse error [message #164946] Fri, 08 April 2011 06:40 Go to previous message
juboy309 is currently offline  juboy309   United Kingdom
Messages: 17
Registered: May 2003
Karma:
Junior Member
Hi there, our host recently upgraded MySQL and our forum is no longer working correctly.

The host suggested upgrading FUD Forum itself. I've followed all the upgrade steps but when running upgrade.php the following error is returned:

Parse error: syntax error, unexpected $end in /usr/local/home/httpd/vhtdocs/conFUD/sql/mysql/db.inc on line 243

Any idea how I can fix this so that the upgrade runs please?

Also, for information, the existing error message on the forum itself is whenever you try and read a post when logged in:

(/usr/local/home/httpd/vhtdocs/convergent/forum/index.php:117
/usr/local/home/httpd/vhtdocs/convergent/forum/theme/default/thread.php:481
/usr/local/home/httpd/vhtdocs/convergent/forum/theme/default/thread.php:502
/usr/local/home/httpd/vhtdocs/convergent/forum/index.php:1144
) 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 'reads FROM fud26_fc_view v INNER JOIN fud26_forum f ON f.id=v.f INNER J' at line 1
Query: SELECT f.id, f.name, c.name, c.id, CASE WHEN 1098803539 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS reads FROM fud26_fc_view v INNER JOIN fud26_forum f ON f.id=v.f INNER JOIN fud26_cat c ON c.id=v.c LEFT JOIN fud26_msg m ON m.id=f.last_post_id LEFT JOIN fud26_forum_read fr ON fr.forum_id=f.id AND fr.user_id=3 ORDER BY v.id
Server Version: 5.0.20a-max
[Referring Page] http://www.convergent-av.co.uk/forum/


Thanks for any assistance Smile
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: update 2.7.7 > 3.0
Next Topic: Fatal error: Allowed memory size xxx admimport.php line 52
Goto Forum:
  

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

Current Time: Fri Nov 22 04:00:36 GMT 2024

Total time taken to generate the page: 0.05336 seconds