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

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
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, 345 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 - Getting Errors? Read This [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  This topic is locked: you cannot edit posts or make replies.printer-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
chatserv
General
General


Joined: Jan 12, 2003
Posts: 3128

Location: Puerto Rico

PostPosted: Mon Feb 10, 2003 10:10 am Reply with quoteBack to top

While most of this is covered in the welcome thread i decided to place them here to see if it helps users having these problems.
--------------------------------------------------------------------------------------
sql_layer.php errors

PHP-Nuke 5.6 and lower:

If getting errors that mention line 286 of sql_layer.php, open sql_layer.php and change lines 285-288 from:
Code:

    case "MySQL":
        $row = mysql_fetch_row($res);
        return $row;
    break;;

to:
Code:

    case "MySQL":
    if ($row = mysql_fetch_row($res)) {
    return $row;
    } else {
    print (mysql_error());
    }
    break;;


PHP-Nuke 6.0 and up

If getting errors that mention line 301 of sql_layer.php open sql_layer.php and change lines 300-303 from:
Code:

    case "MySQL":
        $row = mysql_fetch_row($res);
        return $row;
    break;;

to:
Code:

    case "MySQL":
    if ($row = mysql_fetch_row($res)) {
    return $row;
    } else {
    print (mysql_error());
    }
    break;;


Upload the modified sql_layer.php file and go back to your site, this modification will not fix the errors but will usually make the error more detailed, as an example the error may now contain another line that says:
table nuke_main does not exist.

This will help solve your problems as you now know what is causing it.
--------------------------------------------------------------------------------------
Users get a _ERROR message when they click finish on new registrations:

PHP-Nuke 5.6 and earlier:

Open modules/Your_Account/index.php and change line 154 from:
Code:

       echo ""._ERROR."<br>";

to:
Code:

       print (mysql_error());
       echo ""._ERROR."<br>";


PHP-Nuke 6.0 and up:

Open modules/Your_Account/index.php and change line 114 from:
Code:

       echo ""._ERROR."<br>";

to:
Code:

       print (mysql_error());
       echo ""._ERROR."<br>";


This will not fix the error but it will tell you what is wrong, usually a mismatch between the users table and the FinishNewUser function. Most of the time people that get this last error are those that have installed the phpBB port and they get it because they fail to upload all files that come with the port.

_________________
Feed a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
ScriptHeaven | NukeResources
Find all posts by chatservView user's profileSend private messageVisit poster's website
disgruntledtech
Site Admin
Site Admin


Joined: Apr 14, 2003
Posts: 991

Location: Tulsa, OK

PostPosted: Fri Oct 24, 2003 10:25 pm Reply with quoteBack to top

bumped from unanswered
Find all posts by disgruntledtechView user's profileSend private messageSend e-mailVisit poster's website
Display posts from previous:      
Post new topic  This topic is locked: you cannot edit posts or make replies.printer-friendly view
View previous topic Log in to check your private messages View next topic
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



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
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.052 Seconds - 251 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::