SEO

I have such mysq select queries:

SELECT count( DISTINCT (
chart_number
) ) AS chart_number_qty, YEAR( chart_date ) AS year_chart
FROM table_table
WHERE category = 'LP LP LP'
GROUP BY year_chart
HAVING year_chart =2007

Unfortunately this select gives me an error. It used to work well before,
but now
it doesn`t work and gives me such error:

#5 - Out of memory (Needed 6693225 bytes)

Could you advise me what I should do?
Is it a fault of admins?
Is it an admin`s work? Should they fix this problem up?

Kindest regards
M. from Poland

== Quote from K. (halinacierniak@poczta.onet.pl)'s article
> I have such mysq select queries:
> SELECT count( DISTINCT (
> chart_number
> ) ) AS chart_number_qty, YEAR( chart_date ) AS year_chart
> FROM table_table
> WHERE category = 'LP LP LP'
> GROUP BY year_chart
> HAVING year_chart =2007
> Unfortunately this select gives me an error. It used to work well before,
> but now
> it doesn`t work and gives me such error:
> #5 - Out of memory (Needed 6693225 bytes)
> Could you advise me what I should do?
> Is it a fault of admins?
> Is it an admin`s work? Should they fix this problem up?
> Kindest regards
> M. from Poland


if you're getting the error number 5, it signifies an input/output error. however,
it would be helpfuel if you can post the error logs regarding this error or the
actual error description and code.

--
POST BY: lark with PHP News Reader

U¿ytkownik "lark" <hamzee@sbcglobal.net> napisa³ w wiadomo¶ci
news:x%vdi.14879$RX.6498@newssvr11.news.prodigy.ne t...
> == Quote from K. (halinacierniak@poczta.onet.pl)'s article
>> I have such mysq select queries:
>> SELECT count( DISTINCT (
>> chart_number
>> ) ) AS chart_number_qty, YEAR( chart_date ) AS year_chart
>> FROM table_table
>> WHERE category = 'LP LP LP'
>> GROUP BY year_chart
>> HAVING year_chart =2007
>> Unfortunately this select gives me an error. It used to work well before,
>> but now
>> it doesn`t work and gives me such error:
>> #5 - Out of memory (Needed 6693225 bytes)
>> Could you advise me what I should do?
>> Is it a fault of admins?
>> Is it an admin`s work? Should they fix this problem up?
>> Kindest regards
>> M. from Poland
>
>
> if you're getting the error number 5, it signifies an input/output error.
> however,
> it would be helpfuel if you can post the error logs regarding this error
> or the
> actual error description and code.
>
> --
> POST BY: lark with PHP News Reader


I don`t know what exactly is wrong with it but I get such logs:

82.146.225.77 - - [18/Jun/2007:19:42:42 +0200] "GET
/MZ_CRM/index.php?id_page=lp HTTP/1.1" 200 3215
"http://www.listaprzebojow.com.pl/MZ_CRM/index.php" "Mozilla/4.0
(compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
82.146.225.77 - - [18/Jun/2007:19:42:45 +0200] "GET
/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK HTTP/1.1" 200 3080
"http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp" "Mozilla/4.0
(compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET
/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki
HTTP/1.1" 200 3712
"http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK"
"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET /MZ_CRM/img/cal.gif
HTTP/1.1" 304 -
"http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki"
"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
82.146.225.77 - - [18/Jun/2007:19:42:51 +0200] "GET
/MZ_CRM/index.php?subtytul2=szukajstatystyki&id_page=lp&su btytul=lp_Radio_PIK&nr_notowania_od_szukaj=&nr_not owania_do_szukaj=&data_notowania_od_szukaj=&data_n otowania_do_szukaj=&data_notowania_rok_szukaj=2007 &data_notowania_miesiac_szukaj=&data_notowania_dzi en_szukaj=&utwory_albumy=utwory&but=Szukaj
HTTP/1.1" 200 31487
"http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki"
"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"

Thank you for help
Marcin

== Quote from MZ (marcinzmyslowski@poczta.onet.pl)'s article
> U¿ytkownik "lark" <hamzee@sbcglobal.net> napisa³ w wiadomo¶ci
> news:x%vdi.14879$RX.6498@newssvr11.news.prodigy.ne t...
> > == Quote from K. (halinacierniak@poczta.onet.pl)'s article
> >> I have such mysq select queries:
> >> SELECT count( DISTINCT (
> >> chart_number
> >> ) ) AS chart_number_qty, YEAR( chart_date ) AS year_chart
> >> FROM table_table
> >> WHERE category = 'LP LP LP'
> >> GROUP BY year_chart
> >> HAVING year_chart =2007
> >> Unfortunately this select gives me an error. It used to work well before,
> >> but now
> >> it doesn`t work and gives me such error:
> >> #5 - Out of memory (Needed 6693225 bytes)
> >> Could you advise me what I should do?
> >> Is it a fault of admins?
> >> Is it an admin`s work? Should they fix this problem up?
> >> Kindest regards
> >> M. from Poland
> >
> >
> > if you're getting the error number 5, it signifies an input/output error.
> > however,
> > it would be helpfuel if you can post the error logs regarding this error
> > or the
> > actual error description and code.
> >
> > --
> > POST BY: lark with PHP News Reader
> I don`t know what exactly is wrong with it but I get such logs:
> 82.146.225.77 - - [18/Jun/2007:19:42:42 +0200] "GET
> /MZ_CRM/index.php?id_page=lp HTTP/1.1" 200 3215
> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php" "Mozilla/4.0
> (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
> 82.146.225.77 - - [18/Jun/2007:19:42:45 +0200] "GET
> /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK HTTP/1.1" 200 3080
> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp" "Mozilla/4.0
> (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
> 82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET
> /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki
> HTTP/1.1" 200 3712
> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK"
> "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
> 82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET /MZ_CRM/img/cal.gif
> HTTP/1.1" 304 -
>
"http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki"
> "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
> 82.146.225.77 - - [18/Jun/2007:19:42:51 +0200] "GET
>
/MZ_CRM/index.php?subtytul2=szukajstatystyki&id_page=lp&su btytul=lp_Radio_PIK&nr_notowania_od_szukaj=&nr_not owania_do_szukaj=&data_notowania_od_szukaj=&data_n otowania_do_szukaj=&data_notowania_rok_szukaj=2007 &data_notowania_miesiac_szukaj=&data_notowania_dzi en_szukaj=&utwory_albumy=utwory&but=Szukaj
> HTTP/1.1" 200 31487
>
"http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki"
> "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
> Thank you for help
> Marcin

i believe this is an apache log. i meant mysql server logs. if mysql is running on
windows, it'll be helpful to have the windows own events logs.
--
POST BY: lark with PHP News Reader

U¿ytkownik "lark" <hamzee@sbcglobal.net> napisa³ w wiadomo¶ci
news:YBzdi.26053$YL5.25989@newssvr29.news.prodigy. net...
> == Quote from MZ (marcinzmyslowski@poczta.onet.pl)'s article
>> Uytkownik "lark" <hamzee@sbcglobal.net> napisa w wiadomoci
>> news:x%vdi.14879$RX.6498@newssvr11.news.prodigy.ne t...
>> > == Quote from K. (halinacierniak@poczta.onet.pl)'s article
>> >> I have such mysq select queries:
>> >> SELECT count( DISTINCT (
>> >> chart_number
>> >> ) ) AS chart_number_qty, YEAR( chart_date ) AS year_chart
>> >> FROM table_table
>> >> WHERE category = 'LP LP LP'
>> >> GROUP BY year_chart
>> >> HAVING year_chart =2007
>> >> Unfortunately this select gives me an error. It used to work well
>> >> before,
>> >> but now
>> >> it doesn`t work and gives me such error:
>> >> #5 - Out of memory (Needed 6693225 bytes)
>> >> Could you advise me what I should do?
>> >> Is it a fault of admins?
>> >> Is it an admin`s work? Should they fix this problem up?
>> >> Kindest regards
>> >> M. from Poland
>> >
>> >
>> > if you're getting the error number 5, it signifies an input/output
>> > error.
>> > however,
>> > it would be helpfuel if you can post the error logs regarding this
>> > error
>> > or the
>> > actual error description and code.
>> >
>> > --
>> > POST BY: lark with PHP News Reader
>> I don`t know what exactly is wrong with it but I get such logs:
>> 82.146.225.77 - - [18/Jun/2007:19:42:42 +0200] "GET
>> /MZ_CRM/index.php?id_page=lp HTTP/1.1" 200 3215
>> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php" "Mozilla/4.0
>> (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
>> 82.146.225.77 - - [18/Jun/2007:19:42:45 +0200] "GET
>> /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK HTTP/1.1" 200 3080
>> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp"
>> "Mozilla/4.0
>> (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
>> 82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET
>> /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki
>> HTTP/1.1" 200 3712
>> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK"
>> "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
>> 82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET /MZ_CRM/img/cal.gif
>> HTTP/1.1" 304 -
>>
> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki"
>> "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
>> 82.146.225.77 - - [18/Jun/2007:19:42:51 +0200] "GET
>>
> /MZ_CRM/index.php?subtytul2=szukajstatystyki&id_page=lp&su btytul=lp_Radio_PIK&nr_notowania_od_szukaj=&nr_not owania_do_szukaj=&data_notowania_od_szukaj=&data_n otowania_do_szukaj=&data_notowania_rok_szukaj=2007 &data_notowania_miesiac_szukaj=&data_notowania_dzi en_szukaj=&utwory_albumy=utwory&but=Szukaj
>> HTTP/1.1" 200 31487
>>
> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki"
>> "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
>> Thank you for help
>> Marcin
>
> i believe this is an apache log. i meant mysql server logs. if mysql is
> running on
> windows, it'll be helpful to have the windows own events logs.
> --
> POST BY: lark with PHP News Reader


Unfortunately I cannot find these mysql logs. Maybe my provider doesn`t
provide
me mysql logs. I have only phpmyadmin if we mean mysql server. I will
contact with admin
tomorrow, because today I cannot catch him.

Thank you for help
I will send post tomorrow
Marcin

Hello after 2 days!

I have checked today and mysql query works well.
I didn`t reach admin that`s why I don`t know what they did.
Maybe there were some admin work lately which I don`t know.

The most interesting thing for me is that mysql query works well now.

Thank everybody for help
Marcin