MySQL Little help - Printable Version

MySQL Little help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Little help (/showthread.php?tid=562750)

MySQL Little help - iBanner - 11.02.2015

Can someone please tell me what am I missing? Here's what the problem, every time I register from the server it seems like it doesn't save from the database. So everytime I exit the game and reconnect it always bring me to register screen.

Код:

[18:01:51] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:01:51] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:01:51] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:01:51] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:01:51] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:01:51] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:01:51] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:01:51] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:01:52] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `tehserverz1351` WHERE `Server` = '1';", callback: "Safe_LoadServerStats", format: "(null)"
[18:01:52] [DEBUG] mysql_format - connection: 1, len: 256, format: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '%s', `Last_Restarted_Date` = '%s' WHERE `Server` = '1';"
[18:01:52] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '18:1:52', `", callback: "(null)", format: "(null)"
[18:01:52] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - starting query execution
[18:01:52] [ERROR] CMySQLQuery::Execute[Safe_LoadServerStats] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:01:52] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - error will be triggered in OnQueryError
[18:01:52] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:01:52] [DEBUG] Calling callback "OnQueryError"..
[18:01:52] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:05:15] [DEBUG] mysql_errno - connection: 1
[18:05:15] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `tehserverz1351` WHERE `Server` = '1';", callback: "Safe_LoadServerStats", format: "(null)"
[18:05:15] [DEBUG] mysql_format - connection: 1, len: 256, format: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '%s', `Last_Restarted_Date` = '%s' WHERE `Server` = '1';"
[18:05:15] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '18:5:15', `", callback: "(null)", format: "(null)"
[18:05:15] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:05:15] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:05:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:05:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:05:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:05:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:05:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:05:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:05:15] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - starting query execution
[18:05:15] [ERROR] CMySQLQuery::Execute[Safe_LoadServerStats] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:05:15] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - error will be triggered in OnQueryError
[18:05:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:05:15] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:05:15] [DEBUG] Calling callback "OnQueryError"..
[18:05:54] [DEBUG] mysql_format - connection: 1, len: 158, format: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE Username = '%e' LIMIT 1"
[18:05:54] [DEBUG] mysql_tquery - connection: 1, query: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE", callback: "CheckAccount", format: "i"
[18:05:54] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution
[18:05:54] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 0.359 milliseconds
[18:05:54] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[18:05:54] [DEBUG] Calling callback "CheckAccount"..
[18:05:54] [DEBUG] cache_get_data - connection: 1
[18:05:54] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[18:06:26] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `tehuzerz1351` (Username, Password, IP, Score, Cash,", callback: "(null)", format: "(null)"
[18:06:26] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `tehserverz1351` SET `Total_Users` = '%i' WHERE Server = '1';"
[18:06:26] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Total_Users` = '1' WHERE Server = '", callback: "(null)", format: "(null)"
[18:06:26] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:06:26] [ERROR] CMySQLQuery::Execute[] - (error #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 ''1' at line 1
[18:06:26] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:06:26] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:14:08] [DEBUG] mysql_format - connection: 1, len: 620, format: "UPDATE `tehuzerz1351` SET Admin = '%i', VIP = '%i', LastActive = '%s', Cash = '%i', Score = '%i', Kills = '%i', Deaths = '%i', S..."
[18:14:08] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehuzerz1351` SET Admin = '0', VIP = '0', LastActive = '", callback: "(null)", format: "(null)"
[18:14:08] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:14:08] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Bounce' in 'field list'
[18:59:08] [DEBUG] mysql_errno - connection: 1
[18:59:08] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `tehserverz1351` WHERE `Server` = '1';", callback: "Safe_LoadServerStats", format: "(null)"
[18:59:08] [DEBUG] mysql_format - connection: 1, len: 256, format: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '%s', `Last_Restarted_Date` = '%s' WHERE `Server` = '1';"
[18:59:08] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '18:59:8', `", callback: "(null)", format: "(null)"
[18:59:08] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:59:08] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:59:08] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:59:08] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:59:08] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:59:08] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:59:08] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:59:08] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:59:08] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - starting query execution
[18:59:08] [ERROR] CMySQLQuery::Execute[Safe_LoadServerStats] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:59:08] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - error will be triggered in OnQueryError
[18:59:08] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:59:08] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:59:08] [DEBUG] Calling callback "OnQueryError"..
[19:03:06] [DEBUG] mysql_format - connection: 1, len: 158, format: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE Username = '%e' LIMIT 1"
[19:03:06] [DEBUG] mysql_tquery - connection: 1, query: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE", callback: "CheckAccount", format: "i"
[19:03:06] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution
[19:03:06] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 1.312 milliseconds
[19:03:06] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:03:06] [DEBUG] Calling callback "CheckAccount"..
[19:03:06] [DEBUG] cache_get_data - connection: 1
[19:03:06] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:03:43] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `tehuzerz1351` (Username, Password, IP, Score, Cash,", callback: "(null)", format: "(null)"
[19:03:43] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `tehserverz1351` SET `Total_Users` = '%i' WHERE Server = '1';"
[19:03:43] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Total_Users` = '1' WHERE Server = '", callback: "(null)", format: "(null)"
[19:03:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:03:43] [ERROR] CMySQLQuery::Execute[] - (error #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 ''1' at line 1
[19:03:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:03:43] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[19:03:56] [DEBUG] mysql_format - connection: 1, len: 620, format: "UPDATE `tehuzerz1351` SET Admin = '%i', VIP = '%i', LastActive = '%s', Cash = '%i', Score = '%i', Kills = '%i', Deaths = '%i', S..."
[19:03:56] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehuzerz1351` SET Admin = '0', VIP = '0', LastActive = '", callback: "(null)", format: "(null)"
[19:03:56] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:03:56] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Bounce' in 'field list'

Re: MySQL Little help - kevin1990 - 11.02.2015

Look at the errors and read your MySQL_Log.txt

Its saying right there, The TABLE 'propowner.tehserverz1351' Does NOT exist.

Re: MySQL Little help - kevin1990 - 11.02.2015

You also have unknown column "Bounce"

I would first check to make sure you are connected to the RIGHT database. If you are on localhost, You could have numorous and you may have gotten it mistaken.

Then I would check your .SQL file.

If you downloaded this script then open the SQL in your phpmyadmin click on the correct DB where you uploaded the SQL and check that the table propowner.tehserverz1351 is infact there. If it is not, Create a new table.

If the table is not there, I image none of the columns or rows are there either. You will need to add those too.

Go through your script and find out what saves where.

Start adding the correct columns and rows to the correct tables

Re: MySQL Little help - iBanner - 11.02.2015

Quote:

Originally Posted by kevin1990

You also have unknown column "Bounce"

I would first check to make sure you are connected to the RIGHT database. If you are on localhost, You could have numorous and you may have gotten it mistaken.

Then I would check your .SQL file.

If you downloaded this script then open the SQL in your phpmyadmin click on the correct DB where you uploaded the SQL and check that the table propowner.tehserverz1351 is infact there. If it is not, Create a new table.

If the table is not there, I image none of the columns or rows are there either. You will need to add those too.

Go through your script and find out what saves where.

Start adding the correct columns and rows to the correct tables

thanks for the important notes mate! btw this gm is what I am trying to fixUFS Gamemode

I've already added propowner.tehserverz1351 but still showing the same error. still doesn't exist. I hope you could still help me with this. thanks looking forwards!

Re: MySQL Little help - kevin1990 - 11.02.2015

I clicked on that link and this is what I have found....

Quote:

» Download

NOTE: Check attachments for gamemode files.
If you need planes, vehicles.txt files go: HERE
If you need SQL file for version 2, go: HERE

Please report any bugs or problems on this thread.
Attached Files
File Type: rar Download here (USF).rar (307.5 KB, 1967 views)
File Type: zip Download here (USF) VERSION 2 [MYSQL].zip (369.1 KB, 153 views)
__________________

Did you download the USF VERSION 2 [MYSQL]?

Did you download where it says "If you need the SQL file for version 2, go :HERE"

Download that SQL. Open up to phpmyadmin...

Go to your database and import that SQL... It will create all the right tables, rows and columns you need.

If your still having troubles let me know.

Re: MySQL Little help - iBanner - 11.02.2015

Quote:

Originally Posted by kevin1990

I clicked on that link and this is what I have found....

Did you download the USF VERSION 2 [MYSQL]?

Did you download where it says "If you need the SQL file for version 2, go :HERE"

Download that SQL. Open up to phpmyadmin...

Go to your database and import that SQL... It will create all the right tables, rows and columns you need.

If your still having troubles let me know.

I don't know why still not working. Yes I'm using the Latest gm and the latest sql. Is it okay if you do it from your computer? I'm not sure but I guess I have problem with my wampserver.

Re: MySQL Little help - kevin1990 - 11.02.2015

Yea no worries. I'm at work for another 30 min. Ill let you know when I get home. Add me on Skype, Kmiles1990