Hello,
I've used the ser_mysql.sh script to upgrade my database but when issuing
ser_mysql.sh copy sernew
I get
MySql password for myadminuser: creating database sernew ... ERROR 1054 at line 111: Unknown column 'perms' in 'field list'
and the new database has the tables but they are mostly empty.
This is the output of the script with -x added: + DBNAME=ser + DBHOST=mydbserver + USERNAME=ser + DEFAULT_PW=mypass + ROUSER=serro + RO_PW=mypass2 + SQL_USER=myadminuser + CMD=mysql -h mydbserver -umyadminuser + DUMP_CMD=mysqldump -h mydbserver -umyadminuser -c -t + BACKUP_CMD=mysqldump -h mydbserver -umyadminuser -c + TABLE_TYPE=TYPE=MyISAM + USERCOL=username + GENHA1=gen_ha1 + FOREVER=2020-05-28 21:32:15 + DEFAULT_ALIASES_EXPIRES=2020-05-28 21:32:15 + DEFAULT_Q=1.0 + DEFAULT_CALLID=Default-Call-ID + DEFAULT_CSEQ=42 + DEFAULT_LOCATION_EXPIRES=2020-05-28 21:32:15 + export PW + '[' 2 -ne 0 ']' + prompt_pw ++ stty -g + savetty=500:5:bf:8a3b:3:1c:7f:15:4:0:1:0:11:13:1a:0:12:f:17:16:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0 + printf 'MySql password for myadminuser: ' MySql password for myadminuser: + stty -echo + read PW + stty 500:5:bf:8a3b:3:1c:7f:15:4:0:1:0:11:13:1a:0:12:f:17:16:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0 + echo
+ shift + '[' 1 -ne 1 ']' + tmp_file=/tmp/ser_mysql.32727 + ser_dump ser + '[' 1 -ne 1 ']' + mysqldump -h mydbserver -umyadminuser -c -t -pmypass ser + ret=0 + '[' 0 -ne 0 ']' + ser_create sernew no_init_user + '[' 2 -eq 1 ']' + '[' 2 -eq 2 ']' + INITIAL_USER= + echo 'creating database sernew ...' creating database sernew ... + sql_query + mysql -h mydbserver -umyadminuser -pmypass + ret=0 + '[' 0 -ne 0 ']' + ser_restore sernew /tmp/ser_mysql.32727 + '[' 2 -ne 2 ']' + sql_query sernew + mysql -h mydbserver -umyadminuser -pmypass sernew ERROR 1054 at line 111: Unknown column 'perms' in 'field list' + ret=1 + rm /tmp/ser_mysql.32727 + exit 1
Any ideas why it fails?
thanks
Luca