Update logger plugin

11 years 2 months ago #221833 by edmundcheong
Update logger plugin was created by edmundcheong
How much can the update logger plugin record? A million or a billion transactions? I saw in SQL that the index column of the table is int(10).. Meaning maximum record it can store is 9,999,999,999?

Am I right? Meaning almost a trillion records?

Please Log in to join the conversation.

11 years 2 months ago #221846 by krileon
Replied by krileon on topic Update logger plugin
As many rows as your database can handle. The ID column can handle up to 10 digits, but that can easily be changed if you really need to. Ideally you'd prune out old entries as needed though to keep it responsive. Pruning could be just deleting entries from xyz date and outward or moving them to a second table for record keeping purposes.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: edmundcheong

Please Log in to join the conversation.

11 years 1 month ago - 11 years 1 month ago #224273 by edmundcheong
Replied by edmundcheong on topic Update logger plugin
I am not sure if you realised this but the plugin does not log when a user changes a field with value to blank/empty..

From blank to a value, the plugin captures as a transaction but not the other way round..

Any way I can make the plugin to log if a user changes a data from a value to blank?

Please Log in to join the conversation.

11 years 1 month ago #224278 by nant
Replied by nant on topic Update logger plugin

edmundcheong wrote: I am not sure if you realised this but the plugin does not log when a user changes a field with value to blank/empty..

From blank to a value, the plugin captures as a transaction but not the other way round..

Any way I can make the plugin to log if a user changes a data from a value to blank?


What version do you have installed?
What CB version?
What Joomla version?
What field type are you updating?

Please Log in to join the conversation.

10 years 8 months ago #232404 by edmundcheong
Replied by edmundcheong on topic Update logger plugin
Sorry this might be old but I am revisiting this problem.

This problem is happening on the latest CB and Joomla 3.0.

So far happening on all fields except for date fields..

Please Log in to join the conversation.

10 years 8 months ago #232451 by edmundcheong
Replied by edmundcheong on topic Update logger plugin

edmundcheong wrote: I am not sure if you realised this but the plugin does not log when a user changes a field with value to blank/empty..

From blank to a value, the plugin captures as a transaction but not the other way round..

Any way I can make the plugin to log if a user changes a data from a value to blank?


It is about the problem mentioned above.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.242 seconds