Announcement

Collapse
No announcement yet.

Update Problem with DB

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

  • Update Problem with DB

    When I went to upgrade to gold version I got to vbulletin-language.xml and it gave me this database error

    Code:
    Database error in vBulletin 3.0.0 Release Candidate 4:
    Invalid SQL: INSERT INTO phrase
    (languageid, phrasetypeid, varname, text)
    VALUES
    (-1, 0, 'addlist_buddy', '$userinfo[username] has now been successfully added to your buddy list. You will now be returned to where you were.'),
    (-1, 0, 'addlist_ignore', '$userinfo[username] has now been successfully added to your ignore list. You will now be returned to where you were.'),
    (-1, 0, 'attachdel', 'Selected attachments have been deleted.'),
    (-1, 0, 'calendaraddevent', 'Thanks for adding that event, you will now be returned to the event.'),
    (-1, 0, 'calendardeleteevent', 'Thanks for deleting that event. You will now be returned to your calendar.'),
    (-1, 0, 'calendarmoderated', 'Your event will not appear on the calendar until it is approved by a moderator.'),
    (-1, 0, 'calendarupdateevent', 'Thanks for updating that event, you will be returned to it.'),
    (-1, 0, 'deletepost', 'The post has been successfully deleted. You will now be returned to the thread.'),
    (-1, 0, 'deleteposts', 'The selected posts have been deleted. You will now be returned to the thread.'),
    (-1, 0, 'deletethread', 'The thread has been successfully deleted. You will now be returned to the forum.'),
    (-1, 0, 'deleteusernote', 'User Note has been deleted and you will now be returned to $userinfo[username]\'s User Notes.'),
    (-1, 0, 'dst', 'DST Settings Updated'),
    (-1, 0, 'duplicatepost', 'This post is a duplicate of a post that you have posted in the last five minutes. You will be redirected to that thread.'),
    (-1, 0, 'duplicatethread', 'This thread is a duplicate of a thread that you have posted in the last five minutes. You will be redirected to the thread listings.'),
    (-1, 0, 'editthanks', 'The post has been successfully edited. You are now being taken to the post.'),
    (-1, 0, 'editthread', 'The thread has been successfully edited. You are now being taken to the thread.'),
    (-1, 0, 'foldersedited', 'Your $itemtype folders have been updated. You will now be returned to your $itemtypes.'),
    (-1, 0, 'forumpasswordcorrect', 'The password was correctly entered. You are being redirected to where you were.'),
    (-1, 0, 'login', 'Thank you for logging in, $bbuserinfo[username].'),
    (-1, 0, 'logout', 'Logging you out, $bbuserinfo[username].'),
    (-1, 0, 'lostactivatecode', 'You account details and activation code have been sent to that email address. You will now be returned to where you were.'),
    (-1, 0, 'lostpw', 'Your username and details about how to reset your password have been sent to you by email. You will now be returned to where you were before.'),
    (-1, 0, 'markread', 'All forums have been marked as read and the new post indicators will now be off.'),
    (-1, 0, 'markread_single', 'This forum has been marked as read and its new post indicator will now be off.'),
    (-1, 0, 'mergethread', 'Those threads have been successfully merged. You will now be returned to the result of the merging.'),
    (-1, 0, 'movethread', 'The thread has been successfully moved / copied. You will now be returned to the thread.'),
    (-1, 0, 'nodelete', 'You have chosen not to delete this post. You are now being returned to the thread.'),
    (-1, 0, 'nodeletenote', 'You will be returned to $userinfo[username]\'s User Notes.'),
    (-1, 0, 'openclose', 'The thread has been successfully $action. You are now being taken to the thread.'),
    (-1, 0, 'pm_messagesdeleted', 'The message(s) have been deleted. You are now being redirected to your PM list.'),
    (-1, 0, 'pm_messagesent', 'Your private message has been sent. You will now be taken to your PM list. Thanks!'),
    (-1, 0, 'pm_messagesmarkedas', 'Selected Messages Marked as $readunread'),
    (-1, 0, 'pm_messagesmoved', 'Your message(s) have been moved. You will now be returned to your PM list.'),
    (-1, 0, 'pm_receiptsdeleted', 'Private Message Receipts Deleted'),
    (-1, 0, 'pollvotethanks', 'Thank you for voting. You will now be taken back to the poll.'),
    (-1, 0, 'post_manage', 'This post was successfully managed. You are now being redirected to it.'),
    (-1, 0, 'postthanks', 'Thank you for posting! You will now be taken to your post. If the administrator has selected to moderate all posts in this forum, you will be taken back to the forum and your post will be displayed presently. If you opted to post a poll, you will now be allowed to do so.'),
    (-1, 0, 'redirect_dst', 'DST Settings Updated'),
    (-1, 0, 'redirect_removedusers', 'Users removed from usergroup.'),
    (-1, 0, 'redirects_removed', 'Thread moved redirects successfully removed. You are now being redirected back to the thread.'),
    (-1, 0, 'registerthanks', 'Thank you for registering, $username. You will now be returned to the forum summary page.'),
    (-1, 0, 'reminderdeleted', 'Reminder(s) have been deleted. You will now be returned to your current event reminders.'),
    (-1, 0, 'removelist_buddy', '$userinfo[username] has now been successfully removed from your buddy list. You will now be returned to where you were.'),
    (-1, 0, 'removelist_ignore', '$userinfo[username] has now been successfully removed from your ignore list. You will now be returned to where you were.'),
    (-1, 0, 'reportthanks', 'Thank you for reporting that post. It will be dealt with as appropriate in due course.'),
    (-1, 0, 'reputationadd', 'Thanks for adding Reputation to this user. May you be lucky enough to receive the same Reputation back in turn.'),
    (-1, 0, 'search', 'Your search is in progress and you will be taken to the results in a moment. Thank you for your patience.'),
    (-1, 0, 'search_preferencessaved', 'Search Preferences Saved'),
    (-1, 0, 'sentemail', 'We have sent your email to $sendtoname. You will now be returned to the thread.'),
    (-1, 0, 'sentfeedback', 'Your feedback to the webmaster has been sent.'),
    (-1, 0, 'splitthread', 'The thread has been successfully split into two. Please wait while you are taken to the new thread.'),
    (-1, 0, 'sticky', 'The thread has been successfully $action. You are now being taken to the thread.'),
    (-1, 0, 'sub_threadsmoved', 'Your thread(s) have been moved. You will now be returned to your subscriptions.'),
    (-1, 0, 'subemail', 'Your email subscription choices have been updated. You will now be returned to your subscriptions.'),
    (-1, 0, 'submove', 'Your thread(s) have been moved. You will now be returned to your subscriptions.'),
    (-1, 0, 'subsadd_event', 'A notification for this event has been added.'),
    (-1, 0, 'subsadd_forum', 'A subscription for this forum has been added.'),
    (-1, 0, 'subsadd_thread', 'A subscription for this thread has been added.'),
    (-1, 0, 'subsremove_event', 'Your notification for this event has been removed.'),
    (-1, 0, 'subsremove_forum', 'Your subscription for this forum has been removed.'),
    (-1, 0, 'subsremove_thread', 'Your subscription for this thread has been removed.'),
    (-1, 0, 'subupdate', 'Subscription(s) have been updated. You will now be returned to your current subscriptions.'),
    (-1, 0, 'threadclosed', 'Sorry! This thread is closed! You will now be returned to the thread.'),
    (-1, 0, 'threadrate_add', 'Your vote on this thread has been added.'),
    (-1, 0, 'threadrate_update', 'Your vote on this thread has been updated.'),
    (-1, 0, 'updatelist_buddy', 'Your buddy list has been updated.'),
    (-1, 0, 'updatelist_ignore', 'Your ignore list has been updated.'),
    (-1, 0, 'updatethanks', 'Thank you for updating your profile, $bbuserinfo[username].'),
    (-1, 0, 'updatethanks_newemail', 'Thank you for updating your profile, $bbuserinfo[username]. Because you changed your email address, you will be sent an email to verify its existence.'),
    (-1, 0, 'usergroup_displaygroupupdated', 'Your primary display group is now $usergroup[title]'),
    (-1, 0, 'usergroup_nolongermember', 'You are no longer a member of this usergroup.'),
    (-1, 0, 'usergroup_requested', 'Your request to join this usergroup has been logged.'),
    (-1, 0, 'usergroup_welcome', 'Congratulations, you are now a member of the <i>$usergroupname</i> usergroup.'),
    (-1, 0, 'usernoteaddevent', 'Your note regarding $userinfo[username] has been recorded.')
    mysql error: Duplicate entry 'attachdel--1-0' for key 2
    mysql error number: 1062
    any help would be great.

  • #2
    Originally posted by Roland
    When I went to upgrade to gold version I got to vbulletin-language.xml and it gave me this database error

    Code:
    Database error in vBulletin 3.0.0 Release Candidate 4:
    Invalid SQL: INSERT INTO phrase
    (languageid, phrasetypeid, varname, text)
    VALUES
    (-1, 0, 'addlist_buddy', '$userinfo[username] has now been successfully added to your buddy list. You will now be returned to where you were.'),
    (-1, 0, 'addlist_ignore', '$userinfo[username] has now been successfully added to your ignore list. You will now be returned to where you were.'),
    (-1, 0, 'attachdel', 'Selected attachments have been deleted.'),
    (-1, 0, 'calendaraddevent', 'Thanks for adding that event, you will now be returned to the event.'),
    (-1, 0, 'calendardeleteevent', 'Thanks for deleting that event. You will now be returned to your calendar.'),
    (-1, 0, 'calendarmoderated', 'Your event will not appear on the calendar until it is approved by a moderator.'),
    (-1, 0, 'calendarupdateevent', 'Thanks for updating that event, you will be returned to it.'),
    (-1, 0, 'deletepost', 'The post has been successfully deleted. You will now be returned to the thread.'),
    (-1, 0, 'deleteposts', 'The selected posts have been deleted. You will now be returned to the thread.'),
    (-1, 0, 'deletethread', 'The thread has been successfully deleted. You will now be returned to the forum.'),
    (-1, 0, 'deleteusernote', 'User Note has been deleted and you will now be returned to $userinfo[username]\'s User Notes.'),
    (-1, 0, 'dst', 'DST Settings Updated'),
    (-1, 0, 'duplicatepost', 'This post is a duplicate of a post that you have posted in the last five minutes. You will be redirected to that thread.'),
    (-1, 0, 'duplicatethread', 'This thread is a duplicate of a thread that you have posted in the last five minutes. You will be redirected to the thread listings.'),
    (-1, 0, 'editthanks', 'The post has been successfully edited. You are now being taken to the post.'),
    (-1, 0, 'editthread', 'The thread has been successfully edited. You are now being taken to the thread.'),
    (-1, 0, 'foldersedited', 'Your $itemtype folders have been updated. You will now be returned to your $itemtypes.'),
    (-1, 0, 'forumpasswordcorrect', 'The password was correctly entered. You are being redirected to where you were.'),
    (-1, 0, 'login', 'Thank you for logging in, $bbuserinfo[username].'),
    (-1, 0, 'logout', 'Logging you out, $bbuserinfo[username].'),
    (-1, 0, 'lostactivatecode', 'You account details and activation code have been sent to that email address. You will now be returned to where you were.'),
    (-1, 0, 'lostpw', 'Your username and details about how to reset your password have been sent to you by email. You will now be returned to where you were before.'),
    (-1, 0, 'markread', 'All forums have been marked as read and the new post indicators will now be off.'),
    (-1, 0, 'markread_single', 'This forum has been marked as read and its new post indicator will now be off.'),
    (-1, 0, 'mergethread', 'Those threads have been successfully merged. You will now be returned to the result of the merging.'),
    (-1, 0, 'movethread', 'The thread has been successfully moved / copied. You will now be returned to the thread.'),
    (-1, 0, 'nodelete', 'You have chosen not to delete this post. You are now being returned to the thread.'),
    (-1, 0, 'nodeletenote', 'You will be returned to $userinfo[username]\'s User Notes.'),
    (-1, 0, 'openclose', 'The thread has been successfully $action. You are now being taken to the thread.'),
    (-1, 0, 'pm_messagesdeleted', 'The message(s) have been deleted. You are now being redirected to your PM list.'),
    (-1, 0, 'pm_messagesent', 'Your private message has been sent. You will now be taken to your PM list. Thanks!'),
    (-1, 0, 'pm_messagesmarkedas', 'Selected Messages Marked as $readunread'),
    (-1, 0, 'pm_messagesmoved', 'Your message(s) have been moved. You will now be returned to your PM list.'),
    (-1, 0, 'pm_receiptsdeleted', 'Private Message Receipts Deleted'),
    (-1, 0, 'pollvotethanks', 'Thank you for voting. You will now be taken back to the poll.'),
    (-1, 0, 'post_manage', 'This post was successfully managed. You are now being redirected to it.'),
    (-1, 0, 'postthanks', 'Thank you for posting! You will now be taken to your post. If the administrator has selected to moderate all posts in this forum, you will be taken back to the forum and your post will be displayed presently. If you opted to post a poll, you will now be allowed to do so.'),
    (-1, 0, 'redirect_dst', 'DST Settings Updated'),
    (-1, 0, 'redirect_removedusers', 'Users removed from usergroup.'),
    (-1, 0, 'redirects_removed', 'Thread moved redirects successfully removed. You are now being redirected back to the thread.'),
    (-1, 0, 'registerthanks', 'Thank you for registering, $username. You will now be returned to the forum summary page.'),
    (-1, 0, 'reminderdeleted', 'Reminder(s) have been deleted. You will now be returned to your current event reminders.'),
    (-1, 0, 'removelist_buddy', '$userinfo[username] has now been successfully removed from your buddy list. You will now be returned to where you were.'),
    (-1, 0, 'removelist_ignore', '$userinfo[username] has now been successfully removed from your ignore list. You will now be returned to where you were.'),
    (-1, 0, 'reportthanks', 'Thank you for reporting that post. It will be dealt with as appropriate in due course.'),
    (-1, 0, 'reputationadd', 'Thanks for adding Reputation to this user. May you be lucky enough to receive the same Reputation back in turn.'),
    (-1, 0, 'search', 'Your search is in progress and you will be taken to the results in a moment. Thank you for your patience.'),
    (-1, 0, 'search_preferencessaved', 'Search Preferences Saved'),
    (-1, 0, 'sentemail', 'We have sent your email to $sendtoname. You will now be returned to the thread.'),
    (-1, 0, 'sentfeedback', 'Your feedback to the webmaster has been sent.'),
    (-1, 0, 'splitthread', 'The thread has been successfully split into two. Please wait while you are taken to the new thread.'),
    (-1, 0, 'sticky', 'The thread has been successfully $action. You are now being taken to the thread.'),
    (-1, 0, 'sub_threadsmoved', 'Your thread(s) have been moved. You will now be returned to your subscriptions.'),
    (-1, 0, 'subemail', 'Your email subscription choices have been updated. You will now be returned to your subscriptions.'),
    (-1, 0, 'submove', 'Your thread(s) have been moved. You will now be returned to your subscriptions.'),
    (-1, 0, 'subsadd_event', 'A notification for this event has been added.'),
    (-1, 0, 'subsadd_forum', 'A subscription for this forum has been added.'),
    (-1, 0, 'subsadd_thread', 'A subscription for this thread has been added.'),
    (-1, 0, 'subsremove_event', 'Your notification for this event has been removed.'),
    (-1, 0, 'subsremove_forum', 'Your subscription for this forum has been removed.'),
    (-1, 0, 'subsremove_thread', 'Your subscription for this thread has been removed.'),
    (-1, 0, 'subupdate', 'Subscription(s) have been updated. You will now be returned to your current subscriptions.'),
    (-1, 0, 'threadclosed', 'Sorry! This thread is closed! You will now be returned to the thread.'),
    (-1, 0, 'threadrate_add', 'Your vote on this thread has been added.'),
    (-1, 0, 'threadrate_update', 'Your vote on this thread has been updated.'),
    (-1, 0, 'updatelist_buddy', 'Your buddy list has been updated.'),
    (-1, 0, 'updatelist_ignore', 'Your ignore list has been updated.'),
    (-1, 0, 'updatethanks', 'Thank you for updating your profile, $bbuserinfo[username].'),
    (-1, 0, 'updatethanks_newemail', 'Thank you for updating your profile, $bbuserinfo[username]. Because you changed your email address, you will be sent an email to verify its existence.'),
    (-1, 0, 'usergroup_displaygroupupdated', 'Your primary display group is now $usergroup[title]'),
    (-1, 0, 'usergroup_nolongermember', 'You are no longer a member of this usergroup.'),
    (-1, 0, 'usergroup_requested', 'Your request to join this usergroup has been logged.'),
    (-1, 0, 'usergroup_welcome', 'Congratulations, you are now a member of the <i>$usergroupname</i> usergroup.'),
    (-1, 0, 'usernoteaddevent', 'Your note regarding $userinfo[username] has been recorded.')
    mysql error: Duplicate entry 'attachdel--1-0' for key 2
    mysql error number: 1062
    any help would be great.
    same here as you......Please help!

    RC4 TO Gold.

    Comment


    • #3
      did you upload the new XML-files? Because the script tried to make duplicate entries - which didn't work.

      Comment


      • #4
        I have tried for many times but no way.
        I use an old rc4's file: include/adminfunctions_language.php to solve this problem.
        Works like a charm now.

        Comment


        • #5
          You didnt run upgrade.php and went straight to upgrade11.php ALWAYS run upgrade.php
          Scott MacVicar

          My Blog | Twitter

          Comment


          • #6
            Originally posted by Scott MacVicar
            You didnt run upgrade.php and went straight to upgrade11.php ALWAYS run upgrade.php
            Not your pointed that.
            In admincp use upload language.xml meet this problem too.

            Comment


            • #7
              yeah would still happen if you never ran upgrade.php regardless if you do it via tools.php in the extras folder, admincp or upgrade11.php

              We added variable names to the special phrase groups.
              Scott MacVicar

              My Blog | Twitter

              Comment


              • #8
                Originally posted by Scott MacVicar
                yeah would still happen if you never ran upgrade.php regardless if you do it via tools.php in the extras folder, admincp or upgrade11.php

                We added variable names to the special phrase groups.
                thank you Scott.

                Comment


                • #9
                  I try to run that one but i get another error.
                  Code:
                  Could not find phrase 'security_alert_x_still_exists'.

                  Comment


                  • #10
                    Originally posted by Scott MacVicar
                    You didnt run upgrade.php and went straight to upgrade11.php ALWAYS run upgrade.php
                    What should I do now then. I can't access the admincp or the upgrade.php. Is there away to manualy add the updates?

                    Comment


                    • #11
                      Can anyone help me, I can't even get into my admin cp where is need to get to.

                      Comment


                      • #12
                        Did you make a backup of the db prior to attempting the upgrade? If so I would restore it and try again.
                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment


                        • #13
                          the last backup is earlyer that day and there was activity durring the day so I would like to keep everything. Is there a way to just add the new phrases?

                          Comment


                          • #14
                            I think I fixed it or at least I hope I did. What I did was some how get into the admin cp and upload the new lang xml file and now everything seems to work.

                            Comment

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