Custom fields have disapeard on invoices, emails and delivery notes

  • Posts: 9
  • Thank you received: 0
7 years 3 months ago #275995

-- url of the page with the problem -- : mueller-fandre.de
-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.74
-- PHP version -- : 7.0.19
-- Browser(s) name and version -- : Firefox 54.01
-- Error-message(debug-mod must be tuned on) -- : none

Hi,

the custom fields have disapeared in delivery notes, emails and invoices after updating Hikashop and Joomla.
I can fill them in the front end, but they are not shown anymore on the delivery notes, emails and invoices in the backend.

I also have a error message checking the Database:
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

I have installed Hikashop over the existing installtion, but no changes.

Stefan

Attachments:

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #275997

Hello,

If you have updated HikaShop from a 2.x version ; you might want to check the configuration of the fields.
In Hikashop 2.6 a modification in the custom field system allowed to have more "display" settings.
In HikaShop 3.x we made modifications to re-organize them and provide a more homogeneous configuration.
Do not hesitate to re-save the custom field in order to be sure that its configuration is right stored in the database.

If the problem persist, we would need more details about your custom field configuration.

Regarding the error you have in the "check database", it's related to the fact that your HikaShop user table and your Joomla users table do not have the same collation.
It is not a problematic issue since only that specific database check task will try to make such kind of relation which is used in order to synchronize the Joomla users with the HikaShop users (in case some are missing in HikaShop).

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: 9
  • Thank you received: 0
7 years 3 months ago #276028

Hi,

I re-saved the fields, but there are no changes. What do you need for further testing?

Stefan

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

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
7 years 3 months ago #276037

Hello,

Do you try to manage Display options and re-save your custom field configuration ?
Can you provide some screenshot of your custom fields configuration page ?
Awaiting news from you.

regards

Last edit: 7 years 3 months ago by Philip.

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

  • Posts: 9
  • Thank you received: 0
7 years 3 months ago #276126

Hi,

I have found the issue - sometimes you are blind - see attachment. Some buttons were disabled, I don't know why. Bút now it seems to work.

Thanks

Stefan

Attachments:

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

Time to create page: 0.046 seconds
Powered by Kunena Forum