ERROR 500 on some PlaySMS pages

playSMS Help
1

Hi guys,

When I go to report pages, I got an 500 error.
I checked apache logs, it says:

PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 75 bytes) in /var/www/html/playsms/lib/composer/vendor/pear/db/DB/mysqli.php on line 458
PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /var/www/html/playsms/plugin/feature/simplebilling/fn.php on line 99

I think it’s maybe the database that went too big now, how can I do a clean purge ?

2

As a temporary solution, I set the php mem limit to -1 in php.ini

http://php.net/manual/en/ini.core.php#ini.memory-limit

But the real problem is that we need a purge DB function on playSMS admin panel.

3

Have to see what tables are huge, the main should be playsms_tblSMSOutgoing,

4

Yes, I already checked, I got bit more than 277 000 entries in it (those days, something like 40 000 SMS are sent each month), but how to clear it properly, with all the relations, without breaking playSMS ?

5

Depending on hardware you are running, 227k is a small table. You can delete past messages from this table without breaking anything.