vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   SQL error (https://vborg.vbsupport.ru/showthread.php?t=238491)

shozy 03-17-2010 02:45 PM
SQL error
 
hi guyzz i am having problem in my forum admincp

it looks like this :

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.forum.rushlush.com home page, then try to open another page.
Click the Back button to try another link.
The www.forum.rushlush.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
Quote:
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT adminmessage.adminmessageid
FROM adminmessage AS adminmessage
INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
WHERE adminmessage.status = 'undone'
AND adminmessage.script <> ''
AND adminlog.dateline > adminmessage.dateline
GROUP BY adminmessage.adminmessageid;

MySQL Error : Table 'sadiaforum.adminlog' doesn't exist
Error Number : 1146
Request Date : Wednesday, March 17th 2010 @ 11:43:35 AM
Error Date : Wednesday, March 17th 2010 @ 11:43:35 AM
Script : http://www.forum.rushlush.com/admincp/index.php?do=home
Referrer : http://www.forum.rushlush.com/admincp/
IP Address : 78.15.229.44
Username : ╰☆╮♡ Sh?zу ♡╰☆╮
Classname : vB_Database
MySQL Version : 5.0.51a-log

What i have to do for solve it please help

borbole 03-17-2010 03:04 PM
Quote:
Originally Posted by shozy (Post 2005574)
hi guyzz i am having problem in my forum admincp

it looks like this :

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.forum.rushlush.com home page, then try to open another page.
Click the Back button to try another link.
The www.forum.rushlush.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.



What i have to do for solve it please help
According to the error you have a missing db table (adminlog). try to recreate it and see fi that would help.

shozy 03-17-2010 09:45 PM
please tell me the whole process

where i go for make new table ?? please

borbole 03-17-2010 10:52 PM
Quote:
Originally Posted by shozy (Post 2005752)
please tell me the whole process

where i go for make new table ?? please
You can see the syntax for the creating of the db tables at the mysql-schema.php file in the /install/ folder. Whereas the query can be run at the SQL box in the phpmyadmin in the cp of your db. Make sure to select the db name that your forum resides on though.


All times are GMT. The time now is 10:25 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.01034 seconds
  • Memory Usage 1,718KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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