Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-02-2010, 07:37 PM
smnet smnet is offline
 
Join Date: Feb 2009
Posts: 92
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Know why?? datastore->fetch() breaking blogs.

Hi guys,

I have a custom datastore item called 'navcache' which I use on everypage in building the header. The datastore item is refreshed every few hours via cron and works fine.....

However, I get a database error when i visit any blog page I and I cant work out why.... I've narrowed it down though.

In global_start hook I have this code:-
$vbulletin->datastore->fetch(Array('navcache',));

This pulls in the info I need in the header and all pages display fine except the blogs, which throw this error:-
Quote:
Database error in vBulletin 3.8.1:

Invalid SQL:

(
SELECT COUNT(*) AS total,
FROM_UNIXTIME(dateline - , '%c-%e-%Y') AS period
FROM blog AS blog

WHERE state IN('visible', 'moderation', 'deleted') AND dateline >= 1272150000 AND dateline < 1272832492
GROUP BY period
) UNION (
SELECT COUNT(*) AS total,
FROM_UNIXTIME(dateline - , '%c-%e-%Y') AS period
FROM blog AS blog
WHERE blog.userid IN (3) AND dateline >= 1272150000 AND dateline < 1275778800
GROUP BY period
);

MySQL Error : 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 ' '%c-%e-%Y') AS period
FROM blog AS blog

WHERE state IN('visible', 'mo' at line 3
Error Number : 1064
Request Date : Sunday, May 2nd 2010 @ 09:34:52 PM
Error Date : Sunday, May 2nd 2010 @ 09:34:52 PM
Script : http://www.xxxxxxxx.com/blog.php
Referrer :
IP Address : x.x.x.x
Username : xxxxxxx
Classname : vB_Database_MySQLi
MySQL Version : 5.0.45
It's really weird because as I said all pages function fine... If I remove that line of code from global_start then it works fine (but obviously my header neeeds that datastore info)

Does anyone have any idea why this is happening and can you suggest a fix?

Cheers for your help,
Reply With Quote
 


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

Forum Jump


All times are GMT. The time now is 07:18 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03109 seconds
  • Memory Usage 2,219KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)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)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete