Black email log?

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
1 year 11 months ago #347458

-- HikaShop version -- : 4.6.2
-- Joomla version -- : 4.2.5
-- PHP version -- : 8
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : none

NB title should say BLANK but it will not let me edit it?

Hi, This looks to have been happening since upgrading to Joomla 4?

See attached. ALL emails sent to customers are blank in the email history? no id is being set all showing 0?

I know some email are being sent out correctly as I have them sent to my admin email also it appears just to be the log that is faulty?

Attachments:
Last edit: 1 year 11 months ago by mohairbears.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
1 year 11 months ago #347459

Hi,

This looks like a problem with the structure of the hikashop_email_log table. This would happen if the primary key / auto_increment on the column email_log_id would have been removed. This has happened (on other tables) to a few users in the past when migrating / updating websites.
I would recommend to delete that table via PHPMyAdmin. That way, the email history mechanism will automatically recreate it with the primary key / auto increment and it should then work properly.

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

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
1 year 11 months ago #347491

Hi, Did that, well copied and cleared all info so blank database. Unfortunate its still the same? 0 id and blank email data?

Rgds

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
1 year 11 months ago #347499

Hi,

Can you provide a screenshot of the structure of the email_log table in your PHPMyAdmin ?

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

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
1 year 11 months ago #347508

Attached thanks

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
1 year 11 months ago #347510

Hi,

Note that you should not empty the email_log table but delete it, otherwise, HikaShop won't add it back and will just fill it again, not solving anything.

Here is how it should look:
i.imgur.com/NEa9OE0.png
Note the "AUTO_INCREMENT" text in the "extra" column for the email_log_id and the primary key in the indexes area at the bottom.
Please make sure it is like that and it will then work properly.

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

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
1 year 11 months ago #347522

Hi, yes thats the fix.

Thank you

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

Time to create page: 0.092 seconds
Powered by Kunena Forum