Bug Random Feature DB Error

[CharlieDelta]

It has been over 24 hours and the feature channel never changed so I tried to manually run the schedule task to test and get this db error;

Database error in vBulletin 4.2.3 Beta 2:

Invalid SQL:
SELECT channelid FROM dbtech_twitch_channel WHERE featured = '0' ORDER BY RAND() LIMIT 1;

MySQL Error   : Unknown column 'featured' in 'where clause'
Error Number  : 1054
Request Date  : Friday, September 26th 2014 @ 08:38:31 PM
Error Date    : Friday, September 26th 2014 @ 08:38:32 PM
Script        : http://.../cronadmin.php?do=runcron&cronid=273
Referrer      : http://www..../cronadmin.php?do=modify
IP Address    : 24.156.247.126
Username      : CharlieDeltaCDN
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.37-cll

PHP Warning: mysqli_query() [function.mysqli-query]: (42S22/1054): Unknown column 'featured' in 'where clause' in ..../includes/class_core.php on line 1393

 

[Fillip H.]

I've added a hotfix to /dbtech/twitch_pro/cron/featured.php

 

[CharlieDelta]

I now get these errors when running manually;

PHP Warning: mysqli_query() [function.mysqli-query]: (42S22/1054): Unknown column 'vapeman18' in 'where clause' in ..../includes/class_core.php on line 1393

Database error in vBulletin 4.2.3 Beta 2:

Invalid SQL:
UPDATE dbtech_twitch_channel SET isfeatured = '1' WHERE channelid = vapeman18;

MySQL Error   : Unknown column 'vapeman18' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, September 27th 2014 @ 04:02:27 PM
Error Date    : Saturday, September 27th 2014 @ 04:02:27 PM
Script        : http://www..../cronadmin.php?do=runcron&cronid=273
Referrer      : http://www..../cronadmin.php?do=modify
IP Address    : 24.156.247.126
Username      : CharlieDeltaCDN
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.37-cll

 

[Fillip H.]

If I didn't know better I'd say you were doing this on purpose!

No but in seriousness though, round 2 of hotfix for the same file is up

 

[CharlieDelta]

Works perfect now.