Upgrade from Version somewhat beteween 0.9.9.2 and RCx to 1.2

playSMS Install and Upgrade
1

Hi,
I am just trying to upgrade to 1.2.
Currently in place is some release candidate. Unfortunately I am not able to execute any sql-script.

Trying to execute upgrade 0.9.9.2 I receive this error:
/opt/playsms/_install/db> mysql -uplaysms -p******* < playsms-upgrade_0.9.9.2_to_1.0.sql
ERROR 1091 (42000) at line 23: Can’t DROP ‘gpid’; check that column/key exists

=> I guess I am on a later version. Trying the next upgrade-file:

mysql -uplaysms -p* < playsms-upgrade_1.0-rc4_to_1.0.sql
ERROR 1050 (42S01) at line 163: Table ‘playsms_tblSMSInbox’ already exists
=> version already in place? commenting out the line…

mysql -uplaysms -p* < playsms-upgrade_1.0-rc4_to_1.0.sql
ERROR 1060 (42S21) at line 86: Duplicate column name ‘acl_id’
=> commenting out this line as well…

/opt/playsms/_install/db> mysql -uplaysms -p* < playsms-upgrade_1.0-rc4_to_1.0.sql
ERROR 1060 (42S21) at line 171: Duplicate column name ‘tags’
=> commenting out this one as well…

mysql -uplaysms -p* < playsms-upgrade_1.0-rc4_to_1.0.sql
ERROR 1051 (42S02) at line 165: Unknown table ‘playsms_tblUser_country’
=> ok, did that for all other errors. then applied 1.0_to_1.1.sql and 1.1_to_1.2.sql.
those were running fine. But after logging in I get
FATAL ERROR : Fail to load main config from registry

Checking that table: there is only one entry in there:
MariaDB [playsms]> select * from playsms_tblRegistry;
±------------±—±----±---------------±----------------±----------------±---------------+
| c_timestamp | id | uid | registry_group | registry_family | registry_key | registry_value |
±------------±—±----±---------------±----------------±----------------±---------------+
| 0 | 2 | 1 | core | config | playsms_version | 1.2 |
±------------±—±----±---------------±----------------±----------------±---------------+
1 row in set (0.00 sec)

What is going wrong here???

edit: OK, login is possible after manually altering table tblUser by “flag_deleted”. Also the table playsms_tblSMSOutgoing has to be altered as described in rc4-update-script (rc8).
Now most is fine, but all phonebooks are gone…

kind regards,
andre

2

0.9.9.2 to 1.0 got major updates on phonebook

suggestion, next time updating mysql you should solve the encountered problem right away and do not continue unless its fixed, for example this one:

you should open playsms-upgrade_0.9.9.2_to_1.0.sql and go to line 23, see something related to gpid and workaround that, like probably remove that line since you don’t have gpid (probably already removed by other updates you don’t remember you did)

anton

anton

3

ok… that did the trick… however, i had to disable about 50 lines… thanks yor support.