mysql error
#1

Код:
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?
Reply
#2

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

oh lord dominic, yu senpai, helped me
Reply
#4

Код:
[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)
Reply
#5

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).
Reply
#6

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

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)