[Mattakil]

my server works fine on localhost, using my local database. I exported it to my VPS, and transfered the database to the vps server too, everything connects fine, but it says the table "Accounts" doesnt exist...but it does? Im sure its not spelled wrong, as all I did was import from one to the other, so it seems odd to me that this would happen

Код:

 >> mysql_connect( )
[23:19:30] CMySQLHandler::CMySQLHandler() - constructor called.
[23:19:30] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "purerp_server" | Username: "purerp" ...
[23:19:30] CMySQLHandler::Connect() - Connection was successful.
[23:19:30] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

Код:

 - An error has occured. (Error ID: 1146, Table 'purerp_server.ACCOUNTS' doesn't exist)

The above is what happens when a query is called.

[Face9000]

Create the table then?

[Mattakil]

Quote:

Originally Posted by Face9000 Create the table then?

Like I said, I imported the table.

[Misiur]

SQL language, as most programming languages, is case sensitive. If the table is called "accounts" instead of "ACCOUNTS", it will report missing table "ACCOUNTS".

[Mattakil]

Quote:

Originally Posted by Misiur SQL language, as most programming languages, is case sensitive. If the table is called "accounts" instead of "ACCOUNTS", it will report missing table "ACCOUNTS".

im not sure why exporting it changed that, I opened up the .sql file and changed it to ACCOUNTS, iti works now, thank you