I recieved many errors during installation. After looking further the MySQL doesnt appear to like anything
with "CLOB" => EXTRA_SCHEDULES CLOB. I changed each to LONGTEXT which allowed me add the tables. Any suggestion?
mysql> create database art;
mysql> grant all on art.* to artuser@localhost identified by "artpassword";
mysql> use art;
mysql> ."D:\Software\ArtApp\art-5.9\art-5.9\database\database\art_tables.sql"
mysql> . "PACKAGE_PATH\database\quartz\tables_mysql.sql"
mysql> quit;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
If you look at the art-tables.sql file you will see at the top some notes. You should make some replacements before running the file e.g. clob to longtext, timestamp to datetime.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I recieved many errors during installation. After looking further the MySQL doesnt appear to like anything
with "CLOB" => EXTRA_SCHEDULES CLOB. I changed each to LONGTEXT which allowed me add the tables. Any suggestion?
mysql> create database art;
mysql> grant all on art.* to artuser@localhost identified by "artpassword";
mysql> use art;
mysql> ."D:\Software\ArtApp\art-5.9\art-5.9\database\database\art_tables.sql"
mysql> . "PACKAGE_PATH\database\quartz\tables_mysql.sql"
mysql> quit;
Hello,
If you look at the art-tables.sql file you will see at the top some notes. You should make some replacements before running the file e.g. clob to longtext, timestamp to datetime.