I also get the "MySQL Error : Table 'XXXXX_phpads.session' doesn't exist" error.
In fact, i get 2 SQL on the same page.
Before the upgrade to 3.5, it worked fine, and after the upgrade, I copied and pasted the exact code from the phpinclude_start template into a plugin with the global_start hook.
This is the code
Code:
if (@include('/var/vhosts/com/s/i/s/sistersofbreastfeeding/htdocs/_/adserver/phpadsnew.inc.php')) {
if (!isset($phpAds_context)) $phpAds_context = array();
$phpAds_raw = view_raw ('zone:4', 0, '_blank', 'http://sistersofbreastfeeding.com', '0', $phpAds_context);
$banner = $phpAds_raw['html'];
}
these are the errors:
Code:
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1128146372
ORDER BY username ASC;
MySQL Error : Table 'sisters_adserver.session' doesn't exist
Error Number : 1146
Date : Friday, September 30th 2005 @ 11:14:32 PM
Script : http://www.sistersofbreastfeeding.com/boards/index.php?
Referrer : http://www.sistersofbreastfeeding.com/boards/online.php?order=asc&sort=username&pp=20&page=1
IP Address : 24.16.63.220
Username : MrWee
Classname : vb_database
Code:
Database error in vBulletin 3.5.0:
Invalid SQL:
UPDATE session
SET lastactivity = 1128147272, location = '/boards/index.php?', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '44b217e04e55e3ca3491ffed6ee9020b';
MySQL Error : Table 'sisters_adserver.session' doesn't exist
Error Number : 1146
Date : Friday, September 30th 2005 @ 11:14:33 PM
Script : http://www.sistersofbreastfeeding.com/boards/index.php?
Referrer : http://www.sistersofbreastfeeding.com/boards/online.php?order=asc&sort=username&pp=20&page=1
IP Address : 24.16.63.220
Username : MrWee
Classname : vb_database
Thanks in advance for your help