[Skip to main content](#vessel-content)

#   Email history data blank

##

- **[mrooke](/forum/user/18053-mrooke "View mrooke's Profile")**
- [![mrooke's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18053-mrooke "View mrooke's Profile") Topic Author
- [ Offline](/forum/user/18053-mrooke)

Less More

- Posts: 56
- Thank you received: 4
-
-

5 years 3 months ago [\#334954](#334954) by [mrooke](/forum/user/18053-mrooke "View mrooke's Profile")  *[Email history data blank](/forum/35-orders-management/903059-email-history-data-blank#334954 "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.28 -- PHP version -- : 7.4 -- Browser(s) name and version -- : FireFox  Hello, I am diagnosing an issue with email delivery and when I went to Customers &gt; email history I find the list of generated/sent emails however no ID's are being assigned to them. When I click on an individual email, there is only blank data. The resend button also is not working. I just reinstalled/updated Hika with no change. Please see screenshots.  Thank you  Matt")* was created by *[mrooke](/forum/user/18053-mrooke "View mrooke's Profile")*

-- HikaShop version -- : 4.4.3
-- Joomla version -- : 3.9.28
-- PHP version -- : 7.4
-- Browser(s) name and version -- : FireFox

Hello, I am diagnosing an issue with email delivery and when I went to Customers &gt; email history I find the list of generated/sent emails however no ID's are being assigned to them. When I click on an individual email, there is only blank data. The resend button also is not working. I just reinstalled/updated Hika with no change. Please see screenshots.

Thank you

Matt

- [ ![screen-2.jpg](/forum/attachment/53374) ](/forum/attachment/53374 "screen-2.jpg") [ ](/forum/attachment/53374?download=1 "screen-2.jpg")
- [ ![screen-1.jpg](/forum/attachment/53375) ](/forum/attachment/53375 "screen-1.jpg") [ ](/forum/attachment/53375?download=1 "screen-1.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwMzA1OS1lbWFpbC1oaXN0b3J5LWRhdGEtYmxhbms/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86359
- Thank you received: 14296
-
-

5 years 2 months ago [\#334958](#334958) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Email history data blank](/forum/35-orders-management/903059-email-history-data-blank#334958 "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.28 -- PHP version -- : 7.4 -- Browser(s) name and version -- : FireFox  Hello, I am diagnosing an issue with email delivery and when I went to Customers &gt; email history I find the list of generated/sent emails however no ID's are being assigned to them. When I click on an individual email, there is only blank data. The resend button also is not working. I just reinstalled/updated Hika with no change. Please see screenshots.  Thank you  Matt")*

Hi,

I would say this means that there is a problem with the auto_increment of the hikashop_email_log table in your database which must have been unset. I've seen it happen when Joomla websites are transfered, backed up and such in rare cases.
The "check database" button of the HikaShop configuration might help. However, I would recommend you to check that table in your database via your PHPMyAdmin access, normally provided to you by your hosting company.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwMzA1OS1lbWFpbC1oaXN0b3J5LWRhdGEtYmxhbms/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[mrooke](/forum/user/18053-mrooke "View mrooke's Profile")**
- [![mrooke's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18053-mrooke "View mrooke's Profile") Topic Author
- [ Offline](/forum/user/18053-mrooke)

Less More

- Posts: 56
- Thank you received: 4
-
-

5 years 2 months ago [\#334971](#334971) by [mrooke](/forum/user/18053-mrooke "View mrooke's Profile")  Replied by *[mrooke](/forum/user/18053-mrooke "View mrooke's Profile")* on topic *[Email history data blank](/forum/35-orders-management/903059-email-history-data-blank#334971 "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.28 -- PHP version -- : 7.4 -- Browser(s) name and version -- : FireFox  Hello, I am diagnosing an issue with email delivery and when I went to Customers &gt; email history I find the list of generated/sent emails however no ID's are being assigned to them. When I click on an individual email, there is only blank data. The resend button also is not working. I just reinstalled/updated Hika with no change. Please see screenshots.  Thank you  Matt")*

Thanks Nicolas, This site was in fact recently transferred. I have located the table in PHPMyAdmin. What should I do? re upload an earlier version of that specific table?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwMzA1OS1lbWFpbC1oaXN0b3J5LWRhdGEtYmxhbms/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86359
- Thank you received: 14296
-
-

5 years 2 months ago [\#334976](#334976) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Email history data blank](/forum/35-orders-management/903059-email-history-data-blank#334976 "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.28 -- PHP version -- : 7.4 -- Browser(s) name and version -- : FireFox  Hello, I am diagnosing an issue with email delivery and when I went to Customers &gt; email history I find the list of generated/sent emails however no ID's are being assigned to them. When I click on an individual email, there is only blank data. The resend button also is not working. I just reinstalled/updated Hika with no change. Please see screenshots.  Thank you  Matt")*

Hi,

You could yes.
You need to check that the auto_increment is still on the email_log_id column (the primary key of the table).
[ www.tutorialspoint.com/how-to-add-auto-i...ase-using-phpmyadmin](https://www.tutorialspoint.com/how-to-add-auto-increment-to-column-in-mysql-database-using-phpmyadmin)
You might have to delete all the data in the table to be able to do that.
Also, if the email_log_ids are all 0, then it means that the primary key is probably removed on the email_log_id column since when a column is a primary key, every row needs to have a different value in that column.
Deleting the table and installing the install package of HikaShop should make it for a simple solution to have the email history area work normally again.
Note however that if you lost the primary key / auto_increment in that table, you might have lost these on other tables too. And that would be bad when creating new orders / products / categories. So I would recommend checking the other tables too.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwMzA1OS1lbWFpbC1oaXN0b3J5LWRhdGEtYmxhbms/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.058 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
