Bug SQL error when removing category or extension

[Vcize]

Attempting to remove a category returns the following error:

Invalid SQL:

SELECT dbtech_downloads_categoryid, title AS title
FROM dbtech_downloads_category
WHERE dbtech_downloads_categoryid = 1;

Attempting to remove an extension returns:

Invalid SQL:

SELECT dbtech_downloads_extensionid, extension AS title
FROM dbtech_downloads_extension
WHERE dbtech_downloads_extensionid = 8;

Product version is actually 2.0.0b2. It wouldn't let me enter characters in the version box.

 

[Fillip H.]

Can you please post the full error messages? You've cropped out the message details, which I need in order to see what's wrong

 

[Vcize]

Sorry, the column names do not exist..

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT dbtech_downloads_categoryid, title AS title
FROM dbtech_downloads_category
WHERE dbtech_downloads_categoryid = 1;

MySQL Error : Unknown column 'dbtech_downloads_categoryid' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 27th 2013 @ 02:03:49 PM
Error Date : Wednesday, February 27th 2013 @ 02:03:49 PM
Script : http://www.mydomain.com/admincp/vbdownloads.php?do=category&action=delete&categoryid=1
Referrer : http://www.mydomain.com/admincp/vbdownloads.php?do=category
IP Address : myip
Username : myusername
Classname : vB_Database
MySQL Version : 5.0.96-community

 

[Vcize]

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT dbtech_downloads_extensionid, extension AS title
FROM dbtech_downloads_extension
WHERE dbtech_downloads_extensionid = 8;

MySQL Error : Unknown column 'dbtech_downloads_extensionid' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 27th 2013 @ 02:05:14 PM
Error Date : Wednesday, February 27th 2013 @ 02:05:14 PM
Script : http://www.mydomain.com/admincp/vbdownloads.php?do=extension&action=delete&extensionid=8
Referrer : http://www.mydomain.com/admincp/vbdownloads.php?do=extension
IP Address : myip
Username : myusername
Classname : vB_Database
MySQL Version : 5.0.96-community

 

[Fillip H.]

This will be fixed in the next Beta release, for now you can add a new plugin in the hook location admin_delete_confirmation with the following contents:

if (defined('IN_VBDOWNLOADS') AND $idfield == $table . 'id')
{
	$idfield = substr($table, strlen('dbtech_downloads_')) . 'id';
	$handled = true;
	
	$item = $vbulletin->db->query_first("
		SELECT $idfield, $titlename AS title
		FROM " . TABLE_PREFIX . "$table
		WHERE $idfield = '$itemid'
	");
}