vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database Error (https://vborg.vbsupport.ru/showthread.php?t=173016)

Virtualshiner 03-14-2008 03:32 PM
Database Error
 
Hi
I tried to get onto my site today and I got a database error.
This is the email I get:

Code:
Database error in vBulletin 3.7.0 Beta 6:

Invalid SQL:

                SELECT
                        post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
                        user.*, userfield.*, usertextfield.*,
                        icon.title as icontitle, icon.iconpath,
                        avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
                       
                       
                        editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
                        editlog.reason AS edit_reason, editlog.hashistory,
                        postparsed.pagetext_html, postparsed.hasimages,
                        sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
                        sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
                        , '' AS field6, '' AS field7
                       
                FROM post AS post
                LEFT JOIN user AS user ON(user.userid = post.userid)
                LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
                LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
                LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
                LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
               
                       
                LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
                LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1)
                LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 1)
                LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
                       
                WHERE post.postid IN (0,178,179,181,183,184,191,199,202,215,224)
                ORDER BY post.dateline;

MySQL Error  : Table 'disneyma_vb.user' doesn't exist
Error Number  : 1146
Date          : Friday, March 14th 2008 @ 12:41:11 PM
Script        : http://disneymagiconline.com/vbulletin/showthread.php?t=46
Referrer      :
IP Address    : 74.6.19.134
Username      : Unregistered
Classname    : vB_Database
MySQL Version :
Any help?

Opserty 03-14-2008 03:40 PM
Have you (un)installed a modification recently?

Virtualshiner 03-14-2008 03:51 PM
Sorry, I updated the code.
That was an old error.

Opserty 03-14-2008 03:54 PM
Quote:
MySQL Error : Table 'disneyma_vb.user' doesn't exist
Your user table doesn't exist. Are you using a prefix for your tables or anything? Have you made any changes to your board or database recently?

Virtualshiner 03-14-2008 03:55 PM
The only thing that has happened is the board moved servers. It is with the same host etc

Opserty 03-14-2008 04:28 PM
Have you checked the the database (and table) exist? (Via. your hosting Control Panel)

Virtualshiner 03-14-2008 04:33 PM
Yep
I can see disneyma_vb

Lynne 03-14-2008 04:55 PM
And can you see the user table?

Have you tried to run repair/optimize on the table?

Virtualshiner 03-14-2008 05:34 PM
I dont know what you mean

I cant access anything on my site and I have looked to repair/optimize the table but I dont know where that is.

Edit: In the cPanel, I clicked Repair db but the error is still there.

Lynne 03-14-2008 05:49 PM
If you are in cPanel and using phpMyAdmin, can you see the user table?

Also, sometimes you need to repair the table more than once.


All times are GMT. The time now is 11:41 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01546 seconds
  • Memory Usage 1,735KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete