I cannot send forms to mobile phones when I change the database settings to MySQL

[Maduka Okafor]

Hey!

I have changed the database settings to MySQL details on frontlineSMS; but I cannot send forms to my mobile phone. The message for sending the new forms remains pending and never gets to the mobile phone.

Meanwhile, on the SQLlite mode, fronlineSMS send forms to my mobile phone and i receive the forms.

Can anyone help with this?

Thank you.

[Alex Anderson]

Hi Maduka,

Are you sure you've made no other changes to your system? Perhaps you had an old FrontlineSMS database in MySQL which is causing problems? We'll take a look here, and see if we have the same issue.

Alex

[Maduka Okafor]

Hello Alexander,

Thank you for your response.

I did not make any other changes apart from entering the required parameters in the database...

Database Type: MySQL
Database Name: election
Database Server: localhost
Database Port: 3306
Database Username: root
Database Password: xxxx

That was all I did. I also cleared the database and tried it again. I have also done a fresh installation on a new PC, still same result.

I shall await your response after you've tried it.

Thank you.

[Alex Anderson]

Hi Maduka,

Thanks for the info :¬) Can you send us your logs? You can do that by selecting "Submit Error Report" from the Help menu.

Cheers,

Alex

[Maduka Okafor]

Hello Alexander,

Very well then. Would do so as soon as I finish from work at the office.

Thank you.

[Maduka Okafor]

Hello Alexander,

Sorry for not sending you this like I promised to.

Please find attached the error log.

Hope to hear from you soon.

Thanks.

[Alex Anderson]

Hi Maduka,

Thanks for the logs. It looks like the problem is caused by the version of MySQL you are using. FrontlineSMS should integrate okay with MySQL v5. What version do you have?

Alex

[Maduka Okafor]

Hello Alexander,

I'm using MySQL Version 5.1.36. It came bundled with the WAMP sever.

Did it work on yours?

Please let me know if it did.

Thank you.

[Alex Anderson]

Hi Manduka,

Sorry for the slow response on this. It seems this is an issue between FrontlineSMS and your version of MySQL when attempting to execute the SQL command "CREATE TABLE tablename IF NOT EXISTS". I'd recommend you try the latest 1.6.x build of FrontlineSMS - you can get it from http://www.frontlinesms.com/download/

Alex

[Lester Flores]

Have the same problem that has Makuda, and i am using the lastest version 1.6.1.6, can you said me how to fix this problems is important to me fix it.

[Morgan Belkadi]

Hi Lester,

can you send us your logs as well?

Cheers,
Morgan

[Lester Flores]

hi thx for quick aswer. attach logs done.

[Morgan Belkadi]

Hi Lester,

how did you setup your MySQL database? Using a server tool like "Wamp"? I can see a "Communications link failure" in your logs, so make sure your database is reachable, and that you configuration is alright in FrontlineSMS.

Best,
Morgan