+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Installation and Upgrades Support (https://community.mybb.com/forum-182.html)
+--- Thread: Attempting to update to 1.8.7 fails and breaks our database (/thread-191386.html)
Attempting to update to 1.8.7 fails and breaks our database - Monkeys - 2016-04-12
- Detailed description of your problem, including steps to reproduce if necessary
We attempted to update to 1.8.7 but that resulted in an error message ( http://lifepunch.net/s/2hTAHIRT4GuGqdw.png ) "1264 - Out of range value for column 'postnum' at row 599".Once that happened, I simply reverted back to the 1.8.6 files but we started getting bugs, such as plugins displaying their variables twice after being disabled/re-enabled, quick replies not refreshing the page automatically and seemingly "loading forever", the CHMOD had been reverted to not 777 on the necessary files, the "last poster" on the forums' index not updating..See this thread for more info: http://community.mybb.com/thread-191243-post-1217026.htmlNow I've rolled back both the 1.8.6 files AND the database and we're back to normal, the bugs are gone, etc.. but we are back to 1.8.6.So now, before we can update to 1.8.7, we need to find out what is wrong with our database that is causing these issues when we attempt to update.Thank you for your help.
- URL to your forum/URL to specific problematic page
www.lifepunch.net/forums - New installation or upgrade (from which version of MyBB)?
Upgrade from 1.8.6 - Test user account (if it requires additional permissions)
Will PM if necessary. - Screenshot or error text, verbatim
http://community.mybb.com/thread-191243-post-1217026.html#pid1217026
RE: Attempting to update to 1.8.7 fails and breaks our database - Destroy666 - 2016-04-12
Please start creating upgrade-related topic in the forum situated right below General Support - thank you. Moved there.
(2016-04-12, 12:43 PM)Monkeys Wrote: Once that happened, I simply reverted back to the 1.8.6 files
That's one of the worst thing you could do - don't do it. But good that you reverted the whole backup afterwards.
What's your MySQL version, which system does your server run and what's the highest value you have in that postnum column (or just provide the value from the mentioned row)?
RE: Attempting to update to 1.8.7 fails and breaks our database - Monkeys - 2016-04-12
Why is that the worst thing to do? If a backup fails and my forums are broken and inaccessible, rolling back the files & database to the backup I had is not a good thing?
Current version: 1.8.6
SQL Engine is MySQLi 5.5.38
Running on a dedicated server with Windows Server Web
Highest value for postnum is 3510. There are 8 entries that have -1 though, don't know why.
I keep trying to run the SQL query "select * from mybb_users where ROWNUM = 599" but it returns nothing.
RE: Attempting to update to 1.8.7 fails and breaks our database - Monkeys - 2016-04-15
Anyone?
RE: Attempting to update to 1.8.7 fails and breaks our database - Monkeys - 2016-04-18
Am I allowed to bump threads?
RE: Attempting to update to 1.8.7 fails and breaks our database - Monkeys - 2016-04-24
Well I don't know why this thread was ignored. Either way, big thanks to .m. for helping out.
The issue was that some postnums were at -1 for whatever reason. Set them to 0 and that fixed it.