Page 1 of 1

Warning: mysql_query() [solved]

Posted: Thu Apr 14, 2005 1:47 am
by stef
hi,

after succeed installation,
on the sidebar, i have several messages like :
Warning: mysql_query() [http://www.mysql.com/doc]: Your query requires a full tablescan (table serendipity1_plugins, 12 rows affected). Use EXPLAIN to optimize your query. in /home/ecoles/eco-ornolac/sy9/include/db/mysql.inc.php on line 37
You could see here

note about hosting :

safe_mode ON
register_globals ON
magic_quotes_gpc ON

is it possible to "repair" ?

thanks.

Re: Warning: mysql_query()

Posted: Thu Apr 14, 2005 11:43 am
by garvinhicking
This is no error, this is a MySQL optimization hint. I've never seen that, try to turn it off. :-D

(The query NEEDS to do a full tablescan, it is mandatory. No way to optimize, as this is what we want, to get ALL plugins from the table. The message thus is obsolete)

Regards,
Garvin

Warning: mysql_query()

Posted: Thu Apr 14, 2005 2:57 pm
by stef
Ok,

I have ask my hosting administrator and it done.

8)