work in progress: simple vertical sms app: vertsms - Page 25 - maemo.org

Frank Banul | # 241 | 2010-05-31, 13:12 | Report

If you don't mind, where do you use seq_id? That seems to be the last variable set from the sqlite related code.

FWIW, I removed the sqlite from gvSMS and it didn't seem to change the behavior.

While I'm at it, ADDR_TYPE of 129 seems to be required for T-Mobile domestic (US) numbers. Using 132 fails. I tried to use your international support. Then to make things more interesting, ADDR_TYPE 129 or 132 works fine on AT&T domestic numbers.

Originally Posted by ossipena View Post

don't touch the sqlite! it fetches the unique id needed for adding a message. it seems to be easier than api way apparently and since it only reads one column through it shouldn't mess the db up.

thanks,
Frank

ossipena | # 242 | 2010-05-31, 16:34 | Report

seq_id is given to api command. there is no direct requirement but if it works without it, the rtcom-eventlogger probably creates one automatically. but it needs to be unique number in database or problems will probably come.

just realized what is wrong in new sms.py: it outputs 8bit text but of course sms is 7 bit

e: is there a easy way to convert?

Last edited by ossipena; 2010-05-31 at 16:55.

Frank Banul | # 243 | 2010-05-31, 18:18 | Report

Should the existing code:
put_to_sent_sms(own_number, number, 0, strippednumber, message)

be:
put_to_sent_sms(own_number, number, seq_id, strippednumber, message)

?

Originally Posted by ossipena View Post

seq_id is given to api command. there is no direct requirement but if it works without it, the rtcom-eventlogger probably creates one automatically. but it needs to be unique number in database or problems will probably come.

Frank

The Following User Says Thank You to Frank Banul For This Useful Post:
ossipena

Xonir | # 244 | 2010-05-31, 20:45 | Report

what's that? help!

~ $ python /opt/vertsms/vertsms_gui.py
response was: -5
Traceback (most recent call last):
File "/opt/vertsms/vertsms_gui.py", line 422, in send
s = sms.SMS(text, number)
File "/opt/vertsms/vertsms/sms.py", line 125, in __init__
self.write_to_rtcomm(msg, number)
File "/opt/vertsms/vertsms/sms.py", line 226, in write_to_rtcomm
cursor.execute('SELECT id FROM Events')
sqlite3.OperationalError: no such table: Events

ossipena | # 245 | 2010-05-31, 20:57 | Report

Originally Posted by Xonir View Post

what's that? help!

~ $ python /opt/vertsms/vertsms_gui.py
response was: -5
Traceback (most recent call last):
File "/opt/vertsms/vertsms_gui.py", line 422, in send
s = sms.SMS(text, number)
File "/opt/vertsms/vertsms/sms.py", line 125, in __init__
self.write_to_rtcomm(msg, number)
File "/opt/vertsms/vertsms/sms.py", line 226, in write_to_rtcomm
cursor.execute('SELECT id FROM Events')
sqlite3.OperationalError: no such table: Events

I'll remove those sqlite lines as soon as I get new octification working so shouldn't be a problem in next version. is your rtcom-eventlogger database corrupt?

kid2k | # 246 | 2010-06-01, 10:12 | Report

hello

I translated the program to Arabic language
Please help me
I have a problem
When selecting the second character of any number deletes the entered text
Please i need to solution of the problem

Attached Files

vertsms-ar_0.6_all.deb (28.3 KB, 121 views)

Xonir | # 247 | 2010-06-01, 11:06 | Report

Originally Posted by ossipena View Post

I'll remove those sqlite lines as soon as I get new octification working so shouldn't be a problem in next version. is your rtcom-eventlogger database corrupt?

I don't know..how can I check it?

Frank Banul | # 248 | 2010-06-01, 14:01 | Report

If the sqlite code stays, you'll also need to take into account the name change between PR1.2 and PR1.x. Maybe the below?

Originally Posted by Frank Banul View Post

Code:

        try:
            connection = sqlite3.connect(os.path.join(os.environ['HOME'], '.rtcom-eventlogger', 'el-v1.db'))
        except:
            connection = sqlite3.connect(os.path.join(os.environ['HOME'], '.rtcom-eventlogger', 'el.db'))
        cursor = connection.cursor()        
        cursor.execute('SELECT id FROM Events')
        id_array = cursor.fetchall()  
        seq_id = max(id_array)[0] + 1

Xonir | # 249 | 2010-06-01, 17:16 | Report

Originally Posted by Frank Banul View Post

If the sqlite code stays, you'll also need to take into account the name change between PR1.2 and PR1.x. Maybe the below?

wow..this error is disappears

now, it save the message in conversation, but it's not received by the recipient!

vertsms gui says me: it was not possible to send the message to.. (or samething like that..)

Last edited by Xonir; 2010-06-01 at 17:44.

ossipena | # 250 | 2010-06-01, 20:13 | Report

i am so pissed to this forum at this moment so I will be at radio silence. and further developing vertsms will be done but more slowly.

I will add settings to the gui so one can configure TON themselves. that should stop errors with message sending but it requires user interaction at first. this comes after I get that frigging PDU string creation working...

and about my decision.. you can thank the mother****ers here personally who only b*tch until they get tired and switch to whining. and when they get tired to whining, they restart the b*tching. I am trying to be happy but their negativity spreads like a disease here.

Might not come back until meego is up and running, but we'll see.