SMS Server Tools 3
This site is hosted by Kekekasvi.com
 Menu
Basic information:
Additional information:
Support:
Get SMS Server Tools 3:
Additional Options

 Sponsored links

 Search
Custom Search

 Visitor locations
 
 SMS Server Tools 3 Community
Welcome, Guest. Please login or register. Tue Nov 24, 2020 17:38
SMSTools3 Community » Help and support Bottom

Mysql error

Login and Post Reply

Page:  1

Author Post
Member
Registered:
Apr 2011
Location: gaborone, Botswana
Operating system name and version: windows 7
Version of smsd: 3.1.14
Smsd installed from: sources / package repository / from elsewhere...sources
Name and model of a modem / phone: Huwawei e180
Interface: serial / USB / some adapter...USB

I had installed smssevertools a computer and wampserver, everything was working fine. i used this script to test event handelling and logging into mysql database
#!/bin/bash
SENT='jjj'
TEXT='fff'
SQL_ARGS="-h localhost -u root "" -Dsmsd -s -e"
mysql $SQL_ARGS "insert into rsms (sent,text) values (\"$SENT\",\"$TEXT\");"

This was also working fine.

I installed smsservertools and latest version of wamp on another computer. servertools works fine but the script above those not work anymore. i get the error
1102 (44000): incorrect database name 'insert into rsms (sent,text) values (jjj,)fff;

what could be the problem?

Member
Registered:
Apr 2011
Location: athens, Greece
Is there a database in the new system named smsd ?

Member
Registered:
Apr 2011
Location: gaborone, Botswana
Topic owner
Yes there is a databse named smsd

Member
Registered:
Apr 2011
Location: athens, Greece
Well, check if the table rsms exist in the specific database
You can use mysql -u root -p from command line
show databases;
use smsd;
show tables;

Member
Registered:
Apr 2011
Location: gaborone, Botswana
Topic owner
the table rsms and field have been checked and verified that they are in the database

Login and Post Reply

Page:  1

SMSTools3 Community » Help and support Top

 
Time in this board is UTC.  

Privacy Policy   SMS Server Tools 3 Copyright © Keijo Kasvi.