My tables in Database (specific update and message Tables) are grown , and I can't remove old records(foreign key error)
what can I do ?
can I remove these Tables (update AND message )?
mohsenshahab
All 4 comments
Updates table can be emptied without a problem, no foreign key errors there.
TRUNCATE telegram_update;
As for the others, you could just ignore the foreign key constraints and empty it.
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE message;
SET FOREIGN_KEY_CHECKS = 1;
@jacklul Any downside on doing this? Apart from the obvious links being broken?
noplanman
on 11 Jul 2017
No idea but editing message that was previously in database can result in constrain error in this case.
We might want to implement cleanup <days> command for this...
I have very similar command in one of my bots, If i don't forget I'll handle this!
jacklul
on 12 Jul 2017
Implemented in https://github.com/php-telegram-bot/core/pull/563
jacklul
on 15 Jul 2017
@mohsenshahab Check out the new /cleanup admin command in version 0.46.0 馃憤
noplanman
on 16 Jul 2017
Related issues
sineverba
路
3Comments
smaznet
路
4Comments
irmmr
路
3Comments
NabiKAZ
路
4Comments
sayjeyhi
路
3Comments
Most helpful comment
No idea but editing message that was previously in database can result in constrain error in this case.
We might want to implement
cleanup <days>command for this...I have very similar command in one of my bots, If i don't forget I'll handle this!