SQL Errors.
#1

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!
Reply
#2

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?
Reply
#3

Tables probably not created as the log says, you can create manually or by the script
Reply
#4

It's made by the script. Let me show you.. this is the SQL script.
http://pastebin.com/pgjGFBqi
Reply
#5

Capitalize your table names

PHP код:
ALTER TABLE tablename RENAME newname
Reply
#6

I don't know what you mean..
Reply


Forum Jump:


Users browsing this thread: