SQL Error : 1064

Nuke Cadet Joined: Jan 09, 2006 Posts: 1

I got the following error trying to add a user account as moderator to a forum through section "User Admin > Permissions". I'm running BBtoNuke 2.0.7 by Nuke Cops.

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 = 1

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 : 528
File : admin_ug_auth.php

Support Mod Joined: Oct 19, 2004 Posts: 1032 Location: UK

firstly this will fix your problem.

http://nukecops.com/postp83601.html

Secondly, I highly recomend you upgrade your forums to at least 2.0.15.

It takes 5 minutes to get past 2.0.7.

Please use the search function in future.

Many Thanks

Nuke Cadet Joined: May 22, 2006 Posts: 3

I searched and tried fixes, my errors changed twice but not fixed any help or pointers for me to fix this? www.the77clan.com thanks anyone...

Code:

Error getting user list for group

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 'ORDER BY u.username' at line 7

SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending FROM nuke_users u, nuke_bbuser_group ug WHERE ug.group_id = '7' AND u.user_id = ug.user_id AND ug.user_pending = '0' AND ug.user_id <> ORDER BY u.username

Line : 797
File : groupcp.php

Site Admin Joined: Jun 18, 2004 Posts: 208

well that message codes meaning unable to insert

and looking at the sql shows this

nuke_bbuser_group

which is possibly from a mod you have installed and you have not done all the edits correctly

try this may work

ALTER TABLE nuke_users DROP bbuser_group;

then see if it works

thanks

steve

Nuke Cadet Joined: May 22, 2006 Posts: 3

thanks steve i will try that and post later today when i arrive home from work.

Nuke Cadet Joined: May 22, 2006 Posts: 3

SQL query:

ALTER TABLE nuke_users DROP bbuser_group

MySQL said: Documentation
#1091 - Can't DROP 'bbuser_group'. Check that column/key exists

Can I upload new original files, which I believe I tried. I turned off cash mod and other unessicary stuff. It also happens when I try to change forum permissions for users, I get an SQL error. Getting confused but dont want to restore.