When I click on
http://www.surfzone.se/forum/profile.php?do=fbb_pages to enable publish to page account I get this error
Database error in vBulletin 3.8.2:
Invalid SQL:
UPDATE `forum`
SET fbtarget_id_permission_granted = '106985142665342'
WHERE fbtarget_id = '106985142665342';
MySQL Error : Table 'forum1-latin.forum' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 30th 2010 @ 02:54:52 PM
Error Date : Tuesday, March 30th 2010 @ 02:54:52 PM
Script :
http://www.some.com/forum/profile.ph...publish_stream
Referrer :
http://www.some.com/forum/profile.php?do=fbb_pages
IP Address : 1.1.1.1
Username : ?????
Classname : vB_Database
MySQL Version : 5.0.67-0ubuntu6.1-log
Missing table prefix in some code?
Found it in hook_profile_start.php
$vbulletin->db->query_write("
UPDATE `
forum`
SET fbtarget_id_permission_granted = '$tmp'
WHERE fbtarget_id = '$pageid'
");
The table prefix is missing. I hardcoded my prefix and now it works fine.