Thread
:
URGENT: Session Table Default Structure
View Single Post
#
8
05-23-2002, 11:08 PM
GOSatisfy
Join Date: Apr 2002
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
My database is returning the following error:
Quote:
Database error in vBulletin 2.2.5:
Invalid SQL:
SELECT
thread.threadid
FROM thread
WHERE thread.forumid = 28
AND thread.sticky=0
AND thread.visible=1
AND sticky=0
ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
mysql error: Unknown error
mysql error number: 1105
Date: Thursday 23rd of May 2002 07:53:09 PM
Script:
http://dev.campkr.com/boards/boards/...?s=&forumid=28
Referer:
http://dev.campkr.com/boards/showthr...s=&threadid=79
However, if I remover the ", lastpost DESC" it returns what it is supposed to. How do I correct this so lastpost DESC will work when called from vB?
-bryan
GOSatisfy
View Public Profile
Visit GOSatisfy's homepage!
Find all posts by GOSatisfy
X
vBulletin 3.8.12 by vBS Debug Information
Page Generation
0.01138 seconds
Memory Usage
1,763KB
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(202, 0, 1,''); -> cached fperms for forum 202
returning smilies from the datastore
(unspecified) fetch_permissions(202, 0, 1,''); -> cached fperms for forum 202
(unspecified) fetch_permissions(202, 0, 1,''); -> cached fperms for forum 202
php_sapi_name(): fpm-fcgi