Database Error when changing Admin max number of pm's

[dlewisr]

Hi all.

I'm trying to change the maximum number of pm's that admin can have in their box. At the moment it is set to 50 but I'd like to increase it to 250, possible more. When I try to change it via Admin - Usergroup manager - Edit Aministrator- Maximum stored messages 250 then update, I get a database error number 1054

UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',

Is there another way to change the quota?

Cheers in advance.

[Lynne]

Can you please post the exact database error you are getting.

[dlewisr]

This is the error Lynne.
MySQL Error : Unknown column 'ms_vopt_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, October 19th 2011 @ 06:31:17 PM
Error Date : Wednesday, October 19th 2011 @ 06:31:17 PM
Script : http://www.xxxxxxxx/admincp/usergroup.php?do=update
Referrer : http://www.xxxxxxx/admincp/usergroup...&usergroupid=6
IP Address : 84.13.127.203
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.1.56-log

[Lynne]

That is from a modification. Disable, or uninstall, the modification and the error will go away.

[dlewisr]

Sorry for the delay in getting back to you, I've been working away from home. I'll go through the mods to see which one it is. Thanks Lynne, much appreciated.

[dlewisr]

I've disabled every mod and it still will not let me change the admin pm max messages.

MySQL Error : Unknown column 'ms_vopt_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, October 30th 2011 @ 08:16:46 AM
Error Date : Sunday, October 30th 2011 @ 08:16:47 AM
Script : http://www.xxxxxx/admincp/usergroup.php?do=update
Referrer : http://www.xxxxxx/admincp/usergroup....&usergroupid=6
Username : xxxxxx
Classname : vB_Database
MySQL Version : 5.1.56-log

Still getting the same error log 1054

[dlewisr]

Still have this error even though I have uninstalled all mods, upgraded to the latest version and reverted any templates customised. I can't make any changes at all to usergroups. Very frustrating Someone please put me out of my misery.

In saying that......... happy holidays to those of you in the States. Have a good one, hope it's as warm there as we're having in the UK. Enjoy

(I think I just clicked on the 'report post' icon by mistake then!!! Sorry)

[borbole]

Originally Posted by dlewisr

Still have this error even though I have uninstalled all mods, upgraded to the latest version and reverted any templates customised. I can't make any changes at all to usergroups. Very frustrating Someone please put me out of my misery.

In saying that......... happy holidays to those of you in the States. Have a good one, hope it's as warm there as we're having in the UK. Enjoy

(I think I just clicked on the 'report post' icon by mistake then!!! Sorry)

As mentioned by Lynne that comes from a plugin. You must delete its xml fileas well that is used to add a custom permission for the usergroups. That should fix the error. i.e. make a complete uninstall of that mod and not a partial one.

[Lynne]

It's from a leftover xml file that was uploaded for the modification. Uninstalling a mod requires going through the installation instructions backwards and undoing everything - removing files, template edits, etc as well as uninstalling the product.

[dlewisr]

I've just found this in the includes/xml folder

bitfield_ms_vopt.xml

could it be that? I'm wary of deleting it incase it's a valid file.