Issue: Unknown column 'injecttypeid' in 'where clause' -

Issue Tools
- View Changes

August 9, 2018 7:24 AM

SeToY

Junior Member

Unknown column 'injecttypeid' in 'where clause' -

Unknown column 'injecttypeid' in 'where clause' -

Hi,

this error just popped up:

Code:

Server Error Log
Error Info
XenForo_Exception: Database Error: SELECT * FROM `vw_integrate` WHERE injecttypeid = 1 AND `injectid` IN (64) LIMIT 1000 Mysqli prepare error: Unknown column 'injecttypeid' in 'where clause' - vault\core\controller\db\xf.php:187
Generated By: Unknown Account, 18 minutes ago
Stack Trace
#0 D:\inetpub\wwwroot\domain.com\vault\core\controller\db\xf.php(203): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception), 'SELECT * FROM `...')
#1 D:\inetpub\wwwroot\domain.com\vault\core\model\db\mysql\vw.php(27): vw_DB_Controller_XF->query_read('SELECT * FROM `...')
#2 D:\inetpub\wwwroot\domain.com\vault\core\model\cron\deferred\node\vw.php(71): vw_DB_MySQL_Model->select(Array)
#3 D:\inetpub\wwwroot\domain.com\vault\core\model\cron\deferred\vw.php(85): vw_Cron_Deferred_Node_Model->run(Array)
#4 D:\inetpub\wwwroot\domain.com\library\vw\XenForo\Deferred\vw.php(28): vw_Cron_Deferred_Model->exec()
#5 D:\inetpub\wwwroot\domain.com\library\XenForo\Model\Deferred.php(295): vw_XenForo_Deferred_vw->execute(Array, Array, 8, '')
#6 D:\inetpub\wwwroot\domain.com\library\XenForo\Model\Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 8, '', false)
#7 D:\inetpub\wwwroot\domain.com\library\XenForo\Model\Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 8, '', false)
#8 D:\inetpub\wwwroot\domain.com\deferred.php(23): XenForo_Model_Deferred->run(false)
#9 {main}
Request State
array(3) {
  ["url"] => string(49) "https://domain.com/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(16) "/wiki/Wiki-Pages"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}

CHeers

Issue Details

Issue Number 5438

Issue Type Bug

Project VaultWiki 4.x Series

Category Moderator Tools

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.23

Fixed Version 4.0.23

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 9, 2018 2:40 PM
pegasus

VaultWiki Team
This occurs after physically deleting a wiki page. Due to this error, forum integrations that were showing the page will not be removed. Affected integrations would now have to be updated manually.

In vault/core/model/cron/deferred/node/vw.php, find:

Code:

$query = $data['query'];

After it, add:

Code:

if (!empty($data['dm']) AND $data['dm'] == 'Integrate' AND !vw_Hard_Core::model('Version')->installed('4.0.24')) { vw_Hard_Core::controller('DM')->create('Integrate', 'SILENT')->instance->controller->assert_injectid_field(); }

It should be noted that this issue only occurs between 4.0.23 build 001 and 4.0.23 PL 1, and you need to be on at least 4.0.23 build 002 for the above code to fix the issue.
Reply
August 9, 2018 2:46 PM

SeToY

Junior Member

Thank you

Originally Posted by pegasus

Affected integrations would now have to be updated manually.

How would I go about doing this?

Reply

August 9, 2018 3:13 PM

pegasus

VaultWiki Team

After you save at least one new integration (which will update your database with the 4.0.24 columns), you can try the query:

Code:

DELETE integrate
FROM vw_integrate AS integrate
INNER JOIN vw_nodetype AS ntype ON (ntype.accesskey = 'Page' AND integrate.injecttypeid = ntype.id)
LEFT JOIN vw_page AS page ON (page.pageid = integrate.injectid)
WHERE page.pageid IS NULL

+ Reply

All times are GMT -4. The time now is 7:26 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Unknown column 'injecttypeid' in 'where clause' -

Issue Tools