FluxCP Mob & Item SQL Errors

[Snaehild]

Hi,

I'm getting these error when trying to access Mob & Items pages on FluxCP. I have imported the SQL files already from rathena/sql-files/

Error: Flux_Error

Message: MySQL error (SQLSTATE: 42S22, ERROR: 1054): Unknown column 'equip_locations' in 'where clause'

Message: MySQL error (SQLSTATE: 42S22, ERROR: 1054): Unknown column 'Scale' in 'where clause'

 

[Fhaarnius]

That's because of incompatibility.

 

On 6/16/2021 at 5:45 AM, Snaehild said:

 

Error: Flux_Error

Message: MySQL error (SQLSTATE: 42S22, ERROR: 1054): Unknown column 'equip_locations' in 'where clause'

Import these compatibility files: 

item_db_compat.sql AND item_db2_compat.sql 
OR
item_db_re_compat.sql AND item_db2_re_compat.sql

from [rathena's root]/sql-files/compatibility.

And then modify your fluxcp's root/modules/item/index.php. Look for something like this:

{$server->charMapDatabase}.item_db

then edit item_db to item_db_compat. Or item_db_re to item_db_re_compat.

Connect the module to the compatible view, not directly to the table. You get the point right? 

_______________________________________________________

On 6/16/2021 at 5:45 AM, Snaehild said:

 

Message: MySQL error (SQLSTATE: 42S22, ERROR: 1054): Unknown column 'Scale' in 'where clause'

 

Sorry, I haven't found a solution for this one either.
But modifying the query can be a temporary solution, if you know what you're doing. 

[Snaehild]

Hi @Fhaarnius

Thank you for the response.

I was able to make it work by importing older SQL files from the repo

But there's still an error on MVP rankings

I'm using the SQL files from 10b5965d1dae1defa4ae50c79824babc0e07335e which worked both for my mob & items db. I'm not sure if it's related to this.

Error: PDOException

Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ragnarok.monsters' doesn't exist

File: E:\xampp\htdocs\flux\lib\Flux\Connection\Statement.php:50

File	Line	Function/Method
E:\xampp\htdocs\flux\lib\Flux\Connection\Statement.php	50	PDOStatement::execute()
E:\xampp\htdocs\flux\themes\th1\main\rightbar.php	166	Flux_Connection_Statement::execute()
E:\xampp\htdocs\flux\themes\th1\footer.php	5	include()
E:\xampp\htdocs\flux\lib\Flux\Template.php	403	include()
E:\xampp\htdocs\flux\lib\Flux\Dispatcher.php	170	Flux_Template::render()
E:\xampp\htdocs\flux\index.php	169	Flux_Dispatcher::dispatch()
Exception Trace As String
#0 E:\xampp\htdocs\flux\lib\Flux\Connection\Statement.php(50): PDOStatement->execute(NULL)
#1 E:\xampp\htdocs\flux\themes\th1\main\rightbar.php(166): Flux_Connection_Statement->execute()
#2 E:\xampp\htdocs\flux\themes\th1\footer.php(5): include('E:\\xampp\\htdocs...')
#3 E:\xampp\htdocs\flux\lib\Flux\Template.php(403): include('E:\\xampp\\htdocs...')
#4 E:\xampp\htdocs\flux\lib\Flux\Dispatcher.php(170): Flux_Template->render()
#5 E:\xampp\htdocs\flux\index.php(169): Flux_Dispatcher->dispatch(Array)
#6 {main}