[Issues with Purchase page - Flux CP]

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.

[Hackshield or Harmony ?]

Well, you can use HackShield as a free alternative. They're basically the same in terms of security. Harmony is just somewhat more flexible because you can edit its settings (like bypassing security measures for selected accounts etc.) unlike HackShield.

Is HackShield free? Where can I download it?