- Posts: 25
- Thank you received: 0
error in hikashop admin: customers: e-mail history
- Cybermissy
-
Topic Author
- Offline
Less
More
10 years 1 week ago #250301
by Cybermissy
error in hikashop admin: customers: e-mail history was created by Cybermissy
-- 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
-- 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.
10 years 1 week ago #250303
by Jerome
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.
Replied by Jerome on topic error in hikashop admin: customers: e-mail history
Hi,
Please go in your HikaShop configuration and click on the toolbar button "check database".
Regards,
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.
- Cybermissy
-
Topic Author
- Offline
Less
More
- Posts: 25
- Thank you received: 0
10 years 1 week ago #250515
by Cybermissy
Replied by Cybermissy on topic error in hikashop admin: customers: e-mail history
Hi Jerome,
I get a lot of errors there, only one is fixed of them:
I get a lot of errors there, only one is fixed of them:
Code:
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.
- Cybermissy
-
Topic Author
- Offline
Less
More
- Posts: 25
- Thank you received: 0
10 years 1 week ago #250518
by Cybermissy
Replied by Cybermissy on topic error in hikashop admin: customers: e-mail history
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.
Less
More
- Posts: 15
- Thank you received: 1
9 years 9 months ago #258307
by cesarsupport
Replied by cesarsupport on topic error in hikashop admin: customers: e-mail history
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
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.
9 years 8 months ago #258587
by Jerome
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.
Replied by Jerome on topic error in hikashop admin: customers: e-mail history
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,
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.195 seconds