2010-03-26, 12:29 AM
Hi. Ive been trying to switch my friend's forum over to anew MyBB forum, however Ive been running into quite a few errors in trying to use the Merge utility.
He is currently running a SMF 1.1.11 script, which seems to be supported. However, Ive been running into a serious block. After getting to the Usergroups Module, I hit run and got an SQL error telling me a certain field did not exist(minPost in smf_membergroups). I went to that table in phpMyAdmin and found the field did exist, it was just called min_post instead. So, hoping I could get away with it, I removed the "_" and trying running the module again. It worked and went to the Module page. I checked the settings and had it proceed. However, on the page with the progress bar, it again ran into a SQL problem, and couldn't find "addDeny" in "smf_permissions" I checked out smf_permissions and same problem, the field was actually called "add_deny". So, again, I tried changing it. It got rid of the SQL error so I tried again. However, on the same page, I'm not getting this error:
Looking in that table, there appears to be no "ID_BOARD" field at all. So, I dont want to add one and keep going, and seriously hope I wont have to be making SQL modifications during the whole process.
In short, the Merger system keeps hitting SQL errors because fields either have slightly different names or don't exist, even though the script its converting from is supposedly supported.
SMF Forums:
http://www.irongaming.net/
MyBB Forums:
http://www.irongaming.net/forums/
He is currently running a SMF 1.1.11 script, which seems to be supported. However, Ive been running into a serious block. After getting to the Usergroups Module, I hit run and got an SQL error telling me a certain field did not exist(minPost in smf_membergroups). I went to that table in phpMyAdmin and found the field did exist, it was just called min_post instead. So, hoping I could get away with it, I removed the "_" and trying running the module again. It worked and went to the Module page. I checked the settings and had it proceed. However, on the page with the progress bar, it again ran into a SQL problem, and couldn't find "addDeny" in "smf_permissions" I checked out smf_permissions and same problem, the field was actually called "add_deny". So, again, I tried changing it. It got rid of the SQL error so I tried again. However, on the same page, I'm not getting this error:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'ID_BOARD' in 'where clause'
Query:
SELECT ID_GROUP, permission FROM smf_board_permissions WHERE addDeny = 1 AND ID_BOARD = 0
Looking in that table, there appears to be no "ID_BOARD" field at all. So, I dont want to add one and keep going, and seriously hope I wont have to be making SQL modifications during the whole process.
In short, the Merger system keeps hitting SQL errors because fields either have slightly different names or don't exist, even though the script its converting from is supposedly supported.
SMF Forums:
http://www.irongaming.net/
MyBB Forums:
http://www.irongaming.net/forums/