FUDforum: FUDforum Installation Issues

Home » FUDforum » FUDforum Installation Issues » Migration Problem

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

Re: Migration Problem [message #187583 is a reply to message #187582]

Fri, 14 September 2018 22:49

art

Messages: 35
Registered: June 2009

Karma:

Member

This time, I got past the point where the v.3.0.9 upgrade script was creating the composite primary key on fud28_index(word_id,msg_id). So I think my assumption that fud28_index had duplicates was probably the sticking point there. That plus the fact that I've seen them.

But this time the 3.0.9 upgrade script broke on line 1036:

Fatal error: Call to undefined function q_limit() in ./forum/upgrade.php on line 1036

I've seen that code in the FUDforum cross-reference so I'm adding the q_limit() function (shown below) at the top of the 3.0.9 upgrade script. I expect the function was introduced in an earlier version of the code between 3.0.0 and 3.0.9, and I've skipped it. I'll take the chance that's all I'm missing, and I'm adding the function to the upgrade script.

function q_limit($query, $limit, $off=0)
{
	if ($off) {
		return $query .' LIMIT '. $off .','. $limit;
	} else {
		return $query .' LIMIT '. $limit;
	}
}

So I'm back to the starting point:

1. Drop all tables in the migration-sandbox database.
2. Import the archived SQL dump of the v.2.8 database.
3. Delete all the forum files and subdirectories.
4. Install the v.2.8 flat files from the backup tarball.
5. Copy the modified GLOBALS.php file in place (with db/user for the sandbox database).
6. Delete the fud28_index, fud28_title_index, fud28_search and fud28_search_cache tables.
7. Run the consistency check.
8. Run the v.3.0.0 upgrade script.
9. Chmod 0755 ./forum/adm and run the consistency check.
10. Run the modified v.3.0.9 upgrade script (with q_limit function added).
11. If it works, run the consistency check.
12. Create a v.3.0.9 theme with the same look-and-feel as my v.2.8.0 forum.

We'll see how it goes...

[Updated on: Fri, 14 September 2018 23:21]

Report message to a moderator

[Message index]

		Migration Problem By: art on Mon, 10 September 2018 17:13
		Re: Migration Problem By: naudefj on Mon, 10 September 2018 20:03
		Re: Migration Problem By: art on Mon, 10 September 2018 20:59
		Re: Migration Problem By: art on Tue, 11 September 2018 22:37
		Re: Migration Problem By: art on Thu, 13 September 2018 15:34
		Re: Migration Problem By: art on Thu, 13 September 2018 21:18
		Re: Migration Problem By: art on Thu, 13 September 2018 22:51
		Re: Migration Problem By: art on Thu, 13 September 2018 22:57
		Re: Migration Problem By: art on Fri, 14 September 2018 00:28
		Re: Migration Problem By: art on Fri, 14 September 2018 15:42
		Re: Migration Problem By: art on Fri, 14 September 2018 19:40
		Re: Migration Problem By: art on Fri, 14 September 2018 20:30
		Re: Migration Problem By: art on Fri, 14 September 2018 22:49
		Re: Migration Problem By: GaryM on Fri, 14 September 2018 23:45
		Re: Migration Problem By: art on Fri, 14 September 2018 23:47
		Re: Migration Problem By: art on Sat, 15 September 2018 16:53
		Re: Migration Problem By: naudefj on Sat, 15 September 2018 17:34
		Re: Migration Problem By: art on Sun, 16 September 2018 00:14
		Re: Migration Problem By: GaryM on Mon, 17 September 2018 23:32

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

]

Current Time: Wed Dec 18 04:48:12 GMT 2024

Total time taken to generate the page: 0.04308 seconds