MySQL Errors - phpBB3

159 views Asked by At

Being a complete noob at PHP, I've been trying to install phpBB3 with several mods. However, something has broken the site and I can't receive support from the official forums unless I know which mod is causing the problems. Here is the error message I'm receiving:

    SQL ERROR [ mysqli ]

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 '*, pb.id AS pb_id, pb.holding AS pb_holding FROM (phpbb_users u CROSS JOIN phpbb' at line 1 [1064]

SQL

SELECT u.*, z.friend, z.foe, p.*, gu.personal_album_id, gu.user_images, .*, pb.id AS pb_id, pb.holding AS pb_holding FROM (phpbb_users u CROSS JOIN phpbb_posts p) LEFT JOIN phpbb_zebra z ON (z.user_id = 2 AND z.zebra_id = p.poster_id) LEFT JOIN phpbb_gallery_users gu ON (gu.user_id = p.poster_id) LEFT JOIN phpbb_points_bank pb ON (pb.user_id = p.poster_id) WHERE p.post_id = 3 AND u.user_id = p.poster_id

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 189
CALL: dbal->sql_error()

FILE: [ROOT]/viewtopic.php
LINE: 1050
CALL: dbal_mysqli->sql_query()

I'm not sure what other info I should post here, but feel free to ask. Thank you in advance.

1

There are 1 answers

2
Hakem On

Try to find the file containing this in the ultimate points mod, and add a ,after it, to be like this

'SELECT'        => 'u.*, z.friend, z.foe, p.*, pb.id AS pb_id, pb.holding AS pb_holding,

Source is this link, but it is in Polish.