| Da-Vinci |
09-23-2011 10:24 PM |
Hi Ted, I didn't have the product enabled in the forums, guess I missed that, DOH!!!
But when I try to enable it I get this Database error.
Code:
Database error in vBulletin 4.1.5:
Invalid SQL:
UPDATE forum SET
title_clean = 'General',
title = 'General',
description_clean = '',
description = '',
link = '',
displayorder = 1,
parentid = 29,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options, options + 8192),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options - 256, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
options = IF(options & 131072, options - 131072, options),
styleid = 0,
imageprefix = '',
password = '',
forumiconimg = 'cartman.png',
forumiconimg_forum_height = '50',
forumiconimg_forum_width = '50',
default_tags = '',
productforumsbits = '1',
default_tags_ids = ''
WHERE forumid = 34;
MySQL Error : Unknown column 'productforumsbits' in 'field list'
Error Number : 1054
Request Date : Saturday, September 24th 2011 @ 12:49:55 AM
Error Date : Saturday, September 24th 2011 @ 12:49:56 AM
Script : http://www.cameraguru.co.uk/admincp/forum.php?do=update
Referrer : http://www.cameraguru.co.uk/admincp/forum.php?do=edit&f=34
IP Address : 78.144.36.145
Username : Pablo
Classname : vB_Database
MySQL Version : 5.0.22-Debian_0ubuntu6.06.11
If I try to select Manage Products & Reviews I get this Database error.
Code:
Database error in vBulletin 4.1.5:
Invalid SQL:
SELECT COUNT(productid) AS count FROM pf_product;
MySQL Error : Table 'cameraguru.pf_product' doesn't exist
Error Number : 1146
Request Date : Saturday, September 24th 2011 @ 12:57:07 AM
Error Date : Saturday, September 24th 2011 @ 12:57:07 AM
Script : http://www.cameraguru.co.uk/admincp/productforums.php?do=productforums
Referrer : http://www.cameraguru.co.uk/admincp/index.php?do=nav
IP Address : 78.144.36.145
Username : Pablo
Classname : vB_Database
MySQL Version : 5.0.22-Debian_0ubuntu6.06.11
And if I try to uninstall the product I get this.
Code:
Database error in vBulletin 4.1.5:
Invalid SQL:
DROP TABLE `pf_product`;
MySQL Error : Unknown table 'pf_product'
Error Number : 1051
Request Date : Saturday, September 24th 2011 @ 12:58:57 AM
Error Date : Saturday, September 24th 2011 @ 12:58:58 AM
Script : http://www.cameraguru.co.uk/admincp/plugin.php?do=productkill
Referrer : http://www.cameraguru.co.uk/admincp/plugin.php?do=productdelete&productid=product_forums&s=
IP Address : 78.144.36.145
Username : Pablo
Classname : vB_Database
MySQL Version : 5.0.22-Debian_0ubuntu6.06.11
Obviously I'm missing the table pf_product but how do I add that table to my database?
I've tried overwriting the product but it hasn't helped. |
More Information