[Skip to main content](#vessel-content)

#   No data displayed in custom fields

##

- **[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")**
- [![paulus67's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/21159-paulus67 "View paulus67's Profile") Topic Author
- [ Offline](/forum/user/21159-paulus67)

Less More

- Posts: 9
- Thank you received: 0
-
-

12 years 7 months ago -  12 years 7 months ago [\#146522](#146522) by [paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")  *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#146522 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")* was created by *[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")*

-- url of the page with the problem -- : [ www.kneedbaresteen.nl](http://www.kneedbaresteen.nl)
-- HikaShop version -- : 2.2.2. Hikashop Business
-- PHP version -- : 5.3.27
-- Browser(s) name and version -- : All platforms
-- Error-message(debug-mod must be tuned on) -- : Rather not = live site

When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice.
The names of the fields are displayed in the backend but there is no content when filled in
The names of the fields are not displayed in the e-mail notice, both customer and admin.
In a backup dummy version (same version Hikashop) everything was displaying correctly.
I think the errors occured on the live site after renewing and editing the custom fields (probably)
When deleting the old fields and creating new ones they all have the same issue
Not sure if it's a MySQL problem - can' t figure it out

Anyone suggestions?
Thanx

Paul

- [ ![h1aa16be.png](/forum/attachment/15737) ](/forum/attachment/15737 "h1aa16be.png") [ ](/forum/attachment/15737?download=1 "h1aa16be.png")

Last edit: 12 years 7 months ago by [paulus67](/forum/user/21159-paulus67 "View paulus67's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86315
- Thank you received: 14276
-
-

12 years 7 months ago -  12 years 7 months ago [\#146581](#146581) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#146581 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Hi,

It's probably a problem with the database structure. Go in your phpmyadmin and check the structure of the table hikashop_order.
Do you see your fields there ? If not, that explains the problem.
Either the system doesn't have the right to create the columns for your fields because of the mysql user permissions (no ALTER), or the field name is too long/protected (and in that case recreate the fields with a smaller column name). Note that it won't save any field if not all the columns of the fields are present in the hikashop_order table.

Last edit: 12 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")**
- [![paulus67's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/21159-paulus67 "View paulus67's Profile") Topic Author
- [ Offline](/forum/user/21159-paulus67)

Less More

- Posts: 9
- Thank you received: 0
-
-

12 years 7 months ago [\#146655](#146655) by [paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")  Replied by *[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")* on topic *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#146655 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Thanks for your answer.

The columns were there actually. I recreated the fields and used a smaller column name. They show up in the database table but that did not do the trick
I'm not sure what you mean with *"Note that it won't save any field if not all the columns of the fields are present in the hikashop\_order table"*
What exactly should I do with that?
Is it an idea as to replace the whole hikashop_order table with a version that actually works or will I lose critical data then?

Paul

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

12 years 7 months ago [\#146818](#146818) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#146818 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Hi Paul,

Replace the table might be risky and you won't have your custom field anymore.
So you can try to do that (but don't forget to save your order before by exporting for example) and then recreate your custom field.
Before doing so you can also try to enable error reporting and debug mode in Joomla to make sure there is no error displayed.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")**
- [![paulus67's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/21159-paulus67 "View paulus67's Profile") Topic Author
- [ Offline](/forum/user/21159-paulus67)

Less More

- Posts: 9
- Thank you received: 0
-
-

12 years 7 months ago [\#146868](#146868) by [paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")  Replied by *[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")* on topic *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#146868 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

I did enable error debug in Joomla but there were no errors displayed.
I installed a exact backup on a dummy site, cleaned up its database and it worked fine!
No issues with the same site.
Could it be that when I refresh the database and reinstall the site on the live URL the issue disappears?
Should I give it a try?

Paul

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

12 years 7 months ago [\#146913](#146913) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#146913 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Hi Paul,

Did you extracted a backup of your live site on a dummy site?
If you did that and it works fine, then I don't think the issue is related to the table.
But if you solved the issue on a dummy site by changing the DB it worth giving a try on the live site.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")**
- [![paulus67's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/21159-paulus67 "View paulus67's Profile") Topic Author
- [ Offline](/forum/user/21159-paulus67)

Less More

- Posts: 9
- Thank you received: 0
-
-

12 years 7 months ago [\#146950](#146950) by [paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")  Replied by *[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")* on topic *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#146950 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Eliot,
Yes, I did extract a backup of my live site on a dummy site.
It seemed to solve the issue.
But if it is not the table what else could it be then?
Any ideas?

Pau

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

12 years 7 months ago [\#146969](#146969) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#146969 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Well if you solved the issue this way (I mean, if you had the issue on your dummy site and it solved it) then you can try on your live site.
If it doesn't solve the problem, you could try to install the last version of Hikashop (2.3.0). We did a lot of bug fix.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")**
- [![paulus67's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/21159-paulus67 "View paulus67's Profile") Topic Author
- [ Offline](/forum/user/21159-paulus67)

Less More

- Posts: 9
- Thank you received: 0
-
-

12 years 7 months ago [\#148247](#148247) by [paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")  Replied by *[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")* on topic *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#148247 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Ok, so I performed the trick at the live site
I upgraded Hikashop, cleared the database and reinstalled a backup on the live site.
Problem solved. Everything is normal again.
Seems to me that indeed the problem was in the table. After cleaning and reinstalling there were no issues.

Thread can be closed
Thanx for the support

Paul

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

12 years 7 months ago [\#148297](#148297) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[No data displayed in custom fields](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#148297 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Ok,
Thanks for your feedback ![:)](/media/kunena/emoticons/8.png ":)").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")**
- [![paulus67's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/21159-paulus67 "View paulus67's Profile") Topic Author
- [ Offline](/forum/user/21159-paulus67)

Less More

- Posts: 9
- Thank you received: 0
-
-

12 years 7 months ago [\#149529](#149529) by [paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")  Replied by *[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")* on topic *[No data displayed in custom fields (part 2)](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#149529 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Back again - same problem !
After a few orders the data in the custom fields disapeared again. So I deleted the fields and created new ones.
This worked for two times - after that same problem again.
I made sure with my hosting company that I have ALTER rights so I'm convinced that it is not a MySQL problem.
It must be a PHP problem, maybe a bug and I would appreciate if you could look into it.
I ve created an PHP error log and several errors are displayed in it while making an order (see attachment)
I'm not into PHP so hopefully you can make something out of it

Paul

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86315
- Thank you received: 14276
-
-

12 years 7 months ago [\#149572](#149572) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[No data displayed in custom fields (part 2)](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#149572 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

These notices are not related to the problem.

If you have the columns in the database for your fields, then it's not a problem with the mysql queries. It's probably not a problem happening when the order is created but more of a problem of when the user is logged in.
On some servers, based on the way the user session is handled, it's possible that the session data of the custom fields is lost during the login as the user session is recreated at that moment.
The simplest to validate that theory will be to move the "fields" view after the "login" view in your checkout workflow option of the configuration. That way, there won't be any user session change after the user has entered his info in the custom fields.

The following user(s) said Thank You: [paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")**
- [![paulus67's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/21159-paulus67 "View paulus67's Profile") Topic Author
- [ Offline](/forum/user/21159-paulus67)

Less More

- Posts: 9
- Thank you received: 0
-
-

12 years 7 months ago [\#149715](#149715) by [paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")  Replied by *[paulus67](/forum/user/21159-paulus67 "View paulus67's Profile")* on topic *[No data displayed in custom fields (part 2)](/forum/32-content-creation/866327-no-data-displayed-in-custom-fields#149715 "-- url of the page with the problem -- :   www.kneedbaresteen.nl  -- HikaShop version -- : 2.2.2. Hikashop Business -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : All platforms -- Error-message(debug-mod must be tuned on) -- : Rather not = live site  When customer enters data on custom fields in order checkout it is not displayed in backend (order details) nor in customers e-mail notice. The names of the fields are displayed in the backend but there is no content when filled in The names of the fields are not displayed in the e-mail notice, both customer and admin. In a backup dummy version (same version Hikashop) everything was displaying correctly. I think the errors occured on the live site after renewing and editing the custom fields (probably) When deleting the old fields and creating new ones they all have the same issue Not sure if it's a MySQL problem - can' t figure it out  Anyone suggestions? Thanx  Paul")*

Nicolas,

I have no login option in the checkout proces. Customers can place orders as a guest.
Though I changed the adress and fields order and placed the fields after the adress in the checkout workflow.
It works !
Hopefully it stays this way - perhaps after a few tries the porblem occurs again
But for now problem solved.
Thank you very much!

Paul

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2MzI3LW5vLWRhdGEtZGlzcGxheWVkLWluLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.256 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
