| Moving Forum between hosts [message #26131] |
Wed, 06 July 2005 03:06  |
hari
Messages: 23
Registered: November 2003
Location: Los Angeles, California, ...
Karma:
|
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 gotFatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log
/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?
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]