vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Need A Little Help (https://vborg.vbsupport.ru/showthread.php?t=124088)

teedizz 08-16-2006 04:43 AM
Need A Little Help
 
I have just recently installed 3.6 on my server but in a serperate folder because I wanted to work on 3.6 while i still had 3.5 running smoothly. The path to my forums is /forums so I made a seperate folder named forumz so the path to 3.6 would be /forumz. ....I created a new database for the forumz but now on my 3.5 forums i get an error everytime i go to click on a thread that says:

Code:
Database error in vBulletin 3.5.2:

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,
                        level,
                        deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
                        editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
                        editlog.reason AS edit_reason,
                        post_parsed.pagetext_html, post_parsed.hasimages,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
                       
                       
                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 reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
                        LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
                LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
                LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
                       
                WHERE post.postid IN (0,202486,202922,203613,203615)
                ORDER BY post.dateline;

MySQL Error  : Table 'stricklystreet_vb.post_parsed' doesn't exist
Error Number : 1146
Date        : Wednesday, August 16th 2006 @ 12:31:24 AM
Script      : http://www.**********.com/forums/showthread.php?t=122084
Referrer    : http://www.***********.com/forums/forumdisplay.php?f=16
IP Address  : **.**.***.***
Username    : teedizz
Classname    : vb_database

does anyone know why im getting this error?

I mean i can create threads, navigate the forums but i just cant view any thread content

AN-net 08-16-2006 02:26 PM
have you modified any of your files or database? the reason for the error is that the table post_parsed does not exist.

looking at my 3.5.4 database structure post_parsed is a default table that should exist.

it seems it got deleted here is a query to add the table back:
[sql]
CREATE TABLE `post_parsed` (
`postid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`styleid_code` int(11) NOT NULL default '-1',
`styleid_html` int(11) NOT NULL default '-1',
`styleid_php` int(11) NOT NULL default '-1',
`styleid_quote` int(11) NOT NULL default '-1',
`hasimages` smallint(6) NOT NULL default '0',
`pagetext_html` mediumtext NOT NULL,
PRIMARY KEY (`postid`,`styleid_code`,`styleid_html`,`styleid_p hp`,`styleid_quote`),
KEY `dateline` (`dateline`)
);
[/sql]

teedizz 08-16-2006 04:30 PM
Thanks bro...where do I add that at?

AN-net 08-16-2006 07:07 PM
you can it run via the admincp if you have allowed yourself to run queries via the admincp or from your site's controlpanel using phpmyadmin or similar MySQL manager.

teedizz 08-17-2006 02:02 AM
Thanks alot bro


All times are GMT. The time now is 09:16 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.01049 seconds
  • Memory Usage 1,727KB
  • 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)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