» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 58
0 members and 58 guests
No Members online
Most users ever online was 611, 03-21-2008 at 11:10 PM.
» .::.
Web Hosting - web hosting, dedicated servers and web design services
Online Degree - search for 1000+ online degrees, online colleges & online universities.
Tattoo - we are a group of tattoo enthusiasts
Gexa Energy - your absolute best choice in electric service
Texas electricity - save on electric rates
Football Betting - best nfl betting promotions at sportsbook.com.
Oral Chelation - initial cleansing of your veins & arteries
Portatiles - Ofertas en Ordenadores y Portatiles. Increibles Ofertas DELL.

Register Now! Contact Us

About this Page
This is a discussion on Forum SQL errors within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; I have searched around the forums and see that 1064 is a common problem, however nothing relates to this 1064, ...


Go Back   Nukemods Forum » PHP-Nuke 7.x » Nuke 7.x - General

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-31-2005, 03:30 AM
Junior Member
 
Join Date: Nov 2004
Posts: 1
Forum SQL errors
I have searched around the forums and see that 1064 is a common problem, however nothing relates to this 1064, I have spent the last hour searching before posting my problems.

Error getting user list for group


This one is for usergroups on the forums
Code:
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 = '3' AND u.user_id = ug.user_id AND ug.user_pending = '0' AND ug.user_id <> ORDER BY u.username

Line : 796
File : /modules/Forums/groupcp.php
Another forum problem:

This one is for userlist within the admin section of the forums.
Code:
Could not count Users

DEBUG MODE

SQL Error : 1054 Unknown column 'uid' in 'field list'

SELECT uid FROM nuke_users WHERE uid > 0

Line : 74
File : /home/calton22/public_html/radio/modules/Forums/admin/admin_users_list.php
Third problem relates to my sites avatars, anytime I try to delete any that are un-used I get:

Code:
The requested URL /modules/Forums/admin/modules.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Errors on my phpnuke forum. :( can you help? gsfmrmoo Other "stuff" 7 03-20-2005 04:57 PM
Parse Errors? marston Open topics 1 01-10-2005 09:47 AM
fiblack3d forum errors with 6.9.1 Silentprophet Theme packs 9 11-10-2004 06:57 AM
Forum Avatar errors SuperConductor Site design 2 04-29-2003 07:43 AM
PHPBB Errors. nick Purged Topics 11 11-18-2002 10:56 AM


All times are GMT -5. The time now is 11:43 AM.


Design by Vjacheslav Trushkin, color scheme by ColorizeIt!.

LinkBacks Enabled by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31