Raised This Month: $ Target: $400
 0% 

[Help/MySQL] Load Query failed. [1054] Unknown column


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
KaLoIaN
Senior Member
Join Date: Feb 2013
Old 05-07-2016 , 02:19   [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #1

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

Last edited by KaLoIaN; 05-07-2016 at 02:26.
KaLoIaN is offline
GordonFreeman (RU)
Veteran Member
Join Date: Jan 2010
Location: Uzbekistan
Old 05-07-2016 , 04:53   Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #2

just remove `escapes`.
__________________
The functional way is the right way
GordonFreeman (RU) is offline
KaLoIaN
Senior Member
Join Date: Feb 2013
Old 05-07-2016 , 08:35   Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #3

Quote:
Originally Posted by GordonFreeman (RU) View Post
just remove `escapes`.
LOL

L 05/07/2016 - 1537: [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

Last edited by KaLoIaN; 05-07-2016 at 10:02.
KaLoIaN is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 05-07-2016 , 10:58   Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #4

I would rename the 'name' field to something else. I believe name is a reserved term in SQL, try player_name instead.
__________________
Bugsy is offline
KaLoIaN
Senior Member
Join Date: Feb 2013
Old 05-08-2016 , 02:48   Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #5

Quote:
Originally Posted by Bugsy View Post
I would rename the 'name' field to something else. I believe name is a reserved term in SQL, try player_name instead.
L 05/08/2016 - 09:452: [zp_mod_advs_mysqltest.amxx] Load Query failed. [1054] Unknown column 'escapes.pname' in 'where clause'


Hmmmm... nope.....
KaLoIaN is offline
KaLoIaN
Senior Member
Join Date: Feb 2013
Old 05-08-2016 , 08:21   Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #6

Quote:
Originally Posted by Bugsy View Post
I would rename the 'name' field to something else. I believe name is a reserved term in SQL, try player_name instead.
That error occurs when someone connects to the server.
KaLoIaN is offline
KaLoIaN
Senior Member
Join Date: Feb 2013
Old 05-08-2016 , 14:18   Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #7

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 ......
KaLoIaN is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 05-08-2016 , 15:23   Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #8

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:
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time.  Use      ;;
;;  amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;mysql
sqlite
__________________

Last edited by Bugsy; 05-08-2016 at 15:23.
Bugsy is offline
KaLoIaN
Senior Member
Join Date: Feb 2013
Old 05-09-2016 , 03:12   Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #9

Quote:
Originally Posted by Bugsy View Post
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:
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time.  Use      ;;
;;  amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;mysql
sqlite
Done.. now another error:

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:
public MySql_Init()
{
    
SQL_SetAffinity"sqlite" ); 

Last edited by KaLoIaN; 05-09-2016 at 03:14.
KaLoIaN is offline
KaLoIaN
Senior Member
Join Date: Feb 2013
Old 05-11-2016 , 04:33   Re: [Help/MySQL] Load Query failed. [1054] Unknown column
Reply With Quote #10

Somebody...?
KaLoIaN is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 18:32.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode