Jump to content

Uncaught exception when deleting guest content from pages


Recommended Posts

The background task to delete guest content from pages is spewing uncaught exceptions

SELECT * FROM `cms_custom_database_1` WHERE record_author_name='<redacted>' ORDER BY primary_id_field LIMIT 0,250
Unknown column 'record_author_name' in 'where clause'

#0 /opt/forum/system/Db/Select.php(388): IPS\_Db->preparedQuery()
#1 /opt/forum/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 /opt/forum/applications/core/extensions/core/Queue/MemberContent.php(93): IteratorIterator->rewind()
#4 /opt/forum/system/Task/Task.php(47): IPS\core\extensions\core\Queue\_MemberContent->run()
#5 /opt/forum/applications/core/tasks/queue.php(43): IPS\_Task::runQueue()
#6 /opt/forum/system/Task/Task.php(375): IPS\core\tasks\_queue->IPS\core\tasks\{closure}()
#7 /opt/forum/applications/core/tasks/queue.php(38): IPS\_Task->runUntilTimeout()
#8 /opt/forum/system/Task/Task.php(274): IPS\core\tasks\_queue->execute()
#9 /opt/forum/system/Task/Task.php(237): IPS\_Task->run()
#10 /opt/forum/applications/core/interface/task/task.php(58): IPS\_Task->runAndLog()
#11 {main}

 

Link to comment
Share on other sites

1 hour ago, Colonel_mortis said:

The background task to delete guest content from pages is spewing uncaught exceptions

SELECT * FROM `cms_custom_database_1` WHERE record_author_name='<redacted>' ORDER BY primary_id_field LIMIT 0,250
Unknown column 'record_author_name' in 'where clause'

#0 /opt/forum/system/Db/Select.php(388): IPS\_Db->preparedQuery()
#1 /opt/forum/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 /opt/forum/applications/core/extensions/core/Queue/MemberContent.php(93): IteratorIterator->rewind()
#4 /opt/forum/system/Task/Task.php(47): IPS\core\extensions\core\Queue\_MemberContent->run()
#5 /opt/forum/applications/core/tasks/queue.php(43): IPS\_Task::runQueue()
#6 /opt/forum/system/Task/Task.php(375): IPS\core\tasks\_queue->IPS\core\tasks\{closure}()
#7 /opt/forum/applications/core/tasks/queue.php(38): IPS\_Task->runUntilTimeout()
#8 /opt/forum/system/Task/Task.php(274): IPS\core\tasks\_queue->execute()
#9 /opt/forum/system/Task/Task.php(237): IPS\_Task->run()
#10 /opt/forum/applications/core/interface/task/task.php(58): IPS\_Task->runAndLog()
#11 {main}

 

Interesting, that column was added about two years ago and we checked the table structures in 4.6.

If you run the following, does it complete without error and add the missing column?

\IPS\cms\Databases::checkandFixDatabaseSchema( 1 );

 

Link to comment
Share on other sites

1 hour ago, Stuart Silvester said:

Interesting, that column was added about two years ago and we checked the table structures in 4.6.

If you run the following, does it complete without error and add the missing column?

\IPS\cms\Databases::checkandFixDatabaseSchema( 1 );

 

Yeah that did it. There was a period where due to a bug on my side we weren't running some manual upgrade code (just the json-defined changes) - if it was meant to be changed in an upgrade, that's probably the root cause, in which case that's on me.

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...