mysql error table doesn't exist !

[krg2k]

we installed the game system but we get a mysql error table not exist everything we do:

mySQL error: Table 'idob_forums.useridob_games_settings' doesn't exist

most likely its because of table prefix so how and where do we set the table prefix for the arcade system ?

our db name is idob_forums and our table prefix is idob_ ..

thanks

--------------- Added 1202866316 at 1202866316 ---------------

here is the exact error we get every time we click on arcade:

mySQL query error: SELECT arcade_access, p_require FROM useridob_usergroup WHERE usergroupid = 1

mySQL error: Table 'idob_forums.useridob_usergroup' doesn't exist
mySQL error code:
Date: Tuesday 12th 2008f February 2008 07:30:22 PM

--------------- Added 1202866795 at 1202866795 ---------------

looks like the "useridob_...." is messed up where is the word 'user' is coming before idob_usergroup ?

[MrZeropage]

Ok, you need some special fix it seems ;)

open /arcade/functions/dbclass.php

search forif(!strpos($the_query, "idea") || !strpos($the_query, "identity")) {and replace withif(!strpos($the_query, "idea") || !strpos($the_query, "identity") || !strpos($the_query,"idob")) {

Let me know if this helps :)'

[krg2k]

that didn't do any good .. !!!! and why are we stiping the word IDOB out ? from this line that the error is creating "idob_forums.useridob_usergroup" the only word that doesn't need to be there is the word 'user' because table idob_usergroup does exist !!!...

for example here is another error I get in the backend:
mySQL error: Table 'idob_forums.useridob_games_settings'

again the word 'user' is extra in that line.. cuz the table idob_games_settings, does exist

[krg2k]

well looks like there is no solution for this MOD's errors...
if we can't figure why the mod wont install right then we will have to pick the other arcade system... :(

[MrZeropage]

if you provide access to AdminCP+FTP I will fix this directly on your site.

Although I thought my last suggest would already make it work, but I can fix that "onsite"

[krg2k]

hey
sorry we can't give out access to our database company policy... but someone should be able to help us figure this out, it should be something very simple... its a fresh install "NEW" install of the arcade so the problem is right out of the box... !!

we installed v3acrade with out any problems if we can't fix this we'll just stay with that one

thanks

--------------- Added 1203366328 at 1203366328 ---------------

in the db_class.php do I need to set these settings or leave them as default Blank?

class db_driver {

var $obj = array ( "sql_database" => "" ,
"sql_user" => "root" ,
"sql_pass" => "" ,
"sql_host" => "localhost",
"sql_port" => "" ,
"persistent" => "0" ,
"sql_tbl_prefix" => "ibf_" ,
"cached_queries" => array(),
'debug' => 0,
);

var $query_id = "";
var $connection_id = "";
var $query_count = 0;
var $record_row = array();
var $return_die = 0;
var $error = "";
var $failed = 0;

[MrZeropage]

leave this settings blank, the data is included from config.php and converted.

I will try to give my testforum a tableprefix like your and check if the error comes up there, too...

[krg2k]

sounds good.. our table prefix is 'idob_'

thanks

[krg2k]

still no luck...

[MrZeropage]

please try this:

open /arcade/functions/dbclass.php

search for if ($this->obj['sql_tbl_prefix'] != "ibf_")
{
$the_query = preg_replace("/ibf_(\S+?)([\s\.,]|$)/", $this->obj['sql_tbl_prefix']."\\1\\2", $the_query);
}and remove this code.

then search for$the_query = str_replace(",id", ",userid", $the_query);and after this add if ($this->obj['sql_tbl_prefix'] != "ibf_")
{
$the_query = preg_replace("/ibf_(\S+?)([\s\.,]|$)/", $this->obj['sql_tbl_prefix']."\\1\\2", $the_query);
}

[krg2k]

thanks that fixed it

[MrZeropage]

fine, integrated this adaption in next v2.6.7+