mysql connection - Printable Version

mysql connection - 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 connection (/showthread.php?tid=492223)

mysql connection - Mattakil - 02.02.2014

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.

Re: mysql connection - Face9000 - 02.02.2014

Create the table then?

Re: mysql connection - Mattakil - 02.02.2014

Quote:

Originally Posted by Face9000

Create the table then?

Like I said, I imported the table.

Re: mysql connection - Misiur - 02.02.2014

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

Re: mysql connection - Mattakil - 02.02.2014

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