Announcement

Collapse
No announcement yet.

Upgrading from 3.8.6 to 4.2.0 - Error 1064

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

  • [Suite] Upgrading from 3.8.6 to 4.2.0 - Error 1064

    Morning all...So I've been working on upgrading my forum (test install) from 3.8.6 to 4.2.0...ran into the collation error and have that all fixed up...But got to the following section:

    Code:
    • Upgrading to 4.2.0
    • Processing Blog
    • Step 1 - Creating blog table
    • Creating blog_attachmentlegacy table
    • Creating blog_category table
    • Creating blog_categorypermission table
    • Creating blog_categoryuser table
    • Creating blog_deletionlog table
    • Creating blog_editlog table
    • Creating blog_featured table
    • Creating blog_groupmembership table
    • Creating blog_grouppermission table
    • Creating blog_hash table
    • Creating blog_moderation table
    • Creating blog_moderator table
    • Creating blog_pinghistory table
    • Creating blog_rate table
    • Creating blog_read table
    • Creating blog_relationship table
    • Creating blog_search table
    • Creating blog_searchresult table
    • Creating blog_sitemapconf table
    • Creating blog_custom_block table
    • Creating blog_custom_block_parsed table
    • Creating blog_summarystats table
    • Creating blog_subscribeentry table
    • Creating blog_subscribeuser table
    • Creating blog_tachyentry table
    • Creating blog_text table
    • Creating blog_textparsed table
    • Creating blog_trackback table
    • Creating blog_trackbacklog table
    • Creating blog_user table
    • Creating blog_usercss table
    • Creating blog_usercsscache table
    • Creating blog_userread table
    • Creating blog_userstats table
    • Creating blog_views table
    • Creating blog_visitor table
    • Altering cron Table (1 of 1)
    • Altering cron Table (1 of 1)
    • Altering cron Table (1 of 1)
    • Altering cron Table (1 of 1)
    • Updating datastore table
    • Altering user Table (1 of 2)
    • Altering user Table (2 of 2)
    • Altering usergroup Table (1 of 5)
    • Altering usergroup Table (2 of 5)
    • Altering usergroup Table (3 of 5)
    • Altering usergroup Table (4 of 5)
    • Altering usergroup Table (5 of 5)
    • Altering moderatorlog Table (1 of 9)
    • Altering moderatorlog Table (2 of 9)
    • Altering moderatorlog Table (3 of 9)
    • Altering moderatorlog Table (4 of 9)
    • Altering moderatorlog Table (5 of 9)
    • Altering moderatorlog Table (6 of 9)
    • Altering moderatorlog Table (7 of 9)
    • Altering moderatorlog Table (8 of 9)
    • Altering moderatorlog Table (9 of 9)
    • Altering administrator Table (1 of 1)
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating usergroup table
    • Updating contenttype table
    • Updating activitystreamtype table
    • Step 2 - Updating Permissions
    • Step 3 - Skipping step, not needed
    • Step 4 - Skipping step, not needed
    • Step 5 - Skipping step, not needed
    • Step 6 - Skipping step, not needed
    • Step 7 - Skipping step, not needed
    • Step 8 - Skipping step, not needed
    • Step 9 - Skipping step, not needed
    • Step 10 - Skipping step, not needed
    • Step 11 - Skipping step, not needed
    • Step 12 - Skipping step, not needed
    • Step 13 - Skipping step, not needed
    • Step 14 - Skipping step, not needed
    • Step 15 - Skipping step, not needed
    • Step 16 - Skipping step, not needed
    • Step 17 - Product upgrade completed
    • Step 18 - Importing vbulletin-mobile-style-blog.xml
    • Template Group: Blog
    • Template Group: Search
    • Step 18 - Import Done
    • Processing CMS
    • Creating cms_article table
    • Creating cms_grid table
    • Creating cms_layout table
    • Creating cms_layoutwidget table
    • Creating cms_node table
    • Creating cms_category table
    • Creating cms_navigation table
    • Creating cms_nodecategory table
    • Creating cms_sectionorder table
    • Creating cms_nodeinfo table
    • Creating cms_nodeconfig table
    • Creating cms_widget table
    • Creating cms_widgetconfig table
    • Creating cms_widgettype table
    • Creating cms_permissions table
    • Altering usergroup Table (1 of 1)
    • Altering administrator Table (1 of 1)
    • Updating cms_permissions table
    • Updating action table
    • Updating action table
    • An error has occurred with your database. Please contact vBulletin Support for assistance. Module: vbcms, Step 1 Database Error:1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3, 'BaseWidget', 'config', 'Config'), (, 3, 'BaseWidget', 'edit', 'Edit')' at line 5 Query: INSERT IGNORE INTO action (routeid, packageid, controller, useraction, classaction) VALUES (, 3, 'BaseWidget', 'config', 'Config'), (, 3, 'BaseWidget', 'edit', 'Edit')
    I was messing around with the impex software (not on this upgrade here) and ran into a TYPE/ENGINE change that needed to be completed in the impex/index.php file...Now I know that the impex stuff has nothing to do with this

    Any thoughts as to what needs to be changed in the system to get it to move forward on the upgrade?

    Thanks.

    - - - Updated - - -

    I should add that the 3.8.6 install was a "FORUM ONLY" install and the 4.2.0 install is the SUITE with mobile/cms/blog.

  • #2
    What version of PHP and MySQL are you using?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    Vote for your most annoying bugs.
    I am not currently available for vB Messenger Chats.

    Comment


    • #3
      Apache:
      2.2.22


      CentOS:
      CentOS release 6.2 (Final)


      cPanel:
      11.30.6 (build 6)


      Curl:
      7.12.1


      MySQL
      5.5.23


      phpMyAdmin
      3.4.9


      Python:
      2.6.6



      Program
      Version


      Perl:
      5.8.8


      PHP:
      5.2.17


      ionCube Loader:
      4.0.12


      Zend Optimizer:
      3.3.9


      Ruby:
      1.8.7


      Rails:
      2.3.14


      OpenSSL:
      1.0.0-fips

      Comment


      • #4
        In your config.php file change:

        $config['Database']['dbtype'] = 'mysql';

        to:

        $config['Database']['dbtype'] = 'mysqli';

        Uncomment this line:
        // $config['Mysqli']['charset'] = 'utf8';

        Set this line to true:
        $config['Database']['force_sql_mode'] = false;

        Upgrade your PHP to 5.3.13

        None of the rest of that is really relevant.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud customization and demonstration site.
        vBulletin 5 Documentation - Updated every Friday. Report issues here.
        vBulletin 5 API - Full / Mobile
        Vote for your most annoying bugs.
        I am not currently available for vB Messenger Chats.

        Comment


        • #5
          changes made to config.php as outlined above.

          php version is 5.3.13 now.

          Did fresh copy of live database...changed all collations...disable hooks is present in config.php
          Went though the whole upgrade process up to the same point as before and then ...........

          Code:
          An error has occurred with your database. Please contact vBulletin Support for assistance.Module: vbcms, Step 1 Database Error:1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3, 'BaseWidget', 'config', 'Config'), (, 3, 'BaseWidget', 'edit', 'Edit')' at line 5Query:
          INSERT IGNORE INTO action (routeid, packageid, controller, useraction, classaction) VALUES (, 3, 'BaseWidget', 'config', 'Config'), (, 3, 'BaseWidget', 'edit', 'Edit')

          Comment


          • #6
            Open a ticket at your Customer Area and provide all the necessary infos so one of the vb staff can investigate this issue.

            Comment


            • #7
              borbole...I've done that already...was just hoping that someone on the forums would be able to shoot me a quick fix for it.

              Comment


              • #8
                For everyone else who comes across this:

                $config['Database']['force_sql_mode']

                Was set to true, change to $config['Database']['force_sql_mode'] = false;

                Comment


                • #9
                  Thanks Zach...I was just coming into post this....

                  Comment

                  Working...
                  X