New Course Addition Error Message

[foxgolfer]

I previously posted that I was having difficulty adding a new course, something I had done many times. Following is the message I receive after entering the course basic information:



ADD FACILITY


INSERT INTO tblCourse (fid, version, CourseName, NewCourseName, NumberOfHoles, dtmCreated, dtmUpdated, UpdatedBy, CreatedBy, clat, clon, Par) VALUES (, 1, 'Sanctuary Golf Course', 'Sanctuary Golf Course', 18, now(), now(), '68.253.210.203', '68.253.210.203', 41.523584, -87.950449, 72)

Bad query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'Sanctuary Golf Course', 'Sanctuary Golf Course', 18, now(), now(), '68.253.' at line 1

Please go Back and try again.

Any ideas what's happening?

Thanks,
Tom

[ashworth]

Originally Posted by foxgolfer

I previously posted that I was having difficulty adding a new course, something I had done many times. Following is the message I receive after entering the course basic information:



ADD FACILITY


INSERT INTO tblCourse (fid, version, CourseName, NewCourseName, NumberOfHoles, dtmCreated, dtmUpdated, UpdatedBy, CreatedBy, clat, clon, Par) VALUES (, 1, 'Sanctuary Golf Course', 'Sanctuary Golf Course', 18, now(), now(), '68.253.210.203', '68.253.210.203', 41.523584, -87.950449, 72)

Bad query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'Sanctuary Golf Course', 'Sanctuary Golf Course', 18, now(), now(), '68.253.' at line 1

Please go Back and try again.

Any ideas what's happening?

Thanks,
Tom

Thanks for reporting this Tom.

I had a small bug on my web site. It has now been fixed. Like I said I have been doing a lot of work and someone this small bug caused a big issue!

Thanks again Tom! (Justin gives Tom a Gold star )