Hi all, I'm trying to upgrade from 1.1.5 to 1.2.1 and the preocess hangs at the "Rebuilding Last Post Columns" stage with the following error:
MySQL error: 1109
Unknown table 't' in where clause
Query: SELECT COUNT(*) as num_threads FROM mybb_threads WHERE t.closed NOT LIKE 'moved|%'
I
am selecting the 1.0.x / 1.1.x option at the beginning so I'm kind of clueless about this.
Thanks in advance!
Hmm... lemme go fix this in a moment.
Put this in your install/resources/ folder and refresh the page to continue with the installation
OMG that file would have saved my life yesterday. Is that the new one in 1.2.1? If not it should be.
It is already in 1.2.1 - all it fixes is the above mentioned error.
Chris
Actually chris, no
That was a bug in 1.2.1
Yes, but the 1.2.1 download has been updated.
Thank you very *very* much guys! It replaced all my accentuated vocals with a ? symbol, but it's working nicely! Thx again! n_n
There seems to be still something wrong as a user over here tried to upgrade from 1.1.8 to 1.2.1 and received this error:
Quote:MySQL error: 1054
Unknown column 'tid' in 'field list'
Query: SELECT tid, firstpost FROM mybb_threads WHERE closed NOT LIKE 'moved|%' ORDER BY tid ASC LIMIT 0, 200
I just got same error on a 1.1.8 > 1.2.1 upgrade. The fix was posted but has this been placed in the download yet?
Also "Rebuilding Last Post Columns" takes FOREVER. Can't this be done in a better way? It takes about 3 minutes per 200 threads. I have 1700 threads. My fear of course is a timeout.