Error saving Plan

  • Posts: 254
  • Thank you received: 17
  • Hikaserial Subscription Hikashop Business
8 months 5 days ago #276298

-- HikaShop version -- : 3.1.1
-- HikaSerial version -- : 2.0.0
-- Joomla version -- : 3.7.5
-- PHP version -- : 7.1.8
-- Browser(s) name and version -- : Chrome 60

Hi Jerome,

Creating a new Plan (or editing) > Saving (or Saving and close):

An error has occurred.
1146 Table 'myDBname.#__hikaserial_pack_email' doesn't exist


Please, What am I missing ?
Anyway, going back to the Packs page the Pack seem has been saved correctly, but I cannot entry in the Configuration anymore, the same error message appear

Last Edit: 8 months 5 days ago by joomleb.

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

  • Posts: 22257
  • Thank you received: 3465
  • MODERATOR
8 months 5 days ago #276299

Hello,

Please go in the HikaShop configuration panel and click on the button "check database".
It will create the missing table.

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: 254
  • Thank you received: 17
  • Hikaserial Subscription Hikashop Business
8 months 5 days ago #276311

Hi Jerome,
done, that table seem to be fixed. But as result I have back some errors.
Don't knowing the Check Database feature I attach here the pdf file report...

File Attachment:

File Name: HikaSubscription.pdf
File Size:59 KB


Please, let me know if all is good, or if I have to do something, thanks!

Attachments:

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

  • Posts: 22257
  • Thank you received: 3465
  • MODERATOR
8 months 4 days ago #276312

Hello,

I don't see any specific problem with your PDF and it looks like it fix the table and the columns.
So please explain your problem.


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: 254
  • Thank you received: 17
  • Hikaserial Subscription Hikashop Business
8 months 3 days ago #276470

joomleb wrote: Hi Jerome,
done, that table seem to be fixed. But as result I have back some errors.
Don't knowing the Check Database feature I attach here the pdf file report...

File Attachment:

File Name: HikaSubscription.pdf
File Size:59 KB


As you can see in thepdf, the report wrote:

Info Field "pack_email_id" missing in hikaserial_pack_email
Error Could not add the field "pack_email_id" in the table "hikaserial_pack_email"
Duplicate ​column​ ​name​ ​'pack_email_id'

Info Field "pack_id" missing in hikaserial_pack_email
Error​ Could not add the field "pack_id" in the table "hikaserial_pack_email"
Duplicate​ ​column​ ​name​ ​'pack_id'

Info Field "pack_email_type" missing in hikaserial_pack_email
Error Could not add the field "pack_email_type" in the table "hikaserial_pack_email"
Duplicate​ ​column​ ​name​ ​'pack_email_type'

Info​ Field "pack_email_days" missing in hikaserial_pack_email
Error Could not add the field "pack_email_days" in the table "hikaserial_pack_email"
Duplicate​ ​column​ ​name​ ​'pack_email_days'

Info​ Field "pack_email_template" missing in hikaserial_pack_email
Error Could not add the field "pack_email_template" in the table "hikaserial_pack_email"
Duplicate​ ​column​ ​name​ ​'pack_email_template'

So, Don't knowing how run/have to run the Check Database feature, I attach here the pdf file report:
1 - Because I'm been educated to report the results when people gently suggest and tech me;
2 - To permit you to ivestigate if you think something is not running as you expected;
3 - With "Please, let me know if all is good, or if I have to do something" I mean that if you think that something is not running as expected, I'm here ready to be helpful doing all what is needed...

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

  • Posts: 22257
  • Thank you received: 3465
  • MODERATOR
8 months 3 days ago #276517

Hello,

Once again, I don't see what is your problem.

You performed a "check database" and it fixed some issues.
The fact you got the "duplicate" is normal because the table was just fix in the first step of the process.
If you have feedback about the "check database", please contact the HikaShop team for that. HikaSerial is just using the system/features so I cannot provide any kind of support for it.

Thank you for your understanding.

Now, what is the resort of my support is to be sure that the "check database" did its job and fix the table schema ; that you are not able to perform the save the plan (the original issue).

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: 254
  • Thank you received: 17
  • Hikaserial Subscription Hikashop Business
8 months 2 days ago #276591

Once again, I don't see what is your problem.


Please, do not treat me as stupid.

Now, the four "Errors" messages are for the HikaSerial table "hikaserial_pack_email". This is why I wrote:

done, that table seem to be fixed. But as result I have back some errors.
Don't knowing the Check Database feature I attach here the pdf file report...


And then I also add to explain me better:

So, Don't knowing how run/have to run the Check Database feature, I attach here the pdf file report:
1 - Because I'm been educated to report the results when people gently suggest and tech me;
2 - To permit you to ivestigate if you think something is not running as you expected;
3 - With "Please, let me know if all is good, or if I have to do something" I mean that if you think that something is not running as expected, I'm here ready to be helpful doing all what is needed...


PS I'm not here on HikaShop because I think you are nice, I'm not interested to know "if you are nervous", "if you don't like your work", or "If the girl betrayed you" and so on.
I'm here because I think HikaShop is a valid team with very good components. This is why I paid for HikaShop components.
Staying here I'm looking to observe all the HikaShop rules.
If, for any reason, you don't want me here, there is no problem, refund me what I paid and I'll looking for others components. Simply and really without any problems.
But, Please, do not treat me as stupid.

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

  • Posts: 61852
  • Thank you received: 8797
  • MODERATOR
8 months 2 days ago #276605

Hi,

To answer your previous question:

Please, let me know if all is good, or if I have to do something, thanks!

It looks good and you can ignore the duplicate error messages since it means that the columns are where they should be.

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

  • Posts: 254
  • Thank you received: 17
  • Hikaserial Subscription Hikashop Business
8 months 1 day ago #276743

Hi Nicolas,
thanks and Yes, I can confirm you that seem to be fixed. I'm using HikaSerial Subscription and the issue did not reappear...

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

Moderators: Obsidev
Time to create page: 0.104 seconds
Powered by Kunena Forum