Tweet
Hey guys..
Kinda scared at the moment
.
We have already successfully imported one copy of phpbb onto our server, and tonight we were attempting to import a second one. The objective was to merge two old boards into a new one.
I uploaded the .sql dump of the second phpBB into its own database, and then that was set to go.
Then ran admincp and backed up my vB database (containing the first board, which was successfully transferred).. and then I went into the import tool and clicked the reset button at the top. Then I ran the first module.
I then realized that I needed to change the config settings for the impex file. I did that, uploaded it.
Then I went back into the admin.. went to the import.. clicked module one.. went to the NEXT page.. where it says check database.. then I click back.. and got an error:
There seems to have been a slight problem with the Youthcove.com Community database.
It then sent an email to the admin with the following error:
Invalid SQL:
SELECT * FROM cpsession
WHERE userid =
AND hash = '96e1fXXXXX4369c3de44971'
AND dateline > 1100224931
mysql error: 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 'AND hash = '96e1f1c4fXXXXXX69c3de44971'
AND dateline >
mysql error number: 1064
----------------------------
Help? Do we restore the database and try again? *takes a deep breath*.. this is scary =P.
-Jonathan
Kinda scared at the moment
.We have already successfully imported one copy of phpbb onto our server, and tonight we were attempting to import a second one. The objective was to merge two old boards into a new one.
I uploaded the .sql dump of the second phpBB into its own database, and then that was set to go.
Then ran admincp and backed up my vB database (containing the first board, which was successfully transferred).. and then I went into the import tool and clicked the reset button at the top. Then I ran the first module.
I then realized that I needed to change the config settings for the impex file. I did that, uploaded it.
Then I went back into the admin.. went to the import.. clicked module one.. went to the NEXT page.. where it says check database.. then I click back.. and got an error:
There seems to have been a slight problem with the Youthcove.com Community database.
It then sent an email to the admin with the following error:
Invalid SQL:
SELECT * FROM cpsession
WHERE userid =
AND hash = '96e1fXXXXX4369c3de44971'
AND dateline > 1100224931
mysql error: 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 'AND hash = '96e1f1c4fXXXXXX69c3de44971'
AND dateline >
mysql error number: 1064
----------------------------
Help? Do we restore the database and try again? *takes a deep breath*.. this is scary =P.
-Jonathan
.
Comment