FUDforum: FUDforum Installation Issues » problems after migration

Home » FUDforum » FUDforum Installation Issues » problems after migration

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

problems after migration [message #39652]

Thu, 15 November 2007 17:57

andy_scouser

Messages: 76
Registered: June 2003

Karma:

Member

Hello chaps,

Probably a bone question but, I need to move my forum to another server soon so I have been doing some testing.

I installed 2.7.7 (non zl) on the new server (zl) in 'live'
mysql 4.0.13max on old 4.0.24-log on new. (vanilla solaris 10 x86)
temporarily set local host files to lie about hostname, to match production.
Installed forum and all was well, showing temp forum etc.

Then i imported data from 'live' and after import it complained of admin user not matching on new build. I did install the forum using the same account as last time with the same passowrd.

i have checked account on old and new and the encrypted password looks fine.
The cookie i am getting form the new build looks fine
Nothing in the FUDforum errors section of the new install either apart from when i try and hit the front page....i get

?616 ?1195149083?(/var/apache2/honda_htdocs/index.php:75 
/var/apache2/honda_htdocs/index.php:314 
/var/apache2/honda_htdocs/theme/default/index.php:41 
/var/apache2/honda_htdocs/index.php:1198 
) 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 '' at line 1 
Query: UPDATE honda_ses SET sys_id='81db1c15aa19e7f670ec5e5334b4c7be', forum_id=0, time_sec=1195149083, action='Browsing the <a h
ref=\"index.php?t=index\">forum list</a>', returnto='' WHERE id= 
Server Version: 4.0.24-log 

I can't log in to run the consistancy checker.

Can you please let me know i can look next?

Thanks all.

Report message to a moderator

[Message index]

		problems after migration By: andy_scouser on Thu, 15 November 2007 17:57
		Re: problems after migration By: andy_scouser on Thu, 15 November 2007 18:05
		Re: problems after migration By: Ilia on Thu, 15 November 2007 19:09
		Re: problems after migration By: andy_scouser on Thu, 15 November 2007 19:36
		Re: problems after migration By: andy_scouser on Fri, 16 November 2007 11:52
		Re: problems after migration By: andy_scouser on Sat, 17 November 2007 02:23

Previous Topic:	Fudforum doesnt work in EGW
Next Topic:	Admin log in problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 23:23:55 GMT 2024

Total time taken to generate the page: 0.06641 seconds