[Serusers] Ser 0.8.14 to 0.9.3 database upgrade

[Luca Corti]

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

-- 
Luca Corti
PGP Key ID 1F38C091
BOFH excuse of the moment:
Backbone Scoliosis