[ItsJosh]

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!

[Shockey HD]

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?

[Shinja]

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

[ItsJosh]

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

[Flake.]

Capitalize your table names

PHP код:

ALTER TABLE tablename RENAME newname; 


[ItsJosh]

I don't know what you mean..