Error with kinetic an 1.7 rc3
-
- Regular
- Posts: 3652
- Joined: Mon Feb 13, 2006 2:40 am
- Location: Chicago, IL, USA
- Contact:
Re: Error with kinetic an 1.7 rc3
Static page issue: http://board.s9y.org/viewtopic.php?f=3&t=19219
=Don=
Re: Error with kinetic an 1.7 rc3
Timbalu wrote:Also you should investigate the slowness of your server responses. What could cause these hangouts..?
Which still has to get solved, otherwise your blog will keep slowing down until it breaks.Jochen Hoff wrote:The slowness of the server comes from time to time. Duckhome takex most of the power, but i not able to clear the problem. Is the same with the traffic. Its terrible. But i have no money to pay an administrator so it is a problem.
Code: Select all
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_en')
WHERE isdraft = 'false' AND timestamp <= 1364059587
ORDER BY timestamp DESC
LIMIT 5
/ Incorrect key file for table '/tmp/#sql_e1b_0.MYI'; try to repair it
SELECT DISTINCT id, title, timestamp, epm.value AS multilingual_title FROM tb_entries AS e LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid LEFT OUTER JOIN tb_entryproperties AS epm ON (epm.entryid = e.id AND epm.property = 'multilingual_title_en') WHERE isdraft = 'false' AND timestamp <= 1364059587 ORDER BY timestamp DESC LIMIT 5
Incorrect key file for table '/tmp/#sql_e1b_0.MYI'; try to repair it
and read
http://stackoverflow.com/questions/2090 ... iple-joins
It seems your servers or domains /tmp folder is running out of space, from time to time. There are different solutions for this... (give it more discspace, give it more ram, run REPAIR TABLE, run ANALYSE TABLE )
Regards,
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Re: Error with kinetic an 1.7 rc3
Don, I still need that test, as it might be needed to add this patch to 1.7.
Regards,
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
-
- Regular
- Posts: 3652
- Joined: Mon Feb 13, 2006 2:40 am
- Location: Chicago, IL, USA
- Contact:
Re: Error with kinetic an 1.7 rc3
I have not forgotten, just very busy. I'll get to it, but it might not be until early next week after Easter.
=Don=