phpbb-auction.com Forum Index phpbb-auction.com
Download, Support, Documentation
 
Donate to phpbb-auction.com to support the project


phpbb-Auction
  Home
   - News
   - Bug report/Patches
   - Future Features
  Demo
  Downloads
   - Version 1.3m  (Core /Lang /Mods)
   - Version 1.2m  (Core /Lang /Mods)
   - Version 1.0m  (Core /Lang /Mods)
   - All
  Services
  Documentation
   - Features
   - Documents
   - How-Tos
   - About
  Support
   - English
   - German
  Development
   - Changlog
   - Requests
   - Team
   - CVS
  Community
   - Website of the Month
   - Websites
   - Community Forum
   - Member

Navigation
FAQFAQ
SearchSearch
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesLog in to check your private messages
Log inLog in

Forum
Changing start time auctions
Sun Feb 07, 2010 4:33 am FR
Easy: what code to use to update sql table?
Fri Oct 16, 2009 8:39 am guyb
Unlimited products(downloads)
Wed Oct 14, 2009 7:09 pm hoimyr
Seller chooses currency
Sun Oct 11, 2009 8:00 pm hoimyr
Cant select end date without getting error
Sun Oct 11, 2009 6:43 pm hoimyr

About
Author: FR
Credits:
Brookfresh, Brad Lawryk, Crogon, DaMysterious, EklipzeDesigns, ML, musashi, phpBB Group, phpBB-Auction-Team, php-styles, sanman, Tel, Vampy, wGEric

Supported Sites





Statistics
User: 17840
Posts: 18401
Latest User: douglaswg11

wierd, random "SQL error: 1146"

 
Post new topic   Reply to topic    phpbb-auction.com Forum Index -> Bug report-Patches Version 1.3m
View previous topic :: View next topic  
Author Message
guyb
Small-Cap Auctioneer
Small-Cap Auctioneer


Joined: 22 Oct 2008
Posts: 21

PostPosted: Thu Nov 13, 2008 10:35 pm    Post subject: wierd, random "SQL error: 1146" Reply with quote

I've had a few instances in the last week or so where I randomly receive the following error when I log in - but the referenced table *does* exist in my SQL DB (I've checked):


General Error

Could not obtain user/online information

DEBUG MODE

SQL Error : 1146 Table 'myforum.AUCTION_OFFER_TABLE' doesn't exist

SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip, o.FK_auction_offer_user_id FROM phpbb_users u, phpbb_sessions s, AUCTION_OFFER_TABLE o WHERE u.user_id = s.session_user_id AND s.session_time >= 1226614146 ORDER BY u.username ASC, s.session_ip ASC

Line : 109
File : page_header.php


The referenced line relates to this code (lines 99-109):
Code:

   $user_forum_sql = ( !empty($forum_id) ) ? "AND s.session_page = " . intval($forum_id) : '';
   $sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip
      FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
      WHERE u.user_id = s.session_user_id
         AND s.session_time >= ".( time() - 300 ) . "
         $user_forum_sql
      ORDER BY u.username ASC, s.session_ip ASC";
   if( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not obtain user/online information', '', __LINE__, __FILE__, $sql);
   }


Sometimes it goes away after half an hour or so; once I even cleared my cache and things were fine.

As my auction mod is heavily modded now (although it's worked fine so far), does anyone have any ideas what causes such a random and incorrect error like this?
Back to top
View user's profile Send private message
FR
Site Admin
Site Admin


Joined: 26 Jan 2004
Posts: 1764
Location: root directory

PostPosted: Tue Feb 03, 2009 2:35 pm    Post subject: Reply with quote

it looks like you either did not update the constants-file with the table names or you did not include the files properly so he can find the resolution for AUCTION_OFFER_TABLE...
_________________
Want to say thank you. Use my Amazon Wishlist
Meet the world on movie-on.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    phpbb-auction.com Forum Index -> Bug report-Patches Version 1.3m All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


phpbb-auction.com - Developed by www.digital-media-lab.com
Sponsored by: www.globibo.com - www.learn2go.de - www.talentone.org - www.language-school.in - www.ping-ke.cn