Hi everyone,
As written in the title of this post, I have just upgraded my perfectly working playSMS installation from rc8 to version 1.0 stable. But after the upgrade, I tried to send SMS and got failed. How can I solve it ?
Best regards,
Edouard.
I think you have failed to insert the update sql file and didnt notice it and continue
which manual did you followed ?
anton
I followed that one : Upgrade from playSMS 1.0-rc8 or 1.0-rc9 to 1.0
Yeah, in fact I got some issues tempting to update sql file and following your advice, I removed the lines causing me troubles. Is there any way to restart updating the sql file to see what is wrong ?
Edouard
drop the db, re insert your old sql file, then insert the upgrade sql file (from rc8.to 1.0)
anton
Hi @anton,
I’ve just dropped the db and reinsertes my old sql file. And then, looking at the playsms_tblRegistry table, I notice that I’m trying to upgrade to 1.0 coming from rc7 ! 
So the point is that how could I upgrade from rc7 to 1.0 ?
Best,
Edouard.
ok, so its not from rc8 as you said ? confirm me
anton
do you remember the step how to insert upgrade sql ?
now, instead of using rc8 file, use this sql file instead:
https://raw.githubusercontent.com/antonraharja/playSMS/master/db/playsms-upgrade_1.0-rc7_to_1.0.sql
anton
I did it and got this error : ERROR 1060 (42S21) at line 7: Duplicate column name ‘p_smsc’
Edouard
edit the file, and remove form the top until the line containing p_smsc
from top until this one:
ALTER TABLEplaysms_tblSMSOutgoingCHANGEp_gatewayp_smscVARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
and then re-insert
anton
by re-insert I meant after you edit, remove those line I asked you, save the file, then insert that file again, no need to drop db and all again
anton
I dit it and got this time this error : ERROR 1060 (42S21) at line 1: Duplicate column name ‘p_gateway’
Edouard
do exactly like before, just remove form the top until that line (its 1 line after previous error), then re insert again
anton
Doing so, I ended up again with an error. This time the error is : ERROR 1091 (42000) at line 33: Can’t DROP ‘uid_mobile’; check that column/key exists.
I guess I must remove the problematic line again and again till it’s OK. Right ?
Yup. Until the import finishes cleanly, no error. Always remove from the top until the line causing the error.
anton
1 Like
Done. Import finished. Now, when I send SMS, it failed.
Edouard
for all we know now your server is using playSMS 1.0, so lets start debugging
please set logstate to 3 on your config.php, and restart your playsmsd, playsmsd restart
and then watch the log:
tail -f /var/log/playsms/playsms.log | tee test1.txt
and then send single SMS (which will fail)
ctrl+c the tail command above and send me the test1.txt (sanitize first for numbers and private info, and then attach the file)
anton
it looks like Kannel drop your SMS, I see no error on playSMS part
see this part:
- - 2015-06-08 10:47:12 PID55755690a30d7 - L2 sendsms # saving smslog_id:114 u:1 g:0 gw:kannel smsc:mobiweb s:EDOUARD d:22966477832 type:text unicode:0 status:0
- - 2015-06-08 10:47:12 PID55755690a30d7 - L2 sendsms_process # saved smslog_id:114 id:112
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 sendsms # final smslog_id:114 gw:kannel smsc:mobiweb message:Hi u there, good morning!! len:26
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 kannel_hook_sendsms # enter smsc:mobiweb smslog_id:114 uid:1 to:22966477832
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 kannel_hook_sendsms # URL: http://localhost:13131/cgi-bin/sendsms?username=playsms&password=playsms&from=EDOUARD&to=22966477832&dlr-mask=31&dlr-url=http%3A%2F%2Flocalhost%2Fplaysms%2Findex.php%3Fapp%3Dcall%26cat%3Dgateway%26plugin%3Dkannel%26access%3Ddlr%26type%3D%25d%26smslog_id%3D114%26uid%3D1&account=admin&text=Hi+u+there%2C+good+morning%21%21&smsc=MobiWEB
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 dlr # isdlrd:1 smslog_id:114 p_status:2 uid:1
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 kannel__outgoing # end smslog_id:114 p_status:2
your Kannel reject/denied playSMS (meaning playSMS has done its job).
you can try submit this from browser (change localhost if your Kannel server IP):
http://localhost:13131/cgi-bin/sendsms?username=playsms&password=playsms&from=EDOUARD&to=22966477832&dlr-mask=31&dlr-url=http%3A%2F%2Flocalhost%2Fplaysms%2Findex.php%3Fapp%3Dcall%26cat%3Dgateway%26plugin%3Dkannel%26access%3Ddlr%26type%3D%25d%26smslog_id%3D114%26uid%3D1&account=admin&text=Hi+u+there%2C+good+morning%21%21&smsc=MobiWEB
anton
1 Like
Yeah ! I did it !
Indeed, playSMS has done its job. Trying to submit from lynk browser, it failed. Then, I checked config files and everything was ok except that smsbox was off. I restarted it and everything is working fine now.
Thank you very much for the assistance. Great software, great forum ! 
Edouard