Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Error inserting in MessageLog
sp_NewPost Add Reply sp_NewTopic Add Topic
August 24, 2012
10:27 pm
Diego J.
Guest
Guests

Thanks for your help! I have resolved the issue.

Regards, Diego

August 24, 2012
5:34 pm
Henk Helmantel
Guest
Guests

According to this bug report, it is a bug in MySQL/ODBC that affects only some configurations.

You can remove the Send time field from the database field list in the SMS Log tab page of the SQL Connector in Diafaan SMS Server. That means the send time will not be written in the database but you could add a field to the table that automatically inserts the current time with the NOW() function.

The same bug will also affect other date/time fields in the SQL Connector.

Regards, Henk

August 24, 2012
3:32 pm
Diego J.
Guest
Guests

Thanks for you response!

I checked the SMS Log tab and this option is marked, i also checked the Event Log and i found this error:

8/23/2012 2:20:47 PM ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.33-community-nt]Incorrect datetime value: '2012-08-23 14:20:45.778000000' for column 'SendTime' at row 1 SQL Connector

Have i to change something in any table of the database?

Regards, Diego

August 24, 2012
10:09 am
Henk Helmantel
Guest
Guests

Hi Diego,

If all settings in Diafaan SMS Server and the database layout are correct, the sent and failed messages (but not the queued ones) are stored automatically in the MessageLog table.

There are two possible reasons why the records might not be written to the MessageLog table:

- In the SMS Log tab page of the SQL Connector properties, the "Database table" option is not checked. In that case the MessageLog table will simply not be used.

- There is an error in the database layout or a (typing?) error in the matching database field names in the SQL Connector properties. In that case there will be an error logged in the Event Log of Diafaan SMS Server that hopefully sheds some light on the cause of the error.

Regards, Henk

August 23, 2012
10:47 pm
Diego J.
Guest
Guests

Hi!

I have been using the Diafaan app with MySQL and it works great, but i'm having a problem, the data is inserted in MessageOut table and the SMS messages are sent well, but the data are not inserted in the MessageLog table automatically, is this an error? or have i to configure another parameter in the application?

Thanks for your help!

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
8 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 364

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 532

Posts: 1847

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 553