1054 Unknown column 'pack_email_inherit' in 'field list'

  • Posts: 276
  • Thank you received: 17
6 years 8 months ago #274026

-- HikaShop version -- : You have the latest stable version of HikaShop Business: 3.1.1
-- HikaSerial version -- : You have the latest stable version of HikaSubscription: 2.0.0
-- Joomla version -- : Joomla! 3.7.3 Stable [ Amani ] 4-July-2017 08:03 GMT
-- PHP version -- : 7.0.7
-- Browser(s) name and version -- : Version 59.0.3071.115 (Build officiel) (64 bits)
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'pack_email_inherit' in 'field list'

Hello

I have been waiting a long time for this hikaserial subscription after successfully using akeeba subscription, emerald.
First quarter of an hour of discovery:
1) Installation OK
2) Dark blue menu bar with invisible controls


3) Unable to create a new plan.

Message:
"1054 Unknown column 'pack_email_inherit' in 'field list'"


Tank You
Some research but I could not create a new plan !!!

Attachments:

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
6 years 8 months ago #274036

Hello,

Can you please perform a "check database" via your HikaShop configuration screen ?
I will fix the SQL query for the table creation during the installation ; but the SQL file should be good and the "check database" should fix it.

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: 276
  • Thank you received: 17
6 years 8 months ago #274064

Hello,

Ok for point 3

Another point now appeared:

4) In the view of the "Plan emails" tab




here is the error: 1146 Table 'ghxt_prosystemefr2. # __ hikaserial_ack_email' does not exist


Tank you

Attachments:

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
6 years 8 months ago #274065

Hello,

You can re-download the beta package to get the fix.

Regards,

PS : Your backend menu color is not related to HikaSerial. There is indeed some CSS to handle menus in HikaSerial but that's for the legacy menus, since a long time HikaSerial is using the HikaShop menu and so its CSS.


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: 276
  • Thank you received: 17
6 years 8 months ago #274092

Bonjour Jérome

0K pour le point 4)

Point 2) Dark blue menu bar with invisible controls
Je ne comprend pas ta réponse :

PS : Your backend menu color is not related to HikaSerial. There is indeed some CSS to handle menus in HikaSerial but that's for the legacy menus, since a long time HikaSerial is using the HikaShop menu and so its CSS.


5) Erreur sur enregistrer suite à modification du plan :
Je modifie le plan et je click sur enregistrer :


Voici l'erreur:


Heureux de vous aider et bonne journée
Nota: Je suis très intéressé par cette extension que j'attend depuis longtemps pour simplifier les abonnements suite à l'acquisition des produits à télécharger sur hikashop.

Attachments:

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
6 years 8 months ago #274095

Hello,

This thread has been started in English ; please stay in English.
Otherwise you can create a new one with a French title ; but it won't be easy for other users if you change the language in the middle.
Thank you for your understanding.

About the SQL error ; I hope that Joomla will fix soon the error display and re-introduce the SQL query detail (or at least an option to do it otherwise debug is impossible).
I was able to reproduce your issue by installing HikaSubcription beta on an HikaSerial 2.0.0.
So I made a patch and updated the package.

For your backend menu ; it's not related to HikaSerial. That's 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.

  • Posts: 276
  • Thank you received: 17
6 years 8 months ago #274160

Ok resolved => 5) Error on recording due to plan modification:
I just tested all the basic commands:
New plan, Edit and Delete and everything looks OK


Remainder Error Item 2) Dark blue menu bar with invisible controls
I do not know what to do ???

Have a good day

Last edit: 6 years 8 months ago by Teophile.

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
6 years 8 months ago #274181

Hello,

2 - You can check your CSS rules
www.hikashop.com/support/documentation/1...the-display.html#css

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.

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