php - MySQL错误 -phpBB3
作为一个完整的PHP菜鸟,我一直在尝试用几个mod安装phpBB3。然而,有些东西打破了网站,我无法从官方论坛获得支持,除非我知道哪个mod导致了问题。以下是我收到的错误消息:
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()
我不确定我应该在这里发布什么其他信息,但随便问一下。提前谢谢。
最佳答案:
1 个答案:
答案 0 :(得分:0)
尝试在终极点mod中找到包含此文件的文件,并在其后面添加,
,就像这样
'SELECT' => 'u.*, z.friend, z.foe, p.*, pb.id AS pb_id, pb.holding AS pb_holding,
来源是link,但它是波兰语。
本文经用户投稿或网站收集转载,如有侵权请联系本站。