Shame, I do. And I did everything to make sure EasyMOD processes the Approval MOD corectly.RMcGirr83 wrote:By hand as I don't trust ezMod.
Shame, I do. And I did everything to make sure EasyMOD processes the Approval MOD corectly.RMcGirr83 wrote:By hand as I don't trust ezMod.
RMcGirr83 wrote:Okay.uncle.f wrote:Try installing the contrib/scripts/admin_sync_all.php script and run it from ACP to synchronize every post in all of your forums. If that does not help, then install contrib/scripts/admin_approval_reset.php script and run it from ACP followed by the 'Sync All' script (this will reset all posts approval status and resynchronize your forums). Afterwards try making a post that requires approval and see if you will get it on your index.RMcGirr83 wrote:That is exactly what I am talking about. Sorry about the pic, but yes I am logged in as Admin and when viewing a forum I can see that posts need to be approved but not when viewing the index.
By hand as I don't trust ezMod.If none of the above works, then it's either bad Approval MOD installation (how did you install it by the way?) or a conflict with another MOD that modifies the index.php page.
What can I do?Couldn't update private forum permissions
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, 1)' at line 2
INSERT INTO phpbb_auth_access (forum_id, group_id, auth_mod, auth_approve) VALUES (74, , 0, 1)
Line : 451
File : admin_ug_auth.php
Your SQL query that was modified by the Aproval MOD installation does not work properly. 99.99% chance it is caused by mistake in editing your admin_ug_auth.php file. Also could be due to conflict with another MOD but rather unlikely for that particular file.modernmom wrote:When trying to update permissions for a user, I get this error:
What can I do?Couldn't update private forum permissions
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax
To avoid this questions "ping pong" please see the Approval MOD FAQ, question 18.modernmom wrote:EasyMod...
You are experiencing a conflict between two MODs that changed the same bit of code in your viewforum.php file. I can try and help you if you send me your viewforum.php file as well as the complete answers to the questionnaire that you can find in the Approval MOD FAQ, question #18. Email all of that directly to me. You will find my e-mail in the Approval MOD FAQ as well.AcidRain wrote:i got in this problem that they r saying is approval mod
i had the approval mod installed by a pro in phpinstallers named RMCGRill
Firstly, phpBB 3.0 includes some (limited) features of the Approval MOD out of the box called moderation queue. At the moment I have neither time nor incentive to develop such a MOD for phpBB 3.0.tleah wrote:Are you going to update this mod for php version 3? Thanks.
After looking through your viewforum.php file I found the source of your problem. The problem is neither with the Approval MOD itself, nor it is caused by a MOD conflict. It looks like it is a human error done while editing viewforum.php file.AcidRain wrote:i got in this problem that they r saying is approval mod problem http://www.phpbb.com/community/viewtopi ... 1&t=676495
i had the approval mod installed by a pro in phpinstallers named RMCGRill
Code: Select all
ORDER BY $sql_approve_order, p2.post_time DESC
Code: Select all
ORDER BY t.topic_type DESC, $sql_approve_order, p2.post_time DESC
Code: Select all
#
#-----[ FIND ]---------------------------------------------
#
$sql
FROM
WHERE
AND
AND
AND
AND
AND t.topic_type <> " . POST_ANNOUNCE
#
#-----[ BEFORE, ADD ]-----
#
// sql modified by approval mod
#
#-----[ IN-LINE FIND ]-----------------
#
p2.post_time
#
#-----[ IN-LINE AFTER, ADD ]-----
#
, p2.post_approve
#
#-----[ IN-LINE FIND ]-----------------
#
= t.topic_last_post_id
#
#-----[ IN-LINE REPLACE WITH ]-----
#
= $sql_approve_where
#
#-----[ FIND ]---------------------------------------------
#
$limit_topics_time
ORDER BY t.topic_type
#
#-----[ IN-LINE FIND ]-----------------
#
t.topic_last_post_id DESC
#
#-----[ IN-LINE REPLACE WITH ]-----
#
$sql_approve_order
Code: Select all
p2.post_time DESC
That is true, I only included it in my "fix" because it has already been there.RMcGirr83 wrote: no where in either these instructions nor in a vanilla phpbb is there this in the sql
Code: Select all
p2.post_time DESC
Let me make it straight (I guess I did not make it very clear in my last post). In no way all that I wrote above was directed towards you and you alone. I know exactly how it feels when you do something for free and get something else than "thank you" in return. What I wrote was not an attempt to discredit your work. An error was made, so what -- we are all human. The point is that it happens way to often with many different people and I just got tired of researching "problems with my MOD" when in reality they are something else. So I snapped. I guess people who do not understand how free and open source works spoil the whole experience for those who care.RMcGirr83 wrote: Not sure where that came from but yeah an error was made, so shoot me. What do you want for nothing.
Absolutely agree, however, if you are comfortable enough editing files by hand why not using EasyMOD as an effective editing tool. The way I use EasyMOD is quite... well... easy and effective. I try to install a MOD with EasyMOD and if I get any "FIND" errors I go to those code points and see what is causing the conflict. Afterwards I alter the "FIND" directive accordingly (not the phpBB files!) and re-run EasyMOD. This way you only need to resolve the actual conflicts and the rest of the installation takes seconds.RMcGirr83 wrote: PS EasyMod is not some panacea for installing mods...especially if mods have been installed that alter the files to begin with.
thanx ubcle f. , it worked, thanx for giving all that time to sort out the matter.uncle.f wrote:You are experiencing a conflict between two MODs that changed the same bit of code in your viewforum.php file. I can try and help you if you send me your viewforum.php file as well as the complete answers to the questionnaire that you can find in the Approval MOD FAQ, question #18. Email all of that directly to me. You will find my e-mail in the Approval MOD FAQ as well.AcidRain wrote:i got in this problem that they r saying is approval mod
i had the approval mod installed by a pro in phpinstallers named RMCGRill