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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
upgrade.php from 2.6.7 to 3.0.0 - parse error [message #164946] Fri, 08 April 2011 02:40 Go to next message
juboy309 is currently offline  juboy309   United Kingdom
Messages: 17
Registered: May 2003
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
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 07:08 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3681
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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.
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 05:35 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3681
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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.
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 04:49 Go to previous messageGo to next message
juboy309 is currently offline  juboy309   United Kingdom
Messages: 17
Registered: May 2003
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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?

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 12:00 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3681
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Problem was resolved by removing the fud_sql_error_handler() function from the version 3.0.0 upgrade script.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Sat Oct 20 21:55:03 EDT 2018

Total time taken to generate the page: 0.00688 seconds