steve
2007-09-06T21:52:00Z
I am trying to create the mysql table from the example mySQL folder using:
mysql -u root -p exchange_cal < "Example MySQL Outlook 2000.sql"

I get this error:
ERROR 1064 (42000) at line 1: 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 ' #9632;C 3' at line 1

I am running mysql server5 and mysql-connector-odbc-3.51.19-win32

Any ideas would be appreciated.
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2007-09-07T09:30:00Z
it probably the drop statement?
Try to open the script and run only the creation statement:
CREATE TABLE contacts(
OCS_ID int(11) NOT NULL DEFAULT '0' auto_increment,
OCS_SENSITIVITY int NULL ,
OCS_IMPORTANCE char(1) NULL ,
OCS_BILLINGINFORMATION varchar(32) NULL ,
OCS_MILEAGE decimal(16, 3) NULL ,
OCS_NOAGING char(1) NULL ,
OCS_INITIALS varchar(32) NULL ,
OCS_FIRSTNAME varchar(128) NULL ,
OCS_MIDDLENAME varchar(128) NULL ,
OCS_LASTNAME varchar(128) NULL ,
OCS_SUFFIX varchar(32) NULL ,
OCS_FULLNAME varchar(255) NULL ,
OCS_FILEAS varchar(255) NULL ,
OCS_JOBTITLE varchar(64) NULL ,
OCS_COMPANYNAME varchar(64) NULL ,
OCS_DEPARTMENT varchar(64) NULL ,
OCS_GENDER char(1) NULL ,
OCS_SELECTEDMAILINGADDRESS char(1) NULL ,
OCS_ACCOUNT varchar(32) NULL ,
OCS_ANNIVERSARY varchar(32) NULL ,
OCS_BIRTHDAY datetime NULL ,
OCS_ASSISTANTNAME varchar(255) NULL ,
OCS_CHILDREN varchar(128) NULL ,
OCS_COMPUTERNETWORKNAME varchar(20) NULL ,
OCS_FTPSITE varchar(255) NULL ,
OCS_CUSTOMERID varchar(32) NULL ,
OCS_GOVERNMENTID varchar(32) NULL ,
OCS_ORGANIZATIONID varchar(32) NULL ,
OCS_HOBBY varchar(64) NULL ,
OCS_INETFREEBUSSY varchar(255) NULL ,
OCS_JOURNAL char(1) NULL ,
OCS_LANGUAGE varchar(32) NULL ,
OCS_MANAGERNAME varchar(255) NULL ,
OCS_NETMEETINGALIAS varchar(128) NULL ,
OCS_NETMEETINGSERVER varchar(255) NULL ,
OCS_NICKNAME varchar(128) NULL ,
OCS_OFFICELOCATION varchar(64) NULL ,
OCS_PERSONALHOMEPAGE varchar(255) NULL ,
OCS_PROFESSION varchar(64) NULL ,
OCS_REFERREDBY varchar(255) NULL ,
OCS_SPOUCE varchar(255) NULL ,
OCS_WEBPAGE varchar(255) NULL ,
OCS_CATEGORY varchar(64) NULL ,
OCS_BUSINESS_CITY varchar(64) NULL ,
OCS_BUSINESS_COUNTRY varchar(32) NULL ,
OCS_BUSINESS_POSTALCODE varchar(16) NULL ,
OCS_BUSINESS_POSTOFFICEBOX varchar(16) NULL ,
OCS_BUSINESS_STATE varchar(32) NULL ,
OCS_BUSINESS_STREET varchar(64) NULL ,
OCS_BUSINESS_FAX varchar(32) NULL ,
OCS_BUSINESS_HOMEPAGE varchar(255) NULL ,
OCS_BUSINESS_TELEPHONE varchar(32) NULL ,
OCS_BUSINESS_TELEPHONE2 varchar(32) NULL ,
OCS_EMAIL1ADDRESS varchar(128) NULL ,
OCS_EMAIL1ADDRESS_TYPE varchar(64) NULL ,
OCS_EMAIL2ADDRESS varchar(128) NULL ,
OCS_EMAIL2ADDRESS_TYPE varchar(64) NULL ,
OCS_EMAIL3ADDRESS varchar(128) NULL ,
OCS_EMAIL3ADDRESS_TYPE varchar(64) NULL ,
OCS_HOME_CITY varchar(64) NULL ,
OCS_HOME_COUNTRY varchar(32) NULL ,
OCS_HOME_POSTALCODE varchar(16) NULL ,
OCS_HOME_POSTOFFICEBOX varchar(16) NULL ,
OCS_HOME_STATE varchar(32) NULL ,
OCS_HOME_STREET varchar(64) NULL ,
OCS_HOME_FAX varchar(32) NULL ,
OCS_HOME_TELEPHONE varchar(32) NULL ,
OCS_HOME_TELEPHONE2 varchar(32) NULL ,
OCS_OTHER_CITY varchar(64) NULL ,
OCS_OTHER_COUNTRY varchar(32) NULL ,
OCS_OTHER_POSTALCODE varchar(16) NULL ,
OCS_OTHER_POSTOFFICEBOX varchar(16) NULL ,
OCS_OTHER_STATE varchar(32) NULL ,
OCS_OTHER_STREET varchar(64) NULL ,
OCS_OTHER_FAX varchar(32) NULL ,
OCS_OTHER_TELEPHONE varchar(32) NULL ,
OCS_ASSISTANTTELEPHONE varchar(32) NULL ,
OCS_BODY text NULL ,
OCS_CALLBACKTELEPHONE varchar(32) NULL ,
OCS_CARTELEPHONE varchar(32) NULL ,
OCS_COMPANYMAINTELEPHONE varchar(32) NULL ,
OCS_ISDNNUMBER varchar(32) NULL ,
OCS_MOBILEPHONE varchar(32) NULL ,
OCS_USERCERTIFICATE varchar(128) NULL ,
OCS_UNREAD char(1) NULL ,
OCS_TITLE varchar(50) NULL ,
OCS_USER1 varchar(50) NULL ,
OCS_USER2 varchar(50) NULL ,
OCS_USER3 varchar(50) NULL ,
OCS_USER4 varchar(50) NULL ,
OCS_TTYTDD varchar(50) NULL ,
OCS_RADIOTELEPHONE varchar(50) NULL ,
OCS_TELEX varchar(50) NULL ,
OCS_PAGER varchar(50) NULL ,
OCS_PRIMARYTELEPHONE varchar(50) NULL ,
PRIMARY KEY(OCS_ID)
);

steve
2007-09-07T15:52:00Z
No that dosnt help.
However I renamed the file from Example MySQL Outlook 2000.sql to something shorter like "test" and got an error about invalid default value. After i removed the Default '0' and it worked.

mysql -u root -p exchange_cal < "test"
Administrator
2007-09-07T16:01:00Z
The script has been created for mySQL 4. IS it possible your version does not support the syntax?