suddenly mysql problem encountered :(

[suski78]

Warning: mysql_query(): Your query requires a full tablescan (table configuration, 164 rows affected). Use EXPLAIN to optimize your query. in /var/www/html/eshop/catalog/admin/includes/functions/database.php on line 45

 

 

Anybody know, why do I get this?

I can remove errors by configuring the application_top.php like this:

 

// error_reporting(E_ALL & ~E_NOTICE); // this removed

error_reporting(E_ERROR|E_PARSE|E_ERROR|E_CORE_ERROR|E_COMPILE_ERROR); // this added

 

Is there a way to remove this error by making simple modifications to some settings or is the problem really that oscommerce table queries are not optimizes at all?

 

Please, I would appriceate, if someone would know a solution for this.

:|

[♥ecartz]

The problem is that you really need *all* the contents of that table, so the warning is redundant (i.e. you actually do want to do a table scan). Configuration Cache might fix this for you. If not, just turn off the warning notice (as per the method you posted).

 

Hth,

Matt

[suski78]

You mean I should download some configuration cache files and replace my files with those?

Sorry, I'm very new to oscommerce