Bug Database error when importing

[TandyServices]

I get a database error when I try to import:

Database error in vBulletin 4.2.0:Invalid SQL:DELETE FROM dbtech_gallery_categories WHERE import_id		> 0 && import_type	= 'vb_album';MySQL Error   : Unknown column 'import_id' in 'where clause'Error Number  : 1054Request Date  : Tuesday, July 31st 2012 @ 05:52:18 AMError Date    : Tuesday, July 31st 2012 @ 05:52:19 AMScript        : [URL]http://www.truckingspace.com/admincp/dbtgallery.php?do=import&instanceid=1&delete_prev=1&step=3&mod=vb_album[/URL]Referrer      : [URL]http://www.truckingspace.com/admincp/dbtgallery.php?do=import&step=2&mod=vb_album[/URL]IP Address    : 97.78.7.33Username      : SlingerClassname     : vB_DatabaseMySQL Version : 5.1.63-community-log

 

[TandyServices]

Database error in vBulletin 4.2.0:Invalid SQL: SELECT * FROM 'album';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 ''album'' at line 1Error Number : 1064Request Date : Tuesday, July 31st 2012 @ 05:52:04 AMError Date : Tuesday, July 31st 2012 @ 05:52:05 AMScript : Log in - TruckingSpace - vBulletin Admin Control PanelReferrer : Log in - TruckingSpace - vBulletin Admin Control PanelIP Address : 97.78.7.33Username : Slinger

 

[Dylan]

If it hasn't gotten to the part where it tries to import categories then it doesn't see that field yet.

For the second error, I have to fix it in the next release. If you want to fix it manually and try again

Open dbtech/gallery/includes/class_import.php
On line 170 change

SELECT * FROM " . $this->registry->db->sql_prepare($table)

to

SELECT * FROM " . $table

 

[Dylan]

I made some more import changes and did a hotfix on the current version files. If you are still having problems, try downloading the 1.1.2 package.

 

[TandyServices]

Thank you.. Will see what happens and let you know..