Bug database Error after i set up auto post new thread / new posts

[undertable99]

Hi every was fine until i decided to open thread settings. i set it on and when someone make a donations i am receiving this database error. It was written as unregistered members but they are actually registered users. Sometimes it does show a moderated post/thread but sometimes none. Have i done anything wrong?

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT *
FROM vb4dbtech_vbdonate_donations
WHERE id =;

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 '' at line 3
Error Number : 1064
Request Date : Tuesday, April 23rd 2013 @ 02:31:07 AM
Error Date : Tuesday, April 23rd 2013 @ 02:31:07 AM
Script : http://undertable99forum.com/vbdonate_gateway.php
Referrer :
IP Address : 66.211.170.66
Username : Unregistered
Classname : vB_Database
MySQL Version :

This is my setting :

 

[Ozzy47]

I'll check it out later today when I get home from work.

 

[undertable99]

Sure=) Thanks ozzy!

 

[Ozzy47]

I have not forgot about this, just been quite busy.

 

[undertable99]

I do understand=) Just get back when you are more free. Its still not giving much problems except the id cant be found...

 

[Ozzy47]

I will take a look at it this week if all goes to plan.

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 authorized 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

 

[undertable99]

Hi ozzy , i am sorry for the late reply. I was in hospital for some treatment till now. I will be sending all the login account details over via pm now.

I have a new problem. I have close the auto new post/new thread function temporary and after that i received errors. It does not auto move my donators to new usergroup nor update the new award image to them. I need to manually update it in order for it to work. Please kindly help me to rectify it. Thank you very much in advance.


PS: i am not very good with all these.

Like this:
Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE vb4usertextfield
SET
rank = '<img src="images/ranks/logosponsor.png" alt="" border="" />'
WHERE usertextfield.userid = '6724';

MySQL Error : Unknown column 'usertextfield.userid' in 'where clause'
Error Number : 1054
Request Date : Thursday, May 16th 2013 @ 08:22:12 PM
Error Date : Thursday, May 16th 2013 @ 08:22:13 PM
Script : http://abc.com/vbdonate_gateway.php
Referrer :
IP Address : 173.0.81.1
Username : Unregistered
Classname : vB_Database
MySQL Version :

 

[Ozzy47]

Sounds like there is some missing stuff in the DB, I'll check it out in awhile.