Importing of itemInfo.lua with UTF-8 character encoding results in an error. about fluxcp HOT 8 OPEN

You have to use EUC-KR instead of UTF-8.

from fluxcp.

You have to use EUC-KR instead of UTF-8.

@secretdataz

I'm currently using EUC-KR with my IDE, but the import error persists. Does my database need to use it too?

Edit: I truncated cp_itemdesc and reimported with the correct character set, and I am still receiving the same error.

Edit: Could this be related to my PHP or MySQL version?

from fluxcp.

Also having problems with this, I installed Fluxcp locally and it works, after that, export your cp_itemdesc table and import it to your online Fluxcp.
This is just an alternative solution

from fluxcp.

I'm currently using EUC-KR with my IDE

Why should IDE help with php/mysql error :)

Change DB (at least for cp_itemdesc table) encoding and/or connection encoding

It should work with utf8 actually, so check that connection, database and table actually uses utf8.

from fluxcp.

I'm currently using EUC-KR with my IDE

Why should IDE help with php/mysql error :)

I am confirming that the contents of the itemInfo.lua file hasn't changed by using the wrong character encoding... :)

Change DB (at least for cp_itemdesc table) encoding and/or connection encoding

It should work with utf8 actually, so check that connection, database and table actually uses utf8.

The database is already using utf8. Same with the connection.

I'm pretty sure rAthena and FluxCP ships with the database and connection string with UTF8, so I am not sure how that is helpful.

from fluxcp.

Ah, my mistake. I thought the file was worked on with the wrong encoding.

from fluxcp.

Ah, my mistake. I thought the file was worked on with the wrong encoding.

All good. If this doesn't get fixed, I will probably create my own import tool.

I think I have seen previous bugs where the importer broke. It seems kinda flimsy.

from fluxcp.

It seems the error goes away when I downgraded from PHP 8.x to PHP 7.2.

@Akkarinage the README says the project uses PHP 5.2... It seems the documentation for FluxCP in regards to dependencies is severely lacking and major bugs go ignored.

Can you confirm the supported version of PHP and MySQL? At this point I plan to write my own control panel because the FluxCP codebase is a mess and sorting through everything seems like more pain than it's worth.

I also noticed that the mapdb and mobdb were removed without a replacement as well...

Unsure if there are any security vulnerabilities as well. It doesn't help that PHP 5.2 is being pushed still.

from fluxcp.