Pre-Renewal FluxCP Item Database error item_db.sql Fix

[loremipsum]

I spent way too long trying to fix this out, hope this helps someone.

 

This solution assumes you:
- Use Pre-Renewal setting (Not Renewal) for FluxCP (rathena-FluxCP-5ec2229)

- Use item_db.txt on your server (rathena - Revision 17704: /)

- Converted item_db.txt to item_db.sql using the tool mentioned below.

- FluxCP otherwise works fines and is installed correctly, just not displaying Item Database

 

If you have FluxCP installed and updated your item_db.sql by creating it through the currently featured tool on the download page called "rAthena Database Editor 0.1.3 Alpha" then it will cause your item database not to display correctly, and here's the simple solution.

 

Once you find this error in your error.php logs on Flux Control Panel:

/public_html/cp/data/logs/mysql/errors/ (whatever it generated for today).php

open up the file and if you see a line like this:

[2014-07-29 06:06:54] [SQLSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'

It means that the item_db.sql has a descrepancy between names for what it's using on the "attack" column of the item database due to them renaming that column to: "atk:matk".

 

The solution, rename that column to "attack".

 

You could use this (or use the GUI in MySQL Workbench):

ALTER TABLE item_db CHANGE atk:matk attack INT

If you get a SQL syntax error you can always use the GUI, select item_db, right click, Alter Table, and rename it from there.

Edited July 29, 2014 by Zairik