vb.org Archive - Blogs causing database error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Blogs causing database error (https://vborg.vbsupport.ru/showthread.php?t=204478)

readjono

02-06-2009 04:49 PM

Blogs causing database error

They have been working perfectly until recently. Now the index page does not load...

Database error
The [Site Name] database has encountered a problem.

When I disable blogs it, however, works. I got someone to reinstall them last time and that solved it. But they may have done something else to fix it. Can't get in touch with them so was throwing this out to you guys. It's obviously since I've upgraded but seems a common problem with all versions of the blog.

Lynne

02-06-2009 04:52 PM

When you get the database error page, view the page source and the actual database error will be shown. We can't suggest to you what a solution may be if you don't post the actual database error.

readjono

02-06-2009 05:00 PM

Code:

<!--

Database error in vBulletin 3.8.1:



Invalid SQL:



                SELECT user.username, blog.userid, blog.title, blog.blogid, blog.postedby_userid, blog.postedby_username, bu.title AS blogtitle

                FROM blog AS blog

                LEFT JOIN blog_user AS bu ON (blog.userid = bu.bloguserid)

                LEFT JOIN user AS user ON (blog.userid = user.userid)

                

                WHERE

                        state = 'visible' AND

                        dateline &lt;= 1233946749 AND

                        blog.pending = 0 AND

                        ~blog.options &amp; 8 AND

                        bu.options_buddy &amp; 1 AND

                        bu.options_member &amp; 1

                         AND blog.userid &lt;&gt; 

                ORDER BY dateline DESC

                LIMIT 1;



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 'ORDER BY dateline DESC

                LIMIT 1' at line 14

Error Number  : 1064

Request Date  : Friday, February 6th 2009 @ 06:59:09 PM

Error Date    : Friday, February 6th 2009 @ 06:59:09 PM

Script        : ***********/index.php

Referrer      : 

IP Address    : 92.20.224.143

Username      : Guest

Classname     : vB_Database

MySQL Version : 

-->

Lynne

02-06-2009 05:10 PM

Try disabling your plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:


		
			
define('DISABLE_HOOKS', true);

readjono

02-06-2009 05:45 PM

Seemingly has no effect. Shall request paid services for this.

puertoblack2003

02-06-2009 06:09 PM

there's a temp fix go to vb.com freddie gave me a fix.I was having that issue too.It'll be nice if you also report it :up:

All times are GMT. The time now is 07:14 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01250 seconds Memory Usage 1,722KB 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)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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
Messages: