Update Install Error

Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Forum rules
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Locked
lvnthedream
Registered User
Posts: 1
Joined: Thu Feb 05, 2009 2:04 pm

Update Install Error

Post by 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
I've been banned
Posts: 280
Joined: Mon Feb 02, 2009 5:39 pm

Re: Update Install Error

Post by 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
User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: Update Install Error

Post by 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
Registered User
Posts: 6
Joined: Fri Feb 06, 2009 2:40 am

Re: Update Install Error

Post by 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.
Locked