Quote:
Originally Posted by gemmagy
I tried to contact vbulletin to see if they could help me this is their answer:
It sounds like you are trying to install a resource from vBulletin.org. We do not give support for customizations as we aren't the author of that code. I suggest to contact the author of this resource. Ask him to update his code to take table prefixes into account. Your table prefix is jelsoft_ if I remember correctly.
please help!!!
|
Here's the email I got from my database when one of the mods went into the GUI pm:
Database error in vBulletin 3.0.6:
Invalid SQL:
DELETE FROM jelsoft_attachment
WHERE postid = 0 AND private = 0 AND
dateline < 1108738351
mysql error: Unknown column 'private' in 'where clause'
mysql error number: 1054
and,,,,,,,,,,,,,,,,,,,,,
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT
pm.*, pmtext.*,
icon.title AS icontitle, icon.iconpath,
IF(ISNULL(pmreceipt.pmid), 0, 1) AS receipt, pmreceipt.readtime, pmreceipt.denied, attach
FROM jelsoft_pm AS pm
LEFT JOIN jelsoft_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN jelsoft_icon AS icon ON(icon.iconid = pmtext.iconid)
LEFT JOIN jelsoft_pmreceipt AS pmreceipt ON(pmreceipt.pmid = pm.pmid)
WHERE pm.userid=3 AND pm.pmid=128
mysql error: Unknown column 'attach' in 'field list'
mysql error number: 1054