PS3 Menu SQL Error

by killamods1 - 01-11-2019 - 01:05 PM
Posts:
287

Reputation:
0

Credits:

GoldDiamondEmerald
Emerald Member
Emerald
Posts:
287

Threads:
11

Joined:
Dec 2016

Likes:
23

Credits:

Reputation:
0

Warning Level:

2 Years Of Service
GoldDiamondEmerald
#1
OP
Posted: 01-11-2019 - 01:05 PM
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]
Posts:
93

Reputation:
-4

Credits:

Junior Member
Posts:
93

Threads:
1

Joined:
Sep 2018

Likes:
0

Credits:

Reputation:
-4

Warning Level:

#2
Posted: 01-11-2019 - 03:05 PM
Idk maybe before pasting learn some simple stuff?
Posts:
164

Reputation:
18

Credits:

GoldDiamondEmeraldDiscord
Emerald Member
Emerald
Posts:
164

Threads:
13

Joined:
Jul 2017

Likes:
0

Credits:

Reputation:
18

Warning Level:

1 Year Of Service
GoldDiamondEmeraldDiscord
#3
Posted: 01-12-2019 - 04:00 AM
stop using independence website :D

[Image: InceptionMenu.gif]




USERS BROWSING THIS THREAD:  1 Guest(s)
"Join for the content, stay for the community."
© All Rights Reserved DemonForums.
© 2015-2018 / DemonForums
Server time: 01-22-2019, 09:55 PM (1185 Days Online)