Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

why doesn't this sql script work in mysql?

Options
  • 14-12-2004 12:05am
    #1
    pwd
    Closed Accounts Posts: 5,284 ✭✭✭


    This is a script to be run while setting up openwiki:

    CREATE TABLE [openwiki_attachments] (
    [att_wrv_name] [nvarchar] (128) NOT NULL ,
    [att_wrv_revision] [int] NOT NULL ,
    [att_name] [nvarchar] (255) NOT NULL ,
    [att_revision] [int] NOT NULL ,
    [att_hidden] [int] NOT NULL ,
    [att_deprecated] [int] NOT NULL ,
    [att_filename] [nvarchar] (255) NOT NULL ,
    [att_timestamp] [datetime] NOT NULL ,
    [att_filesize] [int] NOT NULL ,
    [att_host] [nvarchar] (128) NULL ,
    [att_agent] [nvarchar] (255) NULL ,
    [att_by] [nvarchar] (128) NULL ,
    [att_byalias] [nvarchar] (128) NULL ,
    [att_comment] [text] NULL

    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    It generates syntax errors when I run it on mysql. I've run it with and without a semicolon on the end.

    anyone know why?


Comments

  • Options
    #2
    leeroybrown
    Closed Accounts Posts: 7,563 ✭✭✭leeroybrown


    It looks more like an SQL Server script. Check if there is a specific MySQL create script with openwiki.


  • Options
    #3
    pwd
    Closed Accounts Posts: 5,284 ✭✭✭pwd


    That's it alright!
    They don't have a mysql script, but they do give directions on how to convert the access one into mysql.

    Thanks!


  • Options
    #4
    pwd
    Closed Accounts Posts: 5,284 ✭✭✭pwd


    CREATE TABLE openwiki_attachments (
    att_wrv_name VARCHAR(128) NOT NULL,
    att_wrv_revision INT NOT NULL,
    att_name VARCHAR(255) NOT NULL,
    att_revision INT NOT NULL,
    att_hidden INT NOT NULL,
    att_deprecated INT NOT NULL,
    att_filename VARCHAR(255) NOT NULL,
    att_timestamp DATETIME NOT NULL,
    att_filesize INT NOT NULL,
    att_host VARCHAR(128),
    att_agent VARCHAR(255),
    att_by VARCHAR(128),
    att_byalias VARCHAR(128),
    att_comment TEXT
    )
    ;

    that's the myqsl version. they actually have that in the download, even though they don't mention it in the online docs. accessdump.com converts the mdb perfectly anyway!


Advertisement