https://www.icyphoenix.com/viewtopic.php?f=35&t=4857
-----------------------------------
gearhead
Wed 08 Oct, 2008 04:03

Solved-Error When Trying To Reply To Post Or Create New Topic
-----------------------------------
Hi, all.

 After having trouble with my host, I lost my site. I did have a recent mysql backup. The file was very large, (3900 messages).

I re-installed the forum, and had good success re-adding my users. I have added the sql files from the backup, and for the most part they worked and updated the site.

I am now getting orphan topics back which is cool. I am however, having one problem cropping up so far.

When I try to submit a reply or create a topic and submit, I get this message:

Could not read group permissions for downloads

DEBUG MODE

SELECT * FROM ip_dl_auth

Line : 338
File : class_dlmod.php

Any help would be appreciated....one nice thing is I am saving my forum, and it's almost back to normal!!!!

I am getting better at mysql !!!!! Yipee. I'm really learning some good stuff.....I might even be dangerous with the next step!

 :lol:


UPDATE: I FIXED IT. NEVER MIND.....don't worry, like I said, mysql is getting really pretty easy for me!!!!!

Thanks to all.....especially LOPALONG! :kid:  :kid:  :kid:


-----------------------------------
Limun
Wed 08 Oct, 2008 12:03

Re: Solved-Error When Trying To Reply To Post Or Create New
-----------------------------------
[quote user="gearhead" post="32788"]

UPDATE: I FIXED IT. NEVER MIND.....don't worry, like I said, mysql is getting really pretty easy for me!!!!!

[/quote]

can u please describe how did u fixed this problem ?


-----------------------------------
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:


-----------------------------------
Mighty Gorgon
Thu 09 Oct, 2008 11:00

Re: Solved-Error When Trying To Reply To Post Or Create New
-----------------------------------
The AUTH table sometimes behave strangely... :roll:

A similar problem happened to me some months ago and the only solution was to empty the auth table and reassign permissions again.

I will have a closer to this table and consider if it should be better to implement the phpBB 3 permissions system.

I'll have a play.

Thanks for explaining the problem and the fix you did apply.


-----------------------------------
gearhead
Fri 10 Oct, 2008 00:58

Re: Solved-Error When Trying To Reply To Post Or Create New
-----------------------------------
No problem. I love I.P. I have gotten so used to it for one year and a half.

I am learning as much as possible so to fix small problems that occur. That's the best way to put the actions of that table. 

It is a puzzle that can be easily solved once you look at all the inputs/variables.

Thanks very much MG!

 :mricy:


-----------------------------------
xmenfile
Sun 26 Oct, 2008 14:10

Re: Solved-Error When Trying To Reply To Post Or Create New
-----------------------------------
[quote user="Mighty Gorgon" post="32893"]The AUTH table sometimes behave strangely... :roll:

A similar problem happened to me some months ago and the only solution was to empty the auth table and reassign permissions again.
[quote]

I am having the same problem and want to confirm that I'm going to empty phpbb_autho_access table thru phpmyadmin?  if not, please let me know what and how to empty it.


Thank you,
xmenfile


