vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   can anyone help me with a question please? (https://vborg.vbsupport.ru/showthread.php?t=276772)

bomber1614 01-11-2012 03:24 AM
can anyone help me with a question please?
 
hey guys, i just upgraded to a new vbulletin verison and i when i go to look at a thread or make a thread, i get a database error! can someone please tell me how to fix this!?

HMBeaty 01-11-2012 03:26 AM
Not without knowing what the database error is....

See my article here: https://vborg.vbsupport.ru/showthread.php?t=272014

bomber1614 01-11-2012 03:38 AM
there is the error!

Database error in vBulletin 4.1.9:

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 : Incorrect information in file: './extre520_hax1997/contenttype.frm'
Error Number : 1033
Request Date : Tuesday, January 10th 2012 @ 11:33:19 PM
Error Date : Tuesday, January 10th 2012 @ 11:33:19 PM
Script : http://extremehax.net/showthread.php...t-done-yet&p=5
Referrer : http://extremehax.net/
IP Address : XXXXXXXXXXXX
Username : Apex
Classname : vB_Database
MySQL Version : 5.0.92-community

HMBeaty 01-11-2012 03:48 AM
Do you have vBSEO installed?

bomber1614 01-11-2012 03:53 AM
i have know idea what that is and would you please give me a link or something that i can download that from? lol im sorry i am a little new to vbulletin!

HMBeaty 01-11-2012 03:59 AM
If you don't have vBSEO, don't worry about it. I was asking to help diagnose what's going on on your site with that error. Anyway, try this first go to your AdminCP and repair your database tables. You may need to run that a few times. Then see if it fixes your error.

If that does not work, then you need to execute a few queries. Follow these steps only if the above did not work!

First we need to get rid of the current table, since it can't be repaired
Code:
DROP TABLE contenttype;
Then we need to create it again
Code:
CREATE TABLE contenttype (
 contenttypeid INT UNSIGNED NOT NULL AUTO_INCREMENT,
 class VARBINARY(50) NOT NULL,
 packageid INT UNSIGNED NOT NULL,
 canplace ENUM('0','1') NOT NULL DEFAULT '0',
 cansearch ENUM('0','1') NOT NULL DEFAULT '0',
 cantag ENUM('0','1') DEFAULT '0',
 canattach ENUM('0','1') DEFAULT '0',
 isaggregator ENUM('0', '1') NOT NULL DEFAULT '0',
 PRIMARY KEY (contenttypeid),
 UNIQUE KEY packageclass (packageid, class)
);
If you do not have the suite installed, run this query next:
Code:
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES
(1, 'Post', 1, '0', '1', '0', '1', '0'),
(2, 'Thread', 1, '0', '0', '1', '0', '0'),
(3, 'Forum', 1, '0', '1', '0', '0', '0'),
(4, 'Announcement', 1, '0', '0', '0', '0', '0'),
(5, 'SocialGroupMessage', 1, '0', '1', '0', '0', '0'),
(6, 'SocialGroupDiscussion', 1, '0', '0', '0', '0', '0'),
(7, 'SocialGroup', 1, '0', '1', '0', '1', '0'),
(8, 'Album', 1, '0', '0', '0', '1', '0'),
(9, 'Picture', 1, '0', '0', '0', '0', '0'),
(10, 'PictureComment', 1, '0', '0', '0', '0', '0'),
(11, 'VisitorMessage', 1, '0', '1', '0', '0', '0'),
(12, 'User', 1, '0', '0', '0', '0', '0'),
(13, 'Event', 1, '0', '0', '0', '0', '0'),
(14, 'Calendar', 1, '0', '0', '0', '0', '0');
If you do have the suite installed, run this query:
Code:
INSERT INTO `contenttype` VALUES (1, 'Post', 1, '0', '1', '0', '1', '0');
INSERT INTO `contenttype` VALUES (2, 'Thread', 1, '0', '0', '1', '0', '0');
INSERT INTO `contenttype` VALUES (3, 'Forum', 1, '0', '1', '0', '0', '0');
INSERT INTO `contenttype` VALUES (4, 'Announcement', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (5, 'SocialGroupMessage', 1, '0', '1', '0', '0', '0');
INSERT INTO `contenttype` VALUES (6, 'SocialGroupDiscussion', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (7, 'SocialGroup', 1, '0', '1', '0', '1', '0');
INSERT INTO `contenttype` VALUES (8, 'Album', 1, '0', '0', '0', '1', '0');
INSERT INTO `contenttype` VALUES (9, 'Picture', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (10, 'PictureComment', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (11, 'VisitorMessage', 1, '0', '1', '0', '0', '0');
INSERT INTO `contenttype` VALUES (12, 'User', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (13, 'Event', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (14, 'Calendar', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (15, 'BlogEntry', 2, '0', '1', '0', '1', '0');
INSERT INTO `contenttype` VALUES (16, 'BlogComment', 2, '0', '1', '0', '0', '0');
INSERT INTO `contenttype` VALUES (17, 'Section', 3, '1', '0', '0', '0', '1');
INSERT INTO `contenttype` VALUES (18, 'Article', 3, '1', '1', '1', '1', '0');
INSERT INTO `contenttype` VALUES (19, 'ContentNode', 3, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (20, 'StaticPage', 3, '1', '1', '1', '0', '0');
INSERT INTO `contenttype` VALUES (21, 'PhpEval', 3, '1', '0', '0', '0', '0');

bomber1614 01-11-2012 04:54 AM
still didnt work! would you please teamview me if you can>? thanks!

HMBeaty 01-11-2012 04:57 AM
Then I would suggest submitting a support ticket on vbulletin.com


All times are GMT. The time now is 11:29 PM.

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.02010 seconds
  • Memory Usage 1,738KB
  • 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
  • (4)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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