Forum Issues

New Member Joined: Nov 27, 2008 Posts: 24

2 Problems.

I am admin on site but also have my normal account. When I set myself as moderator (normal account) on the forums and then try to post I get this error.

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 ' forum_topics = forum_topics + 1 WHERE forum_id = 6' at line 2

UPDATE nuke_bbforums SET forum_posts = forum_posts + 1, forum_last_post_id = , forum_topics = forum_topics + 1 WHERE forum_id = 6

Line : 424
File : functions_post.php

Also because of this problem above I deleted a previous account of mine that was set as moderator and now when I try to Group management and click on moderators I get this error.

Could not obtain user info for moderator list

DEBUG MODE

SELECT user_id, username FROM nuke_users WHERE user_id = 13

Line : 121
File : admin_groups.php

Are there fixes for these problems? Thanks

Posted: Mon Jan 05, 2009 1:54 pm

I can remove the 1st error when I remove myself from "Is moderator" to "Not moderator" in the forum options. But I need to be able to post and edit posts and make sticky's but can't sort it out.

Any takers? Smile

Posted: Mon Jan 05, 2009 2:13 pm

I've not been able to replicate this.

What version of mySQL and PHP are you using?

Posted: Mon Jan 05, 2009 4:03 pm

For this:

tallygd wrote:

Also because of this problem above I deleted a previous account of mine that was set as moderator and now when I try to Group management and click on moderators I get this error.

Could not obtain user info for moderator list

DEBUG MODE

SELECT user_id, username FROM nuke_users WHERE user_id = 13

Line : 121
File : admin_groups.php

Search for the FixGroup.php script on the forums here or you need to go into the nuke_bbforums table and change the user_id of the forum modetaor to your new user_id.

Posted: Mon Jan 05, 2009 4:07 pm

http://www.phpbb.com/kb/article/replacing-a-deleted-group-moderator-using-phpmyadmin/

Posted: Mon Jan 05, 2009 4:11 pm

Obviously the first error has to do with this ", forum_last_post_id = ,", but I have no idea how that is happening.

Posted: Mon Jan 05, 2009 5:41 pm

jakec wrote:

I've not been able to replicate this.

What version of mySQL and PHP are you using?

I am using MySQL client version: 4.1.22 and using RavenNuke_v2.30.00 with phpBB 2.0.23.
Other members are now able to post thanks to Guardian2003 but just not ones set as moderators of the forums.

Palbin, thank you for your help so far.

Posted: Tue Jan 06, 2009 3:13 am

So have you run the fixgroup scripts that Palbin mentioned, or used the link he provided?

Posted: Tue Jan 06, 2009 3:59 pm

Sorry all for not getting back sooner but I been under it at work but yes I used the link and was able to get into Group Moderator management.

Thank you Palbin for your help.

I am still working on the other issue. I am still not able to set myself as moderator and not get the error.

Posted: Tue Jan 06, 2009 4:32 pm

Found this googling http://www.phpbb.com/community/viewtopic.php?f=1&t=525464&start=0 so going to try and follow it. Wish me luck. Smile

Posted: Thu Jan 15, 2009 9:47 pm

Still no joy yet. Is there a way that admins can post and edit forums? Because I can't seem to find it.