Warning: mysql_query() [solved]

Having trouble installing serendipity?
Post Reply
stef
Posts: 4
Joined: Wed Apr 13, 2005 4:01 pm

Warning: mysql_query() [solved]

Post 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.
Last edited by stef on Thu Apr 14, 2005 11:10 pm, edited 1 time in total.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Warning: mysql_query()

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
stef
Posts: 4
Joined: Wed Apr 13, 2005 4:01 pm

Warning: mysql_query()

Post by stef »

Ok,

I have ask my hosting administrator and it done.

8)
Post Reply