Database Error when changing Admin max number of pm's
 

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.

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

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

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

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.

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

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.

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.

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.

I always just add an x to the front of the file name to see if there will be any problems deleting it.

Good tip Lynne! I'll give that a blast.

--------------- Added [DATE]1338049313[/DATE] at [TIME]1338049313[/TIME] ---------------

Problem sorted. You're geniuses. ;)

Thank you Lynne as always and Borbole too.

That looks like the file that is causing the db error. But before you delete it, make a backup of it for just in case.

Cheers borbole, I did as Lynne said and put an x at the front of the file name. As soon as I went to edit permissions it rebuilt the bit field and sorted the issue for me. Problem solved... well that one is anyway. :sl I've now deleted it.

Thanks for your help again.

Glad to hear that you got it solved.

That's what I like about this community, people such as yourselves offer help almost immediately to those such as myself who know nothing of coding etc.

Cheers again to the pair of you.

Actually, the best way to uninstall a mod cleanly is to have a backup of that mod somewhere on your HD. Then, just look in the mod for any files that were uploaded and find them on your site and delete them, after you have uninstalled the mod in the product manager. Then you are sure to get everything that might have been left behind. ;)