@pif, can you reproduce this problem, e.g. submit an event as a normal user?
If so, I could take a look at your site and debug the issue further. I’d need FTP and admin info sent to the contact form above.
On another site I now have 152 published locations, which shows correctly, as can be seen on http://www.yogaindebuurt.nl/yoga-scholen/.
7 pages with 20 locations each and 1 page with 12 locations.
Admin
http://i.imgur.com/t2kH3Ka.jpg
MySQL
http://i.imgur.com/ShYmziG.jpg
Then it shows I have 185 locations. That’s 33 ‘ghosts’…
Still need to check which are the ‘odd ones’, but will take a bit…
Try this SQL statement:
SELECT * FROM wp_em_events LEFT JOIN wp_posts ON post_id=ID WHERE ID IS NULL
for locations:
SELECT * FROM wp_em_locations LEFT JOIN wp_posts ON post_id=ID WHERE ID IS NULL
first query returns zero results… which is weird, because after deleting all events through the admin (and checking in MySQL as well, to make sure), still 1 published event remains, but I can’t get it to show in the results.
Also doesn’t show on http://www.yogaindebuurt.nl/evenementen/
second query returns 28 results… (still 5 ghosts then…)
does it maybe have to do with switching from posts to pages or vice versa ?
still 1 published event remains, but I can’t get it to show in the results.
Also doesn’t show on http://www.yogaindebuurt.nl/evenementen/
hmm, am seeing 1 publish event at http://www.yogaindebuurt.nl/evenementen ?
yes, that is created by me….
I found the ‘ghost’ entry in the db and deleted it…
Thread Starter
pif
(@pif)
Thank Marcus for your reply. Unfortunately, I cannot reproduce the problem, since these events (wich are 6 now) are appareaing randomly as far as I can tell…
We use the same process for creating hundreds of events each week. Some day, one new shadow event appear… and I strictly don’t know why.
I see, however is this happening more on recurring events or in normal non-recur events?
Thread Starter
pif
(@pif)
normal events I guess, since I don’t have access to them, can’t really tell.
But here’s a new thing. I *think* it is happening when someone is resubmitting a published event, when he does not have publishing rights.
I use the submission form and some people have a dedicated calendar account. To prevent spam and low quality entries, I did not grant the right to publish to outside users.
BUT apparently, they can edit published events (despite my settings) and that’s probably somewhat sending the event in a gray zone, waiting for approval but not appearing in any event listing…
Are you able to reproduce this consistently when following the steps you think are causing the problem?
Thread Starter
pif
(@pif)
Hello,
Sorry for the late reply.
Yes, I have been able to reproduce the problem. Shadow Events happens when someone without publishing rights accesses a published event, modifies it and then try to republish it.
It withdraws the event from the published state (wich is normal) but does not add him back into the “submitted” list. Therefore, there are unpublished and not findable.
Thank you for your help on this.
