2008-11-17, 01:25 PM
Merging a punbb.
First I used the 1.4 merge system. Everything went great until it got to taking the threads from the old forum, then I keep getting
'Inserting thread #1... Done'
and the page stops there. It doesnt redirect, it does nothing.
So I installed a mybb 1.2 forum & ran that merge system.
I get halfway through taking the threads from old forum & I get an error
'Inserting thread #281... MySQL error: 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 'Lo' LIMIT 1' at line 1
Query: SELECT id, username FROM users WHERE username = 'D'Lo' LIMIT 1
So I go into my database & delete table 281.
Then I get another error when moving threads
'Inserting thread #261... MySQL error: 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 'Lo' LIMIT 1' at line 1
Query: SELECT id, username FROM users WHERE username = 'D'Lo' LIMIT 1'
So, on a hunch I went into admin for the old forum & changed this users name to DLo instead of D'Lo and guess what? It worked
First I used the 1.4 merge system. Everything went great until it got to taking the threads from the old forum, then I keep getting
'Inserting thread #1... Done'
and the page stops there. It doesnt redirect, it does nothing.
So I installed a mybb 1.2 forum & ran that merge system.
I get halfway through taking the threads from old forum & I get an error
'Inserting thread #281... MySQL error: 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 'Lo' LIMIT 1' at line 1
Query: SELECT id, username FROM users WHERE username = 'D'Lo' LIMIT 1
So I go into my database & delete table 281.
Then I get another error when moving threads
'Inserting thread #261... MySQL error: 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 'Lo' LIMIT 1' at line 1
Query: SELECT id, username FROM users WHERE username = 'D'Lo' LIMIT 1'
So, on a hunch I went into admin for the old forum & changed this users name to DLo instead of D'Lo and guess what? It worked