Uncaught exception when deleting guest content from pages

[Colonel_mortis]

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}

 

[Stuart Silvester]

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 );

 

[Colonel_mortis]

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.

[Marc Stridgen]

Glad thats sorted the problem for you 🙂