Bug Database error when opening a pm

[Mica]

Set the board into maintenance mode and proceeded with install. Installation went smooth, took a few moments and set all of the settings the way I wanted them. I reopened the board from maintenance mode. Board was operating and I proceeded to the private message system. All of messages in my inbox could be seen but when I clicked on an individual pm to read its content, I received the following MySql database error.

Database error in vBulletin 4.2.0:

Invalid SQL:

				
			SELECT
				fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
				a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
				at.contenttypes
				 
			FROM attachment AS a
			INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
			LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
			
			
				WHERE
					a.contentid = 480223
						AND
					a.contenttypeid = 
				
			
ORDER BY a.contentid, a.displayorder;

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 'ORDER BY a.contentid, a.displayorder' at line 17
Error Number  : 1064
Request Date  : Tuesday, May 28th 2013 @ 01:31:22 AM
Error Date    : Tuesday, May 28th 2013 @ 01:31:23 AM
Script        : http://micompanions.com/vbforum/private.php?do=showpm&pmid=788516
Referrer      : https://micompanions.com/vbforum/private.php
IP Address    : 71.95.237.26
Username      : Mica
Classname     : vB_Database
MySQL Version : 5.1.68-cll

I saved the error and disabled the mod, all is working with the mod disabled. Any suggestions for fixing this db error?

I am using the following skins on my site from blue pearl skins

Store - BP-Light vBulletin Skins

 

[Fillip H.]

Could you please create and PM me with a temporary FTP and AdminCP account?

For security reasons, we recommend you create a new FTP account only for DBTech support, then disable or delete it after we have both confirmed the issue has been solved and there are no further issues.

The same applies to AdminCP accounts; they should ideally be temporary accounts created for us only. If we have created an account on your site already, you can optionally boost that account to Administrator and then de-admin this account once the issue has been solved.

If you use a .htaccess password protection for your AdminCP directory, it is recommended that you create a new authorised user for DBTech and remove this user once the issue has been solved.

Please test any temporary accounts you create to ensure that the FTP account has access to the forum files, and that the AdminCP account can access the administrative controls for the product we are assisting you with.

Ensuring this is all in order before submitting the information will significantly speed up the process of assisting you. We will alert you via PM if there's any issues with the login information you have provided.

When sending the PM, for your security you should also un-tick the "Save a copy in my Sent Items folder" checkbox. When the access details have been received, we will delete the PM from our inbox. Ensuring you have not kept a copy of the PM reduces the risk of security breaches.

Thank you for helping us debug our products and allowing us to assist you, we appreciate it

 

[Mica]

Info has been pm'ed to you with all of the account info. Thank you!

 

[Fillip H.]

Your forum was missing a critical part of the database - I'm highly surprised your PMs worked at all, much less this mod.

I've re-added the missing database entry, and the mod works fine now.

 

[Mica]

Thank You!

Very speedy fix. I am off to buy the next dbtech mod I want for the site.

Thank you once again.