1146 - Table 'websitezr_bans.mybb_users' doesn't exist
mdb Offline
Junior Member
**
Posts: 27
Joined: May 2012
Post: #1
1146 - Table 'websitezr_bans.mybb_users' doesn't exist
Hey guys,
So again, i'm working on a new custom php script that allows users to view a bans list from a database on our sql. The page works perfectly as far as I can tell, except for that error below keeps getting displayed below the footer. It only happens when I view the page while logged in, not as a guest.

Code:
SQL Error:
    1146 - Table 'websitezr_bans.mybb_users' doesn't exist
Query:
    UPDATE wszr_users SET lastactive='1343662650', timeonline=timeonline+7 WHERE uid='1' 


The script is connecting to our websitezr_bans database where the bans are stored. The page works perfectly except that error being displayed below the footer whilst i'm logged in. I'm assuming it's trying to update my time spent online but for some reason is searching for it within the bans database instead of the mybb forums database. I'm hoping you guys could take a look at my script and possibly see what i'm doing wrong / how to fix it? Below is a link to the script i'm using.

http://pastebin.com/CxmsX3Wc

Thanks guys!

07-31-2012 01:58 AM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
1146 - Table 'websitezr_bans.mybb_users' doesn't exist - mdb - 07-31-2012 01:58 AM

 Standard Tools
Forum Jump: