WordPress.org

Forums

My Calendar
[resolved] Manage events and manage event groups (26 posts)

  1. TheQuintus
    Member
    Posted 1 year ago #

    Hello,I am looking for a handy calendar which I can use for a long term.
    Found this one,and tested it on my local brand new wordpress.
    I created 30 events,and noticed no matter how many events I will create,they will all be loaded in ONE PAGE on manage events and manage event groups,so this will not prevent server load in case there are too many events?

    https://wordpress.org/plugins/my-calendar/

  2. TheQuintus
    Member
    Posted 1 year ago #

    Actually,it will.The screen option allows us to set the number of events for one page.Nice

    But when I was trying to search one event I have already created,it gives me the report there are no events in the database meeting your current criteria.
    Is it a bug?

  3. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    Hard to say. The search only searches some fields, and requires an exact match for your search. It searches title, description, short description, location label, and location city. Withou knowing what your search term was and what the event info is, I really can't tell whether that's a bug.

  4. TheQuintus
    Member
    Posted 1 year ago #

    Exact match?I try to search the exact key words now,but still nothing turns out.Are you sure if the search function is working fine on the latest version of WordPress?

  5. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    Yes, I'm sure it works on the latest version of WordPress. But that doesn't mean that I know it works in your particular situation: perhaps there's something about the yet you're searching, or a conflict with another plugin, etc.

    Can you give me details about your search and your event info?

  6. TheQuintus
    Member
    Posted 1 year ago #

    As I said,it's a brand new wordpress without any plugins installed except My calendar.
    I created an event called "good to test it",then I searched "good to test it" but the result turned out like this:

    There are no events in the database meeting your current criteria.

    Then I go to search results for "good to test it" on database by using phpMyAdmin.I see 1 match in wp_my_calendar,but when I clicked "browse",it gives me this report:

    Error in Processing Request
    Error code: 414
    Error text: Request-URI Too Long
    

    anyway,if I select the form of wp_my_calendar,i can see the event_tiele of "good to test it" there as well as event_desc of "bad to ingore it".

  7. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    The second problem is outside of WordPress, so not directly relevant. What happens if you just search "good"?

  8. TheQuintus
    Member
    Posted 1 year ago #

    If I search "good",the result is the same to search "good to test it" on My calendar search engine.I tried to create a lot of events,and search a little bit,but nothing comes up so far.

    I suspect the second problem causes it,and I have no clue about this issue,on PhpMyAdmin I can search and browse any results from datebase normally except from my calendar.
    O.o

  9. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    That's very weird. Do your events show up on the front-end? I've never encountered a situation where My Calendar's tables are throwing an error in PHPMyAdmin; you may need to consult with your host to try and see what's going on. I don't know enough about your environment to even guess.

  10. TheQuintus
    Member
    Posted 1 year ago #

    Yes,the events show up on the front-end.

    I am using XAMPP to quickly set up MySQL,PHP for wordpress on my window 8,so I am just like the host who got root access to the environment.

    I just installed the wordpress on a real linux server environment,this time I am able to search and browse the database from wp_my_calendar on PHPMyAdmin.But still no any search results on My Calendar search engine.

  11. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    Can you submit a support request via the support form on the My Calendar Help screen? I'd appreciate it; it would give me some additional information about your environment.

  12. TheQuintus
    Member
    Posted 1 year ago #

    I think the support request on the My Calendar Help screen doesn't give you the report that I am using a remote datebase for my wordpress,hehe,I just switched to use the local datebase,now I can get search result from the My Calendar search engine.

    So the issue is crystal clear now,because I am using remote datebase for my wordpress,I can't get any search result on My Calendar search engine.
    I turned on the option to get data from a remote database on My Calendar management and added the datebase coonection code to my theme's functions.php,but it seems doesn't work at all.I don't see any sign the My Calendar is connecting to the remote datebase.

  13. TheQuintus
    Member
    Posted 1 year ago #

    Is it possible the reason we can only use My Calendar search engine to search local datebase only?

  14. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    You shouldn't have access to the manage events page at all if you're pulling events from a remote database; if you're doing that, then all event management takes place on the remote install.

    If the remote DB function isn't being picked up, that mode won't turn on. Can you verify that the function is in your functions.php file in your theme and not wrapped in another conditional query?

  15. TheQuintus
    Member
    Posted 1 year ago #

    Geez,I thought I should have manage events pages if I am using the remote datebase connection code on my theme's function.php.Maybe my calendar did connect to the remote datebase since I misunderstood it.

    Anyway,it's no point to use extra remote datebase for getting the My Calendar search engine works since I don't have manage event option for that.

    Why not you try using your wordpress to connect the remote database,and see if you can get search result from My Calendar search engine?

  16. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    Maybe I'm not clear on what you're doing; are you talking about the event search on the manage events page, or are you talking about the event search in the sidebar widget?

  17. TheQuintus
    Member
    Posted 1 year ago #

    I mean my wordpress itself is connecting a remote datebase,that's the reason why I can't get search result from manage events page and event search in the sidebar widget both.
    If I use my wordpress itself to connect a local datebase,there is no such issue.

  18. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    No, that shouldn't make any difference at all. There's nothing different about the search query from any other query in My Calendar. There may be something about your remote DB server that's odd, but if you're using WordPress to connect to a remote DB and not My Calendar's facility for that, it's just not any different.

    Is that your set up? Wp-config set to a remote DB, and My Calendar using the normal DB?

  19. TheQuintus
    Member
    Posted 1 year ago #

    Yes,Wp-config set to RDS,so My Calendar is using the same RDS without setting it on plugin.

    It is odd too that I am able to search my posts from my wordpress since you believe my RDS is too odd to get the normal search query for My Calendar.

  20. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    I don't "believe [your] RDS is too odd" - I'm simply positing some kind of oddity in that database server as the cause of this issue. I really don't have any information to go on, so all I can do is make guesses.

    I can't reproduce the issue.

  21. TheQuintus
    Member
    Posted 1 year ago #

    Odd thing must got a particular reason.
    When I search 'test it' on My Calendar,this SQL log generated on RDS

    SELECT SQL_CALC_FOUND_ROWS * FROM wp_my_calendar WHERE event_flagged = 0 AND MATCH(event_title,event_desc,event_short,event_label,event_city) AGAINST ('test it' IN BOOLEAN MODE) AND event_status = 1 ORDER BY event_begin DESC LIMIT 0, 50
    

    What is event_flagged for?
    BTW,when I created events,wp_posts got all wp_my_calendar's things,is this redundency necessary?

  22. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    Event flagged indicates whether an event has been flagged as spam by Akismet or Botsmasher. Mostly applies to untrusted event authors, such as when using the My Calendar: Submissions add-on.

    And yes, it is necessary to post to both wp_posts and to the my calendar table. Eventually, the My Calendar table will be made obsolete, but it's still necessary for now.

  23. TheQuintus
    Member
    Posted 1 year ago #

    Finally,I figured it out.
    The wp_my_calendar on my RDS was using InnoDB storage engine which doesn't support the My Calendar search query 'MATCH'

    SELECT SQL_CALC_FOUND_ROWS * FROM wp_my_calendar WHERE event_flagged = 0 AND MATCH(event_title,event_desc,event_short,event_label,event_city) AGAINST ('audience' IN BOOLEAN MODE) AND event_status = 1 ORDER BY event_ID DESC LIMIT 0, 20
    

    I changed its storage engine to MyISAM

    alter table wp_my_calendar engine=MyISAM

    Now I am able to get search result from My Calendar,but only in English,Multi-byte like Korean,Japanese,Chinese doesn't work.
    I checked how wordpress itself get search result.Wordpress uses LIKE search query which is perfectly working on InnoDB or MyISAM storage engine

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%audience%') OR (wp_posts.post_content LIKE '%audience%'))) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private') ORDER BY wp_posts.post_title LIKE '%audience%' DESC, wp_posts.post_date DESC LIMIT 0, 20
    

    I would suggest you change My Calendar to 'LIKE' search query istead of 'MATCH'

  24. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    I'll consider it, but in fact my goal is to make the My Calendar search obsolete, and replace it with the native search, along with making the my calendar events table obsolete. But it all depends on how long that takes me.

  25. TheQuintus
    Member
    Posted 1 year ago #

    If I understand you correctly,I think you mean you want to keep My Calendar not seperated from wp_posts.Why?Is that bad to have wp_my_calendar?

  26. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    Because it makes a lot of aspects of plug-in management vastly easier to use the WordPress native methods for managing data instead of using all custom methods. It means I can significantly reduce the amount of code I need to manage, write, and support, while taking advantage of all the features that are built into WordPress. As it is, there are many features built into WordPress that I would have to re-create in order to use.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • My Calendar
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.