I found the duplicate and deleted it.

I just filled out the form to add another event, but got this error:

Database error: /apps/events/add.php MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1 insert into cov_main (user,event_name,event_desc,event_date,event_enddate,contact_link,contact_name,contact_email,contact_phone,latlon,location) values ('plantmanager','Plumeria Society of America Show & Sale 2','\r\nJuly 23, 2016 @ 9:30 am – 3:00 pm The Plumeria Society of America Plant Show & Sale! Held in Richmond/Rosenburg area @ the Fort Bend County Fairgrounds Date: July 23th Time: 9:30am – 3pm','2016-07-23 21:00:00','2016-06-23 15:00:00','http://www.theplumeriasociety.org/plumeria-events/','','','','29.5446507,-95.7542162','Fortbend County Fairgrounds, 4310 Texas 36, Rosenberg, TX 77471 United States'))
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1)
Session halted.

I keep getting it too.

Ugh, so sorry. Please try again.

Same thing happened to me.

I just tried again, Dave, and got the same error message.

I'm sorry there's a problem, but glad to know it wasn't just Ms. Bumble here!
Here's the error message I just got:
Add an Event
Database error: /apps/events/add.php MySQL error 1416: Cannot get geometry object from data you send to the GEOMETRY field insert into cov_main (user,event_name,event_desc,event_date,event_enddate,contact_link,contact_name,contact_email,contact_phone,latlon,location) values ('MunchkinsMom','Harvest Day 2016','Sacramento’s biggest one-day educational gardening event featuring speakers, demonstrations, garden tours, educational booths, vendors and much more.','2016-08-06 08:00:00','2016-08-06 14:00:00','http://sacmg.ucanr.edu/Fair_Oaks_Horticulture_Center/Workshop_Schedule/','','','','38.6606793,-121.2656767','\r\nFair Oaks Horticulture Center\r\n11549 Fair Oaks Boulevard\r\nFair Oaks, CA 95628')
MySQL Error: 1416 (Cannot get geometry object from data you send to the GEOMETRY field)
Session halted.

Or is it just me....???

Well, at least it looks like we're getting some bugs worked out! Thanks everyone for participating! I really like the calendar of events feature.

MunchkinsMom said:
Database error: /apps/events/add.php MySQL error 1416: Cannot get geometry object from data you send to the GEOMETRY field insert into cov_main ...

Y'know, I really can't blame the database. Geometry really wasn't my strong suit, either...

I got the same message several times again last night also. I'll wait and try again tonight.

Ok I am pretty sure it's working properly now.

@dave , I just added an event but the locations section was truncated. Can you fix my event so that it has the following information in the locations section?


It should read:


Will be held at all four locations, choose the one closest to you:

1835 Rochester Road South,
Rochester Hills, MI 48307
Phone: (248) 651-9000

8600 Dixie Hwy,
Clarkston, MI 48348
Phone: (248) 625-9100

9100 Torrey Rd,
Grand Blanc, MI 48439
Phone: (810) 953-1111

6347 Grand River Ave,
Brighton, MI 48114
Phone: (517) 552-9300


(Bold italic formatting isn't necessary, I just did that so you would know where the information begins/ends.)

Here is the link to the event listing I created: http://garden.org/apps/events/...

Also, in the future, could you consider adding a zip code and proximity search to events? Now that Melanie ( @mellielong ) has given us an excellent motivation for adding events, I have a feeling it's going to see some significant growth in the near future.

You should be able to edit your event. And yes, you can search by zipcode. Just go to the events front page; it's at the top.

Oh, and if there are multiple locations, put them in the full description.

@dave , thank you!

I just tried to update the event and got the error message that others have been getting:

Database error: /apps/events/edit/293/ MySQL error 1416: Cannot get geometry object from data you send to the GEOMETRY field update cov_main set event_name = 'Bordine Nursery\'s Rose Care Seminar', event_desc = 'Rose Care\r\n\r\nThrow all misconceptions about Roses being difficult to grow right out the window! By choosing the right variety and with a little extra knowledge on how to care for Roses anyone can be successful growing them. Let our knowledgeable Purple People teach you how to care for and maintain your Roses so you can enjoy the amazing rewards of their breathtaking flowers all summer long!\r\n\r\nThis is a walking tour. Please come prepared for the weather. Seminar will take place rain or shine.\r\n\r\nDate\r\nJuly 9th, 2016 • 10am\r\n\r\nLocation\r\nRochester Hills, Clarkston, Grand Blanc, Brighton\r\n\r\nCost\r\nFREE\r\n\r\n1835 Rochester Road South, \r\nRochester Hills, MI 48307\r\nPhone: (248) 651-9000\r\n\r\n8600 Dixie Hwy, \r\nClarkston, MI 48348\r\nPhone: (248) 625-9100\r\n\r\n9100 Torrey Rd, \r\nGrand Blanc, MI 48439\r\nPhone: (810) 953-1111\r\n\r\n6347 Grand River Ave, \r\nBrighton, MI 48114\r\nPhone: (517) 552-9300', event_date = '2016-07-09 10:00:00', event_enddate = '2016-06-18 09:00:00', contact_link = 'http://bordines.com/events/all-events/', contact_name = '(Call the individual location that you plan to attend--see location information for more.)', contact_email = '(none provided)', contact_phone = '(Please see Location information for phone number of the location closest to you.)', latlon = ',', location = 'Will be held at all four locations, choose the one closest to you. (See Full Description.) 1835 Rochester Road South, Rochester Hills, MI 48307 Phone: (248) 651-9000 8600 Dixie Hwy, Clarkston, MI 48348 Phone: (248) 625-9100 9100 Torrey Rd, Grand Blanc, MI 4843', geo = GeomFromText( ' POINT( )') where covid = '293'
MySQL Error: 1416 (Cannot get geometry object from data you send to the GEOMETRY field)
Session halted.


I'll try again, but I just wanted to let you know.

dave said:You should be able to edit your event. And yes, you can search by zipcode. Just go to the events front page; it's at the top.

When I searched by zipcode, it gave me all of the results; for example, the second event it listed was in Texas....which is about as far away from me as US events can get. I realized maybe I didn't word my request as accurately as I could have, though. My request is for a 'zip code and proximity' search where you can look for everything within a set radius (options could be 10, 25, 50, 100 mile, or something like that). Perhaps it could be in the form of a textbox for zip codes which allows for comma separation (in the event there is an event with multiple locations). I realize this is probably a lesser-used part of the database and may not warrant much attention right now, but could you consider flagging it 'for future improvements'?

DogsNDaylilies said:I just tried to update the event and got the error message that others have been getting:

Ok, please try again now.

DogsNDaylilies said:My request is for a 'zip code and proximity' search where you can look for everything within a set radius (options could be 10, 25, 50, 100 mile, or something like that).

I'll see about that for the future. For now you can get the same effect by simply ignoring anything that comes up outside that range. Once the events in the list are further away you can simply close the window.

It's now possible to add new events. Thanks, @Dave.

I just noticed that 2 of us have put in the same event....the Plumeria Society of America show. Is there a way to delete one of them or should we just let it go?