http://www.icyphoenix.com/viewtopic.php?f=35&t=4857&p=32876#p32876
-----------------------------------
gearhead
Thu 09 Oct, 2008 01:52

Re: Solved-Error When Trying To Reply To Post Or Create New
-----------------------------------
Yes, Sir. I'll be happy to.

It was simple really. I had to understand the request that was happening when the submit button was pressed. There's a lot of things going on each time a you issue a user command in php and mysql. (pressing submit button in a post or edit or new post).

Seems that when I updated the site with the user/group permissions, there was an error. I had a time trying to correct that. 
There's a lot going on with just that mysql function. During those checkpoints in the process, the error first came about by showing me that there were multiple groups for the same set of people.

 It took a few tries just in IP to delete those groups and start over. Simply deleting them is not the answer. In the meantime, when I loaded mysql data for the user and permissions/groups tables, it gave the assignments of my board the way it was before the crash.....(mixed with the defaults of the new install).

And, having a fresh install, (mysql basically), you have defaults set in the very beginning. Well, those defaults conflicted with the ones I loaded in mysql, from the backup I had.

Fixing things is a breeze of course when you know WHAT to fix. 

I very simply just made the permissions the exact same as the site before the crash, and that completely took care of it!
I fixed it within Icy, just by re-adding the "old" moderators!!!

Cool, huh?

It makes one confident to be able to fix certain functions, but thinking it through is really the first step, instead of just asking for help. You have to exhaust all of the possibilities in a safe manner as not to disturb the mysql/php functionality.

 :mryellow: