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. Sun May 19, 2024 20:36
SMSTools3 Community » Help and support Bottom

[answered] Problem in database creation

  This topic is locked

Page:  1

Author Post
Member
Registered:
Jun 2009
Location: Manila, Philippines
Hi,
I did made a mysql database and table and used the script above. But I'm having an error:


This is what's on line 37:


Do I also have to create the fields on the table that I made or this script will take care of it?

I did tried making the fields too:


Did i do it right?

Administrator
Registered:
May 2009
Location: Jyväskylä, Finland
Quote
I did made a mysql database and table and used the script above. But I'm having an error:



The second argument was not a file, it was directory.

You do not have MySQL command line interface (CLI) installed. You have to install it.

Quote
Do I also have to create the fields on the table that I made or this script will take care of it?

Yes you should do.

Quote
I did tried making the fields too:


Did i do it right?

No. All fields cannot be integers. You could use this kind of statement to create a table:

CREATE TABLE `stored_messages`.`sms_log` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`type` varchar( 16 ) NOT NULL ,
`sent` datetime NOT NULL ,
`received` datetime NOT NULL ,
`sender` varchar( 32 ) NOT NULL ,
`receiver` varchar( 32 ) NOT NULL ,
`status` char( 3 ) NOT NULL ,
`msgid` char( 3 ) NOT NULL ,
`text` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = MYISAM ;
'mysql' Syntax Highlight powered by GeSHi


  This topic is locked

Page:  1

SMSTools3 Community » Help and support Top

 
Time in this board is UTC.  

Privacy Policy   SMS Server Tools 3 Copyright © Keijo Kasvi.