[Neal-UK]

Originally Posted by jluerken

Hi author,

I found a bug in the request award section.

I am using table prefixes in my installation and request_award is not taking care about this.

Everytime a user requests an award I get this db error:

PHP Code:

Database error in vBulletin 3.0.7:
 
Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'88856','CFN|LordSoth Award Request Form','CFN|LordSoth','4','1117187527','Award Request Form - CFN|LordSoth
 
------------------
Sender Information
 
UserID: 4
Username: CFN|LordSoth
Fullname: CFN|LordSoth
 
-----------------------------
Request Information:
Award ID: 3
Award Name: Donationaward
Award Description: Thanks for your donation
[img]http://www.clanforums.com/forum/images/medals/contributoraward.gif[/img]
 
Recipient username : Toky 
 
-----------------------------------------------------
Please explain why the listed recipient should receive the award.
 
Sponsoring
-----------------------------------------------------
','1','1','0','0','1')
mysql error: Table 'usr_web1_3.post' doesn't exist
 
mysql error number: 1146 


The table name is not usr_web1_3.post, its usr_web1_3.vb3_post where vb3_ is the prefix


The error is in request_award.php around line 40
And line 41 has the same error. It should be:

PHP Code:

UPDATE " . TABLE_PREFIX . "thread SET 


I've just had to edit this template in about 8 places to put my db prefix in as i have FORUM before the name.

Is this the mod I only need to do or will other things need to be adjusted to get it working 100%? Don't want new errors on a newly re-installed forum and db.