Bug Database error

[Testeren]

Ops posted too fast so edited. I just downloaded latest version of vbquiz but can't turn it on in user groups.
I get this message every time I try:



Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '360',
`dbtech_vbquiz_permissions` = '2',
`dbtech_vbquiz_entry_permissions` = '0',
`dbtech_vbquiz_maxretries` = '',
`dbtech_vbquiz_entryminrep` = '',
`dbtech_vbquiz_entryminposts` = '',
`dbtech_vbquiz_admin_permissions` = '0',
`dbtech_vbquiz_permissions_pro` = '0',
`vbblog_general_permissions` = '524286',
`vbblog_customblocks` = '10',
`vbblog_custompages` = '10',
`vbblog_entry_permissions` = '57343',
`vbblog_comment_permissions` = '3038',
`dbtech_usertagpermissions` = '0',
`forumpermissions` = '134217727',
`genericpermissions` = '1609564095',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '7',
`pmsendmax` = '15',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '7',
`genericoptions` = '55',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '20000',
`signaturepermissions` = '499711',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`sigmaxvideos` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '400',
`albumpicmaxheight` = '600',
`albummaxpics` = '10000',
`albummaxsize` = '0',
`usercsspermissions` = '191',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '4294967295',
`groupiconmaxsize` = '65535'
WHERE usergroupid=6;

MySQL Error : Unknown column 'dbtech_vbquiz_permissions' in 'field list'
Error Number : 1054
Request Date : Saturday, November 16th 2013 @ 10:44:32 AM
Error Date : Saturday, November 16th 2013 @ 10:44:32 AM
Script : Log ind - xxxx - vBulletin Admin kontrolpanel
Referrer : Log ind - xxxx - vBulletin Admin kontrolpanel
IP Address : xxxxx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.5.32-cll

 

[Dylan]

If you look at the db through an interface my phpmyadmin and go to your database, can you see if the quiz columns were created in the usergroup table?

You should have columns like this

 

[Testeren]

In plain english I uploaded the files wrongly?

 

[Dylan]

If you didn't upload the files correctly there would have been an error when you were installing. I think you're safe there. It sounds like when you installed some of the database columns didn't get created for some reason. I just want to make sure the fields really aren't in your database before I work on some kind of fix file for it.

 

[Testeren]

I go to member groups and try to give myself (admin) rights to the quiz.
I check the yes boxes and hit save and then I get the database error.

I just tried to upload the files again and think I have everyone in the right place.
Not sure where to find what you need in order to help me?

 

[Testeren]

Is this what you are looking fore?

 

[Testeren]

Uninstalled and reinstalled today.
Still get the error when trying to approve user groups:
Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '360',
`dbtech_vbquiz_permissions` = '126',
`dbtech_vbquiz_entry_permissions` = '0',
`dbtech_vbquiz_maxretries` = '',
`dbtech_vbquiz_entryminrep` = '',
`dbtech_vbquiz_entryminposts` = '',
`dbtech_vbquiz_admin_permissions` = '0',
`dbtech_vbquiz_permissions_pro` = '0',
`dbtech_usertagpermissions` = '0',
`forumpermissions` = '134217727',
`genericpermissions` = '1609564095',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '7',
`pmsendmax` = '15',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '7',
`genericoptions` = '55',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '20000',
`signaturepermissions` = '499711',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`sigmaxvideos` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '400',
`albumpicmaxheight` = '600',
`albummaxpics` = '10000',
`albummaxsize` = '0',
`usercsspermissions` = '191',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '4294967295',
`groupiconmaxsize` = '65535'
WHERE usergroupid=6;

MySQL Error : Unknown column 'dbtech_vbquiz_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, November 17th 2013 @ 07:08:39 PM
Error Date : Sunday, November 17th 2013 @ 07:08:39 PM
Script : http://www.xxxx/forums/admincp/usergroup.php?do=update
Referrer : http://www.xxxxx/forums/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : xxx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.5.32-cll

 

[Dylan]

Mokonzi has access to your forum, is it ok if I use that access to try and reinstall it?

 

[Testeren]

Mokonzi has access to your forum, is it ok if I use that access to try and reinstall it?

Absolutly