Plugin Author
Franky
(@liedekef)
I just tried it here and updated from even 1.0.13 to 1.1.0 without problems.
So the only thing I can think about is the database difference. What version of mysql are you running?
Plugin Author
Franky
(@liedekef)
Btw, if running mysql 5.1, would you mind trying this on your database (after taking a backup of course):
ALTER TABLE wp_eme_events CHANGE price price_old decimal(7,2) DEFAULT ‘0.00’;
ALTER TABLE wp_eme_events ADD price text default NULL;
UPDATE wp_eme_events set price=price_old;
I think mysql 5.1 doesn’t allow to convert directly from decimal to text.
After this, update to 1.1.0 and see what gives.
If this works, I’ll use this in the next release.
Thread Starter
HR_Web
(@hr_web)
We are running mysql Version 14.12 Distrib 5.0.95, on a Linux dedicated server.
Would it help if we installed a previous version and then tried to update it from there?
Thanks!
Plugin Author
Franky
(@liedekef)
5.0.95 is really old … but anyway: could you mail me a dump of your wordpress db (from after the EME upgrade) so I can see where the problem is?
Is there a possibility to activate logging on your db server to see which sql statement is actually failing?
I have one other person with a similar issue, but I can’t reproduce it in any way, so I need your input to help get this problem resolved.
Thread Starter
HR_Web
(@hr_web)
As for the “dump of wordpress db”, I assume you mean an export from the wordpress dashboard? And the access to our db server would be via plesk, correct?
Plugin Author
Franky
(@liedekef)
I mean a dump of the wordpress database. And if you’re using plesk: yes.
But I don’t need the access, I just need the dump.
You can mail it to me at liedekef [at] telenet.be
Thread Starter
HR_Web
(@hr_web)
I have emailed you the export. I hope it what’s you need. Thanks!
Plugin Author
Franky
(@liedekef)
Found to be a multisite issue, together with wordpress prepare statements not using backticks for column names …
Here’s the fix:
http://plugins.trac.wordpress.org/changeset/695524
