[MYSQL] "You have an error in your SQL syntax"

[MYSQL] "You have an error in your SQL syntax" - 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] "You have an error in your SQL syntax" (/showthread.php?tid=554382)

[MYSQL] "You have an error in your SQL syntax" - S4MSUNG - 03.01.2015

Hello, Im not sure if this is the correct section to post my issue. But im so confused and beginner with this MySQL

After i uploading the SQL file to my database it shows this error.

Code:

SQL query:


--
-- Dumping data for table `banned`
--

INSERT INTO `banned` (`User`, `Banner`, `IP`, `Date`, `Time`, `Reason`) VALUES


-- --------------------------------------------------------

--
-- Table structure for table `lshousedata`
--

CREATE TABLE IF NOT EXISTS `lshousedata` (
  `Houseid` int(11) NOT NULL,
  `OwnerName` varchar(128) NOT NULL default 'The Bank',
  `OwnerID` int(11) NOT NULL default '-1',
  `RenterName` varchar(128) NOT NULL default 'None',
  `RenterID` int(11) NOT NULL default '-1',
  `HouseName` varchar(50) NOT NULL default 'House',
  `Value` int(11) NOT NULL default '200000',
  `Rent` int(11) NOT NULL default '0',
  `ForSale` int(11) NOT NULL default '0',
  `Alarm` int(11) NOT NULL default '0',
  `Money` int(11) NOT NULL default '0',
  `Drugs` int(11) NOT NULL default '0',
  `Condoms` int(11) NOT NULL default '0',
  `Flowers` int(11) NOT NULL default '0',
  `Robberies` int(11) NOT NULL default '0',
  `Breakins` int(11) NOT NULL default '0',
  `OwnerVisits` int(11) NOT [...]
MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `lshousedata` (
  `Houseid` int(11) NOT NULL,
  `Owne' at line 11

Thanks in advance, I pormise i will give an ++REP

Re: [MYSQL] "You have an error in your SQL syntax" - S4MSUNG - 03.01.2015

My MYSQL version:

MySQL 5.6

Re: [MYSQL] "You have an error in your SQL syntax" - CrazyChoco - 03.01.2015

Did you get the error, while trying to create those tables, or when launching the server?

Re: [MYSQL] "You have an error in your SQL syntax" - S4MSUNG - 03.01.2015

Quote:

Originally Posted by CrazyChoco

Did you get the error, while trying to create those tables, or when launching the server?

Nope, I just uploaded the SQL file then it failed to upload due to that error. I did not launched the server yet because I dont have the SQL File yet uploaded to the database. And basically when launching my server i just receive an error in the end of line like this

Code:

[MYSQL] Could not retrieve field - SERVER SHITTING DOWN