I get the above error message when i try to Store All contents from my calendar to MySQL db.

However when i insert the same item using "Store Item" it works fine.

How do i go around this error message when i want to store all items.

http://img393.imageshack...hp?image=genious3uk9.jpg 

Can you store the error item (Lonndon...) using "Store Item"? Or was it a different item?

Yes I can
Take a look
http://img517.imageshack...hp?image=genious4ce9.jpg 

What do you think is the issue here?

This is strange, the low-level save function is the same for Save Item/All.

Is the error item saved to DB? (I'm trying to determinate if the exception occurs during or after insert to DB)

What is your GeniusConnect, Outlook, MS Exchange version?

What is you SQL statement for primary key generation (AssignTable->Mandatory key)

my PM is select max(gc_id) + 1 from webcast_calendar
This seems to work when i click on "Test Query"

I am using GeniusConnect sp3 latest and outlook 2003

The breakdown is that every time i hit "Store All" it gives me the Error message and stores the same item in the Database over and over.

Yes I can store the same item using "Store Item" without error.

The very first time i Hit "Store All" this is what i get:
http://img73.imageshack....my.php?image=gen5ej8.jpg 

Please Help

This is the table i am using:
DROP TABLE IF EXISTS webcast_calendar;
CREATE TABLE webcast_calendar (
gc_AllDayEvent char(1) NULL ,
gc_BillingInformation varchar(256) NULL ,
gc_Body text NULL ,
gc_BusyStatus int NULL ,
gc_Categories varchar (256) NULL ,
gc_Companies varchar (256) NULL ,
gc_Duration int NULL ,
gc_End datetime NULL ,
gc_Importance int NULL ,
gc_InternetCodepage int NULL ,
gc_IsOnlineMeeting char (1) NULL ,
gc_Location varchar (256) NULL ,
gc_MeetingStatus int NULL ,
gc_MessageClassFormDescription varchar (256) NULL ,
gc_Mileage varchar (256) NULL ,
gc_NetmeetingServer varchar (256) NULL ,
gc_NetMeetingAutoStart char (1) NULL ,
gc_NetMeetingDocPathName varchar (256) NULL ,
gc_NetMeetingOrganizerAlias varchar (256) NULL ,
gc_NetMeetingType int NULL ,
gc_NetShowURL varchar (256) NULL ,
gc_NoAging char (1) NULL ,
gc_OptionalAttendees varchar (256) NULL ,
gc_Organizer varchar (256) NULL ,
gc_ReminderMinutesBeforeStart int NULL ,
gc_ReminderOverrideDefault char (1) NULL ,
gc_ReminderPlaySound char (1) NULL ,
gc_ReminderSet char (1) NULL ,
gc_ReminderSoundFile varchar (256) NULL ,
gc_ReplyTime datetime NULL ,

gc_Resources varchar (256) NULL ,
gc_ResponseRequested char (1) NULL ,
gc_Sensitivity int NULL ,
gc_Start datetime NULL ,
gc_Subject varchar (256) NULL ,
gc_Unread char (1) NULL ,
gc_id int(11) NOT NULL AUTO_INCREMENT,
gc_RecurrencePattern varchar (100) NULL ,
gc_LastModificationTime datetime NULL,
PRIMARY KEY (gc_id)
);

Hi,

The warning about empty primary key value means your query returns NULL value.
Please change the:
select max(gc_id) + 1 from webcast_calendar
to
select IFNULL(max(gc_id)+1, 1) from webcast_calendar

What is the version of your mySQL ODBC driver?

Thank you for your quick response.

I am using MySQL ODBC 3.51 Driver

The new PK works now, but the error is still happening as before.

Here is a new look, I pressed "Store All" 3 times, each time it is inserted to the database with the error showing in Genius as access denied.

http://img511.imageshack...my.php?image=gen6fu6.jpg 

Why would it complain about that event on December 12?

Is this always the same error item?

Do you have enough permission on your public folder?
It look like GeniusConnect is not able to Add custom-fields to that Outlook item.