General Error but from what mod?

Temporary forum to obtain support for MODs/Styles while phpbb.com is down
Locked
bbrian017
Registered User
Posts: 146
Joined: Sun Mar 11, 2007 6:12 pm
Contact:

General Error but from what mod?

Post by bbrian017 »

I got the following error I just need help finding what mod caused it and how to fix it!

Code: Select all

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 'FROM phpbb_posts p, phpbb_users u WHERE p.post_id IN ('2531', '2532') ' at line 3 [1064]

SQL

SELECT p.post_id, p.poster_id, p.post_subject, p.post_time, p.post_username, u.username, u.user_colour, FROM phpbb_posts p, phpbb_users u WHERE p.post_id IN ('2531', '2532') AND p.poster_id = u.user_id

BACKTRACE

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

FILE: includes/functions_admin.php
LINE: 1612
CALL: dbal_mysql->sql_query()

FILE: includes/mcp/mcp_main.php
LINE: 720
CALL: sync()

FILE: includes/mcp/mcp_main.php
LINE: 93
CALL: mcp_move_topic()

FILE: includes/functions_module.php
LINE: 471
CALL: mcp_main->main()

FILE: mcp.php
LINE: 231
CALL: p_master->load_active()

User avatar
RMcGirr83
Registered User
Posts: 357
Joined: Fri Mar 09, 2007 1:51 am
Contact:

Re: General Error but from what mod?

Post by RMcGirr83 »

Which file is that being called from and what does the code in that file look like (eg use the code bbcode tags and post up the php file that is giving you the errors).
Do not hire Christian Bullock he won't finish the job and will keep your money

User avatar
Brf
Support Team
Support Team
Posts: 332
Joined: Sun Mar 11, 2007 1:06 pm

Re: General Error but from what mod?

Post by Brf »

Nope. I do not see any comma at the end of that line in functions_admin.php. Did you just remove a mod or something?

User avatar
RMcGirr83
Registered User
Posts: 357
Joined: Fri Mar 09, 2007 1:51 am
Contact:

Re: General Error but from what mod?

Post by RMcGirr83 »

:roll:

Stupid code scroll thingy.

That line in includes/functions_admin.php should look like this

Code: Select all

				$sql = 'SELECT p.post_id, p.poster_id, p.post_subject, p.post_time, p.post_username, u.username, u.user_colour
					FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u
					WHERE ' . $db->sql_in_set('p.post_id', $post_ids) . '
						AND p.poster_id = u.user_id';
Do not hire Christian Bullock he won't finish the job and will keep your money

Locked