[Skip to main content](#vessel-content) # New email history entries have no data in the backend ## - **[zerioni](/forum/user/51281-zerioni "View zerioni's Profile")** - [![zerioni's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51281-zerioni "View zerioni's Profile") Topic Author - [ Offline](/forum/user/51281-zerioni) Less More - Posts: 8 - Thank you received: 0 - - 3 years 10 months ago [\#348023](#348023) by [zerioni](/forum/user/51281-zerioni "View zerioni's Profile") *[New email history entries have no data in the backend](/forum/25-install-update/905652-new-email-history-entries-have-no-data-in-the-backend#348023 "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 4.2.6 -- PHP version -- : 8.1 We recently upgraded from joomla 3 to 4, following the joomla documentation. Everything is working from the front end as expected. The issue we're seeing in new emails in the Customers->email history have no details populated for the admin (emails are sending correctly). The only thing I can find out of place is this in the check database results: OK Table "hikashop_email_log" checked Error Unknown column 'action_button_type' in 'where clause' Error hikashop_config: Duplicate entry 'website' for key 'PRIMARY' Error ALTER TABLE #__hikashop_config ADD PRIMARY KEY(config_namekey) OK Product categories checked But I'm not sure if that would be related or what the best way to go about fixing it would be.")* was created by *[zerioni](/forum/user/51281-zerioni "View zerioni's Profile")* -- HikaShop version -- : 4.7.0 -- Joomla version -- : 4.2.6 -- PHP version -- : 8.1 We recently upgraded from joomla 3 to 4, following the joomla documentation. Everything is working from the front end as expected. The issue we're seeing in new emails in the Customers->email history have no details populated for the admin (emails are sending correctly). The only thing I can find out of place is this in the check database results: OK Table "hikashop_email_log" checked Error Unknown column 'action_button_type' in 'where clause' Error hikashop_config: Duplicate entry 'website' for key 'PRIMARY' Error ALTER TABLE #__hikashop_config ADD PRIMARY KEY(config_namekey) OK Product categories checked But I'm not sure if that would be related or what the best way to go about fixing it would be. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTY1Mi1uZXctZW1haWwtaGlzdG9yeS1lbnRyaWVzLWhhdmUtbm8tZGF0YS1pbi10aGUtYmFja2VuZD90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 3 years 10 months ago [\#348024](#348024) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[New email history entries have no data in the backend](/forum/25-install-update/905652-new-email-history-entries-have-no-data-in-the-backend#348024 "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 4.2.6 -- PHP version -- : 8.1 We recently upgraded from joomla 3 to 4, following the joomla documentation. Everything is working from the front end as expected. The issue we're seeing in new emails in the Customers->email history have no details populated for the admin (emails are sending correctly). The only thing I can find out of place is this in the check database results: OK Table "hikashop_email_log" checked Error Unknown column 'action_button_type' in 'where clause' Error hikashop_config: Duplicate entry 'website' for key 'PRIMARY' Error ALTER TABLE #__hikashop_config ADD PRIMARY KEY(config_namekey) OK Product categories checked But I'm not sure if that would be related or what the best way to go about fixing it would be.")* Hi, Could you open the table hikashop_email_log via your PHPMyAdmin and look at its structure ? Then, please provide a screenshot of that page. I'm also thinking there might be a problem with that table in the database, preventing the email history plugin from adding new email data properly into it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTY1Mi1uZXctZW1haWwtaGlzdG9yeS1lbnRyaWVzLWhhdmUtbm8tZGF0YS1pbi10aGUtYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[zerioni](/forum/user/51281-zerioni "View zerioni's Profile")** - [![zerioni's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51281-zerioni "View zerioni's Profile") Topic Author - [ Offline](/forum/user/51281-zerioni) Less More - Posts: 8 - Thank you received: 0 - - 3 years 10 months ago [\#348071](#348071) by [zerioni](/forum/user/51281-zerioni "View zerioni's Profile") Replied by *[zerioni](/forum/user/51281-zerioni "View zerioni's Profile")* on topic *[New email history entries have no data in the backend](/forum/25-install-update/905652-new-email-history-entries-have-no-data-in-the-backend#348071 "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 4.2.6 -- PHP version -- : 8.1 We recently upgraded from joomla 3 to 4, following the joomla documentation. Everything is working from the front end as expected. The issue we're seeing in new emails in the Customers->email history have no details populated for the admin (emails are sending correctly). The only thing I can find out of place is this in the check database results: OK Table "hikashop_email_log" checked Error Unknown column 'action_button_type' in 'where clause' Error hikashop_config: Duplicate entry 'website' for key 'PRIMARY' Error ALTER TABLE #__hikashop_config ADD PRIMARY KEY(config_namekey) OK Product categories checked But I'm not sure if that would be related or what the best way to go about fixing it would be.")* Thanks for replying! Attached is the screenshot of the structure from phpMyAdmin. I noticed that it doesn't have a primary key index, which seems odd. Please let me know any problems you see here! [ ![hikashop_email_log.JPG](/forum/attachment/56275) ](/forum/attachment/56275 "..._email_log.JPG") - [ ![hikashop_email_log.JPG](/forum/attachment/56275) ](/forum/attachment/56275 "..._email_log.JPG") [ ](/forum/attachment/56275?download=1 "..._email_log.JPG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTY1Mi1uZXctZW1haWwtaGlzdG9yeS1lbnRyaWVzLWhhdmUtbm8tZGF0YS1pbi10aGUtYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[zerioni](/forum/user/51281-zerioni "View zerioni's Profile")** - [![zerioni's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51281-zerioni "View zerioni's Profile") Topic Author - [ Offline](/forum/user/51281-zerioni) Less More - Posts: 8 - Thank you received: 0 - - 3 years 10 months ago [\#348072](#348072) by [zerioni](/forum/user/51281-zerioni "View zerioni's Profile") Replied by *[zerioni](/forum/user/51281-zerioni "View zerioni's Profile")* on topic *[New email history entries have no data in the backend](/forum/25-install-update/905652-new-email-history-entries-have-no-data-in-the-backend#348072 "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 4.2.6 -- PHP version -- : 8.1 We recently upgraded from joomla 3 to 4, following the joomla documentation. Everything is working from the front end as expected. The issue we're seeing in new emails in the Customers->email history have no details populated for the admin (emails are sending correctly). The only thing I can find out of place is this in the check database results: OK Table "hikashop_email_log" checked Error Unknown column 'action_button_type' in 'where clause' Error hikashop_config: Duplicate entry 'website' for key 'PRIMARY' Error ALTER TABLE #__hikashop_config ADD PRIMARY KEY(config_namekey) OK Product categories checked But I'm not sure if that would be related or what the best way to go about fixing it would be.")* Actually I've just answered my own question: since migrating and losing the primary key index, all the new emails have an id of 0 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTY1Mi1uZXctZW1haWwtaGlzdG9yeS1lbnRyaWVzLWhhdmUtbm8tZGF0YS1pbi10aGUtYmFja2VuZD90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 3 years 10 months ago [\#348074](#348074) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[New email history entries have no data in the backend](/forum/25-install-update/905652-new-email-history-entries-have-no-data-in-the-backend#348074 "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 4.2.6 -- PHP version -- : 8.1 We recently upgraded from joomla 3 to 4, following the joomla documentation. Everything is working from the front end as expected. The issue we're seeing in new emails in the Customers->email history have no details populated for the admin (emails are sending correctly). The only thing I can find out of place is this in the check database results: OK Table "hikashop_email_log" checked Error Unknown column 'action_button_type' in 'where clause' Error hikashop_config: Duplicate entry 'website' for key 'PRIMARY' Error ALTER TABLE #__hikashop_config ADD PRIMARY KEY(config_namekey) OK Product categories checked But I'm not sure if that would be related or what the best way to go about fixing it would be.")* Hi, Yes, that's precisely the problem. You're missing the primary key and auto_increment on the table. For some reason, it seems your migration removed it... You can run this MySQL query via your PHPMyAdmin to add it back: Code: ALTER TABLE #__hikashop_email_log MODIFY email_log_id INT(10) AUTO_INCREMENT PRIMARY KEY; However, this query will only work after you've deleted all the elements with the same email_log_id, and since you have many entries with the value 0 in it, you'll have to delete these first. A simpler simpler would be to just delete the hikashop_email_log table completely from the database. HikaShop will automatically recreate it next time it sends an email with the proper primary key and auto_increment. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTY1Mi1uZXctZW1haWwtaGlzdG9yeS1lbnRyaWVzLWhhdmUtbm8tZGF0YS1pbi10aGUtYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[zerioni](/forum/user/51281-zerioni "View zerioni's Profile")** - [![zerioni's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51281-zerioni "View zerioni's Profile") Topic Author - [ Offline](/forum/user/51281-zerioni) Less More - Posts: 8 - Thank you received: 0 - - 3 years 10 months ago [\#348075](#348075) by [zerioni](/forum/user/51281-zerioni "View zerioni's Profile") Replied by *[zerioni](/forum/user/51281-zerioni "View zerioni's Profile")* on topic *[New email history entries have no data in the backend](/forum/25-install-update/905652-new-email-history-entries-have-no-data-in-the-backend#348075 "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 4.2.6 -- PHP version -- : 8.1 We recently upgraded from joomla 3 to 4, following the joomla documentation. Everything is working from the front end as expected. The issue we're seeing in new emails in the Customers->email history have no details populated for the admin (emails are sending correctly). The only thing I can find out of place is this in the check database results: OK Table "hikashop_email_log" checked Error Unknown column 'action_button_type' in 'where clause' Error hikashop_config: Duplicate entry 'website' for key 'PRIMARY' Error ALTER TABLE #__hikashop_config ADD PRIMARY KEY(config_namekey) OK Product categories checked But I'm not sure if that would be related or what the best way to go about fixing it would be.")* Thanks so much! Just to be sure, if we go with the simple option, am I totally dropping the table, not just truncating it Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTY1Mi1uZXctZW1haWwtaGlzdG9yeS1lbnRyaWVzLWhhdmUtbm8tZGF0YS1pbi10aGUtYmFja2VuZD90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 3 years 10 months ago [\#348079](#348079) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[New email history entries have no data in the backend](/forum/25-install-update/905652-new-email-history-entries-have-no-data-in-the-backend#348079 "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 4.2.6 -- PHP version -- : 8.1 We recently upgraded from joomla 3 to 4, following the joomla documentation. Everything is working from the front end as expected. The issue we're seeing in new emails in the Customers->email history have no details populated for the admin (emails are sending correctly). The only thing I can find out of place is this in the check database results: OK Table "hikashop_email_log" checked Error Unknown column 'action_button_type' in 'where clause' Error hikashop_config: Duplicate entry 'website' for key 'PRIMARY' Error ALTER TABLE #__hikashop_config ADD PRIMARY KEY(config_namekey) OK Product categories checked But I'm not sure if that would be related or what the best way to go about fixing it would be.")* Hi, Yes, you need to drop it. If you truncate it, you'll still have the same problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTY1Mi1uZXctZW1haWwtaGlzdG9yeS1lbnRyaWVzLWhhdmUtbm8tZGF0YS1pbi10aGUtYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.063 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)