Cron - Reminder

-- Error-message(debug-mod must be tuned on) -- : Error 1054 - Unknown column 'id' in 'field list'

Hi Nicolas,
A few days ago I told you about the error I was getting when trying to view the shopping carts. I installed the patch you recommended, but I can see that since then the reminder plugin has not been running correctly.
Error 1054 - Unknown column 'id' in 'field list'.
I’m attaching a screenshot.

Hi Nicolas.
I’m attaching a screenshot showing the messages that appear.

Hi Nicolas.
I have reinstalled HikaShop and the cron is now working. However, I’ve noticed that it sends the same message twice to each user, both for product availability notifications and for cart reminder emails.

I’m not sure if this could be because, when the cron was executed later, the emails had already been generated at the time and are now being sent again when the cron runs.

Hi Nicolas.
With the new version, the reminder plugin is not being executed.
I installed it early this morning.
I created a shopping cart with a test user and, when running the cron, no reminder email is sent.

Nicolas, it’s now working correctly.
Thanks so much

Hi Nicolas.
I’m writing to you again because something very strange is happening.
The other day I wrote to let you know that the Reminder plugin was working correctly.
However, after noticing that it was not being executed, I checked and saw that the plugin seems to have been “removed” from my system (as if it had uninstalled itself).
Please let me know what you need in order to be able to review this.

Hi Nicolas.
I have reinstalled the Reminder plugin again.
I ran the cron, it worked correctly, but the plugin has disappeared from the system again.
I’m attaching a screenshot of the user actions log where you can see that the plugin was installed, but there is no record of its uninstallation.

Nicolas, I reinstalled it again, and the moment the cron URL is executed, the plugin disappears.

Hi Nicolas,

I’ve isolated the issue and it is reproducible on my site with the latest stable Joomla + HikaShop.

Problem: when the HikaShop – Reminder plugin is enabled, running the HikaShop cron URL causes the plugin to disappear from Joomla (it is no longer listed under Extensions → Plugins). The plugin files are still present on the FTP, but Joomla loses the plugin registration (it can be reinstalled again via Extensions → Manage → Discover).

Cron URL used:
/index.php?option=com_hikashop&ctrl=cron

Steps to reproduce

Install the Reminder plugin (if needed via Discover).

Enable (publish) HikaShop – Reminder.

Run the cron URL above.

Go to Extensions → Plugins → the Reminder plugin is gone.

Important note

If the Reminder plugin is disabled (unpublished), running the same cron URL does not make it disappear.

So the “removal” only happens when the Reminder plugin is enabled and the cron is executed.

Could you advise what could trigger Joomla to lose the extension entry for the plugin during cron execution, or if there is a known issue/fix for this?

Thank you.

Hi Nicolas,

I’ve tested the latest package and I can confirm that the cron no longer removes the Reminder plugin from Joomla — so that issue appears to be fully resolved. Thank you for that fix.

During this incident, I noticed that running the cron was also affecting other HikaShop plugins, which would then reappear under Extensions → Manage → Discover. Specifically:

HikaShop Google / Meta Products Feed

HikaShop Orders Automatic Cancel

HikaShop WaitList Notification

While we were debugging, I temporarily disabled these plugins to avoid further issues.

Could you please confirm:

Whether these plugins should now be safe to re-enable with your latest patch?

If so, whether you recommend any specific configuration for them to ensure they work correctly with the Reminder plugin and the cron?

Thank you again for your help.