You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 

Author: mikemLocation: Corn fields of IndianaPostPosted: Wed Jun 18, 2003 8:04 am    Post subject: Re: Guests get error message

You answered yourself here bud.

uninstall your MODS restore your original files.(obvious mis-installation of a mod is possible)
If the problem is gone then ATTEMPT to install your mods again, one ata time, checking after each to see if the error persists.

mikem



Nuke Cops -> BBtoNuke Installation

All times are GMT - 8 Hours

Page 1 of 1

Powered by phpBB © 2001,2002 phpBB Group
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 129 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Guests get error message Guests get error message

Nuke Cops -> BBtoNuke Installation

Author: help PostPosted: Wed Jun 18, 2003 7:46 am    Post subject: Guests get error message

I installed a couple of MODS for phpbb and now when a guest enters the forum an error appears

Code:
phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

SELECT u.*, s.* FROM nuke_bbsessions s, nuke_users u WHERE s.session_id = '' AND u.user_id = s.session_user_id AND session_time >
Line : 280
File : /home/arnolzh/public_html/includes/sessions.php


here's the session.php part referring to the error

Code:
//
      // session_id exists so go ahead and attempt to grab all
      // data in preparation
      //
      $sql = "SELECT u.*, s.*
         FROM " . SESSIONS_TABLE . " s, " . USERS_TABLE . " u
         WHERE s.session_id = '$session_id'
            AND u.user_id = s.session_user_id AND session_time > $expiry_time";
      if ( !($result = $db->sql_query($sql)) )
      {
         message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch', '', __LINE__, __FILE__, $sql);
      }

      $userdata = $db->sql_fetchrow($result);


could you help me pls? Sad
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.412 Seconds - 313 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
added by Evaders - DO NOT REMOVE
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::