Thanks Mr Takejoe. This is probably because of my encodings limitation for varchar index but MySQL.
I had similar exceptions when I made varchar(255) column and giving index with this encoding. 2018년 9월 20일 (목) 오후 12:40, Naoki Takezoe <[email protected]>님이 작성: > Ah, MySQL can't create index for large colums (> 768 bytes). I'll take a > look which column is that to find workaround and to know how we can fix > this problem in the future version of PredictionIO. > > 2018年9月20日(木) 11:45 박명신 <[email protected]>: > >> Hi there! >> >> I'm using PredictionIO with MySQL as a storage. >> >> and my MySQL encoding set is utf-8mb4 so its keep returning >> SQLSyntaxErrorException when I making an app. (especially when pio making >> index for the table) >> >> >> after I got exception, >> >> my DB and table is created also when I repeat 'pio app new ' order, pio >> returns that app is already exists. >> >> and able to delete that app. >> >> if I can't change my DB encoding, how should I deal with this? >> >>
