Announcement

Collapse
No announcement yet.

error when i do upgrade

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

  • [Forum] error when i do upgrade

    Database error in vBulletin 4.0.0 Alpha 6:

    Invalid SQL:
    ALTER TABLE attachment ADD INDEX contenttypeid (contenttypeid,contentid,attachmentid);

    MySQL Error : Key column 'contenttypeid' doesn't exist in table
    Error Number : -1
    Request Date : Tuesday, January 5th 2010 @ 04:44:43 PM
    Error Date : Tuesday, January 5th 2010 @ 04:44:43 PM
    Script : ***********/install/upgrade_400b1.php?step=1
    Referrer :***********//install/upgrade_400b1.php
    Username :
    Classname : vB_Database
    MySQL Version :

  • #2
    This is normally caused by users restoring a DB and leaving the filedata table that vB4 creates in place. Are you running 3.x on your site or a previous version of vB4?
    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)
    - "Quick Route" Interface...

    Comment


    • #3
      I use 3.8.2

      Now i use 3.8.2 , and the problem happened when i do upgrade to version 4.0.0

      Comment


      • #4
        Do you have a backup of your database from before your first attempt to upgrade? If so, try restoring this to a new database, edit the config.php file to point to this new database and try the upgrade again.
        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)
        - "Quick Route" Interface...

        Comment


        • #5
          ok

          will upgrade again

          Regards ,

          Comment


          • #6
            I upgrade again

            I upgrade the forum again and still get the error

            Database error in vBulletin 3.8.2:

            Invalid SQL:
            INSERT INTO tagcontent
            (tagid, contenttypeid, contentid, userid, dateline)
            SELECT tagid, 2, threadid, userid, dateline
            FROM tagthread;

            MySQL Error : Duplicate entry '1-2-8843' for key 1
            Error Number : 1062
            Request Date : Thursday, January 7th 2010 @ 03:40:26 PM
            Error Date : Thursday, January 7th 2010 @ 03:40:26 PM
            Script : ............................/install/upgrade_400a1.php?step=3
            Referrer :
            Username :
            Classname : vB_Database
            MySQL Version : 5.0.85-community

            Comment


            • #7
              Your backup must have had some vB4 tables in it when you backed it up last.

              Go into phpMyAdmin and DROP the tagcontent table from your database and re-run this step. However you may get additional errors during the rest of the upgrade process if other tables already exist.
              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)
              - "Quick Route" Interface...

              Comment


              • #8
                Many thanks for your help

                but after i drop this table get this error

                Database error in vBulletin 4.0.0 Alpha 6:

                Invalid SQL:
                ALTER TABLE attachment ADD INDEX contenttypeid (contenttypeid,contentid,attachmentid);

                MySQL Error : Key column 'contenttypeid' doesn't exist in table
                Error Number : -1
                Request Date : Saturday, January 9th 2010 @ 01:25:55 PM
                Error Date : Saturday, January 9th 2010 @ 01:25:55 PM
                Script : .................................../install/upgrade_400b1.php?step=1
                Referrer : .................................../install/upgrade_400b1.php?step=1
                Username :
                Classname : vB_Database
                MySQL Version :
                Last edited by alaa_co; Sat 9 Jan '10, 1:54am.

                Comment


                • #9
                  Try running this query then refresh the page:

                  Code:
                  ALTER TABLE attachment ADD contenttypeid INT UNSIGNED NOT NULL DEFAULT '0';
                  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)
                  - "Quick Route" Interface...

                  Comment


                  • #10
                    Thanks Trevor Hannant

                    I have altered the table. but after that i get this message

                    Your vBulletin version does not appear to match with the version for which this script was created (version 4.0.0 Beta 3).
                    Please ensure that you are attempting to run the correct script.
                    If you are sure this is the script you would like to run, click here.


                    and when i click here it go back to step below


                    Step 1) Upgrading Advertising Manager
                    • Creating ad table
                    • Creating adcriteria table

                    Comment


                    • #11
                      No way ????

                      Comment


                      • #12
                        Try re-uploading all the files to your server again ensuring that you overwrite all files already there then re-run that step.
                        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)
                        - "Quick Route" Interface...

                        Comment


                        • #13
                          get this error

                          Database error in vBulletin 4.0.0:

                          Invalid SQL:
                          UPDATE style SET
                          dateline = 1263910575,
                          templatelist = 'a:733:{s:18:\".alt1, .alt1Active\";s:5:\"12046\";s:18:\".alt2, .alt2Active\";s:5:\"12047\";s:5:\".alt3\";s:5:\"12048\";s:7:\".button\";s:5:\"12049\";s:8: \".fjdpth0\";s:5:\"12050\";s:8:\".fjdpth1\";s:5:\"12051\";s:8:\".fjdpth2\";s:5:\"12052\";s :8:\".fjdpth3\";s:5:\"12053\";s:8:\".fjdpth4\";s:5:\"12054\";s:6:\".fjsel\";s:5:\"12055\"; s:10:\".highlight\";s:5:\"12056\";s:10:\".inlinemod\";s:5:\"12057\";s:7:\".navbar\";s:5:\" 12058\";s:5:\".page\";s:5:\"12059\";s:6:\".panel\";s:5:\"12060\";s:14:\".panelsurround\";s :5:\"12061\";s:10:\".smallfont\";s:5:\"12062\";s:8:\".tborder\";s:5:\"12063\";s:5:\".tcat\ ";s:5:\"12064\";s:6:\".tfoot\";s:5:\"12065\";s:6:\".thead\";s:5:\"12066\";s:5:\".time\";s: 5:\"12067\";s:15:\".vbmenu_control\";s:5:\"12068\";s:14:\".vbmenu_hilite\";s:5:\"12069\";s :14:\".vbmenu_option\";s:5:\"12070\";s:13:\".vbmenu_popup\";s:5:\"12071\";s:8:\".wysiwyg\" ;s:5:\"12072\";s:12:\"activateform\";s:5:\"12683\";s:21:\"activate_requestemail\";s:5:\"12 684\";s:3:\"ad_\";s:5:\"12107\";s:25:\"ad_archive_above_content1\";s:5:\"12108\";s:25:\"ad _archive_above_content2\";s:5:\"12109\";s:24:\"ad_archive_below_content\";s:5:\"12110\";s: 29:\"ad_board_below_whats_going_on\";s:5:\"12111\";s:13:\"ad_footer_end\";s:5:\"12112\";s: 15:\"ad_footer_start\";s:5:\"12113\";s:28:\"ad_forumdisplay_afterthreads\";s:5:\"12114\";s :24:\"ad_forumhome_afterforums\";s:5:\"12115\";s:25:\"ad_forum_below_threadlist\";s:5:\"12 116\";s:22:\"ad_global_above_footer\";s:5:\"12117\";s:22:\"ad_global_below_navbar\";s:5:\" 12118\";s:17:\"ad_global_header1\";s:5:\"12119\";s:17:\"ad_global_header2\";s:5:\"12120\"; s:13:\"ad_header_end\";s:5:\"12121\";s:14:\"ad_header_logo\";s:5:\"12122\";s:15:\"ad_navba r_below\";s:5:\"12123\";s:22:\"ad_showthread_beforeqr\";s:5:\"12124\";s:23:\"ad_showthread _firstpost\";s:5:\"12125\";s:27:\"ad_showthread_firstpost_sig\";s:5:\"12126\";s:29:\"ad_sh owthread_firstpost_start\";s:5:\"12127\";s:28:\"ad_thread_first_post_content\";s:5:\"12128 \";s:27:\"ad_thread_last_post_content\";s:5:\"12129\";s:9:\"album.css\";s:5:\"12130\";s:8: \"albumbit\";s:5:\"12131\";s:14:\"album_addgroup\";s:5:\"12132\";s:23:\"album_addgroup_gro upbit\";s:5:\"12133\";s:10:\"album_edit\";s:5:\"12134\";s:15:\"album_latestbit\";s:5:\"121 35\";s:10:\"album_list\";s:5:\"12136\";s:23:\"album_moderatedcomments\";s:5:\"12137\";s:16 :\"album_picturebit\";s:5:\"12138\";s:25:\"album_picturebit_checkbox\";s:5:\"12139\";s:23: \"album_picturebit_unread\";s:5:\"12140\";s:17:\"album_picturelist\";s:5:\"12141\";s:17:\" album_pictureview\";s:5:\"12142\";s:18:\"album_picture_edit\";s:5:\"12143\";s:21:\"album_p icture_editbit\";s:5:\"12144\";s:20:\"album_unreadcomments\";s:5:\"12145\";s:12:\"announce ment\";s:5:\"12146\";s:16:\"announcement.css\";s:5:\"12147\";s:17:\"announcement_edit\";s: 5:\"12148\";s:12:\"assetmanager\";s:5:\"12149\";s:16:\"assetmanager.css\";s:5:\"12150\";s: 25:\"assetmanager_detailedview\";s:5:\"12151\";s:17:\"assetmanager_help\";s:5:\"12152\";s: 21:\"assetmanager_listview\";s:5:\"12153\";s:22:\"assetmanager_thumbview\";s:5:\"12154\";s :26:\"assetmanager_uploadcontrol\";s:5:\"12155\";s:24:\"assetmanager_usage_album\";s:5:\"1 2156\";s:26:\"assetmanager_usage_article\";s:5:\"12157\";s:24:\"assetmanager_usage_group\" ;s:5:\"12158\";s:23:\"assetmanager_usage_post\";s:5:\"12159\";s:14:\"attachment.css\";s:5: \"12685\";s:13:\"attachmentbit\";s:5:\"12686\";s:11:\"ATTACHMENTS\";s:5:\"12687\";s:15:\"a ttachments.css\";s:5:\"12688\";s:20:\"backgroundpicker.css\";s:5:\"12689\";s:10:\"bbcode.c ss\";s:5:\"12160\";s:14:\"bbcodelist.css\";s:5:\"12161\";s:11:\"bbcode_code\";s:5:\"12162\ ";s:19:\"bbcode_code_styleid\";i:-1;s:21:\"bbcode_code_printable\";s:5:\"12163\";s:11:\"bbcode_html\";s:5:\"12164\";s:19:\"b bcode_html_styleid\";i:-1;s:21:\"bbcode_html_printable\";s:5:\"12165\";s:10:\"bbcode_php\";s:5:\"12166\";s:18:\"bb code_php_styleid\";i:-1;s:20:\"bbcode_php_printable\";s:5:\"12167\";s:12:\"bbcode_quote\";s:5:\"12168\";s:20:\"b bcode_quote_styleid\";i:-1;s:22:\"bbcode_quote_printable\";s:5:\"12169\";s:12:\"bbcode_video\";s:5:\"12170\";s:16:\ "bdr130_editor_on\";s:5:\"11265\";s:18:\"bdr130_headinclude\";s:5:\"11266\";s:16:\"bdr130_ marq_form\";s:5:\"11267\";s:17:\"bdr130_quickreply\";s:5:\"11268\";s:24:\"bdr130_sid_hide_ noaccess\";s:5:\"11269\";s:12:\"bdr130_table\";s:5:\"11270\";s:16:\"bdr130_table_2nd\";s:5 :\"11271\";s:18:\"bdr130_table_error\";s:5:\"11272\";s:19:\"bdr130_table_output\";s:5:\"11 273\";s:15:\"bdr130_table_td\";s:5:\"11274\";s:15:\"bdr130_table_tr\";s:5:\"11275\";s:16:\ "bdr130_text_form\";s:5:\"11276\";s:13:\"bdr130_usercp\";s:5:\"11277\";s:17:\"block_blogen tries\";s:5:\"12171\";s:17:\"block_cmsarticles\";s:5:\"12172\";s:10:\"block_html\";s:5:\"1 2173\";s:14:\"block_newposts\";s:5:\"12174\";s:19:\"block_sgdiscussions\";s:5:\"12175\";s: 14:\"block_tagcloud\";s:5:\"12176\";s:13:\"block_threads\";s:5:\"12177\";s:8:\"blog.css\"; s:5:\"12178\";s:22:\"board_inactive_warning\";s:5:\"12690\";s:4:\"body\";s:5:\"12073\";s:9 :\"BUDDYLIST\";s:5:WHERE styleid = 2;

                          MySQL Error : Unknown column 'dateline' in 'field list'
                          Error Number : 1054
                          Request Date : Tuesday, January 19th 2010 @ 05:16:15 PM
                          Error Date : Tuesday, January 19th 2010 @ 05:16:16 PM
                          Script : ....................................../install/finalupgrade.php?step=5
                          Referrer : ....................................../install/finalupgrade.php?step=4&startat=60
                          Username :
                          Classname : vB_Database
                          MySQL Version : 5.0.85-community

                          Comment


                          • #14
                            What can i do to finish installtion ?

                            Comment


                            • #15
                              What fields do you have in the style table - if any?
                              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)
                              - "Quick Route" Interface...

                              Comment

                              Related Topics

                              Collapse

                              Working...
                              X