掲示板

Error setting up vmrcre database in mysql

thumbnail
4年前 に Ken M. Penner によって更新されました。

Error setting up vmrcre database in mysql

Padawan 投稿: 31 参加年月日: 18/06/22 最新の投稿
In step 10 of VMR CRE - Bundle Installation for Production, the command

[b]$ mysql -u vmrcre -pvmrcre123 vmrcre < ~/vmrcre-linux/community/webapp/sql/vmrcre-mysql.sql[/b]
produces the error 
ERROR 1064 (42000) at line 117: 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 '// TODO
  `SHELFID` int(11) NOT DEFAULT NULL,
  `TRANSCRIPTIONSTART` int(11) NOT' at line 8
Removing the // line and NOT in the next couple lines eliminates this error but produces:
ERROR 1146 (42S02) at line 354: Table 'vmrcre.SEGMENTREADINGWITNESS' doesn't exist
Removing the line 
alter table SEGMENTREADINGWITNESS add VERSEINSTANCE varchar(20) DEFAULT '' after DOCUMENTID;
eliminates this error message.
thumbnail
4年前 に Troy A. Griffitts によって更新されました。

RE: Error setting up vmrcre database in mysql

Youngling 投稿: 13 参加年月日: 16/08/12 最新の投稿
Yes, thank you Ken!  This line was left over from a copy from update.sql when I was updating the SEGMENTREADINGWITNESS table to add VERSEINSTANCE.  I copied the line for reference and didn't remove it when I was done.  Thank you for reporting it.  I have committed an update to the file.
thumbnail
3年前 に Ken M. Penner によって更新されました。

RE: Error setting up vmrcre database in mysql

Padawan 投稿: 31 参加年月日: 18/06/22 最新の投稿
All the NOT DEFAULTs still need to be changed to DEFAULT