Could not run Mysql DB script for opencrx

2013-10-15
2013-10-30
  • vamseekrishna
    vamseekrishna
    2013-10-15

    I want to connect Mysql to my opencrx 2.9 application,so i have followed entire documentation of below link and i'm stuck at creating tables by running the script in dbcreate-tables.sql file as i'm getting errors even though i'hv set to InnoDB as given in document.Could somebody assist me how to rectify and go further.

    ERROR MESSAGE:
    Script line: 45 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 'SEQUENCE OOCKE1_activity_number_SEQ START WITH 1000000 INCREMENT BY 1' at line 1

    http://www.opencrx.org/opencrx/2.5/MySQL-5/openCRX_Installation_MySQL-5.pdf