Fawlty Adder
01-23-2007, 08:52 AM
Hi
I've recently tried converting my v3arcade 1.07 to ibproarcade ..
I followed the instructions to the letter .. i.e. I first installed ibproarcade , edited whatever templates needed editing
I then ran the converter.php hack .. .it seemed to work fine (i.e. no error reported) ..
I then ran it again to remove v3arcade and followed all the instructions
I also removed v3arcade references from my navbar and postbit/postbit legacy templates.
tried to access my new arcade for the firs time and got a database error...
I've reimported the ibproarcade xml file and tried again but still get a database error ...
any ideas?
thanks!
this is the database error:
Database error in vBulletin 3.6.4: Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_arcade AS phrasegroup_arcade, language.phrasegroup_global AS phrasegroup_global, language.options AS lang_options, language.languagecode AS lang_code, language.charset AS lang_charset, language.locale AS lang_locale, language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.registereddateoverride AS lang_registereddateoverride, language.calformat1override AS lang_calformat1override, language.calformat2override AS lang_calformat2override, language.logdateoverride AS lang_logdateoverride, language.decimalsep AS lang_decimalsep, language.thousandsep AS lang_thousandsep FROM user AS user LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) WHERE user.userid = 1; MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'Error Number : 1054Date : Tuesday, January 23rd 2007 @ 04:55:56 AMScript : http://theaccountancyforums.com/forums/arcade.php?Referrer : http://theaccountancyforums.com/forums/index.php
I've recently tried converting my v3arcade 1.07 to ibproarcade ..
I followed the instructions to the letter .. i.e. I first installed ibproarcade , edited whatever templates needed editing
I then ran the converter.php hack .. .it seemed to work fine (i.e. no error reported) ..
I then ran it again to remove v3arcade and followed all the instructions
I also removed v3arcade references from my navbar and postbit/postbit legacy templates.
tried to access my new arcade for the firs time and got a database error...
I've reimported the ibproarcade xml file and tried again but still get a database error ...
any ideas?
thanks!
this is the database error:
Database error in vBulletin 3.6.4: Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_arcade AS phrasegroup_arcade, language.phrasegroup_global AS phrasegroup_global, language.options AS lang_options, language.languagecode AS lang_code, language.charset AS lang_charset, language.locale AS lang_locale, language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.registereddateoverride AS lang_registereddateoverride, language.calformat1override AS lang_calformat1override, language.calformat2override AS lang_calformat2override, language.logdateoverride AS lang_logdateoverride, language.decimalsep AS lang_decimalsep, language.thousandsep AS lang_thousandsep FROM user AS user LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) WHERE user.userid = 1; MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'Error Number : 1054Date : Tuesday, January 23rd 2007 @ 04:55:56 AMScript : http://theaccountancyforums.com/forums/arcade.php?Referrer : http://theaccountancyforums.com/forums/index.php