error in hikashop admin: customers: e-mail history

  • Posts: 25
  • Thank you received: 0
8 years 2 months ago #250301

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.2
-- PHP version -- : 5.6.18
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : Er heeft zich een fout voorgedaan.
1146 Table 'dib_dib.#__hikashop_email_log' doesn't exist SQL=SELECT COUNT(*) FROM #__hikashop_email_log AS a WHERE a.email_log_published = 1 ORDER BY a.email_log_id asc

Hi,

When I select e-mail history in the hikashop admin I get this error:

1146 Table 'dib_dib.#__hikashop_email_log' doesn't exist SQL=SELECT COUNT(*) FROM #__hikashop_email_log AS a WHERE a.email_log_published = 1 ORDER BY a.email_log_id asc

How to solve this?

Is this because I updated from free tot essential en then to business edition?

Kind regards

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 2 months ago #250303

Hi,

Please go in your HikaShop configuration and click on the toolbar button "check database".

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 25
  • Thank you received: 0
8 years 2 months ago #250515

Hi Jerome,

I get a lot of errors there, only one is fixed of them:

Info Field "email_log_id" missing in hikashop_email_log
Error Could not add the field "email_log_id" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) unsigned NOT NULL AUTO_INCREMENT' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD int(10) unsigned NOT NULL AUTO_INCREMENT
Info Field "email_log_sender_email" missing in hikashop_email_log
Error Could not add the field "email_log_sender_email" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_sender_name" missing in hikashop_email_log
Error Could not add the field "email_log_sender_name" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_recipient_email" missing in hikashop_email_log
Error Could not add the field "email_log_recipient_email" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_recipient_name" missing in hikashop_email_log
Error Could not add the field "email_log_recipient_name" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_reply_email" missing in hikashop_email_log
Error Could not add the field "email_log_reply_email" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_reply_name" missing in hikashop_email_log
Error Could not add the field "email_log_reply_name" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_cc_email" missing in hikashop_email_log
Error Could not add the field "email_log_cc_email" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_bcc_email" missing in hikashop_email_log
Error Could not add the field "email_log_bcc_email" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_subject" missing in hikashop_email_log
Error Could not add the field "email_log_subject" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD text NOT NULL
Info Field "email_log_altbody" missing in hikashop_email_log
Error Could not add the field "email_log_altbody" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD text NOT NULL
Info Field "email_log_body" missing in hikashop_email_log
Error Could not add the field "email_log_body" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD text NOT NULL
Info Field "email_log_name" missing in hikashop_email_log
Error Could not add the field "email_log_name" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_ref_id" missing in hikashop_email_log
Error Could not add the field "email_log_ref_id" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT ''' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD varchar(255) NOT NULL DEFAULT ''
Info Field "email_log_params" missing in hikashop_email_log
Error Could not add the field "email_log_params" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD text NOT NULL
Info Field "email_log_date" missing in hikashop_email_log
Error Could not add the field "email_log_date" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD int(10) NOT NULL
Info Field "email_log_published" missing in hikashop_email_log
Error Could not add the field "email_log_published" in the table "hikashop_email_log"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(3) unsigned NOT NULL DEFAULT '1'' at line 1 SQL=ALTER TABLE #__hikashop_email_log ADD tinyint(3) unsigned NOT NULL DEFAULT '1'

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

  • Posts: 25
  • Thank you received: 0
8 years 2 months ago #250518

Ah when i click check database the second time everything is ok. And the error is gone on the e-mail history page!

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

  • Posts: 15
  • Thank you received: 1
7 years 10 months ago #258307

I have the same problem.
When I select e-mail history in the hikashop admin I get this error: ... _hikashop_email_log' doesn't exist ...
Ah when i click check database the second time everything is ok. And the error is gone on the e-mail history page!
But also the Recaptcha of the contact forms disappeared !!!
I hope can you help me.
Kind regards.

- HikaShop version -- : 2.6.4
- Joomla version -- : 3.6.5
- PHP version -- : 5.3.29
- BD --: 10.1.20-MariaDB

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 10 months ago #258587

Hi,

I am sorry but I don't understand your message.
I don't see what is the link between the emeail history and the recaptcha (and there is possible link at all).

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.078 seconds
Powered by Kunena Forum