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

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
    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.

  • 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?

  • Also discussions do not show...

    Database connection details were unchanged.

  • pioc34pioc34 Pézenas ✭✭

    in your conf/config.php

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

  • Is your php version greater than php 7.2?

  • 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!

  • 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
    


  • 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}
    


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

  • 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.

  • 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 Pézenas ✭✭

    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

  • 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 Pézenas ✭✭
  • What would be the alternative for Htmlawed that works with 3.3?

Sign In or Register to comment.