XantaraFlux looking for wrong item_db2

[sietse11]

Hey folks,

 

I need some help.

I am trying to test the paypal sandbox.

But when I go to the itemshop I get the following error.

 

Message: Failed to import/replace rows from table 'ragnarok.item_db2'

 

now this table is called item_db2_re

 

I tried to fix it like this,

modules/itemshop/add.php

($server->isRenewal) {
	$fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
} //else {
	//$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
}

I removed the if statement and secured the else statement for future reference.

Saved

Reloaded the page same error.

-------------------------------------------------------------

fixed by doing this

Modules/itemshop/add.php

if ($server->isRenewal) {
	$fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
}       else {
	$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
}

added the _re behind "{$server->charMapDatabase}.item_db2_re")

 

and 

 

lib/flux/itemshop.php

if($this->server->isRenewal) {
			$fromTables = array("$db.item_db_re", "$db.item_db2");
		} else {
			$fromTables = array("$db.item_db", "$db.item_db2");
		}

TO

if($this->server->isRenewal) {
			$fromTables = array("$db.item_db_re", "$db.item_db2_re");
		} else {
			$fromTables = array("$db.item_db", "$db.item_db2");
		}

Edited January 15, 2014 by sietse11