Error with kinetic an 1.7 rc3

[Don Chambers]

Static page issue: http://board.s9y.org/viewtopic.php?f=3&t=19219

[Timbalu]

Also you should investigate the slowness of your server responses. What could cause these hangouts..?

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.

Which still has to get solved, otherwise your blog will keep slowing down until it breaks.

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

Watch this
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 )

[Timbalu]

Don, I still need that test, as it might be needed to add this patch to 1.7.

[Don Chambers]

I have not forgotten, just very busy. I'll get to it, but it might not be until early next week after Easter.