Blog Documentation Book a Demo
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

upgrading from 2.x

UdoUdo New
in Vanilla 3.x Help

Hello,

Where can I find howto documentation to upgrade a version 2.x situation to 3.3?

Please let me know!


Kind regards,

Udo

Tagged:
«1

Comments

  • UdoUdo New

    Is this the documentation to use? https://docs.vanillaforums.com/developer/installation/self-hosting/#from-vanilla-2-8-or-earlier

  • BleistivtBleistivt Moderator

    Yes.

    My themes: pure | minusbaseline - My plugins: CSSedit | HTMLedit | InfiniteScroll | BirthdayModule | [all] - PM me about customizations

    VanillaSkins.com - Plugins, Themes and Graphics for Vanillaforums OS

  • UdoUdo New
    edited March 2020

    Thanks.

    We followed these rules and get a few errors:

    mod_fcgid: stderr: PHP Fatal error: Unknown column 't.FullName' in 'field list' in [path]library/database/class.database.php on line 407

    mod_fcgid: stderr: PHP Fatal error: Unknown column 'w.Participated' in 'field list' in [path]library/database/class.database.php on line 421

    mod_fcgid: stderr: PHP Fatal error: Class 'AssetModel' not found in [path]/library/core/class.controller.php on line 1645

    PHP Warning: dateTimeToTimeStampcalled with bad input in [path]/library/Vanilla/Formatting/DateTimeFormatter.php on line 228

    mod_fcgid: stderr: PHP Warning: dateTimeToTimeStampcalled with bad input in [path]/library/Vanilla/Formatting/DateTimeFormatter.php on line 228


    The main page shows:

    Something has gone wrong.

    We've run into a problem and are unable to handle this request right now.

    Please check back in a little while.


    Also the /discussion 'directory' link shows a 404.

    Does this mean a .htaccess (which?) needs tweaking for rewriting?

    How do we proceed from here?

  • BleistivtBleistivt Moderator

    If you haven't modified your .htaccess file in the main directory, delete it and rename .htaccess.dist to .htaccess

    Try if you can access the dashboard and visit /utility/update

    Disable all plugins, if you haven't already.

    Then visit and run /utility/structure.

    My themes: pure | minusbaseline - My plugins: CSSedit | HTMLedit | InfiniteScroll | BirthdayModule | [all] - PM me about customizations

    VanillaSkins.com - Plugins, Themes and Graphics for Vanillaforums OS

  • UdoUdo New

    We have the renamed .htaccess.dist in place.

    We edited rewritebase for the directory where the forum is.

    /utility/update gives us a 404.

    Main page gives debug:


    Fatal Error in PHP.gdn_ErrorHandler();

    Unknown column 't.FullName' in 'field list'

    The error occurred on or near: /home/someuser/www/library/database/class.database.php

    403:                // If we get here then the pdo statement prepared properly.

    404:                break;

    405:

    406:            } catch (Gdn_UserException $uex) {

    407:                trigger_error($uex->getMessage(), E_USER_ERROR);

    408:            } catch (Exception $ex) {

    409:                list($state, $code, $message) = $pDO->errorInfo();

    410:

    411:                // If the error code is consistent with a disconnect, attempt to retry


    Backtrace:

    /home/someuser/www/library/database/class.database.phpPHP::gdn_ErrorHandler();

    [/home/someuser/www/library/database/class.database.php:407] PHP::trigger_error();

    [/home/someuser/www/library/database/class.sqldriver.php:1707] Gdn_Database->query();

    [/home/someuser/www/library/database/class.sqldriver.php:664] Gdn_SQLDriver->query();

    [/home/someuser/www/applications/dashboard/models/class.tagmodel.php:314] Gdn_SQLDriver->get();

    [/home/someuser/www/applications/vanilla/settings/class.hooks.php:726] TagModel->joinTags();

    [/home/someuser/www/applications/vanilla/settings/class.hooks.php:726] VanillaHooks->base_render_before();

    [/home/someuser/www/library/Garden/EventManager.php:278] PHP::call_user_func_array();

    [/home/someuser/www/library/core/class.pluginmanager.php:810] Garden\EventManager->fire();

    [/home/someuser/www/library/core/class.pluginmanager.php:773] Gdn_PluginManager->callEventHandler();

    [/home/someuser/www/library/core/class.pluggable.php:205] Gdn_PluginManager->callEventHandlers();

    [/home/someuser/www/applications/vanilla/controllers/class.discussionscontroller.php:228] Gdn_Pluggable->__call();

    [/home/someuser/www/library/core/class.dispatcher.php:872] DiscussionsController->index();

    [/home/someuser/www/library/core/class.dispatcher.php:289] Gdn_Dispatcher->dispatchController();

    [/home/someuser/www/index.php:29] Gdn_Dispatcher->dispatch();


    Variables in local scope:

    [sql] 'select td.DiscussionID as `DiscussionID`, t.TagID as `TagID`, t.Name as `Name`, t.FullName as `FullName`
from `GDN_TagDiscussion` `td`
join `GDN_Tag` `t` on t.TagID = td.TagID
where `td`.`DiscussionID` in (null)'
[inputParameters] array (
)
[options] array (
  'Type' => 'select',
  'Slave' => NULL,
  'ReturnType' => 'DataSet',
)
[returnType] 'DataSet'
[tries] 2
[try] 0
[pDO] array (
)
[pDOStatement] false
[state] '42S22'
[code] 1054
[message] 'Unknown column \'t.FullName\' in \'field list\''
[uex] array (
)


    So something basic is wrong, but what?

  • UdoUdo New
    edited March 2020

    We managed to run utility/upgrade:

    Debug Trace

    Notice   

    The addon with key HtmLawed could not be found and will not be started.

    #0 [internal function]: gdn_ErrorHandler(1024, 'The addon with ...', '/home/pponuuser...', 1115, Array)

    #1 /home/someuser/www/library/Vanilla/AddonManager.php(1115): trigger_error('The addon with ...')

    #2 /home/someuser/www/bootstrap.php(431): Vanilla\AddonManager->startAddonsByKey(Array, 'addon')

    #3 [internal function]: {closure}(Object(Garden\Container\Container), Object(Gdn_Configuration), Object(Vanilla\AddonManager), Object(Garden\EventManager), Object(Gdn_Request))

    #4 /home/someuser/www/vendor/vanilla/garden-container/src/Container.php(740): call_user_func_array(Object(Closure), Array)

    #5 /home/someuser/www/bootstrap.php(492): Garden\Container\Container->call(Object(Closure))

    #6 /home/someuser/www/index.php(22): require_once('/home/someuser...')

    #7 {main}


    HtmLawed was not disabled, so why can't it be found?

  • UdoUdo New

    Also discussions do not show...

    Database connection details were unchanged.

  • pioc34pioc34 ✭✭

    in your conf/config.php

    find $Configuration['EnabledPlugins']['HtmLawed'] = true; and replace it by $Configuration['EnabledPlugins']['HtmLawed']=false;

  • ianw5555ianw5555 ✭

    Is your php version greater than php 7.2?

  • UdoUdo New
    https://open.vanillaforums.com/discussion/comment/260217#Comment_260217

    I believe so.

    In the mean time things appear to be working after we figured out an issue with the subdirectory where the forum is installed.

    Thanks for your replies and support!

  • UdoUdo New

    With all plugins disabled, when I post a message, I get:


    Debug Trace

     Notice Undefined index: Announce

#0 /home/someuser/applications/vanilla/controllers/class.postcontroller.php(184): gdn_ErrorHandler(8, 'Undefined index...', '/home/pponuuser...', 184, Array)
#1 /home/someuser/library/core/class.dispatcher.php(872): PostController->discussion('bla...')
#2 /home/someuser/library/core/class.dispatcher.php(289): Gdn_Dispatcher->dispatchController(Object(Gdn_Request), Array)
#3 /home/someuser/index.php(29): Gdn_Dispatcher->dispatch()
#4 {main}

    Database issue?

  • UdoUdo New
    edited March 2020

    What would be recommended upgrades for these plugins? (3.3 compatible, safe, etc)

    HtmLawed
AllViewed
Tagging
VanillaStats
FileUpload
SplitMerge
cleditor
Emotify
JumpToTop
Mediator
LatestPostList
DiscussionPolls
Quotes
WhosOnline


  • UdoUdo New

    What would be the cause of this?

    All plugins are disabled:


    NoticedateTimeToTimeStampcalled with bad input 

#0 [internal function]: gdn_ErrorHandler(512, 'dateTimeToTimeS...', '/home/someuser...', 228, Array)
#1 /home/someuser/library/Vanilla/Formatting/DateTimeFormatter.php(228): trigger_error('dateTimeToTimeS...', 512)
#2 /home/someuser/library/core/class.format.php(1292): Vanilla\Formatting\DateTimeFormatter::dateTimeToTimeStamp('', false)
#3 /home/someuser/applications/vanilla/models/class.discussionmodel.php(1009): Gdn_Format::toTimestamp('')
#4 /home/someuser/applications/vanilla/models/class.discussionmodel.php(1004): DiscussionModel->calculate(Object(stdClass))
#5 /home/someuser/applications/vanilla/models/class.discussionmodel.php(782): DiscussionModel->addDiscussionColumns(Object(Gdn_DataSet))
#6 /home/someuser/applications/vanilla/models/class.discussionmodel.php(556): DiscussionModel->getWhere(Array, '', '', 50, 0, true)
#7 /home/someuser/applications/vanilla/controllers/class.discussionscontroller.php(192): DiscussionModel->getWhereRecent(Array, 50, 0)
#8 /home/someuser/library/core/class.dispatcher.php(872): DiscussionsController->index(1)
#9 /home/someuser/library/core/class.dispatcher.php(289): Gdn_Dispatcher->dispatchController(Object(Gdn_Request), Array)
#10 /home/someuser/index.php(29): Gdn_Dispatcher->dispatch()
#11 {main}


  • ianw5555ianw5555 ✭

    I take it you disabled your plugins before you updated as per the instructions?

  • UdoUdo New

    Yes!

    If we disable the debug then the forum appears to function (mostly?).

    We are of course missing some plugins, but that is it so far.

  • UdoUdo New

    W.r.t. plugins:

    • Which WYSIWYG editor works well with 3.3?
    • Which JumpToTop rquivalent plugin works with 3.3?
    • Which plugin allows uploads to attach to a message, and is compatible with 3.3?

    Most plugins in this area are quite old and not maintained since the past few years.

  • pioc34pioc34 ✭✭

    1-advanced editor works well

    2- Jomp to top can be replaced easily with css and an anchor link in your template view

    3-files uploaded with advanced editor are attached to the message

  • UdoUdo New

    Thanks, I enabled the advanced editor.

    Appears to work, needs more testing.

    Thanks for the tip.


    W.r.t. number 2: need to research some more as I have no experience in this area but will ask someone else who could have.

  • pioc34pioc34 ✭✭

    for jump to top, look at this https://css-tricks.com/need-to-scroll-to-the-top-of-the-page/

  • UdoUdo New

    What would be the alternative for Htmlawed that works with 3.3?

Sign In or Register to comment.