Jurij Posted May 10, 2023 Share Posted May 10, 2023 Hello, I'm upgrading forum to the latest 4.7.10 version and upgrade process has stuck on the error: Unknown column 'forums_topics.publish_date' in 'where clause' : /public_html/system/Db/Select.php::446 SELECT * FROM `sonyforums_topics` AS `forums_topics` WHERE forums_topics.forum_id=? AND forums_topics.approved=1 AND forums_topics.state != ? AND forums_topics.last_post<=? AND forums_topics.publish_date <=? ORDER BY forums_topics.last_post DESC LIMIT 1 Retry and continue buttons do not work and i can't proceed with the upgrade. Is there any way to solve this problem? Thanks, Jurij Link to comment Share on other sites More sharing options...
Marc Posted May 10, 2023 Share Posted May 10, 2023 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Link to comment Share on other sites More sharing options...
Jurij Posted May 10, 2023 Author Share Posted May 10, 2023 Hello, Thanks for quick reply. I've updated "stored access information" section. Please let me know if you will have any troubles with logging to FTP / ACP. Best regards, Jurij Link to comment Share on other sites More sharing options...
Jim M Posted May 10, 2023 Share Posted May 10, 2023 Thank you. I have transferred this to a ticket so we can further investigate. Please watch your email for further correspondence. Link to comment Share on other sites More sharing options...
Jurij Posted May 11, 2023 Author Share Posted May 11, 2023 Hello, Problem is now solved by Invision Community Team. It appeared to be a bug in update process. They have a fix but they don't know in which version it will be implemented yet. Thank you very much for help and best regards, Jurij Link to comment Share on other sites More sharing options...
Marc Posted May 11, 2023 Share Posted May 11, 2023 Thank you for your feedback, and glad to hear the issue is now resolved on your site 🙂 Link to comment Share on other sites More sharing options...
Brad Olson Posted June 14, 2023 Share Posted June 14, 2023 Bumping this as I have the same error during the upgrade process. The fix doesn't appear to have been implemented yet so if someone could contact me with the details it would be appreciated. The access info in my account has been updated. Link to comment Share on other sites More sharing options...
Marc Posted June 14, 2023 Share Posted June 14, 2023 I have created a ticket on this for you, so we can take a closer look Link to comment Share on other sites More sharing options...
Phil A Posted August 15, 2023 Share Posted August 15, 2023 Hi, I am having the same problem this morning. Is this still an issue with the newest version? I'm running into the same issue on a local install of this. Is it something I can fix myself? Link to comment Share on other sites More sharing options...
Jim M Posted August 15, 2023 Share Posted August 15, 2023 This was resolved in 4.7.11 so is in the most recent release if you're running 4.7.12. Link to comment Share on other sites More sharing options...
Recommended Posts