3.1 MySQL Error(FIXED)

[WB]

We are getting some intermittent MySQL errors on our site (the site is set to email errors to the admin email address).

The error is in the form of:

__

An error was encountered during execution of the query:

REPLACE INTO laston VALUES(X,XX,XXXXXXXX)

The query returned with an errorcode of:

Table 'dbname.laston' doesn't exist

__


It appears that the query isn't taking into account the db prefix, since we have a prefix_laston table, which I think is the one the values need to get inserted into.

Looking at index.php, there is:

ppmysql_query("REPLACE INTO {$Globals['pp_db_prefix']}laston VALUES($cat,{$User['userid']},$lasttimeon)", $link);

Looking at the other queries in it, the variable used is:

rp_db_prefix rather than pp_db_prefix

so I suspect that may be the cause of the error.

Can you confirm if that is the case and it needs to be updated to rp from pp?

If not, where might the error come from?

Thanks.

[Chuck S]

Indeed this is correct it should read rp_db_prefix

if ( $User['userid'] > 0 && $Globals['displaynew'] == "yes" ) {
ppmysql_query("REPLACE INTO {$Globals['rp_db_prefix']}laston VALUES($cat,{$User['userid']},$lasttimeon)", $link);
}

[WB]

Thanks.