Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: [SOLVED]Delete events & records when php memory is exhausted

[SOLVED]Delete events & records when php memory is exhausted 12 years 11 months ago #16031

  • ontarget
  • ontarget's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 0
Hi
DT register v 2.7.11b
When I click on records I am getting the message.
Fatal error: Allowed memory size of 134217728 bytes exhausted
I understand this is due to the server memory limits of 128m.
How can I delete the records and events when I cant access them. What would be the correct sql statement to use to delete them directly from the database?
Thanks

Please Log in or Create an account to join the conversation.

[SOLVED]Delete events & records when php memory is exhausted 12 years 11 months ago #16035

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
You can't access event management either? If you can, deleting an event will automatically delete all associated records.

Please Log in or Create an account to join the conversation.

[SOLVED]Delete events & records when php memory is exhausted 12 years 11 months ago #16039

  • ontarget
  • ontarget's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 0

dthadmin wrote: You can't access event management either? If you can, deleting an event will automatically delete all associated records.


No Events link leads to a blank page which suggest not enough memory

Please Log in or Create an account to join the conversation.

[SOLVED]Delete events & records when php memory is exhausted 12 years 11 months ago #16045

  • ontarget
  • ontarget's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 0
Is it less exhaustive on memory if I break up repeating events into smaller chunks e.g April - June / July - Aug instead of April - Aug
Please advise on best practice as this is really frustrating having to repeatedly and manually delete hundreds of events everytime I get a fatal error with memory. :cry:
Those in the same boat experiencing fatal error memory issues you can still access your events from the frontend of Joomla.
Look forward to your response

Please Log in or Create an account to join the conversation.

[SOLVED]Delete events & records when php memory is exhausted 12 years 11 months ago #16052

  • ontarget
  • ontarget's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 0
Update:
Breaking up your repeating events into smaller chunks does not work and you will still get the fatal error memory exhausted message.
Unless your on a VPS or better your stuffed if your host only allocates a max of 128m memory.
I am limited to a running a max of 2 events repeating from 1 April to 31 Oct
I add a third event and I max out the memory then I have to delete all my events and start again.

Please Log in or Create an account to join the conversation.

[SOLVED]Delete events & records when php memory is exhausted 12 years 11 months ago #16101

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Updating to 2.7.12c will incorporate fixes for this so the large amount of queries and memory usage is not an issue. Thanks.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Time to create page: 0.722 seconds