MYSQL DATABASE ERROR - Printable Version

MYSQL DATABASE ERROR - 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 DATABASE ERROR (/showthread.php?tid=646896)

MYSQL DATABASE ERROR - JulianWilliams - 26.12.2017

Код:

[06:39:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage0")
[06:39:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage1")
[06:39:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage2")
[06:39:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage3")
[06:53:45] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage0")
[06:53:45] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage1")
[06:53:45] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage2")
[06:53:45] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage3")
[06:56:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage0")
[06:56:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage1")
[06:56:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage2")
[06:56:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage3")

And I believe this is the reason why our dynamic doors in game and gates as well are missing. The DDs are invisible, while gates are completely missing.

Re: MYSQL DATABASE ERROR - MEW273 - 26.12.2017

The error is quite descriptive, the fields "dgGateFlage0-3" are not present in your table. If you have access to phpMyAdmin (or another GUI) check that you have the field names correct and are selecting from the correct table.

Re: MYSQL DATABASE ERROR - JulianWilliams - 26.12.2017

Quote:

Originally Posted by MEW273

The error is quite descriptive, the fields "dgGateFlage0-3" are not present in your table. If you have access to phpMyAdmin (or another GUI) check that you have the field names correct and are selecting from the correct table.

That's too bad, my host doesn't have any connections with PhpmyAdmin. Can I use HeidiSQL program instead? It's similar to Navicat btw.

Re: MYSQL DATABASE ERROR - Ritzy2K - 26.12.2017

You can actually edit your SQL database and simply reupload where you did previously, though you must know SQL syntax, though.