Streetlite
2005-02-24T16:18:00Z
After installing GeniusConnect (OutlookConnect 1.0.2.7, DBContact 1.0.1.9) and setting up tables, when I try to upload an Outlook 2003 address book, I get the following errors:

37000 [mySQL][ODBC 3.51 Driver][mysqld-3.23.58-log] You have an error in your SQL syntax near "NULL" at line 1 (1064)

An error occurred during setting values

What do I need to do?
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2005-02-24T16:37:00Z
mySQL is not supporting ANSI quoted identifiers.
Please install latest version 1.0.2.8
and see:
http://support.geniusconnect.com/Posts/t98- 
Streetlite
2005-02-24T16:47:00Z
I just installed 1.0.2.8, I have the latest mySQL ODBC driver 3.51 and I tried unchecking the "use ANSI quoted identifiers" - still get same errors.
What now?
Administrator
2005-02-24T16:51:00Z
Do you have column named "NULL"? this is reserved keyword.

When do you get the error, loading or storing?
Streetlite
2005-02-24T17:17:00Z
No column named "NULL" - get errors trying to upload to mySQL table.
The .ini and the SQL structure are here:

ftp://www.streetlite.org/GeniusConnect/ 


Administrator
2005-02-24T20:54:00Z
the sql statement for the primary key is the problem:
id=NOT NULL DEFAULT '0' auto_increment
you have to define something like:
select (max(id)+1) from <my table...> and remove the auto_increment from your table
Streetlite
2005-02-24T22:47:00Z
OK - did all that and uploaded the changed .ini and sql structure files to:

ftp://www.streetlite.org/GeniusConnect/ 

Let me know what to do next - it still doesn't work
Administrator
2005-02-25T12:33:00Z
çhange
select max(id)+1 from 'econtactpro'
to
select max(id)+1 from econtactpro

NULL is not a SQL statement:
category=NULL
first=NULL
middle=NULL
last=NULL
title=NULL
company=NULL
birthday=NULL
home=NULL
office=NULL
mobile=NULL
fax=NULL
pager=NULL
other=NULL
email=NULL
homepage=NULL
icq=NULL
msn=NULL
aol=NULL
yahoo=NULL
aim=NULL
ip=NULL
street=NULL
city=NULL
state=NULL
zip=NULL
country=NULL
type=NULL
note=NULL

link these fields to Outlook,
or enter some sql statement if field is mandatory in the database, if not remove the fields from
mandatory column list.

example statement for mandatory key:
select 'Some Default Value'




Administrator
2005-02-25T12:35:00Z
please install our mySQL example this will help you understand
Streetlite
2005-02-25T17:11:00Z
OK - thanks for your attention to getting me up and going on your software. There is still something that I am missing because your example files don't work either.

I a now working exclusively with the example files you have provided with the program and an Outlook 2003 Contacts folder called Test that has one record in it.

I have created a table from your mySQL-Outlook.sql then exported the structure of the resulting table to contact.sql (changed table name to contact rather than contacts).

Then I linked your program to it by importing your mySQL-Outlook.ini (changed SQL statement on primary to reflect changed table name) and exported the results to contact.ini.

Then I tried to upload and got "Error in your SQL syntax near "'contact""

I then exported the one Outlook contact I was trying to upload to test.csv.

ftp://www.streetlite.org/GeniusConnect/ 

Can you get this to work on your end?
Administrator
2005-02-25T17:23:00Z
Error in your SQL syntax near "'contact"":

mySQL is not supporting ANSI quoted identifiers.
please see:
http://support.geniusconnect.com/Posts/t97- 
Streetlite
2005-02-25T17:49:00Z
Yeah - thank you - the demo with one record works. I now have something to work with.
I'm sure I'll have more questions as I progress. Thanks very much for your rapid responses so far!
Similar Topics