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, 54 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 - SQL Error : 1064 You have an error in your SQL syntax near.. [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
x
Corporal
Corporal


Joined: Mar 25, 2003
Posts: 57

Location: Puerto Rico

PostPosted: Tue Apr 29, 2003 11:42 am Reply with quoteBack to top

I have a smallish question though... can anyone tell me what this error means? I get this error when I am trying to add the God Account to the adminsitration of certain forums. It also happens when I try to add one of my admins to the forums as the moderator.


Couldn't delete auth access info

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'AND auth_mod = 0' at line 3

DELETE FROM nuke_bbauth_access WHERE group_id = AND auth_mod = 0

Line : 175
File : /usr/local/apache/htdocs/modules/Forums/admin/admin_ug_auth.php
Find all posts by xView user's profileSend private messageVisit poster's websiteMSN MessengerICQ Number
disgruntledtech
Site Admin
Site Admin


Joined: Apr 14, 2003
Posts: 994

Location: Tulsa, OK

PostPosted: Tue Apr 29, 2003 11:47 am Reply with quoteBack to top

you need PHP-Nuke 6.5 Bug-Sec Patch 3

Quote:
Third compillation of fixes to known PHP-Nuke 6.5 bugs, Just upload to the main Nuke folder so that the included files replace the existing ones.
Fixes:
1-Private Messages within the Journal module broken link due to lines that were meant to be commented
breaking the code.
2-Link to Offsite avatars not displaying.
3-Error when clicking the e-mail button in member list.
4-Clicking page number causes invalid session message on Forums.
5-Forum asks to delete install/ and contrib/ directories.
6-Saving Forum profile info changes theme.
7-Couldn't delete auth access info.
8-phpBB logo broken link in the phpBB admin section.
9-Preview Forum: call to undefined function: opentable.
10-Broken rank images in Forum admin section.
11-Avatars not showing when editing a user in the Forum Admin.
12-Broken links in Forums admin section.
13-Can't post on Content module with single quotes.
14-Language Catala does not work.
15-User Info block displays incorrect private message count.
16-Forum tables use $user_prefix instead of the correct $prefix.
17-RSS blocks add a backslash to any link with single quotes.
18-Incorrect phpBB version.
19-Session length is set to 0 by default.
20-Can't post on Encyclopedia module with single quotes.

Author: chatserv (chatserv at nukeresources dot com)


all hail chatserv!

http://nukecops.com/downloads-file-71-details-PHP-Nuke_6.5_Bug-Sec_Patch_3.html
Find all posts by disgruntledtechView user's profileSend private messageSend e-mailVisit poster's website
x
Corporal
Corporal


Joined: Mar 25, 2003
Posts: 57

Location: Puerto Rico

PostPosted: Thu May 01, 2003 4:07 pm Reply with quoteBack to top

quote="disgruntledtech"]you need PHP-Nuke 6.5 Bug-Sec Patch 3

Author: chatserv (chatserv at nukeresources dot com)[/quote]

all hail chatserv!

http://nukecops.com/downloads-file-71-details-PHP-Nuke_6.5_Bug-Sec_Patch_3.html[/quote]

when you uncompress the file, inside html, there are like 20 *.html files.. what are they for?


X
Find all posts by xView user's profileSend private messageVisit poster's websiteMSN MessengerICQ Number
disgruntledtech
Site Admin
Site Admin


Joined: Apr 14, 2003
Posts: 994

Location: Tulsa, OK

PostPosted: Thu May 01, 2003 4:24 pm Reply with quoteBack to top

read fixchanges.txt
Quote:
7-File: admin_ug_auth.php

Change all instances of:
WHERE group_id = $group_id
to:
WHERE group_id = '$group_id'


or just upload all the files over writing your originals
Find all posts by disgruntledtechView user's profileSend private messageSend e-mailVisit poster's website
x
Corporal
Corporal


Joined: Mar 25, 2003
Posts: 57

Location: Puerto Rico

PostPosted: Fri May 02, 2003 1:08 am Reply with quoteBack to top

disgruntledtech wrote:
read fixchanges.txt
Quote:
7-File: admin_ug_auth.php

Change all instances of:
WHERE group_id = $group_id
to:
WHERE group_id = '$group_id'


or just upload all the files over writing your originals


I did that and now my forums are screwedup with these errors:

Warning: Cannot add header information - headers already sent by (output started at /usr/local/apache/htdocs/header.php:32) in /usr/local/apache/htdocs/includes/sessions.php on line 251

Warning: Cannot add header information - headers already sent by (output started at /usr/local/apache/htdocs/header.php:32) in /usr/local/apache/htdocs/includes/sessions.php on line 252
Find all posts by xView user's profileSend private messageVisit poster's websiteMSN MessengerICQ Number
chatserv
General
General


Joined: Jan 12, 2003
Posts: 3128

Location: Puerto Rico

PostPosted: Fri May 02, 2003 6:45 am Reply with quoteBack to top

Near the start of mainfile.php find:

$phpver = phpversion();
if ($phpver >= '4.0.4pl1' && strstr($HTTP_USER_AGENT,'compatible')) {
if (extension_loaded('zlib')) {
ob_end_clean();
ob_start('ob_gzhandler');
}
} else if ($phpver > '4.0') {


change to:

$phpver = phpversion();
if ($phpver >= '4.0.4pl1')
{
ob_start('ob_gzhandler');
}else if ($phpver > '4.0') {

_________________
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
Display posts from previous:      
Post new topic  Reply to topicprinter-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
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.187 Seconds - 301 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::