Author: petter.tornberg

Description:
The thread_signature column is missing from lqt.pg.sql, which results in LiquidThreads failing on thread creation. With the following error message:

A database error has occurred
Query: UPDATE thread SET thread_signature = '[[User:Admin|Admin]]' WHERE thread_id IS NULL
Function: Thread::doLazyUpdates
Error: 1 ERROR: column "thread_signature" of relation "thread" does not exist at character 54
Backtrace:
#0 /var/www/html/insite/wiki/includes/db/Database.php(538): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'UPDATE thread ...', 'Thread::doLazyU...', false)
#1 /var/www/html/insite/wiki/includes/db/Database.php(1212): DatabaseBase->query('UPDATE thread ...', 'Thread::doLazyU...')
#2 /var/www/html/insite/wiki/extensions/LiquidThreads/classes/Thread.php(867): DatabaseBase->update('thread', Array, Array, 'Thread::doLazyU...')
#3 /var/www/html/insite/wiki/extensions/LiquidThreads/classes/Thread.php(307): Thread->doLazyUpdates()
#4 /var/www/html/insite/wiki/extensions/LiquidThreads/classes/Thread.php(1491): Thread->author()
#5 /var/www/html/insite/wiki/extensions/LiquidThreads/classes/Thread.php(97): Thread->setSignature('[[User:Admin|Ad...')
#6 /var/www/html/insite/wiki/extensions/LiquidThreads/classes/View.php(857): Thread::create(Object(Article), Object(Article), NULL, 0, 'Web page feedba...', 'New thread: Web...', NULL, '[[User:Admin|Ad...')
#7 /var/www/html/insite/wiki/extensions/LiquidThreads/classes/View.php(404): LqtView::newPostMetadataUpdates(Array)
#8 /var/www/html/insite/wiki/extensions/LiquidThreads/pages/TalkpageView.php(307): LqtView->showNewThreadForm(Object(Article))
#9 /var/www/html/insite/wiki/extensions/LiquidThreads/classes/Dispatch.php(57): TalkpageView->show()
#10 /var/www/html/insite/wiki/extensions/LiquidThreads/classes/Dispatch.php(182): LqtDispatch::talkpageMain(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest))
#11 [internal function]: LqtDispatch::tryPage(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest), Object(MediaWiki))
#12 /var/www/html/insite/wiki/includes/Hooks.php(133): call_user_func_array(Array, Array)
#13 /var/www/html/insite/wiki/includes/Wiki.php(469): wfRunHooks('MediaWikiPerfor...', Array)
#14 /var/www/html/insite/wiki/includes/Wiki.php(70): MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest))
#15 /var/www/html/insite/wiki/index.php(117): MediaWiki->performRequestForTitle(Object(Title), Object(Article), Object(OutputPage), Object(User), Object(WebRequest))
#16 /var/www/html/insite/index.php(116): include('/var/www/html/i...')
#17 {main}

Should just be a matter of adding something like:
"thread_signature TEXT NOT NULL DEFAULT '',"
under "CREATE TABLE thread".
(I still consider it as major, since any non-SQL person would be in trouble.)

Version: unspecified
Severity: major
OS: Linux