My importer was motoring along just fine until it got to importing rides.
It appeared to import 8 vehicles and on the 9th it threw this error:
[CODE]Database error in vBulletin 4.2.3:
Database error in vBulletin 4.2.3:
Invalid SQL:
INSERT INTO vb3_vbrides_rides
(categoryid, userid, username, title, carname, year, make, model, options, smalldesc, bodytext, price, paint_color, views, postdate, updated, active, status)
VALUES
('33', '11351', 'dale's48', '1948 Buick Super', '', '1948', 'Buick', 'Super' , '', 'it\'s a 2 door sedanet,all there, much work done, but needs the motor rebuilt', 'it\'s a 2 door sedanet,all there, much work done, but needs the motor rebuilt', '0.00', '', '0', '1301957903', '1301957903', '1', '2');
MySQL Error : 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 's48', '1948 Buick Super', '', '1948', 'Buick', 'Super' , '', 'it\'s a 2 door sed' at line 4
Error Number : 1064
Request Date : Saturday, December 31st 2016 @ 04:02:42 PM
Error Date : Saturday, December 31st 2016 @ 04:02:43 PM
Script : http://www.teambuick.com/forums/admincp/vbrides_import.php?do=import_vehicle
Referrer : https://www.teambuick.com/forums/admincp/vbrides_import.php?do=import_trim
IP Address : 172.218.123.142
Username : Bob
Classname : vB_Database_MySQLi
MySQL Version : 5.6.34
I have gone into the database, and deleted this vehicle, run the script again and had the same error after it imported a few more vehicles. I deleted each problem vehicle as it came up. The script came to an end and loaded the vbulletin admincp. Unfortunately, when I go to rides, they are not there
https://www.teambuick.com/forums/vbrides.php
Sal Collaziano, below, you mention Approving, the script I ran did not require approving, not that it means much as it did not work either
Thanks,