Hi,
I am using a saving system by MySQL. The problem is, that I have multiple tables, in to which data are being saved. Everything works perfectly fine, until I want to load them.
When players connects and enters a correct password, I select all the data from all tables and pass them further into spawning. The problem is, that even that all of these tables and fields, columns are created properly both in the database and stated in the script, the data are not loaded and SQL throws out this error:
Field X does not exist
It is however properly created in the database. Funny part is, that this is only happening to the 2nd and 3rd table. The fields from the first table are being loaded just fine, and so when I move certain fields to the first table, they are excluded from the SQL error and everything works just fine. I am using a MULTI_STATEMENT when selecting these fields from the tables.
For any help, I will be thankful in advance.