vb.org Archive - Db error

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

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

- - Db error (https://vborg.vbsupport.ru/showthread.php?t=223058)

nyqnzguju999

09-12-2009 09:01 PM

Db error

I am getting a DB error:s

Code:

Database Error          Database error

The xx database has encountered a problem.

Please try the following:



    * Load the page again by clicking the Refresh button in your web browser.

    * Open the www.xxx.com home page, then try to open another page.

    * Click the Back button to try another link.



The www.xxx.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

 

We apologise for any inconvenience.

Lynne

09-12-2009 09:23 PM

When you get the error, view the page source for that page and you will see the actual database error near the bottom of that page. It will have some information like this:

Code:

The actual mysql query/code/problem....



MySQL Error : some sort of something here

Error Number : another something here

Date : Sunday, April 13th 2008 @ 11:16:43 AM

Script : http://address.path.path/page.php

Referrer :

IP Address : **.***.**.***

Username : username

Classname : database

nyqnzguju999

09-12-2009 09:26 PM

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT count(*)as cnt,max(dateline) as lastupdate
FROM groupmessage
WHERE groupid='1';

MySQL Error : Unknown column 'groupid' in 'where clause'
Error Number : 1054
Request Date : Friday, September 4th 2009 @ 02:00:21 AM
Error Date : Friday, September 4th 2009 @ 02:00:23 AM
Script : http://www.xxxt.com/forums/cron.php?rand=1252022411
Referrer :
http://www.xxxcom/forums/login.php?d...69d0003ab9109b
IP Address : 59.103.213.251
Username : Unregistered
Classname : vB_Database
MySQL Version :

Lynne

09-12-2009 09:30 PM

There is no column groupid in the groupmessage table, so I'd say this problem is from a modification. Try disabling your modifications/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);

nyqnzguju999

09-14-2009 01:21 PM

Thanks worked like a charm

All times are GMT. The time now is 09:04 AM.

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