No data displayed in custom fields

-- 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

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.

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

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.

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

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.

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

Ok,
Thanks for your feedback .

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

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