Tweet
When I went to upgrade to gold version I got to vbulletin-language.xml and it gave me this database error
any help would be great.
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
thank you Scott.
Comment