vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Blogs Database error in vBulletin 4.1.0 (https://vborg.vbsupport.ru/showthread.php?t=268237)

DanWest 08-09-2011 10:47 AM
Blogs Database error in vBulletin 4.1.0
 
I hope this is the right forum for this question. When I try to enable Blogs on the site I get the Invalid SQL error below. Strange thing is that if I'm logged in as Admin it seem to work, but any other user get this error. Any idea what might be causing this?

I don't have any modifications installed and all blog posts were imported from a Ning site. It has worked before but now I get this error:
Code:
Invalid SQL:

                (
                        SELECT COUNT(*) AS total,
                        FROM_UNIXTIME(dateline - 10800, '%c-%e-%Y') AS period
                        FROM forum_blog AS blog
                       
                        WHERE state IN('visible', 'moderation', 'deleted') AND dateline >= 1311465600 AND dateline < 1312889953
                        GROUP BY period
                ) UNION (
                        SELECT COUNT(*) AS total,
                        FROM_UNIXTIME(dateline - 10800, '%c-%e-%Y') AS period
                        FROM forum_blog AS blog
                        WHERE blog.userid IN () AND dateline >= 1311465600 AND dateline < 1315094400
                        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 ') AND dateline >= 1311465600 AND dateline < 1315094400
                        GROUP BY period
                )' at line 12
Error Number  : 1064
Request Date  : Tuesday, August 9th 2011 @ 02:39:13 PM
Error Date    : Tuesday, August 9th 2011 @ 02:39:13 PM
Script        : http://mysite.com/forum/blog.php
Referrer      : http://mysite.com/forum/forum.php
IP Address    : xx.x.xxx.x
Username      : xxxx
Classname    : vB_Database
MySQL Version : 5.1.54-0.dotdeb.0-log


All times are GMT. The time now is 04:27 PM.

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.00898 seconds
  • Memory Usage 1,710KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete