Before installing vBulletin Connect, it is very important that you read the sticky topics in this channel. They provide important information and tutorials on the best practices in using vBulletin Connect.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
Upgrade to 5.2.3 Error Duplicate Entry in access table
I'm upgrading from 4.2.3 to 5.2.3. I'm currently doing this on a test forum, not live. Wow the upgrade script is slow, is that due to DB size? We can purge data before the live update.
Here is the error I ran into:
521a2 Step #16
Fatal Error Occurred
Duplicate entry '253-0' for key 'userid' on <mydomain>\forums\core\vb\db\query\stored.php : 124
Script: 521a2
Step: 16
I traced it the code in 521a2 Step 16 to a insert statement into the access table. Sure enough there are duplicate entries. 3 userids have multiple records. What's the problem here? Data or schema?
I manually dropped the table access_temp. Now it complains access_temp does not exist. access_temp is created in step 14. How do I rollback the upgrade to step 14?
No, these should really have been removed before you upgraded.
Simplest way now is this:
1. Take a copy of your /core/includes/config.php file.
2. Backup the whole forum folder.
3. Delete everything in the forum folder (except for attachments, avatars, profile pics, sigpics etc if these are stored in the file system)
4. Re-upload all the default vB5 files (except /core/install/)
5. Put back your copy of /core/includes/config.php
No, these should really have been removed before you upgraded.
Simplest way now is this:
1. Take a copy of your /core/includes/config.php file.
2. Backup the whole forum folder.
3. Delete everything in the forum folder (except for attachments, avatars, profile pics, sigpics etc if these are stored in the file system)
4. Re-upload all the default vB5 files (except /core/install/)
5. Put back your copy of /core/includes/config.php
I don't see anything about removing old files in the upgrade instructions. Do you have instructions for this for when I do this on the live system?
I don't see anything about removing old files in the upgrade instructions. Do you have instructions for this for when I do this on the live system?
Pretty much the same.
If your attachments, avatars etc are stored in the file system, then *everything* except those folders needs to be removed - but keep a copy of it all. Then upload the vB5 files into there.
If your attachmnts, avatars etc are in the database, then you can just rename your existing folder to something else, and create a new folder with the same name as the old one had. Then put the vB5 files in there. Or if your forum is in the site root, copy all the old vB4 folders and files to somewhere else as a backup, then upload the vB5 files and folders.
You will need to configure /core/includes/config.php with the right details, same as on previous versions.
You will need rename htaccess.txt in the forum root, to .htaccess (note the period / dot at the front of the name).
Leave the front end config.php alone.
And obviously...have a backup of your database before running the upgrade script.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also consent to the transfer of your data to our servers in the United States, where data protection laws may be different from those in your country.
Comment