Thread
:
mySQL Error #1064
View Single Post
#
1
08-17-2002, 01:36 AM
Dex
Join Date: Dec 2001
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
mySQL Error #1064
This is what my board tells me when I try to change the status of a user (Registered -> Admin):
Quote:
Database error in vBulletin Control Panel 2.2.1:
Invalid SQL: SELECT COUNT(*) AS users FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND usergroup.cancontrolpanel=1 AND user.userid<>
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Friday 16th of August 2002 02:23:41 PM
Script:
http://www.*****.org/memberarea/memb...admin/user.php
Referer:
http://www.*****.org/memberarea/admi...dit&userid=209
I'd appreciate if somebody could help me out, since I'm not all too familiar with PHP and mySQL.
Thanks in advance,
Dex
Dex
View Public Profile
Visit Dex's homepage!
Find all posts by Dex
X
vBulletin 3.8.12 by vBS Debug Information
Page Generation
0.01644 seconds
Memory Usage
1,761KB
Queries Executed
11
(?)
More Information
Template Usage:
(1)
SHOWTHREAD_SHOWPOST
(1)
ad_footer_end
(1)
ad_footer_start
(1)
ad_header_end
(1)
ad_header_logo
(1)
ad_navbar_below
(1)
bbcode_quote
(1)
footer
(1)
gobutton
(1)
header
(1)
headinclude
(6)
option
(1)
post_thanks_box
(1)
post_thanks_button
(1)
post_thanks_javascript
(1)
post_thanks_navbar_search
(1)
post_thanks_postbit_info
(1)
postbit
(1)
postbit_onlinestatus
(1)
postbit_wrapper
(1)
spacer_close
(1)
spacer_open
Phrase Groups Available:
global
postbit
reputationlevel
showthread
Included Files:
./
showpost.php
./
global.php
./includes/
init.php
./includes/
class_core.php
./includes/
config.php
./includes/
functions.php
./includes/
class_hook.php
./includes/
modsystem_functions.php
./includes/
functions_bigthree.php
./includes/
class_postbit.php
./includes/
class_bbcode.php
./includes/
functions_reputation.php
./includes/
functions_post_thanks.php
Hooks Called:
init_startup
init_startup_session_setup_start
init_startup_session_setup_complete
cache_permissions
fetch_postinfo_query
fetch_postinfo
fetch_threadinfo_query
fetch_threadinfo
fetch_foruminfo
style_fetch
cache_templates
global_start
parse_templates
global_setup_complete
showpost_start
bbcode_fetch_tags
bbcode_create
postbit_factory
showpost_post
postbit_display_start
post_thanks_function_post_thanks_off_start
post_thanks_function_post_thanks_off_end
post_thanks_function_fetch_thanks_start
post_thanks_function_fetch_thanks_end
post_thanks_function_thanked_already_start
post_thanks_function_thanked_already_end
fetch_musername
postbit_imicons
bbcode_parse_start
bbcode_parse_complete_precache
bbcode_parse_complete
postbit_display_complete
post_thanks_function_can_thank_this_post_start
showpost_complete
Messages:
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
returning smilies from the datastore
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
php_sapi_name(): fpm-fcgi