Multisite broke

[Anonymous]

Hi there,

First – its a great plugin.

I use it for for some bridgeclubs as a turnement calendar including QR codes for easy transfer to iphones etc.

During the latest update of this plugin the calendar function broke.

The calendar itself works showing both historic and coming events, but the control panel interface is broken. It just says that due to the update you must deactivate and activate the plugin. That means that I cant edit or add events. On multisites this is done in the network site control panel. And I have done it the better part of 10-20 times with obviously no luck.

Site: http://distrikt-nord.wp.jeppesens.com/turneringer-2/turneringer/

What can I do???

Sincerely,

Dr. Karsten Jeppesen

[Franky]

What was the old version? And the WP version?

To quickly get around things: you can reinstall the 1.0.18 version.

[Anonymous]

Hi Franky,

Thanks for answering.

I will try to figure that out, but as you may expect since updating is just mouse-clicks: I have no idea.

I did totally deinstall and subsequently reinstalled Events-Made-Easy, but that didn’t solve the problem, there was no change.

I will have a look at the databases since multisiting sometimes is hit by name confusion by the plugins. Whether that is on the plugin or WP itself I have no idea.

But I always keep everything updated to the latest state.

Sincerely,

Karsten

[Franky]

You can try to activate wp debugging when activating EME, maybe that will show something.

Set

define(‘WP_DEBUG’, true);

in wp-config.php

[Anonymous]

Hi Franky,

Ah – you are too fast for me. I was sifting through the wp database and I have a few things, but I took too long and you already answered 🙂

Using Emma I was looking at the wp database. I have no idea if that helps but there seems to be many instances of:

wp_#_eme_events where # is [1..10] but only wp_5_eme_events contains the real events database. the others just contain the sample 3 events.

Nah – that may not be true since wp_eme_events seems populated too

A few more tidbits: I looked through the code and found that eme_version is requested.

wp_10_options: eme_version=28

wp_3_options: eme_version=28

wp_5_options: eme_version=28 (This is the offending site)

wp_6_options: eme_version=28

wp_7_options: eme_version=28

wp_8_options: eme_version not found

wp_9_options: eme_version=28

wp_options: eme_version not found

I reallize that the version is now 30

the debug didnt turn anything usable out

I just did a baaaad thing. I changed the eme_version to 30 and it now works.

What is the differences in the bases from 28 to 30? could be interesting to see if it was indeed updated and its just the version which wasn’t updated correctly ???

Sincerely,

Karsten

[Franky]

I think there’s something going on with multisite + EME, as another user reported a similar issue.

[Anonymous]

Hi Franky,

edited the last post but you got me again – he he

I just did a baaaad thing. I changed the eme_version to 30 and it now works.

What is the differences in the bases from 28 to 30? could be interesting to see if it was indeed updated and its just the version which wasn’t updated correctly ???

Sincerely,

Karsten

[Franky]

Can you check if this change helps (when doing network deactivation/activation):

http://plugins.trac.wordpress.org/changeset/695426

?

[Franky]

No, just updating to version 30 won’t do 🙂

There are 3 database changes that should be executed (if done manually). I can provide you with those, but I would prefer if you revert back the version to 28 and then try the change in code I mentioned above.

Glad to see somebody with debugging skills 🙂

[Anonymous]

Hi Franky,

I set the version back to 28 and verified that this activated the warning of deactivation/activation. It did.

Then I executed the changes as described in the trac diff.

Finally I deactivated and activated eme again: Sorry – that didn’t work

Karsten

[Franky]

I don’t understand … something in 3.5 or 3.5.1 must have changed (again) for multisite

These are the DB changes:

(change the prefix to your liking):

> ALTER TABLE wp_eme_events MODIFY price text default NULL;

> ALTER TABLE wp_eme_bookings ADD booking_seats_mp varchar(250);

> ALTER TABLE wp_eme_bookings ADD booking_price text DEFAULT NULL;

[Anonymous]

Luckily these fields are of no importance to me (yet) as I use it for bridge club tournaments.

I thank you 1000 times for your help

Let me know if you need me to do further. My email is karsten (at) jeppesens.com should I not find your requests fast enough 🙂

Cheers,

Karsten

[Franky]

Ok, good news (kind of): I can reproduce the problem here with a multisite setup.

Now to go and fix it …

[Franky]

Yes! Found and fixed (due in fact to me trying to use the correct $wpdb->prepare syntax and a incorrect backtick use in that prepare statement for columns):

http://plugins.trac.wordpress.org/changeset/695524

[Author]

Posts