FUDforum: FUDforum Installation Issues » upgrade.php from 2.6.7 to 3.0.0

Home » FUDforum » FUDforum Installation Issues » upgrade.php from 2.6.7 to 3.0.0 - parse error

Show: Today's Messages :: Polls :: Message Navigator

upgrade.php from 2.6.7 to 3.0.0 - parse error [message #164946]

Fri, 08 April 2011 06:40

juboy309

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

Report message to a moderator

[Message index]

		upgrade.php from 2.6.7 to 3.0.0 - parse error By: juboy309 on Fri, 08 April 2011 06:40
		Re: upgrade.php from 2.6.7 to 3.0.0 - parse error By: naudefj on Fri, 08 April 2011 11:08
		Re: upgrade.php from 2.6.7 to 3.0.0 - parse error By: naudefj on Mon, 11 April 2011 09:35
		Re: upgrade.php from 2.6.7 to 3.0.0 - parse error By: juboy309 on Mon, 18 April 2011 08:49
		Re: upgrade.php from 2.6.7 to 3.0.0 - parse error By: naudefj on Tue, 19 April 2011 16:00

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) ] [

]

Current Time: Wed Jun 26 02:13:54 GMT 2024

Total time taken to generate the page: 0.06342 seconds