weird error msg's after php upgrade

[ddas]

we had to do some upgrades to fix some security holes.

php is at 4.3.8 now, since then, all over the site spooky error messages appear, like

 

Warning: mysql_query(): Your query requires a full tablescan (table configuration, 166 rows affected). Use EXPLAIN to optimize your query. in /var/www/poisonfree/shop/includes/functions/database.php on line 44

 

Yeah, really. It just needs a full table scan. I deactivated warnings in php.ini, but it won't go away.

And then there's:

 

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /var/www/poisonfree/shop/includes/functions/database.php:44) in /var/www/poisonfree/shop/includes/functions/sessions.php on line 67

 

I definately do not have any empty lines or spaces after an ?> anywhere, so what's that for?

Which brings me to:

 

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /var/www/poisonfree/shop/includes/functions/database.php:44) in /var/www/poisonfree/shop/includes/functions/sessions.php on line 67

 

I don't even know what that means.

 

Plus, some more warnings regarding the table scans, look here, it's funny, looks like we're being hacked or something:

http://www.poisonfree.com/shop/

 

The thing is, we didn't change a thing in the installation, it worked perfectly before, now everything looks like ... no sales.

 

We also have a messageboard running, an UBBT.

at the bottom of each UBBT page it says:

 

Warning: (null)(): 2 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0

 

any clue? thx!

[Guest]

add this line to the top of catalog/includes/application_top.php:

 

ini_set("mysql.trace_mode","Off");

 

Matti

[ddas]

it worked, thanks!

 

is this an issue with milestone2, or am I just too dumb to configure php?

[Guest]

Its a PHP quirk - dunno if indexing the table would help - perhaps :unsure:

 

Matti