FUDforum: FUDforum Installation Issues » Moving Forum between hosts

Home » FUDforum » FUDforum Installation Issues » Moving Forum between hosts

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

Moving Forum between hosts [message #26131]

Wed, 06 July 2005 03:06

hari

Messages: 23
Registered: November 2003
Location: Los Angeles, California, ...

Karma: 0

Junior Member

I am trying to move the hosting website for my forum, and the username is different.

The old site was running FUDforum 2.6.11. I made a forum datadump, and did a mysqldump of the database too.

I did a fresh install of FUDforum 2.6.13 on the new host, which seemed to go fine. The database name is different than the old database name. (Each host appends the username in front of the database name.)

I then imported the forum datadump into the new installation. It took a few minutes, but this also seemed to succeed. The import screen ended, saying 140000 queries executed. I don't know what this number should be.

When I then tried the "return to forum" link, I got

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log

Running the sql error log through base64_decode(), I get this:

/home/naaluket/public_html/FUDforum2/index.php:1178
) 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 fud26_ses SET sys_id='845888033658ead0f863cdf2c2ffc505', forum_id=0, time_sec=1120616810, action='Browsing the <a href=\"index.php?t=index\">forum list</a>', returnto='S=6aa6ddc0905ae62f6ee165393f3243d7&SQ=e5b152a0f8667f08de9d39c22c1ebf71' WHERE id=
_GET: S=6aa6ddc0905ae62f6ee165393f3243d7&SQ=e5b152a0f8667f08de9d39c22c1ebf71&
Server Version: 4.0.24-standard

The old site was also running mySQL 4.0.24

Does anyone know what might be wrong?

Is there any more information I can provide?

Report message to a moderator

Re: Moving Forum between hosts [message #26132 is a reply to message #26131]

Wed, 06 July 2005 04:14

hari

Messages: 23
Registered: November 2003
Location: Los Angeles, California, ...

Karma: 0

Junior Member

Sorry, I did get it to work. I did a search on "moving the forum". Embarassed

I tried installing 2.6.11 and importing the datadump, but I still get a mySQL error.

I then removed the database, and used the mysql dump to populate it. I copied the FUDforum directories from the old server and edited the GLOBALS.php file to reflect the new host.

Report message to a moderator

Re: Moving Forum between hosts [message #26142 is a reply to message #26132]

Wed, 06 July 2005 13:18

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Have you tried accessing the admin control panel and running the consistency checker?

FUDforum Core Developer

Report message to a moderator

Re: Moving Forum between hosts [message #26150 is a reply to message #26142]

Wed, 06 July 2005 18:02

hari

Messages: 23
Registered: November 2003
Location: Los Angeles, California, ...

Karma: 0

Junior Member

After importing the datadump, I could not access the control panel due to the SQL error.

The other route of importing the mySQL dump, copying the files, and updating GLOBALS.php seems to have worked.

Report message to a moderator

Re: Moving Forum between hosts [message #26162 is a reply to message #26150]

Wed, 06 July 2005 20:20

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Could be a bug with dump/import process, as of 2.6.14 that code has been completely rewritten and simplified.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Upgrade from version 2.3.4
Next Topic:	i can't install the forum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 05:20:26 GMT 2024

Total time taken to generate the page: 0.02421 seconds