forum is messed?

[jooda Jooda Zedraki]

Code: Select all

General Error
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 '' 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: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/auth.php
LINE: 832
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/auth.php
LINE: 400
CALL: auth->acl_raw_data_single_user()

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

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

FILE: [ROOT]/shout.php
LINE: 83
CALL: get_username_string()

FILE: [ROOT]/index.php
LINE: 37
CALL: include('[ROOT]/shout.php')

How to fix?

http://forum.alpha-evolution.net/index.php

[Handyman]

Hey Jooda,

It's a bit hard to tell how to fix it when you haven't provided any details of what you've done.
The problem you're having is that there is no user_id provided in the query, so it's throwing an SQL error.

[jooda Jooda Zedraki]

Fixed now. It was because I deleted a user who had posted in chat lol

[Handyman]

Ahh, that's interesting.
I didn't put any checks in the chat queries to make sure users existed, probably something I should do.