Xantara's Flux not showing Item Database

[Hyvraine]

It doesn't show the items, although its info is stored on a variable. This happens on VPSs (3 of my clients so far have/are experiencing this).

 

I thought I've isolated the problem (it has something to do with the Item Shop) although I still haven't found a fix.

 

Can anyone help? Are there also people other than us who's experiencing this kind of problem?

 

Edit: I think I fucked up somewhere, I mean.. I obviously fucked something up.. any ideas?

Well it works on WAMP.. just on VPS... that doesn't work.

Edited July 2, 2013 by kenshn111

[Mootie]

have your clients import those?

 

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/item_db.sql

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/item_db2.sql

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/mob_db.sql

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/mob_db2.sql

 

 

if worked in your xampp which means you are using localhost and that means those .sql is imported in your database thats why it showed up.

and for your clients problem it seems they didn't import those .sql in their phpmyadmin/database.

[Hyvraine]

Yeah... they have those. The mob database page is working, it's just the item database that has problems. Sometimes viewing an item gives you internal server error .__.

[rosfus]

same 

[Najara]

If you have imported the SQL tables, the problem is that you're running on Hercules.

For some strange reason, the item_db.sql from Hercules is different compared to the item_db.sql from rAthena's.

 

This thread should fix your issue.

 

If not, please double check if you really did import the SQL tables.

Edited July 29, 2013 by Najara

[Hyvraine]

No, I imported the one from rAthena not Hercules. O_o I know there's a difference between the tables (Hercules separated atk and matk)

 

Plus, this only happens on people who are using VPS (well, some of my clients)

Edited July 29, 2013 by kenshn111

[rosfus]

i check error log yesterday ,  it seems mysql db .

 

some table not be exists.

 

use phpmysql to Importing .sql files in "data\schemas\charmapdb\" .

 

and it's fix.