Jump to content

Upgrade to forum 4.7.10 stuck on Unknown column 'forums_topics.publish_date' in 'where clause' error

Jurij
Jurij
in Classic self-hosted technical help

Featured Replies

Posted

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

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. 

 

  • Author

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

Thank you. I have transferred this to a ticket so we can further investigate. Please watch your email for further correspondence.

  • Author

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

Thank you for your feedback, and glad to hear the issue is now resolved on your site 🙂 

  • 1 month later...

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.

I have created a ticket on this for you, so we can take a closer look

  • 2 months later...

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?

This was resolved in 4.7.11 so is in the most recent release if you're running 4.7.12. 

Go to topic listing

Recently Browsing 0

  • No registered users viewing this page.