Thread: Miscellaneous Hacks - Memberlist
View Single Post
  #13  
Old 04 Jul 2015, 13:45
blue6995 blue6995 is offline
 
Join Date: Oct 2005
Originally Posted by Justinphx View Post
I just get a error when accessing the members list after installing. I did set the usergroups.

you do not have permission to access this page. This could be due to one of several reasons:
Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation
I have the same, but when trying to save the update User Group permissions I get the following

Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color = \"blue\"><b>',
`closetag` = '</b></font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '134217727',
`genericpermissions` = '2113929151',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '0',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '7',
`genericoptions` = '63',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '235519',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`sigmaxvideos` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '191',
`visitormessagepermissions` = '62',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`dbtech_vbshoutpermissions` = '2',
`creditspermissions` = '12',
`credits_charge` = '',
`vbsoccer_general_permissions` = '7',
`vbblog_general_permissions` = '524286',
`vbblog_customblocks` = '5',
`vbblog_custompages` = '5',
`vbblog_entry_permissions` = '57343',
`vbblog_comment_permissions` = '3038',
`dbtech_vbactivitypermissions` = '3',
`dbtech_vbactivity_requestdelay` = '1',
`dbtech_vbactivity_nominatedelay` = '1',
`dbtech_vbquiz_permissions` = '122',
`dbtech_vbquiz_entry_permissions` = '14',
`dbtech_vbquiz_maxretries` = '0',
`dbtech_vbquiz_entryminrep` = '0',
`dbtech_vbquiz_entryminposts` = '0',
`dbtech_vbquiz_admin_permissions` = '0',
`dbtech_infopanelspermissions` = '2',
`dbtech_vbactivitymodpermissions` = '0',
`memberindex` = '7',
`dbtech_vbquiz_permissions_pro` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'credits_charge' in 'field list'
Error Number : 1054
Request Date : Friday, July 3rd 2015 @ 09:00:57 PM
Error Date : Friday, July 3rd 2015 @ 09:00:58 PM
Script : http://rwf-forum.co.uk/vBulletin/adm....php?do=update
Referrer : http://rwf-forum.co.uk/vBulletin/adm...&usergroupid=6
Classname : vB_Database_MySQLi
MySQL Version : 5.5.42-cll-lve
Reply With Quote