Hi, I desperately hope someone can help me. Ever since I moved from 1and1 to ASO hosting, I've not been able to place banner ads in my VB header. It works fine when by itself:
http://www.warwickshireonline.com/extra/header2.php
But as soon as I try to impliment it into the header here (
www.warwickshireonline.com), I get database problems.
Using this code:
Code:
<?php
if (@include(getenv('DOCUMENT_ROOT').'/extra/ads/phpadsnew.inc.php')) {
if (!isset($phpAds_context)) $phpAds_context = array();
$phpAds_raw = view_raw ('zone:1', 0, '', '', '0', $phpAds_context);
echo $phpAds_raw['html'];
}
?>
I get this error:
Code:
Database error in vBulletin 3.6.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, infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1155650796
ORDER BY username ASC;
MySQL Error : Table 'wills205_warksads.session' doesn't exist
Error Number : 1146
Date : Tuesday, August 15th 2006 @ 11:06:36 AM
Script : http://www.warwickshireonline.com/
Referrer :
IP Address : 172.213.138.238
Username : Unregistered
Classname : vb_database
Please advise, it worked fine with my old host and this is really frustrating me.
DOH! Nevermind I've just figured it out!