Announcement

Collapse
No announcement yet.

Unexpected Text: errors and Invalid SQL: during upgrade to 4.1.3

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

  • [Suite] Unexpected Text: errors and Invalid SQL: during upgrade to 4.1.3

    I am upgrading from 3.8.5 to 4.1.3 and get the following error.
    Once I received the error, I re-downloaded the entire package and re-uploaded it and restored database.

    After 3 complete install attempts I still get the same error.at 97% done at:
    Processing Skimlinks
    Step 1 - Creating skimlinks table
    Step 2 - Product upgrade completed

    Any suggestions? Thanks much in advance.


    The error:
    Code:
    Unexpected Text:
    
    <?xml version="1.0" encoding="windows-1252"?>
    <?xml version="1.0" encoding="windows-1252"?>
    <errors>
        <error><=!=[=C=D=A=T=A=[<p>Database Error</p>
    
    Invalid SQL:
    
       INSERT INTO setting
       (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder,
       advanced, volatile, validationcode, blacklist, product)
       VALUES
       (
        'templateversion',
        'version',
        '4.1.3',
        '4.1.3',
        'free',
        '',
        1,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'default_route_segment',
        'version',
        'content',
        'content',
        'free',
        '',
        5,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'subscriptionmethods',
        'version',
        '0',
        '0',
        'boolean',
        'yesno',
        10,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'attachfile',
        'version',
        '2',
        '',
        'free',
        'radio:piped\r\n0|no\r\n1|yes(,)userid/userid.attach\r\n2|yes(,)u/s/e/r/i/d/userid.attach',
        20,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'hv_type',
        'version',
        'Question',
        'Image',
        'free',
        'radio:piped\r\n0|disabled\r\nImage|image_verification\r\nQuestion|question_verification\r\nRecaptcha|recaptcha',
        20,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'hv_recaptcha_publickey',
        'version',
        xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',
        '',
        'free',
        '',
        22,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'hv_recaptcha_privatekey',
        'version',
        xxxxxxxxxxxxxx',
        '',
        'free',
        '',
        24,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'hv_recaptcha_theme',
        'version',
        'blackglass',
        'white',
        'free',
        'radio:piped\r\nred|recaptcha_red\r\nwhite|recaptcha_white\r\nblackglass|recaptcha_blackglass\r\nclean|recaptcha_clean',
        25,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'regimagetype',
        'version',
        'GD',
        'GD',
        'free',
        '<div class=\\\"smallfont\\\">\r\n    <label for=\\\"rb_setting[regimagetype]GDttf_0\\\">\r\n  <input type=\\\"radio\\\"\r\n   name=\\\"setting[$setting[varname]]\\\"\r\n   id=\\\"rb_setting[regimagetype]GDttf_0\\\"\r\n   value=\\\"GDttf\\\"\r\n   \" . ($setting[\'value\'] == \'GDttf\' ? \' checked=\"checked\"\' : \'\') . \"\r\n  />GD<br />\r\n  <img src=\\\"../image.php?hash=test&amp;i=gd\\\" alt=\\\"GD\\\" width=\\\"201\\\" height=\\\"61\\\" border=\\\"0\\\" style=\\\"padding: 1px\\\" />\r\n    </label>\r\n</div>\r\n\r\n\" . (!empty($vbulletin->options[\'magickpath\']) ? \"\r\n<div class=\\\"smallfont\\\" style=\\\"margin-top:1em\\\">\r\n    <label for=\\\"rb_setting[regimagetype]Magick_0\\\">\r\n  <input type=\\\"radio\\\"\r\n   name=\\\"setting[$setting[varname]]\\\"\r\n   id=\\\"rb_setting[regimagetype]Magick_0\\\"\r\n   value=\\\"Magick\\\"\r\n   \" . ($setting[\'value\'] == \'Magick\' ? \' checked=\"checked\"\' : \'\') . \"\r\n  />ImageMagick<br />\r\n  <img src=\\\"../image.php?hash=test&amp;i=im\\\" alt=\\\"ImageMagick\\\" width=\\\"201\\\" height=\\\"61\\\" border=\\\"0\\\" style=\\\"padding: 1px\\\" />\r\n    </label>\r\n</div>\r\n\" : \'\') . \"',
        29,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'attachpath',
        'version',
        'attachments',
        '/path/to/your/attachment/directory',
        'free',
        '',
        30,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'regimageoption',
        'version',
        '14',
        '15',
        'bitfield',
        'bitfield:nocache|regimageoptions',
        30,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'usefileavatar',
        'version',
        '1',
        '',
        'boolean',
        'yesno',
        40,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'avatarpath',
        'version',
        './customavatars',
        './customavatars',
        'free',
        '',
        50,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'avatarurl',
        'version',
        'customavatars',
        'customavatars',
        'free',
        '',
        60,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'profilepicpath',
        'version',
        './customprofilepics',
        './customprofilepics',
        'free',
        '',
        70,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'profilepicurl',
        'version',
        'customprofilepics',
        'customprofilepics',
        'free',
        '',
        80,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'sigpicpath',
        'version',
        './signaturepics',
        './signaturepics',
        'free',
        '',
        90,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'sigpicurl',
        'version',
        'signaturepics',
        'signaturepics',
        'free',
        '',
        100,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'fulltextsearch',
        'version',
        '0',
        '0',
        'boolean',
        'yesno',
        110,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'searchimplementation',
        'version',
        'vBDBSearch_Core',
        'vBDBSearch_Core',
        'free',
        '',
        110,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'album_dataloc',
        'version',
        'fs',
        'db',
        'free',
        'radio:piped\r\ndb|DB\r\nfs|File System\r\nfs_directthumb|File System with Direct Thumbs',
        120,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'album_picpath',
        'version',
        'albumpics',
        '',
        'free',
        '',
        130,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'album_thumbpath',
        'version',
        '',
        '',
        'free',
        '',
        140,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'album_thumburl',
        'version',
        '',
        '',
        'free',
        '',
        150,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'usefilegroupicon',
        'version',
        '0',
        '0',
        'boolean',
        'yesno',
        160,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'groupiconpath',
        'version',
        './customgroupicons',
        './customgroupicons',
        'free',
        '',
        165,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'groupiconurl',
        'version',
        'customgroupicons',
        'customgroupicons',
        'free',
        '',
        170,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'apikey',
        'version',
        'LGK7vRfM',
        '',
        'free',
        '',
        180,
        0,
        1,
         '',
         1,
         'vbulletin'
        );
    
    Duplicate entry 'apikey' for key 1]=]=></error>
        <error_html><=!=[=C=D=A=T=A=[<p>Database error in vBulletin 4.1.3</p>
    <p>Invalid SQL:
    
       INSERT INTO setting
       (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder,
       advanced, volatile, validationcode, blacklist, product)
       VALUES
       (
        'templateversion',
        'version',
        '4.1.3',
        '4.1.3',
        'free',
        '',
        1,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'default_route_segment',
        'version',
        'content',
        'content',
        'free',
        '',
        5,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'subscriptionmethods',
        'version',
        '0',
        '0',
        'boolean',
        'yesno',
        10,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'attachfile',
        'version',
        '2',
        '',
        'free',
        'radio:piped\r\n0|no\r\n1|yes(,)userid/userid.attach\r\n2|yes(,)u/s/e/r/i/d/userid.attach',
        20,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'hv_type',
        'version',
        'Question',
        'Image',
        'free',
        'radio:piped\r\n0|disabled\r\nImage|image_verification\r\nQuestion|question_verification\r\nRecaptcha|recaptcha',
        20,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'hv_recaptcha_publickey',
        'version',
        xxxxxxxxxxxxxxxx',
        '',
        'free',
        '',
        22,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'hv_recaptcha_privatekey',
        'version',
        'xxxxxxxxxxxxxxxxx',
        '',
        'free',
        '',
        24,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'hv_recaptcha_theme',
        'version',
        'blackglass',
        'white',
        'free',
        'radio:piped\r\nred|recaptcha_red\r\nwhite|recaptcha_white\r\nblackglass|recaptcha_blackglass\r\nclean|recaptcha_clean',
        25,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'regimagetype',
        'version',
        'GD',
        'GD',
        'free',
        '<div class=\\\"smallfont\\\">\r\n    <label for=\\\"rb_setting[regimagetype]GDttf_0\\\">\r\n  <input type=\\\"radio\\\"\r\n   name=\\\"setting[$setting[varname]]\\\"\r\n   id=\\\"rb_setting[regimagetype]GDttf_0\\\"\r\n   value=\\\"GDttf\\\"\r\n   \" . ($setting[\'value\'] == \'GDttf\' ? \' checked=\"checked\"\' : \'\') . \"\r\n  />GD<br />\r\n  <img src=\\\"../image.php?hash=test&amp;i=gd\\\" alt=\\\"GD\\\" width=\\\"201\\\" height=\\\"61\\\" border=\\\"0\\\" style=\\\"padding: 1px\\\" />\r\n    </label>\r\n</div>\r\n\r\n\" . (!empty($vbulletin->options[\'magickpath\']) ? \"\r\n<div class=\\\"smallfont\\\" style=\\\"margin-top:1em\\\">\r\n    <label for=\\\"rb_setting[regimagetype]Magick_0\\\">\r\n  <input type=\\\"radio\\\"\r\n   name=\\\"setting[$setting[varname]]\\\"\r\n   id=\\\"rb_setting[regimagetype]Magick_0\\\"\r\n   value=\\\"Magick\\\"\r\n   \" . ($setting[\'value\'] == \'Magick\' ? \' checked=\"checked\"\' : \'\') . \"\r\n  />ImageMagick<br />\r\n  <img src=\\\"../image.php?hash=test&amp;i=im\\\" alt=\\\"ImageMagick\\\" width=\\\"201\\\" height=\\\"61\\\" border=\\\"0\\\" style=\\\"padding: 1px\\\" />\r\n    </label>\r\n</div>\r\n\" : \'\') . \"',
        29,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'attachpath',
        'version',
        'attachments',
        '/path/to/your/attachment/directory',
        'free',
        '',
        30,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'regimageoption',
        'version',
        '14',
        '15',
        'bitfield',
        'bitfield:nocache|regimageoptions',
        30,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'usefileavatar',
        'version',
        '1',
        '',
        'boolean',
        'yesno',
        40,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'avatarpath',
        'version',
        './customavatars',
        './customavatars',
        'free',
        '',
        50,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'avatarurl',
        'version',
        'customavatars',
        'customavatars',
        'free',
        '',
        60,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'profilepicpath',
        'version',
        './customprofilepics',
        './customprofilepics',
        'free',
        '',
        70,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'profilepicurl',
        'version',
        'customprofilepics',
        'customprofilepics',
        'free',
        '',
        80,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'sigpicpath',
        'version',
        './signaturepics',
        './signaturepics',
        'free',
        '',
        90,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'sigpicurl',
        'version',
        'signaturepics',
        'signaturepics',
        'free',
        '',
        100,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'fulltextsearch',
        'version',
        '0',
        '0',
        'boolean',
        'yesno',
        110,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'searchimplementation',
        'version',
        'vBDBSearch_Core',
        'vBDBSearch_Core',
        'free',
        '',
        110,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'album_dataloc',
        'version',
        'fs',
        'db',
        'free',
        'radio:piped\r\ndb|DB\r\nfs|File System\r\nfs_directthumb|File System with Direct Thumbs',
        120,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'album_picpath',
        'version',
        'albumpics',
        '',
        'free',
        '',
        130,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'album_thumbpath',
        'version',
        '',
        '',
        'free',
        '',
        140,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'album_thumburl',
        'version',
        '',
        '',
        'free',
        '',
        150,
        0,
        1,
         '',
         0,
         'vbulletin'
        ),
        (
        'usefilegroupicon',
        'version',
        '0',
        '0',
        'boolean',
        'yesno',
        160,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'groupiconpath',
        'version',
        './customgroupicons',
        './customgroupicons',
        'free',
        '',
        165,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'groupiconurl',
        'version',
        'customgroupicons',
        'customgroupicons',
        'free',
        '',
        170,
        0,
        1,
         '',
         1,
         'vbulletin'
        ),
        (
        'apikey',
        'version',
        'LGK7vRfM',
        '',
        'free',
        '',
        180,
        0,
        1,
         '',
         1,
         'vbulletin'
        );<p>
    <p>
    <strong>MySQL Error</strong>   : Duplicate entry 'apikey' for key 1<br />
    <strong>Error Number</strong>  : 1062<br />
    <strong>Request Date</strong>  : Monday, May 30th 2011 @ 02:23:22 AM<br />
    <strong>Error Date</strong>    : Monday, May 30th 2011 @ 02:23:22 AM<br />
    <strong>Script</strong>        : http://site.com/beta/install/upgrade.php<br />
    <strong>Referrer</strong>      : http://site.com/beta/install/upgrade.php<br />
    <strong>Classname</strong>     : vB_Database<br />
    <strong>MySQL Version</strong> : 5.0.92-community<br />
    </p>]=]=></error_html>
    </errors>

  • #2
    Do you already have the Mobile Suite on this site? Or is this from another forum without that?
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - Highlight the correct navigation tab when you are on a custom page
    - "Quick Route" Interface...
    - Allow to use custom icons for individual forums

    Comment


    • #3
      Yes. I have the mobile Suite installed on this site.

      Comment


      • #4
        Any suggestions to fix this?
        Thanks.

        Comment


        • #5
          Please fill out a support ticket at:

          http://members.vbulletin.com/members...ontactform.php

          Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.
          Vote for:

          - *Admin Settable Paid Subscription Reminder Timeframe*
          -
          *PM - Add ability to reply to originator only*
          - Add Admin ability to auto-subscribe users to specific channel(s)
          - Highlight the correct navigation tab when you are on a custom page
          - "Quick Route" Interface...
          - Allow to use custom icons for individual forums

          Comment


          • #6
            Originally posted by Trevor Hannant View Post
            Please fill out a support ticket at:

            http://members.vbulletin.com/members...ontactform.php

            Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.
            I have the same issue after upgrading from 3.8 to 4.1.8. I have already placed a ticket in as well. Is there a manual way for me to correct this since my website is down? From what I am gathering your upgrade script doesn't catch that I already have an api key from 3.8?
            Herp Center - Reptile Forums

            Comment


            • #7
              The one thing that I believe was the fix was removing old styles and I did have one plugin that had to be removed.

              Comment


              • #8
                My site isn't up at all so removing anything doesn't seem to be an option right now unless I were to reinstall the old database and all of the old files. There has to be a manual way for me to remove everything that needs to be removed so I can continue with the final steps of this upgrade.
                Herp Center - Reptile Forums

                Comment


                • #9
                  Hopefully there is a easy way for you. I had to restore my old database and files.

                  Comment


                  • #10
                    Originally posted by iguanairs View Post
                    My site isn't up at all so removing anything doesn't seem to be an option right now unless I were to reinstall the old database and all of the old files. There has to be a manual way for me to remove everything that needs to be removed so I can continue with the final steps of this upgrade.
                    Do you have a note of your old API key?
                    Vote for:

                    - *Admin Settable Paid Subscription Reminder Timeframe*
                    -
                    *PM - Add ability to reply to originator only*
                    - Add Admin ability to auto-subscribe users to specific channel(s)
                    - Highlight the correct navigation tab when you are on a custom page
                    - "Quick Route" Interface...
                    - Allow to use custom icons for individual forums

                    Comment

                    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                    Working...
                    X