Skip to Content Skip to Menu

Update logger plugin

11 years 8 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 or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48536
  • Thanks: 8290
  • Karma: 1445
11 years 8 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 or Create an account to join the conversation.

11 years 7 months ago - 11 years 7 months 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?
Last edit: 11 years 7 months ago by edmundcheong.

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
11 years 7 months 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?
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)

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

11 years 3 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 or Create an account to join the conversation.

11 years 2 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 or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum