General Error but from what mod?

[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()

[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).

[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?

[RMcGirr83]

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';