Update Install Error

[lvnthedream]

http://bowlinggreenmeadows.com/phpBB3

I am able to access the ACP just fine and I am also able to view the Main Forums page but when I choose a Topic I get the following

General Error
SQL ERROR [ mysqli ]

Unknown column 'Array' in 'where clause' [1054]

SQL

SELECT notify_status FROM phpbb_forums_watch WHERE forum_id = 111 AND user_id = Array

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: includes/functions_display.php
LINE: 1041
CALL: dbal_mysqli->sql_query()

FILE: viewforum.php
LINE: 198
CALL: watch_topic_forum()

[bolverk]

Did you start getting this error after an update to 3.0.4 using Automatic update?

After backing up your existing files
I would try downloading a fresh copy of those files (assuming 3.0.4 version) and replacing the ones on your server. Those files being the ones listed in the error message:

includes/db/mysqli.php
includes/functions_display.php
viewforum.php

[Lumpy Burgertushie]

first try this;

go to your config.php file

change the database type from mysqli to simply mysql

see what happens.

robert

[GTK]

I got this from a cashed page on google (all the way at the buttom)

Code: Select all

http://74.125.95.132/search?q=cache:TBWlzw7S5hcJ:www.phpbb.com/community/viewtopic.php%3Ff%3D46%26t%3D1384145%26start%3D0+Unknown+column+%27Array%27+in+%27where+clause%27+[1054]&hl=en&client=firefox-a&gl=us&strip=1

nattivillin » Tue Jan 06, 2009 3:17 am
This is how i fixed my problem. I made a backup of my sql database. I then downloaded the full 3.0.4 install and replaced all the files in the error message with new versions. Its been working with no more sql errors for a week now.

Swanny » Wed Jan 28, 2009 6:39 am
I also wanted to add that I had this error too. I fixed it by using the suggestion above, I downloaded a fresh copy of the latest files, and replaced just those files mentioned in the error message. Works great now.