SA-MP Forums Archive
mysql error - 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 error (/showthread.php?tid=615785)


mysql error - AndreiWow - 27.08.2016

Код:
SQL query:


CREATE TABLE IF NOT EXISTS `911 calls` (
`ID` int(11) NOT NULL,
  `Timestamp` int(11) NOT NULL,
  `Caller` int(6) NOT NULL,
  `Incident` varchar(128) NOT NULL,
  `Location` varchar(128) NOT NULL,
  `Service` int(2) NOT NULL,
  `Number` int(8) NOT NULL,
  `IGTime` int(12) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2
MySQL said: Documentation

#1046 - No database selected
Why?

Re: mysql error - Konstantinos - 27.08.2016

Click on "Databases" left of "SQL" tab and click on the database you want to create this table in. Then go to "SQL" tab and execute the query.

Re: mysql error - AndreiWow - 27.08.2016

oh lord dominic, yu senpai, helped me

Re: mysql error - AndreiWow - 27.08.2016

Код:
[11:41:27] [MYSQL ERROR]: ID: 1146
[11:41:27] [MYSQL ERROR]: Error: Table 'port_9873.Settings' doesn't exist
[11:41:27] [MYSQL ERROR]: Query: SELECT * FROM `Settings` LIMIT 1
[11:41:27] [MYSQL ERROR]: ID: 1146
[11:41:27] [MYSQL ERROR]: Error: Table 'port_9873.Houses' doesn't exist
[11:41:27] [MYSQL ERROR]: Query: SELECT * FROM `Houses` ORDER BY SQLID ASC
[11:41:27] [MYSQL ERROR]: ID: 1146
[11:41:27] [MYSQL ERROR]: Error: Table 'port_9873.Business' doesn't exist
[11:41:27] [MYSQL ERROR]: Query: SELECT * FROM `Business` ORDER BY SQLID ASC
[11:41:27] [MYSQL ERROR]: ID: 1146
[11:41:27] [MYSQL ERROR]: Error: Table 'port_9873.Objects' doesn't exist
[11:41:27] [MYSQL ERROR]: Query: SELECT * FROM `Objects`
[11:41:27] [MYSQL ERROR]: ID: 1146
[11:41:27] [MYSQL ERROR]: Error: Table 'port_9873.Icons' doesn't exist
[11:41:27] [MYSQL ERROR]: Query: SELECT * FROM `Icons` ORDER BY SQLID ASC
[11:41:27] [MYSQL ERROR]: ID: 1146
[11:41:27] [MYSQL ERROR]: Error: Table 'port_9873.ServerVehicles' doesn't exist
[11:41:27] [MYSQL ERROR]: Query: SELECT * FROM `ServerVehicles` ORDER BY SQLID ASC
[11:41:27] [MYSQL ERROR]: ID: 1146
[11:41:27] [MYSQL ERROR]: Error: Table 'port_9873.FactionVehicles' doesn't exist
[11:41:27] [MYSQL ERROR]: Query: SELECT * FROM `FactionVehicles` ORDER BY SQLID ASC
[11:41:27] [MYSQL ERROR]: ID: 1146
[11:41:27] [MYSQL ERROR]: Error: Table 'port_9873.Factions' doesn't exist
[11:41:27] [MYSQL ERROR]: Query: SELECT * FROM `Factions` ORDER BY SQLID ASC
[11:41:27] New version of CrashDetect is available for download (4.13)


Re: mysql error - Konstantinos - 27.08.2016

You will need to create "Settings", "Houses", "Business", "Objects", "Icons", "ServerVehicles", "FactionVehicles" and "Factions" tables. Assuming it is a released script, it should contain them somewhere (in that thread).

Re: mysql error - AndreiWow - 27.08.2016

They are, it say that it failed to connect to the mysql in logs but I used the right user and password, letter by letter

Re: mysql error - Konstantinos - 27.08.2016

Try compiling the scripts once again with the correct mysql details and if it can't connect, you may ask for support from the host you are on.