Order_payment_params has to have a value

-- HikaShop version -- : latest
-- Joomla version -- : latest
-- PHP version -- : latest
-- Browser(s) name and version -- : NA
-- Error-message(debug-mod must be tuned on) -- : Not in page, in connection to filemaker

We have a database connection from filemaker to Mysql . In Filemaker we import our orders. We have just made a new website with Hikashop (used Virtuemart before) and so now we have to change our filemaker connections.

When I change the order status from within filemaker it sends it to mysql hikashop_order table and changes the status there. One one computer this works fine, on another I get a weird error:

According to the definition of "order_payment_params" there needs to be a value entered. Enter a value now.

It is a total mystery why I get the error only on one computer, but my questions are:
- Do you have any idea why that error is there or what it means?
- Can I change anything so the error will not happen?
- Does it matter what value I put in here? So if I just put something in there in the script when it changes the order status what does this impact?

NB we do not use userpoints nor will we ever, that is the only link to this column I could find on the forum.

Thanks in advance

Correction: Error is on all computers. I had a connection error on the other computer, so it did not connect to the mysql database and so the error did not occur. Now it does. So the error is all the time on editing the order_status field.

Hi Nicolas,

Thanks for your reply. I have done so and now I get the same error "order_tax_info must have a value. I have googled the error and others with the same problem came to the conclusion that it means that one field in the record requires validation. Any ideas on this?

We've used this for the past five years with virtuemart without any problems (same filemaker database, same connections same placing of data etc.) so there must be something different in the hikashop mysql that causes the error.

This is what Filemaker says about the issue

This field cannot be modified until <fieldname> is given a valid value

• [You're trying to enter data into a related field, but the match field does not yet have a value. Enter a value in the match field, then enter data in the related field./li]
  
• [The value in the match field is the wrong type for the field's data type (for example, text in a number field)./li]
  
• [The value in the match field is non-alphanumeric (for example: @). If you need to use these characters in match fields, set both match fields' language for indexing to Unicode. See Defining field indexing options for more information./li]