[Help]Execute SQL problems.

[Metis]

Hoi, i got some problems when i try to Execute ANY .sql file to my Ascent database. Tried to exectue a SQL file that would give me all the new season 3 sets and weapons, tho seems not to work. and other sql executes don't work aswell. i'm using Greengiant's latest (i guess) repack of DOOM, rev 5.xxx something. Well, hope this info helps!

-Metis

[Spartansp]

the queries are not correct maybe and if thats not the problem maybe the .sql you downloaded are not for your databse version maybe there are some columns that doesnt match etc.

[Chargar]

Well on some DB's you have to Remove the "1" at the "Name1"
Dunno if that helps tough, I dont use the DB :P

[Metis]

[Err] 1048 - Column 'mapid' cannot be null
[Err] INSERT INTO `items` VALUES ('33666', '4', '3', '-1', 'Vengeful Gladiator\'s Chain Helm', 'Vengeful Gladiator\'s Chain Helm', 'Vengeful Gladiator\'s Chain Helm', 'Vengeful Gladiator\'s Chain Helm', '46884', '4', '0', '0', '0', '1', '4', '-1', '146', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '33', '7', '61', '5', '22', '31', '12', '32', '26', '35', '22', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '830', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15815', '1', '0', '0', '0', '0', '39927', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '723', '85', '0', null, '0', null, '1', '0', '2', '0', '0', '0', '2856', null, '0', '0', '-1', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

That's teh error msg i get.!

[Kiev]

just change the null to 1 and it should work.

[Chargar]

INSERT INTO `items` VALUES ('33666', '4', '3', '-1', 'Vengeful Gladiator\'s Chain Helm', 'Vengeful Gladiator\'s Chain Helm', 'Vengeful Gladiator\'s Chain Helm', 'Vengeful Gladiator\'s Chain Helm', '46884', '4', '0', '0', '0', '1', '4', '-1', '146', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '33', '7', '61', '5', '22', '31', '12', '32', '26', '35', '22', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '830', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15815', '1', '0', '0', '0', '0', '39927', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '723', '85', '0', '0', '0', '0', '1', '0', '2', '0', '0', '0', '2856', '0', '0', '0', '-1', '0');



Try that.

[Metis]

Thanks, that worked like a charm! just all the rest left then change all "null" to "1"?

[Spartansp]

yes basically thats it but if you still getting errors post here the SQL error and we will help you

[Chargar]

Yes. :P Next time see what your Errors says.. lol.