Announcement

Collapse
No announcement yet.

Upgrade from 4.2.3 to 5.2.6

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    replied
    We don't recommend copying the actual database files. A SQL backup should be performed and restored to copy a database. We recommend INNODB because they tend to offer better performance than MyISAM. Especially when coupled with MySQL 5.6 and higher.

    We remove obsolete tables using the DROP TABLE syntax. Nothing more.

    Leave a comment:


  • Gizmo99
    replied
    More info

    If you install VB5 from fresh 95% of the tables are InnoDB

    This means moving vb 5 around needs a export or alike

    Leave a comment:


  • Gizmo99
    replied
    ok this took Beer and Pizza

    with all the PHP MySQL etc updates I have done this is small but massive change in MySQL

    I copied our vb3 db to a new dir to upgrade to VB4

    Upgraded sorted now copy vb4 to new dir to update to VB5

    To move DB files around the storage type needs to be MyISAM is MySQL 5.5 the storage type is moved to InnoDB better etc etc

    in our my.cnf we had set default-storage-engine = MyISAM BUT and its a biggy it was set quite late in my.cnf

    YOU NEED TO PUT IT IN [mysqld] AREA AT THE TOP !

    else new tables or altered tables will be InnoDB and cannot be copied around !

    This can be fixed by using the below for each table the is wrong

    ALTER TABLE <TABLENAME> ENGINE=MySAM

    Enjoy

    Giz

    Leave a comment:


  • Wayne Luke
    replied
    That table shouldn't have been deleted. You haven't even made it to a 5.X upgrade step yet. Plus vBulletin doesn't delete database files directly. It uses the standard MySQL commands. Something else is amiss here.

    Leave a comment:


  • Gizmo99
    replied
    Ok it works

    But this is strange, it starts with the 256 table vb 4 DB then cut it down to 167 then is barp


    An error has occurred with your database. Please contact vBulletin Support for assistance.

    Module: 424b1, Step 1 Database Error:1146

    Table '##SITE##_vb5.attachment' doesn't exist

    it doesn't coz the upgrade removes the table, sorry removes the .MYD and .MYI files and leaves attachment.frm

    ????

    Leave a comment:


  • Gizmo99
    replied
    This is the sticky in this forum https://www.vbulletin.com/forum/foru...m-requirements

    Please update it

    Giz

    Leave a comment:


  • Wayne Luke
    replied
    That is incorrect.. The minimum required version for 5.2.6 is listed here: https://www.vbulletin.com/forum/foru...-now-available

    Please note that the minimum version will most likely be 5.6+ in the next version of 5.3.0.

    Leave a comment:


  • Gizmo99
    replied
    Thanks Mark

    but

    Minimum System Requirements
    These are the Minimum System Requirements. vBulletin 5 Connect will not run or install if these conditions are not met.
    • PHP 5.3.0*
    • MySQL 5.1.5
    • mod_rewrite, URL Rewrite** or equivalent.
    • You must upload the included .htaccess or web.config files.
    • GD or ImageMagick need to be installed and functional within PHP
    • cURL or OpenSSL must be installed.

    Recommended System Requirements
    These are the Recommended System Requirements.
    • PHP 5.4+
    • MySQL 5.5+
    It doesn't say php 5.6 ????

    Giz

    Leave a comment:


  • Mark.B
    replied
    Please upgrade php to 5.5 or 5.6 and then try the upgrade again.

    I strongly suspect the code causing this error is php 5.5 and above only.

    Leave a comment:


  • Gizmo99
    started a topic Upgrade from 4.2.3 to 5.2.6

    Upgrade from 4.2.3 to 5.2.6

    Hi

    Try to do a upgrade, now edited Config.php etc


    The upgrade welcome comes up and askes for Customer Number, put it in

    BANG

    PHP Fatal error: Can't use function return value in write context in /var/www/vhosts/**HOST**/htdocs/bbs_5/core/install/includes/class_upgrade_526b1.php on line 102, referer: http://www.**HOST**.co.uk/bbs_5/core...ll/upgrade.php

    Running PHP Version 5.4.45

    Giz
    Last edited by Gizmo99; Sun 26th Feb '17, 6:26am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X