WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Events Manager] Getting error in widget - did it get tested before release? (26 posts)

  1. anmari
    Member
    Posted 5 years ago #

    Getting error in widget - did it get tested?

    WordPress database error: [Unknown column 'event_contactperson_id' in 'field list']
    SELECT event_id, event_name, DATE_FORMAT(event_start_time, '%e') AS 'event_day', DATE_FORMAT(event_start_time, '%Y') AS 'event_year', DATE_FORMAT(event_start_time, '%k') AS 'event_hh', DATE_FORMAT(event_start_time, '%i') AS 'event_mm', DATE_FORMAT(event_end_time, '%e') AS 'event_end_day', DATE_FORMAT(event_end_time, '%Y') AS 'event_end_year', DATE_FORMAT(event_end_time, '%k') AS 'event_end_hh', DATE_FORMAT(event_end_time, '%i') AS 'event_end_mm', event_start_date, event_end_date, event_start_time, event_end_time, event_notes, event_rsvp, recurrence_id, location_id, event_contactperson_id FROM tst_dbem_events WHERE event_start_date >= '2009-03-13' ORDER BY event_start_date LIMIT 3

    http://wordpress.org/extend/plugins/events-manager/

  2. nutsmuggler
    Member
    Posted 5 years ago #

    Hi Anmari, which version of WordPress are you using?
    I am asking because I don't get the error in my install. I have just tried a clean install on WP 2.7.1 and I everything seems to work fine. If you give me more details here or on the official support page I will try to sort this out.
    Sorry for the inconvenience, the plugin has been tested, but any setup has its own peculiarity, that is why user feedbacks and bug reports are so important.
    Cheers,
    Davide from Events Manager

  3. bhbryant
    Member
    Posted 5 years ago #

    Getting the same error, after doing a plug-in update on the Event Manager.

    using WP 2.7.1

  4. bhbryant
    Member
    Posted 5 years ago #

    Okay...

    I didn't realize it was beta until after reading your post on the official site, as the WordPress plug-ins page just says there's a new version (albiet with the "b" for beta, but it's easy to miss).

    Fortunately, I'd just backed up my database.

    But, I would recommend fixing the auto-update procedure ASAP or removing the update until you've done so, as I'm sure I'm not to only click-happy idiot out there.

  5. nutsmuggler
    Member
    Posted 5 years ago #

    bhbryant
    I am really sorry for the trouble the upgrade has caused.

    The WP repo system allows only to tag a 'stable' version; yet, if you don't tag a new version as stable it's never going to be presented to the users. The best solution would be a way to signal "hey people, warning!" in the auto-update button.

    I tested the plugin on my system and on a couple of clients websites, and didn't get this error, but unluckily these are the kinds of error who pop out only after public betas.

    I am trying to identify the and fix all bugs.

    Davide

  6. rfearns
    Member
    Posted 5 years ago #

    Add me to the list as getting this error. Using 2.7 and this was an auto upgrade. Is there a work around? This is on a community site and the users are going to get restless very soon.

  7. nutsmuggler
    Member
    Posted 5 years ago #

    Hello folks,
    I have finally found the bug and fixed it, it was a stupid typo whiech prevented the column from being created. Now I am testing the 2.0b3 version, which I hope to release this afternoon.
    @ rfearns, if users get restless and feel the code is poorly managed, they can take the plugin, fix it and distribute it with another name; it's on the GPL. But believe me, it takes work. I am doing my best, for free. Pressuring me is of little use.
    Davide

  8. rfearns
    Member
    Posted 5 years ago #

    I didn't mean to sound as if I was trying to pressure you. I thought if there was a work around the issue that I could use that while the fix was being worked on. And my users are old people, doing well to know where the on switch is....... All who use this plugin appreciate all your hard work. Given the number of those spazing when something goes wrong is a testament to its popularity.

  9. nutsmuggler
    Member
    Posted 5 years ago #

    The eventcontactperson_id problem should be fixed in EM 2.0b3, just released. To solve the problem, automatically update to 2.0b3, deactivate and reactivate the plugin. This did the job in my simulations, hope it works in real case scenarios.
    Davide

  10. rfearns
    Member
    Posted 5 years ago #

    Fix did indeed take care of the database error. However now my events are being displayed as

    18 Mar 2009 - 00:00
    #_VENUE
    Venice Theatre Performance

    And the maps are now green squares, but I'm thinking the may be because of the #_VENUE where the name of the place should be

  11. rfearns
    Member
    Posted 5 years ago #

    I figured out that the name of the placeholder #_VENUE had been changed to #LOCATION - is there any others? You really shouldn't change variables from one build to the next - makes for a lot of extra work all the way around. I still have the green square where there used to be a map. Any ideas?

  12. nutsmuggler
    Member
    Posted 5 years ago #

    RFearns, that has changed indeed. You should insert #_LOCATION, it's in the docs.
    This was a change to 1.0 to 2.0, we have been giving a lot of thought about the venue > location issue, there's a long sequence of mail between me an my tester discussing the issue. I am quite opinionated on design issues and I guess sometimes it's better to push the change to the users.
    About the map, in the new version is loaded lazily, so I guess the javascript that loads the map doesn't get loaded. In case you use Firebug, do you get any javascript error?

  13. rfearns
    Member
    Posted 5 years ago #

    No JavaScript errors. But what I am finding repeatedly is a path issue. For example the url to the wordpress stuff is "http:\\mysite.com\cms\wp-content\..........." and your code is looking for "http:\\mysite.com\wp-content\...........". What file do you define the path in so I may fix it?

    For the record, I did read the docs as well as the change log. No where did I see it noted that any of the placeholder names had changed.

  14. rfearns
    Member
    Posted 5 years ago #

    Still have green boxes where the maps used to be, but I did figure out how to fix the path problem. I changed get_bloginfo('url') to get_bloginfo('wpurl') so that it works if wordpress is not in the root directory.

  15. rfearns
    Member
    Posted 5 years ago #

    Ok, got the maps back. Again it was using get_bloginfo('wpurl'); this time in the dbem_events.php. Still got a bit of tinkering to do; maps are beautiful on the admin panel but on the single event page, the streets and such aren't displaying.

  16. travisvlowe
    Member
    Posted 5 years ago #

    I am getting the wrong times displayed on the single event page. No matter what timezone I enter every start and end time is displayed as 6PM

  17. rfearns
    Member
    Posted 5 years ago #

    Travis - Are you using military time?

  18. travisvlowe
    Member
    Posted 5 years ago #

    No, my default single event format is:

  19. #D #j #M #Y
    #g:#i#a - #@g:#@i#@a
    #_LOCATION
    #_ADDRESS

    #_NOTES

  20. For any particular event the time is always the same:

    6:00PM - 6:00PM

    If I change it to military time (#H) it is still wrong:

    18:00 - 18:00

    The grid list of Events from the Edit menu in the Dashboard displays the time as military time, but the time is correct there.

    Thank you for your response so far.

  • rfearns
    Member
    Posted 5 years ago #

    I meant are you entering the event time in military. I have my settings as #M #j #Y at #h:#i#A ( I don't display the end time) and if the event starts at 7PM I enter in 19:00 for the beginning time of the event. I think the #h and #H is just for how the time is displayed on the output page.

  • travisvlowe
    Member
    Posted 5 years ago #

    I don't see how I can enter the events in military time. The time picker seems to be formatted for short time with AM/PM

  • rfearns
    Member
    Posted 5 years ago #

    Hmmmmm, I don't have a time picker. I got the latest version, but I have had path problems getting this plug in to work. You might try the author's site, http://davidebenini.it/category/wordpress/. I think he is on a 8-10 hour time dif than the USA, so he maybe sleeping right now.

  • travisvlowe
    Member
    Posted 5 years ago #

    Excellent. I will try. Thanks for your help.

  • nutsmuggler
    Member
    Posted 5 years ago #

    Hello folks,
    there must be indeed be a problem with the display of time. I haven't been able to reproduce it in my machine, for it seems related to older PHP/MySQL versions, but my friend and main tester Brian experienced the same problem on one of his servers. Also, it's a strange bug that comes and goes unpredictably. To circumvent it, in 2.0b4 I introduced a set of 4 new pre-made time placeholders, documented here.
    I hope they are useful for those experiencing problems with the PHP format characters.
    Davide (EM Developer)

  • Jon Henwood
    Member
    Posted 5 years ago #

    Hi Folks

    Right I have been following the posts as I am having a problem with the events manager too. I have recently downloaded EV 2.0rc1 (seems to be the only one available at the mo). I am running WP 2.7.1 on a php 5 platform (I have to for mailpress). I am getting the following error:

    WordPress database error: [Unknown column 'event_id' in 'field list']
    SELECT event_id, event_name, DATE_FORMAT(event_start_time, '%e') AS 'event_day', DATE_FORMAT(event_start_time, '%Y') AS 'event_year', DATE_FORMAT(event_start_time, '%k') AS 'event_hh', DATE_FORMAT(event_start_time, '%i') AS 'event_mm', DATE_FORMAT(event_end_time, '%e') AS 'event_end_day', DATE_FORMAT(event_end_time, '%Y') AS 'event_end_year', DATE_FORMAT(event_end_time, '%k') AS 'event_end_hh', DATE_FORMAT(event_end_time, '%i') AS 'event_end_mm', event_start_date, event_end_date, event_start_time, event_end_time, event_notes, event_rsvp, recurrence_id, location_id, event_contactperson_id FROM wp_dbem_events WHERE event_start_date >= '2009-04-25' ORDER BY event_start_date LIMIT 20 OFFSET 0

    WordPress database error: [Unknown column 'event_id' in 'field list']
    SELECT event_id, event_name, DATE_FORMAT(event_start_time, '%e') AS 'event_day', DATE_FORMAT(event_start_time, '%Y') AS 'event_year', DATE_FORMAT(event_start_time, '%k') AS 'event_hh', DATE_FORMAT(event_start_time, '%i') AS 'event_mm', DATE_FORMAT(event_end_time, '%e') AS 'event_end_day', DATE_FORMAT(event_end_time, '%Y') AS 'event_end_year', DATE_FORMAT(event_end_time, '%k') AS 'event_end_hh', DATE_FORMAT(event_end_time, '%i') AS 'event_end_mm', event_start_date, event_end_date, event_start_time, event_end_time, event_notes, event_rsvp, recurrence_id, location_id, event_contactperson_id FROM wp_dbem_events WHERE event_start_date >= '2009-04-25' ORDER BY event_start_date

    Please can someone give me a solution

  • cocobongo
    Member
    Posted 4 years ago #

    I've the same problem. Upgraded today using the automatic update and kaboom, hell frozen. Any solution to this? I'm using WP 2.8.4

  • madhavaji
    Member
    Posted 4 years ago #

    I have the same database problem. I followed this thread, found the stable version and installed that, the same database error comes up on the edit page.

    I'm running 2.9.2 WordPress.

    :(

  • Topic Closed

    This topic has been closed to new replies.

    About this Topic

    Tags