usergroup - Problem in editing of group

[sbarbz]

hello !

I have problem when I try to edit a group of users,
I am successful to enter editing of group, second something and try
to guard and this give me the error of sql on account of the database..

Pront Screen :
http://img341.imageshack.us/img341/1349/40492705ez6.jpg

Thank you very much to the helpful !

[Marco van Herwaarden]

Please post the text of the full SQL error message instead of a screenprint. All important information is not visible.

[sbarbz]

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = '(COPPA) Users Awaiting Moderation',
`description` = '',
`usertitle` = '1',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`edithistorypermissions` = '0',
`forumpermissions` = '655375',
`genericpermissions` = '33554499',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`calendarpermissions` = '1',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericoptions` = '56',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`credit_induction` = '0',
`credit_referral` = '0',
`credit_refbonus` = '0',
`credit_daily` = '0',
`credit_active` = '0',
`credit_birthday` = '0',
`credit_repgive` = '0',
`credit_reppos` = '0',
`credit_repneg` = '0',
`credit_thread` = '1',
`credit_threadrate` = '0',
`credit_post` = '0',
`credit_ownthreadpost` = '0',
`credit_postsize` = '0',
`credit_pollmake` = '0',
`credit_pollvote` = '0',
`credit_unthread` = '0',
`credit_unpost` = '0',
`creditpermissions` = '0'
WHERE usergroupid=4;

MySQL Error : Unknown column 'edithistorypermissions' in 'field list'
Error Number : 1054
Date : Thursday, January 31st 2008 @ 06:35:29 PM
Script : http://zcomp.co.il/admincp/usergroup.php?do=update
Referrer : http://zcomp.co.il/admincp/usergroup.php?do=edit&usergroupid=4
IP Address : 79.181.168.49
Username : Admin
Classname : vb_database
Please :)

[Opserty]

Have you un-installed any hacks recently? Like one relating to Edit History? Make sure you've removed the custom file from includes/xml/ which is related to that modification. It should be something like bitfield_XXX.xml (XXX being some kind of name)

[sbarbz]

<u>bitfield_edit_history.xml</u> This ?

I erased the file and not any change in the result, I returned him in order not to destroy something else.

[Opserty]

Yes delete that file, then do the following:


Download and/or open the version of vBulletin which matches your version on your site
Go to the do_not_upload folder
Upload the tools.php file from this folder, make sure you upload this file to the /admincp/ folder on your site
Navigate to the tools.php ([norpase]http://www.yourdomain.com/admincp/tools.php[/noparse])
Look for Datastore Cache and click the [Bitfield Cache] option.
Follow any instructions that may appear
Make sure you delete tools.php as soon are you have completed the above

[sbarbz]

Thank you very much great, I am sure that if I had more patience were helpful me! But I don't have patience, I am a forum starts and apparently that not there was me a problem is elementary newly and this what I did. I thank you very on the excellent support, thank you very much.

[Marco van Herwaarden]

Removing the ./xml/bitfoeld_XXX.xml files belonging to modifications you have uninstalled and editing 1 usergroup should sove your problem.

[Opserty]

Ah yes I forgot that usergroup editing rebuilds the cache if it doesn't match. My bad. :(