[Help/MySQL] Load Query failed. [1054] Unknown column
Here is the error:
L 05/07/2016 - 09:13:13: [zp_mod_advs_mysqltest.amxx] Load Query failed. [1054] Unknown column 'escapes.name' in 'where clause' Here is the code: http://pastebin.com/huN4m6mY Code is in pastebin because the cloudflare of alliedmods does not allow me to post the thread. P.S. Load_MySQL is in client_putinserver |
Re: [Help/MySQL] Load Query failed. [1054] Unknown column
just remove `escapes`.
|
Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Quote:
L 05/07/2016 - 15:33:37: [zp_mod_advs_mysqltest.amxx] Load Query failed. [1054] Unknown column 'name' in 'where clause' I use this tutorial: https://forums.alliedmods.net/showthread.php?t=132686 |
Re: [Help/MySQL] Load Query failed. [1054] Unknown column
I would rename the 'name' field to something else. I believe name is a reserved term in SQL, try player_name instead.
|
Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Quote:
Hmmmm... nope..... |
Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Quote:
|
Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Another error just appeared: L 05/08/2016 - 21:16:19: [zp_mod_advs_mysqltest.amxx] Load Query failed. [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's')' at line 1
That SQL is super problematic ...... |
Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Try adding this at the top of your SQL init function.
SQL_SetAffinity( "sqlite" ); And go into modules.ini and set it this way Code:
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; |
Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Quote:
L 05/09/2016 - 10:10:23: [zp_mod_advs_mysqltest.amxx] Load Query failed. [1] no such column: escapes.pname Mine SQL Init looks like: PHP Code:
|
Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Somebody...?
|
| All times are GMT -4. The time now is 18:32. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.