Warning: The author of this contribution does not provide support for it anymore.

Moderator Needed

Syntax Error - Moderator Needed

Syntax Error

by videoiso » Thu Jul 28, 2011 6:36 pm

Was working fine.
Then tried too delete a topic NOW

General Error
SQL ERROR [ mysql4 ]

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 '' at line 3 [1064]

SQL

SELECT forum_id, auth_option_id, auth_role_id, auth_setting FROM phpbb_acl_users WHERE user_id =

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/auth.php
LINE: 824
CALL: dbal_mysql->sql_query()

FILE: includes/auth.php
LINE: 392
CALL: auth->acl_raw_data_single_user()

FILE: includes/auth.php
LINE: 71
CALL: auth->acl_cache()

FILE: includes/functions_content.php
LINE: 1225
CALL: auth->acl()

FILE: includes/mcp/mcp_queue.php
LINE: 424
CALL: get_username_string()

FILE: includes/functions_module.php
LINE: 507
CALL: mcp_queue->main()

FILE: mcp.php
LINE: 244
CALL: p_master->load_active()
videoiso
Registered User
Posts: 26
Joined: Tue Jul 19, 2011 1:08 pm
Contact:

Re: Syntax Error

by RMcGirr83 » Thu Jul 28, 2011 6:47 pm

Nothing to do with this mod. You added something to mcp.php that is causing the error.
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21334
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Syntax Error

by videoiso » Thu Jul 28, 2011 6:51 pm

RMcGirr83 wrote:Nothing to do with this mod. You added something to mcp.php that is causing the error.


But until the mod was installed there was no problem, and when I install the mod, it does not disappear from the board?!
videoiso
Registered User
Posts: 26
Joined: Tue Jul 19, 2011 1:08 pm
Contact:

Re: Syntax Error

by RMcGirr83 » Thu Jul 28, 2011 6:52 pm

This mod doesn't touch mcp.php and I have this mod installed on my forum and I can delete topics/posts just fine.
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21334
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Syntax Error

by videoiso » Thu Jul 28, 2011 6:55 pm

I unistalled it once before and now I try and uninstall it and it still says 1 topic needs approval.
videoiso
Registered User
Posts: 26
Joined: Tue Jul 19, 2011 1:08 pm
Contact:

Re: Syntax Error

by RMcGirr83 » Thu Jul 28, 2011 7:04 pm

How are you uninstalling it? If via automod, then you need to remove the file from the hooks folder and purge your cache.
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21334
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Syntax Error

by videoiso » Thu Jul 28, 2011 7:12 pm

Yes via automod, please excuse a dumb question hooks folder?
videoiso
Registered User
Posts: 26
Joined: Tue Jul 19, 2011 1:08 pm
Contact:

Re: Syntax Error

by RMcGirr83 » Thu Jul 28, 2011 7:18 pm

via FTP includes/hooks remove the hook_moderator_needed.php file.
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21334
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Syntax Error

by videoiso » Thu Jul 28, 2011 7:26 pm

Ok got rid of the hooks, now only if I could fix the syntax error. Can't hint as too where too go?
videoiso
Registered User
Posts: 26
Joined: Tue Jul 19, 2011 1:08 pm
Contact:

Re: Syntax Error

by RMcGirr83 » Thu Jul 28, 2011 7:36 pm

So it seems it has nothing to do with this modification at all...just as I originally told you.

Check your mcp.php file as that is where the error is generating from.
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21334
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Syntax Error

by videoiso » Thu Jul 28, 2011 7:37 pm

If I go to mod logs there is nothing too approve but the mod says 1 topic too approve?
videoiso
Registered User
Posts: 26
Joined: Tue Jul 19, 2011 1:08 pm
Contact:

Re: Syntax Error

by RMcGirr83 » Thu Jul 28, 2011 7:44 pm

Did you purge the cache as I told you to do?
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21334
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Syntax Error

by videoiso » Thu Jul 28, 2011 7:54 pm

Yup , still getting error when I click moderation queue
videoiso
Registered User
Posts: 26
Joined: Tue Jul 19, 2011 1:08 pm
Contact:

Re: Syntax Error

by RMcGirr83 » Thu Jul 28, 2011 8:06 pm

If you uninstalled the mod (aka removed the edits to the html files) how are you still seeing "1 topic to approve"?
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21334
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Syntax Error

by videoiso » Thu Jul 28, 2011 8:24 pm

I had the mod installed, and when I went mod queue I got error, now I removed mod, and cant fix this freaking error
videoiso
Registered User
Posts: 26
Joined: Tue Jul 19, 2011 1:08 pm
Contact: