steve
2007-09-12T04:39:00Z
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 
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2007-09-12T11:44:00Z
Can you store the error item (Lonndon...) using "Store Item"? Or was it a different item?

steve
2007-09-12T15:32:00Z
Yes I can
Take a look
http://img517.imageshack...hp?image=genious4ce9.jpg 

What do you think is the issue here?
Administrator
2007-09-12T15:45:00Z
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?
Administrator
2007-09-12T15:50:00Z
What is you SQL statement for primary key generation (AssignTable->Mandatory key)
steve
2007-09-12T19:06:00Z
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
steve
2007-09-12T19:07:00Z
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)
);
Administrator
2007-09-12T21:05:00Z
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?
steve
2007-09-12T22:09:00Z
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?
Administrator
2007-09-12T22:14:00Z
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.
Similar Topics