PDA

View Full Version : Database error


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

MrZeropage
01-23-2007, 10:29 AM
are you sure your /arcade.php is the one from ibProArcade ?

Fawlty Adder
01-23-2007, 11:13 AM
hmm ...apparently not.. must have been the old one :o

the arcade link works now but there are currently no games there

there were a few games that came as part of the download...how do I show them as part of the arcade and also under games listing in admincp?

:)

MrZeropage
01-26-2007, 10:16 AM
I've reimported the ibproarcade xml file and tried again but still get a database error ...the problem is that after the converter did its work you re-imported the product again...

does any game show up in admincp -> games list ?