Bug Issue after upgrade of vbDownloads with old database category links causing errors

[bzcomputers]

After upgrading vbDownloads from 1.3.8 to 2.1.0 I've noticed people who linked to the old categories are now getting database errors.

The old links are attempting to come in as: ?do=listings&catid=X

While the new links are: ?categoryid=X

The database is throwing the following error on these old category links.

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT filegroup.*, cat.*, filegroup.image AS image, user.username, user.userid FROM dbtech_downloads_filegroup AS filegroup
INNER JOIN user AS user ON (user.userid = filegroup.userid)
LEFT JOIN dbtech_downloads_categories AS cat ON (cat.catid = filegroup.categoryid)
WHERE filegroup.categoryid = 2
ORDER BY filegroup.updated DESC;

MySQL Error : Table 'cruisin_forum.dbtech_downloads_filegroup' doesn't exist
Error Number : 1146
Request Date : Saturday, June 22nd 2013 @ 03:42:53 PM
Error Date : Saturday, June 22nd 2013 @ 03:42:54 PM
Script : http://www.cruisin.me/downloads/index.php?do=listings&catid=2
Referrer : Main Dining Room - Carnival Cruise Lines - CRUISIN
Classname : vB_Database
MySQL Version : 5.5.31-cll
​

 

[Fillip H.]

Please delete all files except the following from /dbtech/downloads/actions :

• ajax.php
• comment.php
• download.php
• favourites.php
• file.php
• index.html
• main.php
• modcp.php
• search.php

 

[bzcomputers]

Please delete all files except the following from /dbtech/downloads/actions :

• ajax.php
• comment.php
• download.php
• favourites.php
• file.php
• index.html
• main.php
• modcp.php
• search.php

Did this and now database error is gone, thanks.

Is there an .htaccess mod rewrite line I can use to forward the old category urls? I'd try and make one but with all the escaping involved I'd probably be at it for awhile.

 

[Fillip H.]

Unfortunately my knowledge of .htaccess is not much better

 

[bzcomputers]

Unfortunately my knowledge of .htaccess is not much better

Alright, thanks anyway. When I come up with something I'll post it back here.

 

[bzcomputers]

Here is the .htaccess re-write code to forward the old category links to the new links:

This should be placed in your forum directory .htaccess. If your forum is in your root place this in your root .htaccess.

RewriteEngine On
RewriteCond %{QUERY_STRING} ^do=listings&catid=(.*)$
RewriteRule ^(vbdownloads\.php)?$ "http\:\/\/www\.[COLOR="#FF0000"]yoursitename[/COLOR]\.[COLOR="#FF0000"]com[/COLOR]\/[COLOR="#FF0000"]yourforumpath[/COLOR]\/vbdownloads\.php?categoryid=%1" [R=301,L]

Change the code in red above for your specific site.

If your forum is placed in your site root remove the following from the 3rd line:

[COLOR="#FF0000"]yourforumpath[/COLOR]\/