Issues with Purchase page - Flux CP

[Elune Adore]

Critical Error

An error was encountered during the lifetime of the application.

This could be due to a variety of problems, such as a bug in the application.

However, normally it is caused by misconfiguration.

Exception Details

Error: Flux_Error

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

File: /home/avononli/public_html/lib/Flux/TemporaryTable.php:230

File	Line	Function/Method
/home/avononli/public_html/lib/Flux/TemporaryTable.php	81	Flux_TemporaryTable::raise()
/home/avononli/public_html/lib/Flux/ItemShop.php	176	Flux_TemporaryTable::__construct()
/home/avononli/public_html/modules/purchase/index.php	28	Flux_ItemShop::getItems()
/home/avononli/public_html/lib/Flux/Template.php	337	include()
/home/avononli/public_html/lib/Flux/Dispatcher.php	168	Flux_Template::render()
/home/avononli/public_html/index.php	176	Flux_Dispatcher::dispatch()
Exception Trace As String

#0 /home/avononli/public_html/lib/Flux/TemporaryTable.php(81): Flux_TemporaryTable::raise('Failed to impor...')
#1 /home/avononli/public_html/lib/Flux/ItemShop.php(176): Flux_TemporaryTable->__construct(Object(Flux_Connection), 'main.items', Array)
#2 /home/avononli/public_html/modules/purchase/index.php(28): Flux_ItemShop->getItems(Object(Flux_Paginator), NULL)
#3 /home/avononli/public_html/lib/Flux/Template.php(337): include('/home/avononli/...')
#4 /home/avononli/public_html/lib/Flux/Dispatcher.php(168): Flux_Template->render()
#5 /home/avononli/public_html/index.php(176): Flux_Dispatcher->dispatch(Array)
#6 {main}

I am getting this error while trying to open the "purchase" page on my new flux CP installation.

My Game server is hosted on a VPS while my CP is hosted from another domain name.

 

When I use "localhost" as the db server, it works but new accounts cannot be created old accounts cannot be accessed.

When I change it to the game server IP it stop working.

 

What do I need to change and where?

Please guide me with this step. I've tried all possible combinations

 

Thanks in advance,

Elune.

Edited February 18, 2016 by Elune Adore

[Akkarin]

Sounds like a permission issue. Ensure your SQL user has the correct permissions from the appropriate host.