ry167
-
Posts
4 -
Joined
-
Last visited
Posts posted by ry167
-
-
sql updates
why is that so hard to understand?
Then as it says, when i try to run the SQL updates, most work, but using that table get: (for the query:"UPDATE `quest_template` SET `RequiredClasses`=0 WHERE `entry`=8249; -- Junkboxes Needed")
Error Code : 1054
Unknown column 'RequiredClasses' in 'field list'
A good amount of the SQL updates are not working for me, I only gave one example. There are more (any to do with that table) that get a similar error. Its close to the same though so i didn't include screenies for what the world server does after each thing in the sql/updates folder
-
I have tried re-compiling and re-downloading everything, and it still refuses to work.
The authserver starts and runs fine (haven't tried connecting but console shows no errors and runs) but even after a re-compile and re-do of the world database i get this error message in the worldserver console:
"ERROR: [1054] Unknown column 'Id' in 'field list'" - Along with everything else (see image attached).
Then as it says, when i try to run the SQL updates, most work, but using that table get: (for the query:"UPDATE `quest_template` SET `RequiredClasses`=0 WHERE `entry`=8249; -- Junkboxes Needed")
Error Code : 1054
Unknown column 'RequiredClasses' in 'field list'
I have executed the latest TDB_Full from the Githubs downloads have not modified any SQL queries except for password in the creating one.
So uhm, Help? Ill provide any other info if its needed, didn't really know what you would need xD
Thanks in advance
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
Thats what I was trying to do Aokromes but it gave me errors. I have done it before without any troubles.
But MySQL didn't give an error for the mass query from the script that Nay linked me to so its working now. Thanks Nay.
Still confused on why but im happy its working