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: 0

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

Re: upgrade.php from 2.6.7 to 3.0.0 - parse error [message #164953 is a reply to message #164946]

Fri, 08 April 2011 11:08

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

juboy309 wrote:

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

What is your PHP version? FUDforum 3.0.0 required PHP 5.1 or higher. Do you see any obvious errors on line 243?

PS: E-mail me access details if you want me to login and check it out.

Report message to a moderator

Re: upgrade.php from 2.6.7 to 3.0.0 - parse error [message #164975 is a reply to message #164953]

Mon, 11 April 2011 09:35

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Looks like your db.inc is corrupt.

Please download a copy from
http://fudforum.svn.sourceforge.net/viewvc/fudforum/tags/fud2_6_7/install/f orum_data/sql/mysql/db.inc?revision=3040&content-type=text%2Fplain

...and replace your copy at
/usr/local/home/httpd/vhtdocs/conFUD/sql/mysql/db.inc

When done, rebuild your themes and reattempt the upgrade.

Report message to a moderator

Re: upgrade.php from 2.6.7 to 3.0.0 - parse error [message #165034 is a reply to message #164975]

Mon, 18 April 2011 08:49

juboy309

Messages: 17
Registered: May 2003

Karma: 0

Junior Member

Thanks for your help.

I downloaded db.inc, uploaded it as instructed and then ran the theme rebuild, Forum Consistency checker and the SQL optimizer.

Then tried to run the upgrade again and got the following error message:

Fatal error: Cannot redeclare fud_sql_error_handler() (previously declared in /usr/local/home/httpd/vhtdocs/convergent/forum/upgrade.php:472) in /usr/local/home/httpd/vhtdocs/conFUD/sql/mysql/db.inc on line 49

The forum's still down, unfortunately.

Any ideas what the latest problem might be?

Report message to a moderator

Re: upgrade.php from 2.6.7 to 3.0.0 - parse error [message #165043 is a reply to message #165034]

Tue, 19 April 2011 16:00

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Problem was resolved by removing the fud_sql_error_handler() function from the version 3.0.0 upgrade script.

Report message to a moderator

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 Nov 27 09:27:39 GMT 2024

Total time taken to generate the page: 0.03210 seconds