Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Battlefield 3 Stats Module

User Box

Anonymous

38.107.179.219

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ?This sh...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriousl...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Error in sql syntax

Error in sql syntax

7 Replies / 1347 Views


www.clanthemes.com Forum Index » PHPBB	View previous topic :: View next topic

MayhemX1
Reputation: 8.3
Local time: 10:24 PM
Location: Norway

Armour Whore

0.04 posts per day
Medals: 0

Joined: Feb 09, 2009
Last Visit: 18 Jul 2009
Posts: 40
Points: 7901

Error in sql syntax Posted: Mon Mar 23, 2009 2:24 pm
Shop Purchases:Multi Gaming (Warrior) Evo Theme · Clan Roster 2.0

I was making a private forum for my clan members and when i go to add the proper individual permissions,i get this error.. Can someone please explain to me what this means,and how to fix this? Here is the error i get :

Code:

Could not obtain moderator status

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 ') AND aa.group_id = ug.group_id AND aa.auth_mod ' at line 3

SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM nuke_bbauth_access aa, nuke_bbuser_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id

Line : 621
File : admin_ug_auth.php

Another problem i have with the forums,is that when in the forum management,when i try to move the forums up or down nothing happens. Why's that?

I'm running Nuke-Evo 2.0.7

floppy
Reputation: 2087.2
votes: 22
Local time: 4:24 PM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Re: Error in sql syntax Posted: Mon Mar 23, 2009 8:43 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Man, wish I could help, I just not a big fan of EVO.

Phpnuke Downloads | VMaxxRx Male Enhancement

MayhemX1
Reputation: 8.3
Local time: 10:24 PM
Location: Norway

Armour Whore

0.04 posts per day
Medals: 0

Joined: Feb 09, 2009
Last Visit: 18 Jul 2009
Posts: 40
Points: 7901

Error in sql syntax Posted: Mon Mar 23, 2009 11:23 pm
Shop Purchases:Multi Gaming (Warrior) Evo Theme · Clan Roster 2.0

It's ok floppy. Been trying to solve this all day,and still havent gotten any further with my problem.. Dont Know

floppy
Reputation: 2087.2
votes: 22
Local time: 4:24 PM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Re: Error in sql syntax Posted: Mon Mar 23, 2009 11:27 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Well I suggest rethinking the problem. Have you added any mods since you tried this last?

If not, try to google the problem, if that doesn't work try asking at evo extreme website.

I just never ever installed EVO on my local, so I am really no help on this one.

Snype
Reputation: 305.5
votes: 8
Local time: 9:24 PM
Location: lincolshire

0.60 posts per day
Medals: 1 (View more...)

Respected Member

Joined: May 20, 2008
Last Visit: 06 Nov 2011
Posts: 812
Points: 60742

Error in sql syntax Posted: Tue Mar 24, 2009 12:37 am
Shop Purchases:Call of Duty 4 SAS Theme

the most common result of this is a module not ported correctly according to my search results but these are some links with some fixes dont know if they will evan come in handy.

http://www.karakas-online.de/forum/viewtopic.php?t=3264&start=0&postdays=0&postorder=asc&highlight=
http://ravenphpscripts.com/postt15645.html

WebSite > http://www.phpnukeblog.info Xfire > DDsnype MSN > ritchietaylor@live.co.uk Email > admin@phpnukeblog.info

DreAdeDcoRpSE
Reputation: 2221.6
votes: 28
Local time: 4:24 PM
Location: Back of your Mind

Forums Moderator

1.53 posts per day
Medals: 3 (View more...)

Site Admin

Joined: Sep 22, 2007
Last Visit: 09 Feb 2012
Posts: 2459
Points: 128871

Re: Error in sql syntax Posted: Tue Mar 24, 2009 3:12 am
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 · · Modern Warfare 3 Xtreme Theme

That can be a problem. If you installed any modules/blocks/themes recentaly since this error started, then go through them and you must see if they working with the “old” inquiry.

Read more here..

http://www.clanthemes.com/modules.php?name=Forums&file=viewtopic&p=26217&highligt=re-ct-green-and-ravennuke-compatibility#26217

(*)But here is a suggestions I have for you to try,

1.Download the file that I am providing below.
2. Upload the included fixgroup.php located in the FixGroup folder to your modules/Forums folder.
3. Point your browser to http://www.yoursite.com/modules.php?name=Forums&file=fixgroup
4. You should see that all existing users were assign to a usergroup
5. Delete the fixgroup.php in modules/Forums folder again.
6. Alter permissions in Forum ACP -> User Admin -> Permissions

Hope this helps a little.

FixGroups.zip

Description:

Download

Filename:

FixGroups.zip

Filesize:

1.38 KB

Downloaded:

6 Time(s)

MayhemX1
Reputation: 8.3
Local time: 10:24 PM
Location: Norway

Armour Whore

0.04 posts per day
Medals: 0

Joined: Feb 09, 2009
Last Visit: 18 Jul 2009
Posts: 40
Points: 7901

Error in sql syntax Posted: Tue Mar 24, 2009 12:07 pm
Shop Purchases:Multi Gaming (Warrior) Evo Theme · Clan Roster 2.0

Yes! That did the trick,coRpSE. Finally. Pint

I don't know really what caused this to happend in the first place,but i have a suspicion that it could have something to do with either the birthday or reputation features that was in the pro pack i installed. Maybe i did something wrong in the progress there,since all this started right after that install.

But it's working again,thx floppy,snype & coRpSE for your help. Greatly appreciated.

DreAdeDcoRpSE
Reputation: 2221.6
votes: 28
Local time: 4:24 PM
Location: Back of your Mind

Forums Moderator

1.53 posts per day
Medals: 3 (View more...)

Site Admin

Joined: Sep 22, 2007
Last Visit: 09 Feb 2012
Posts: 2459
Points: 128871

Re: Error in sql syntax Posted: Tue Mar 24, 2009 7:02 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 · · Modern Warfare 3 Xtreme Theme

MayhemX1 wrote:

Yes! That did the trick,coRpSE. Finally. Pint

n/p

I found sometimes and I don't know why, but the way that you set up a group and the order you do it in and set up the private area dan cause this error, You can try watching this video where I do go over the correct steps to go with.

http://www.clanthemes.com/tutorials-view-172-set-up-your-forums-and-have-hidden-catagories.html

but glad to hear its working now.

www.clanthemes.com Forum Index » PHPBB

7 Replies / 1347 Views
Page 1 of 1
All times are GMT

Display posts from previous:

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
You cannot attach files in this forum
You can download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work