Errors in database.php and sessions.php

[MrGraphics]

I have a successful installation, but I am getting these errors everywhere on the page. This comes at the top:

 

Warning: mysql_query(): Your query requires a full tablescan (table configuration, 142 rows affected). Use EXPLAIN to optimize your query. in C:\facets.com\catalog\includes\functions\database.php on line 44

 

Warning: session_start(): open(/tmp\sess_e05478e031bb65e4854bd64063bde59d, O_RDWR) failed: Permission denied (13) in C:\facets.com\catalog\includes\functions\sessions.php on line 67

 

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at C:\facets.com\catalog\includes\functions\database.php:44) in C:\facets.com\catalog\includes\functions\sessions.php on line 67

 

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at C:\facets.com\catalog\includes\functions\database.php:44) in C:\facets.com\catalog\includes\functions\sessions.php on line 67

 

Warning: mysql_query(): Your query requires a full tablescan (table currencies, 2 rows affected). Use EXPLAIN to optimize your query. in C:\facets.com\catalog\includes\functions\database.php on line 44

 

Warning: mysql_query(): Your query requires a full tablescan (table languages, 3 rows affected). Use EXPLAIN to optimize your query. in C:\facets.com\catalog\includes\functions\database.php on line 44

 

Warning: mysql_query(): Your query requires a full tablescan (table whos_online, 3 rows affected). Use EXPLAIN to optimize your query. in C:\facets.com\catalog\includes\functions\database.php on line 44

 

Warning: mysql_query(): Your query requires a full tablescan (table specials, 4 rows affected). Use EXPLAIN to optimize your query. in C:\facets.com\catalog\includes\functions\database.php on line 44

 

and this one shows up all over the place:

Warning: mysql_query(): Your query requires a full tablescan (table p, 27 rows affected). Use EXPLAIN to optimize your query. in C:\facets.com\catalog\includes\functions\database.php on line 44

 

I checked to make sure that there were no spaces at the end or beginning of the php files. I'm kinda lost now.

 

 

Also, when I add something to the cart, I get the above lines of error, plus this:

 

Warning: Cannot modify header information - headers already sent by (output started at C:\facets.com\catalog\includes\functions\database.php:44) in C:\facets.com\catalog\includes\functions\general.php on line 29

 

Warning: session_write_close(): open(/tmp\sess_e05478e031bb65e4854bd64063bde59d, O_RDWR) failed: Permission denied (13) in C:\facets.com\catalog\includes\functions\sessions.php on line 106

 

Warning: session_write_close(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in C:\facets.com\catalog\includes\functions\sessions.php on line 106

 

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

 

But if I hit back and check the contents of my cart, the item shows up in it.

 

Your help is greatly appreciated.

[♥Vger]

Change the last line of both configure.php files to read:

 

define('STORE_SESSIONS', 'mysql');

 

That will definitely get rid of some of your errors, but I doubt it will affect the sql errors - but I am no expert on mysql.

 

Vger

[MrGraphics]

That helped a bit, but still have the first group of errors all over the place.

 

I also noticed this error at the bottom of the administraton panel:

 

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

[MrGraphics]

I figured out that if I set

 

mysql.trace_mode = off

 

in my php.ini file, the errors went away. They are probably still there, but the site functions, so . . . oh well.

[MrGraphics]

I set

 

mysql.trace_mode = off

 

in my php.ini, and now everything works.