RE: Error setting up vmrcre database in mysql - Forum
Keskusteluryhmät
RE: Error setting up vmrcre database in mysql
Ken M. Penner, muokattu 5 Vuodet sitten.
Error setting up vmrcre database in mysql
Padawan Viestejä: 31 Liittymispäivä: 22.6.2018 Viimeisimmät viestit
00
In step 10 of VMR CRE - Bundle Installation for Production, the command
produces the error
Removing the // line and NOT in the next couple lines eliminates this error but produces:
Removing the line
eliminates this error message.
[b]$ mysql -u vmrcre -pvmrcre123 vmrcre < ~/vmrcre-linux/community/webapp/sql/vmrcre-mysql.sql[/b] |
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 |
ERROR 1146 (42S02) at line 354: Table 'vmrcre.SEGMENTREADINGWITNESS' doesn't exist |
alter table SEGMENTREADINGWITNESS add VERSEINSTANCE varchar(20) DEFAULT '' after DOCUMENTID; |
Troy A. Griffitts, muokattu 5 Vuodet sitten.
RE: Error setting up vmrcre database in mysql
Youngling Viestejä: 13 Liittymispäivä: 12.8.2016 Viimeisimmät viestit
00
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.
Ken M. Penner, muokattu 4 Vuodet sitten.
RE: Error setting up vmrcre database in mysql
Padawan Viestejä: 31 Liittymispäivä: 22.6.2018 Viimeisimmät viestit
00
All the NOT DEFAULTs still need to be changed to DEFAULT