Can't create/write to file '/var/tmp/mysql/
there is no Cpanel @ hostpoint
Also the issue is random we have archived 5K articles on the 15k to reduce the load of the query
thanks
- Edited
folamour
Hi,
After further investigation, i think issue might not because of ja good template. Ja good layouts for mod_articles_category
only use joomla module data, no extra db query. You can turn on the module, delete all ja good layout content and monitor this issue again. All layouts you can find at: /templates/ja_good/html/mod_articles_category
Because of your site have a mount of articles, i prefer mysql needs more memory. I made some tests and the result is:
SELECT @@key_buffer_size/1024/1024
128.00000000
SELECT @@max_allowed_packet/1024/1024
64.00000000
SELECT @@sort_buffer_size/1024/1024
8.00000000
SELECT @@read_buffer_size/1024/1024
2.00000000
Could you ask db team to increase key_buffer_size, max_allowed_packet, sort_buffer_size and read_buffer_size to 250M?
what this mean i have to delete ja good ? and ask to increase ? without ja good the site don't crash
I call them by phone to ask
- Edited
folamour
Hi,
All queries you sent come from module mod_articles_category
. This is a module of joomla core. Ja Good support some layout override for this module. To test out ja good makes your site crash or not, you can open all override layouts of module mod_articles_category
, empty them and monitor template ja good
again. The folder is /templates/ja_good/html/mod_articles_category
.
Hope this clear.
ok that has to be seen by the level 2 support at hostpoint, but the engineer will be back tomorrow, so i get back in touch with you when he will be back
thanks you a lot for your support because our website is at risk and its 15 year of work,
kind regards,
f.
i'm sorry i dont understood that :
you can open all override layouts of module mod_articles_category, empty them and monitor template ja good again. The folder is /templates/ja_good/html/mod_articles_category.
you want to said to open the file, empty them, save them, and retry ?
have you finished with the web site can i re activate admin tools ?
Does archiving 10k will fix the issue the host ask us to purchase a dedicated server to do your requested modification,
i've also open a thread on joomla.org
ok we have a vps under the hand, but at this time i have reactivated the template and the host said the load is correct
mahta can you tell me if you have modified something on the template and if this modification will be integrated on future release of ja good or not ?
thanks a lot, have a great afternoon
f.