hello

I tried several times to upgrade to php4.10 and php5 through WHM.

When I check one of the sites(http://www.ptitamie.com) on my server I get following error:

A blank page with the following -->

Database error: Invalid SQL: SELECT MAX(id) as cnt FROM banners WHERE payment=1 AND size=0 AND died=0 AND id<>Array
MySQL Error: 1054 (Unknown column 'Array' in 'where clause')
Session halted.

This is a site that a programmer coded for me, when I do a downgrade to php4.9.x it works again.

What could be the problem? The programmer himself checked it too and couldn't find the problem


greetz
Amilo
:confused:

The above shows that you are trying to pass an array as a scalar variable.

Whatever is setting that variable is setting it incorrectly due to a change between PHP4 and PHP5.

Did you remember to upgrade Zend at the same time?? If you do not, it breaks PHP in much the same way you describe.