vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   3.8.1 Clean Install and database restore (https://vborg.vbsupport.ru/showthread.php?t=207650)

ccozkaraca 03-07-2009 09:53 PM
3.8.1 Clean Install and database restore
 
Hi everyone,

Is it possible to do clean install 3.8.1 Vb and just restore users and messages. I tired to upgrade my 3.5.4 and i messed up my database. And my custom template has many errors now.

Can i do that, if yes how please ?

Mark.B 03-07-2009 09:57 PM
Quote:
Originally Posted by ccozkaraca (Post 1762798)
Hi everyone,

Is it possible to do clean install 3.8.1 Vb and just restore users and messages. I tired to upgrade my 3.5.4 and i messed up my database. And my custom template has many errors now.

Can i do that, if yes how please ?
It sort of depends on what changes have been made to the database, if any.

What errors did you get when trying to upgrade? These can usually be sorted quite easily once we know what's happening. Or at least we can tell you if it looks totally screwed!

ccozkaraca 03-08-2009 03:37 PM
I did upload the "upload" files in the zip folder. After than i followed the instructions. I got couple database error messages.

This is one of them ;

PHP Code:
Database error in vBulletin 3.5.4:

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 

So I have found this solution messages ;

Quote:
Originally Posted by Vbulletin Forum
I have fixed it, after I noticed that the upgrade from 3.5.4 to 3.6.0 Beta 1 has renamed the table "post_parsed" to "postparsed"

To fix it I have renamed the postparsed to post_parsed by this syntax:

ALTER TABLE postparsed RENAME post_parsed
After doing that, i was able to reach my forum. But everything was change.

For example;

1- when i hit the "new posts" link i got "There are no unread threads. " this message all the time.

2- There is a little arrow which says " go to last post " when i hit that arrow i got this " No subject specified. If you followed a valid link, please notify the administrator"

3- Before the upgrade i was using a dropdown navlink menu. But after the upgrade my drop down got dissapeared.


And they advised me to these ;

Quote:
Originally Posted by Vbulletin Team
You need to update your counters under Maintenance -> Update Counters as specified during the upgrade process.

For your missing link, you would most likely need to add that code back into your templates.

Reverse your templates

I also did everything Vbulletin Team told me but i still have the same problems.
I got really stuck and don't know what to do...:(

Marco van Herwaarden 03-09-2009 01:50 PM
You can not just go change table names and expect things to still work.

I doubt anyone official vB team member will tell you to change the table names.


All times are GMT. The time now is 02:45 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.00949 seconds
  • Memory Usage 1,733KB
  • 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_php_printable
  • (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