Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2010, 06:28 AM
negrowarez negrowarez is offline
 
Join Date: May 2010
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Problem with database

Disable all plugins and now what I get is this
Code:
Database error in vBulletin 4.0.8:

Invalid SQL:

            (SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid,
                package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled,
                package.class AS class, -1 as isaggregator
            FROM package AS package
            LEFT JOIN product AS product
                    ON product.productid = package.productid
            WHERE product.active = 1
                OR package.productid = 'vbulletin'
            )

            UNION

            (SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid,
                1, 1, contenttype.class AS class  ,  contenttype.isaggregator
            FROM contenttype AS contenttype
            INNER JOIN package AS package ON package.packageid = contenttype.packageid
            LEFT JOIN product AS product ON product.productid = package.productid
            WHERE product.active = 1
            OR package.productid = 'vbulletin'  );

MySQL Error   : Table 'undermu1_negrow.contenttype' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, November 9th 2010 @ 01:37:16 AM
Error Date    : Tuesday, November 9th 2010 @ 01:37:16 AM
Script        : http://undermusicworld.com/newthread.php?do=newthread&f=66
Referrer      : http://undermusicworld.com/forumdisplay.php?66-PRESENTATE
IP Address    : **.***.***.***
Username      : Negrowarez
Classname     : vB_Database
MySQL Version : 5.0.91-community
I can not post anything, the forum I can see it and everything but I can not delete or post anything.
Reply With Quote
  #2  
Old 11-14-2010, 06:16 AM
negrowarez negrowarez is offline
 
Join Date: May 2010
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks everybody for the help
Reply With Quote
  #3  
Old 11-14-2010, 07:29 AM
YankForum's Avatar
YankForum YankForum is offline
 
Join Date: Mar 2010
Location: MY
Posts: 304
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

First, try running Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:
Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

OR:
it seems the table undermu1_negrow.contenttype doesn't exist , try to DROP TABLE IF EXISTS and then recreate it , You can get its structure from the mysql-schema.php file inside the install folder.
Reply With Quote
  #4  
Old 11-19-2010, 12:32 AM
negrowarez negrowarez is offline
 
Join Date: May 2010
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by YankForum View Post
First, try running Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:
Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

OR:
it seems the table undermu1_negrow.contenttype doesn't exist , try to DROP TABLE IF EXISTS and then recreate it , You can get its structure from the mysql-schema.php file inside the install folder.
Thanks YankForum I go to try that.
Reply With Quote
  #5  
Old 11-20-2010, 09:41 AM
negrowarez negrowarez is offline
 
Join Date: May 2010
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The problem remains the same ... I do not know what to do
Reply With Quote
  #6  
Old 11-20-2010, 10:11 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Exactly what did you do? If you actually added a new table, then I don't see how you can still be getting this error. Do you see a table called contenttype in your database?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:12 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.04187 seconds
  • Memory Usage 2,206KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete