Question fix this error

[twolegit]

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT *
FROM dbtech_vbshout_command
WHERE userid = '68'
ORDER BY command ASC;

MySQL Error : Table 'twolegit_vb1.dbtech_vbshout_command' doesn't exist
Error Number : 1146

its always the same user (super mod) and i'm just not sure what he's doing....he is on when I'm not so hard to have a conversation about it

---------- Post added at 01:25 ---------- Previous post was at 01:16 ----------

I just noticed an update for this mod as of today....so this error is prior to the update

 

[Force]

go to your admin panel and run this query

CREATE TABLE `dbtech_vbshout_command` (
`commandid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`command` varchar(50) NOT NULL default '',
`useinput` tinyint(1) unsigned NOT NULL default '0',
`output` mediumtext,
PRIMARY KEY (`commandid`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

[twolegit]

lol, so i am the owner and this is what i get when i select execute SQL query

You are not authorized to execute SQL queries

how would i go about fixing that(i know its not a vbtech) issue

 

[Fillip H.]

Add yourself to the canrunqueries variable in config.php

 

[Ozzy47]

You need to add your user id to the includes/config.php file on this line:

$config['SpecialUsers']['canrunqueries'] = '1,2';

 

[twolegit]

this is what i get when finished

Affected Rows: 0 (0.0031s)

 

[Fillip H.]

That's correct

 

[twolegit]

Great...thank you all for your fast and on point help!

 

[Force]

yes you are welcome for the fix