SQL file included with software does not create tables

Last post 04-05-2010, 7:41 AM by Eric. 1 replies.
Sort Posts: Previous Next
  •  04-04-2010, 6:20 PM 59859

    SQL file included with software does not create tables

    I tried to import to mysql on two totally different servers changing compatibility modes. both unable to create tables using the cutesoftchat.sql  file.
    MySQL ERROR GENERATED:
    #1064 - 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 'i' at line 1

    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CuteChat4_SupportAgent_CuteChat4_SupportDepartment]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

    ALTER TABLE [dbo].[CuteChat4_SupportAgent] DROP CONSTRAINT FK_CuteChat4_SupportAgent_CuteChat4_SupportDepartment

    GO



    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CuteChat4_InstantMessage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

    drop table [dbo].[CuteChat4_InstantMessage]

    GO



    if exists (se[...]
  •  04-05-2010, 7:41 AM 59868 in reply to 59859

    Re: SQL file included with software does not create tables

    Dear lfloyd1,
     
    Cute LiveSupport supports SQL Server 2000, SQL Server 2005, Oracle, MSDE or Access. MySQL is not supported.
     
    Regards,
    Eric
View as RSS news feed in XML