5.13 Usergroup refresh - loss of info(FIXED)

[mjm]

I created a new usergroup (vB), hit PhotoPost Refresh usergroups ...

Result: Upload File Size limit showed at 0 - I have set at 300k, and the Disk Space Limit showed at 300k instead of previous settings.

All my other usergroup settings did not change.

I added usergroup/refreshed 3 gallery apps and the same thing happened for all 3.

I re-entered info -> saved changes, and all is well, but figured best to let you know.

Mark

[Chuck S]

Try this as I dont know what integration your doing but lets use vb3.php as an example

Try making lines 518-519 this

Content visible to verified customers only.

[mjm]

They are using the basic vB user integration - not vB enhanced.

Carole will try out your instructions later tonight.

Thanks,
Mark

[mjm]

Hi Chuck,
We finally got around to trying this out and got the following error on Refresh Usergroups.
On returning to adminCP -> You are not an administrator, and I am not able to access adminCP.

Mark

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: adm-misc

Query: INSERT INTO usergroups (groupid,groupname,cpaccess,uploads,comments,disks pace,uploadsize,editpho,editposts,modaccess,useral bums,reqmod,canassign,uplimit) VALUES('1','Unregistered / Not Logged','0','0',' ments','0','0','0',' tposts','0','0','0',' assign','')

Result: You have an error in your SQL syntax near 'pace,uploadsize,editpho,editposts,modaccess,useral bums,reqmod,canassign,uplimit' at line 1

Database handle: Resource id #8

[Chuck S]

two things I see wrong

I think you have miscopied the code as there is no spacing in my line for diskspace. Also why do your values your trying to copy have non numeric inserts? The entire usergroup editor copies numberic permission settings etc. There is nothing non numeric about our sql inserts there and I see tposts and assign in your sql variable so yes your query will fail

The query as I posted does work fine as I tried it on my install. To get admin access back you need to use phpmyadmin and insert an administrators record back in there which for you would be like this

INSERT INTO pp_usergroups VALUES (6,'Administrator',1,1,1,1,'','','',1,1,1,0,0)

[mjm]

Yup, our mistake. It's working fine now.

A big thanks for the tutorial!

Mark and Carole