ALERT!
Click here to register with a few steps and explore all our cool stuff we have to offer!
Home
Upgrade
Credits
Help
Search
Awards
Achievements
 1836

PS3 Menu SQL Error

by killamods1 - 01-11-2019 - 01:05 PM
#1
When I try to execute the independence sql file into my mysql, I get some errors. Does any one happen to know how to fix these errors? Or can anyone provide me a link possibly on how to correct these errors? I would greatly appreciate it. I am still learning how to do mysql databases so please no hate. I am using this source to learn how it works NOT for my own work. All credits will be given to owner. I will include a screen shot of the errors below, thanks.

Error
Static analysis:
2 errors were found during analysis.

  1. An opening bracket followed by a set of values was expected. (near "CREATE" at position 245)

  2. Unexpected token. (near "CREATE" at position 245)
SQL query:
-- -- Dataark for tabell `bans` -- INSERT INTO `bans` (`id`, `userid`, `type`, `reason`, `unban_when`, `who_banned_them_userid`) VALUES -- -------------------------------------------------------- -- -- Tabellstruktur for tabell `emojis` -- CREATE TABLE IF NOT EXISTS `emojis` ( `id` int(5) NOT NULL, `Name` varchar(50) NOT NULL, `Wut` varchar(50) NOT NULL, `url` varchar(50) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `id_2` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
MySQL said: [Image: dot.gif]
Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `emojis` (
  `id` int(5) NOT NULL,
  `Name` varchar(5' at line 14



[Image: Untitled.png]
#2
Idk maybe before pasting learn some simple stuff?
#3
stop using independence website :D

Users browsing: 2 Guest(s)