Problem after update v1.7.15

[Anonymous]

Hallo Franky,
I have just updated to version 1.7.15.
I noticed some points.

1. In the backend, events | edit, the link for the print view.
I use many custom fields for some events, so the print view is often very wide.
=> The horizontal scroll bar is missing in the print view.

2. Changes to the eme_get_answers function
In the last version, a value of $answer[‘field_name’] was passed. In the current version, you changed this and passed $answer[‘field_id’]. This is a good change, unfortunately, no id is passed.
This may also be the problem for point 1?

I just looked at the db again. I think there is my problem.
In the eme_answers table, there is now a field called field_id, the value is NULL for all previous bookings.
The field field_name is not present.

[Franky]

That means that something has gone wrong for your update.
You should restore the old version of the eme_answers table and execute this manually:

ALTER TABLE wp_eme_answers add field_id INT(11) DEFAULT 0;
UPDATE wp_eme_answers SET field_id = (select field_id from wp_eme_formfields where field_name = ‘wp_eme_answers.field_name’ LIMIT 1);

And see what is the result …

[Franky]

Holy …. I just found the problem … in my tests it was ok, but in the final statement some backquotes slipped in 🙁
This is the correct update statement:
UPDATE wp_eme_answers SET field_id = (select field_id from wp_eme_formfields where field_name = wp_eme_answers.field_name LIMIT 1);

[Author]

Posts