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

Home » FUDforum » FUDforum Installation Issues » Migration Problem
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Migration Problem [message #187576 is a reply to message #187575] Thu, 13 September 2018 21:18 Go to previous messageGo to previous message
art is currently offline  art   
Messages: 35
Registered: June 2009
Karma:
Member

I've created an exact copy of the limping v.2.8.0 forum on another domain. I've copied the MySQL database and I've copied all the FUDforum flat files.

My thought is to debug the v.3.0.0 upgrade script until it flies.

What got me stuck earlier was this error:

ERROR: 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 '60's' LIMIT 1' at line 1
QUERY: DELETE FROM fud28_search WHERE word=''60's' LIMIT 1

I imagine fud28_search probably has apostrophes in it. So I'm going to modify this section of the upgrade.php script:
	while ($r = db_rowarr($c)) {
				$con = '';
				foreach ($f as $k => $v) {
					$con .= "{$v}='{$r[$k]}' AND ";
				}
				$con = substr($con, 0, -4);
				q("DELETE FROM {$tbl} WHERE {$con} LIMIT ".($r[$n] - 1));
			}

I have backups of both the database and the flat files, so I can reload and re-run the script, fixing things as I find them.

[Updated on: Thu, 13 September 2018 21:19]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: upgrade from 3.07 to 3.09 fails
Next Topic: Failing to change forum to RTL
Goto Forum:
  

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

Current Time: Thu Nov 21 21:34:02 GMT 2024

Total time taken to generate the page: 0.06189 seconds