The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Can you please post the exact database error you are getting.
|
#3
|
|||
|
|||
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 |
#5
|
|||
|
|||
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.
|
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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) |
#8
|
||||
|
||||
Quote:
|
Благодарность от: | ||
dlewisr |
#9
|
||||
|
||||
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.
|
#10
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|