Member Avatar for Ronnie.Sk1ttl3s.Eke

I am getting this error when inserting a query into the SQL tab of a database, it only adds 2 tables when it is supposed to add more, but the error is stopping it?

Screenshot:
http://gyazo.com/b62b31137708228beb791ed6c8ad01ea

Query im inserting:
http://pastebin.com/rMJeA0Xb

Software: MySQL
Software version: 5.1.68-cll - MySQL Community Server (GPL)

If you can help me out, I'd really appreciate, thanks!

Edited by Ronnie.Sk1ttl3s.Eke
  • 4 Contributors
  • 5 Replies
  • 250 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by JOSheaIV
Member Avatar for tinstaafl

The error seems to be right after you try to insert a null value, but the table structure seems to want not null

Member Avatar for rch1231

Hello,

From what I can see there is something in the data in some of the inserts that is off or a special charcter . I tried to run your sql code and remove various rows from teh fe table and it would never load. If I removed the inserts for fe it continued on down till it got to news and did the same thing. It might be the text data type you are using. I suggest taking the sql dump and running only the create tables statements to get the tables created and then go back in and create your inital vales again and see what happens.

Member Avatar for Ronnie.Sk1ttl3s.Eke

Thanks for the very detailed reply rch1231, I am no expert in SQL so I don't fully understand what to do, ill maybe get a mate or someone to do what you said, thanks.

Member Avatar for Ronnie.Sk1ttl3s.Eke

I cant do it, could anyone please fix it up for me and send me the code, I am begging you, been trying to do this for over a week, please guys or girls.

Member Avatar for JOSheaIV

Okay so I looked at the screenshot and code, and I saw something that caught my eye.

You said you are only creating 2 tables correct, so I went to your code and looked between where you created your 2nd and 3rd table.

Which is this:

LOCK TABLES `fe` WRITE;
/*!40000 ALTER TABLE `fe` DISABLE KEYS */;
INSERT INTO `fe` (`ID`, `userID`, `type`, `ip`, `note`) VALUES (1,12,'e','110.175.100.136','Auspride018'),(2,13,'e','94.197.11.24',''),(3,8,'f'​,'50.138.30.101','Nely'),(4,8,'f','50.55.247.24','Brittany'),(5,8,'f','98.94.78.​64','channa'),(6,8,'f','108.210.196.40','Hector'),(7,8,'f','70.100.180.240','Kim​mie'),(8,8,'f','50.33.227.18','Karissa'),(9,8,'f','108.214.117.105','Lilla');
/*!40000 ALTER TABLE `fe` ENABLE KEYS */;
UNLOCK TABLES;

Now let's take a look at those values shall we

(1,12,'e','110.175.100.136','Auspride018'),
(2,13,'e','94.197.11.24',''),
(3,8,'f'​,'50.138.30.101','Nely'),
(4,8,'f','50.55.247.24','Brittany'),
(5,8,'f','98.94.78.​64','channa'),
(6,8,'f','108.210.196.40','Hector'),
(7,8,'f','70.100.180.240','Kim​mie'),
(8,8,'f','50.33.227.18','Karissa'),
(9,8,'f','108.214.117.105','Lilla');

Notice how entry 2 has an empty value for the 5th value? Now I am no expert on SQL, but I feel that empty value for the entry between Auspride018 and Nely might be the issue. Why not try inserting a value there, and running it. See if that works

Edited by JOSheaIV
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.