MySQL-Login doesn't works anymore
#1

Hello,
first thing : sorry for my bad english. I'm from Germany.
my problem :
My script gots a MySQL-Account-System.
Up to now there was no problem, but now the password don't gets retrieved.
I didn't changed anything on the script; i just putted in a MySQL-Housesystem-Filterscript.
It doesn't work since i had it in the server.
So i took it out again, but it has not achieved anything.
The connection is made : My MySQL-Whitelist works, and it detects, if the player gots an account, but it writes no new account and the password isn't taken.

The mysql_log-File :

[Sat Sep 10 20:12:07 2011] -------------------------
[Sat Sep 10 20:12:07 2011] Logging Started
[Sat Sep 10 20:12:07 2011] -------------------------
[Sat Sep 10 20:12:07 2011] Connected (0) to samp015 @ 62.75.145.37 via TCP/IP.
[Sat Sep 10 20:12:07 2011] MySQL Server Version 5.0.51a-24+lenny5.
[Sat Sep 10 20:13:02 2011] Error (0): Failed to exeute query. 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 '' at line 1.

What can i do ? I don't know how to continue.

DarthXela
Reply
#2

Код:
check the manual that corresponds to your MySQL server version
Reply
#3

Ya, but i don't know, what is wrong.
Reply
#4

Код:
You have an error in your SQL syntax
Log says it all.
Reply
#5

Quote:
Originally Posted by Vince
Посмотреть сообщение
Код:
You have an error in your SQL syntax
Log says it all.
Yes, i know, but i don't know, WHERE the syntax error is.
Reply
#6

Post the queries you have
Reply
#7

SELECT user FROM whitelist WHERE user='%s' OR user='%s' LIMIT 1
SELECT * FROM banned WHERE IP = '%s'
SELECT * FROM accounts WHERE Username = '%s'
INSERT INTO whitelist (user) VALUES ('%s')
UPDATE whitelist SET user=md5('null') WHERE user='%s'
INSERT INTO accounts (Username, Password, IP, AdminLevel, PremiumLevel, Faction, Score, Money, Kills, Deaths, Handy) VALUES ('%s', '%s', '%s', '0', '0', '0', '0', '%d', '0', '0', '0')
SELECT * FROM accounts WHERE Username = '%s' AND Password = '%s'
UPDATE accounts SET IP = '%s' WHERE Username= '%s'
SELECT * FROM banned WHERE Username = '%s'
UPDATE accounts SET AdminLevel = '%d', Score = '%d', Money = '%d', Kills = '%d', Deaths = '%d' WHERE Username= '%s'
INSERT INTO banned (Username, IP, Banner, Reason) VALUES ('%s', '%s', '%s', '%s')
SELECT * FROM accounts WHERE Username = '%s'
UPDATE accounts SET Username = '%s'

I think, that's it. Need anything more ?

Edit : Do u need the context ?
Reply
#8

Well, I don't really know what the problem is, but try removing the queries one by one to see which line is causing the error
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)