vb.org Archive

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.

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.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