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

Home » FUDforum » FUDforum Installation Issues » Moving Forum between hosts
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
Moving Forum between hosts [message #26131] Tue, 05 July 2005 23:06 Go to next message
hari is currently offline  hari   United States
Messages: 23
Registered: November 2003
Location: Los Angeles, California, ...
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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?
Re: Moving Forum between hosts [message #26132 is a reply to message #26131] Wed, 06 July 2005 00:14 Go to previous messageGo to next message
hari is currently offline  hari   United States
Messages: 23
Registered: November 2003
Location: Los Angeles, California, ...
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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.
Re: Moving Forum between hosts [message #26142 is a reply to message #26132] Wed, 06 July 2005 09:18 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Have you tried accessing the admin control panel and running the consistency checker?

FUDforum Core Developer
Re: Moving Forum between hosts [message #26150 is a reply to message #26142] Wed, 06 July 2005 14:02 Go to previous messageGo to next message
hari is currently offline  hari   United States
Messages: 23
Registered: November 2003
Location: Los Angeles, California, ...
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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.
Re: Moving Forum between hosts [message #26162 is a reply to message #26150] Wed, 06 July 2005 16:20 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Could be a bug with dump/import process, as of 2.6.14 that code has been completely rewritten and simplified.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Thu Oct 19 03:32:19 EDT 2017

Total time taken to generate the page: 0.00708 seconds