SQL Errors. - 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: SQL Errors. (
/showthread.php?tid=613723)
SQL Errors. -
ItsJosh - 30.07.2016
I've installed SCRP (Small County Roleplay) and set it all up. Everything went well until.. I saw this error in the console with something with the SQL.
Quote:
[MYSQL ERROR]: ID: 1146
[MYSQL ERROR]: Error: Table 'jindex.settings' doesn't exist
[MYSQL ERROR]: Query: SELECT * FROM `Settings` LIMIT 1
[MYSQL ERROR]: ID: 1146
[MYSQL ERROR]: Error: Table 'jindex.houses' doesn't exist
[MYSQL ERROR]: Query: SELECT * FROM `Houses` ORDER BY SQLID ASC
[MYSQL ERROR]: ID: 1146
[MYSQL ERROR]: Error: Table 'jindex.business' doesn't exist
[MYSQL ERROR]: Query: SELECT * FROM `Business` ORDER BY SQLID ASC
[MYSQL ERROR]: ID: 1146
[MYSQL ERROR]: Error: Table 'jindex.objects' doesn't exist
[MYSQL ERROR]: Query: SELECT * FROM `Objects`
[MYSQL ERROR]: ID: 1146
[MYSQL ERROR]: Error: Table 'jindex.icons' doesn't exist
[MYSQL ERROR]: Query: SELECT * FROM `Icons` ORDER BY SQLID ASC
[MYSQL ERROR]: ID: 1146
[MYSQL ERROR]: Error: Table 'jindex.servervehicles' doesn't exist
[MYSQL ERROR]: Query: SELECT * FROM `ServerVehicles` ORDER BY SQLID ASC
[MYSQL ERROR]: ID: 1146
[MYSQL ERROR]: Error: Table 'jindex.factionvehicles' doesn't exist
[MYSQL ERROR]: Query: SELECT * FROM `FactionVehicles` ORDER BY SQLID ASC
[MYSQL ERROR]: ID: 1146
[MYSQL ERROR]: Error: Table 'jindex.factions' doesn't exist
[MYSQL ERROR]: Query: SELECT * FROM `Factions` ORDER BY SQLID ASC
|
In the "CONNECTIONS" script which has all the SQL thingys all in, this is what I have.
#define SQL_HOST "mysql3.gear.host"
#define SQL_USER "USER"
#define SQL_PASS "PASSWORD"
#define SQL_DB "scrp 0.21"
I opened the SQL script using MYSQL Workbench, and yeah. This is my first time using mySQL so..
This is what it looks like..
I would appreciate some help, thanks!
Re: SQL Errors. -
Shockey HD - 31.07.2016
These tables don't exist, You got to add them.
settings
houses
business
objects
icons
servervehicles
factionvehicles
factions
Can we see the SQL logs from when the server boots?
Re: SQL Errors. -
Shinja - 31.07.2016
Tables probably not created as the log says, you can create manually or by the script
Re: SQL Errors. -
ItsJosh - 31.07.2016
It's made by the script. Let me show you.. this is the SQL script.
http://pastebin.com/pgjGFBqi
Re: SQL Errors. -
Flake. - 31.07.2016
Capitalize your table names
PHP код:
ALTER TABLE tablename RENAME newname;
Re: SQL Errors. -
ItsJosh - 01.08.2016
I don't know what you mean..