FMLP LITE got stuck on the way

[kkstar]

DEAR ADMIN
I UPLOADED your free autoresponder sofware. I installed it, I configured the other failes as per your instructions. But I am getting STUCK while adding account in mysql data base. I even logged into PHPADMIN and pasted your correction script in the query filed. Yet I am getting the following err.
================================================== =====
Error
SQL query:

CREATE TABLE `swd_account` (

`swd_account` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` char( 16 ) NOT NULL default '',
`isact` tinyint( 4 ) NOT NULL default '1',
PRIMARY KEY ( `pk_account` )
);

MySQL said:

#1072 - Key column 'pk_account' doesn't exist in table

===============================================
What is cpanel? I CAN'T GET IT
KINDLY HELP!

[drquek]

There is error in your commands. Below is the right commands.

You only need to run this if you come across Error Message 1146 when trying to create a new account.

This is because of incompatibility with your mysql version, resulting in two tables (account and user) not created properly. This problem does not arise in FMLP Pro.

a. Log into phpmyadmin on your host
b. Click the database you created
c. Click MYQL
d. Paste the following 2 sets of commands separately inside RUN SQL QUERY input box:

>>>>>>>>
CREATE TABLE `swd_account` (
`pk_account` int(11) NOT NULL auto_increment,
`name` char(16) NOT NULL default '',
`isact` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`pk_account`)
) TYPE=MyISAM;
>>>>>>>>
CREATE TABLE `swd_user` (
`pk_user` int(11) NOT NULL auto_increment,
`fk_account` int(11) NOT NULL default '0',
`email` varchar(40) NOT NULL default '',
`name` varchar(40) default NULL,
`isact` tinyint(4) NOT NULL default '1',
`datereg` date default NULL,
`days` tinyint(4) default '0',
`datelastsend` date default NULL,
`messlastsend` int(11) default NULL,
`countsend` int(11) NOT NULL default '0',
`undelivered` tinyint(4) default NULL,
PRIMARY KEY (`pk_user`),
KEY `fk_account` (`fk_account`,`email`,`isact`),
KEY `email` (`email`)


On your other question, cPanel is a control panel for your linux host.

[kkstar]

Dear Admin
I did as per your advice. While the first script successfully created the table the second one did not. Following is the err message.

================================================== ==
SQL query:

CREATE TABLE `swd_user` (

`pk_user` int( 11 ) NOT NULL AUTO_INCREMENT ,
`fk_account` int( 11 ) NOT NULL default '0',
`email` varchar( 40 ) NOT NULL default '',
`name` varchar( 40 ) default NULL ,
`isact` tinyint( 4 ) NOT NULL default '1',
`datereg` date default NULL ,
`days` tinyint( 4 ) default '0',
`datelastsend` date default NULL ,
`messlastsend` int( 11 ) default NULL ,
`countsend` int( 11 ) NOT NULL default '0',
`undelivered` tinyint( 4 ) default NULL ,
PRIMARY KEY ( `pk_user` ) ,
KEY `fk_account` ( `fk_account` , `email` , `isact` ) ,
KEY `email` ( `email` )

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 15
================================================== =====
What shall I do now?
Thanks

[drquek]

Sorry, the correct instruction should be (notice the last lines were omitted earlier):

6. If you come accross Error Message 1146 when trying to create a new account.
This is because of incompatibility with your mysql version, resulting in two tables (account and user) not created properly. This problem does not arise in FMLP Pro.

a. Log into phpmyadmin on your host
b. Click the database you created
c. Click MYQL
d. Paste the following 2 sets of commands separately inside RUN SQL QUERY input box:

>>>>>>>>
CREATE TABLE `swd_account` (
`pk_account` int(11) NOT NULL auto_increment,
`name` char(16) NOT NULL default '',
`isact` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`pk_account`)
) TYPE=MyISAM;
>>>>>>>>
CREATE TABLE `swd_user` (
`pk_user` int(11) NOT NULL auto_increment,
`fk_account` int(11) NOT NULL default '0',
`email` varchar(40) NOT NULL default '',
`name` varchar(40) default NULL,
`isact` tinyint(4) NOT NULL default '1',
`datereg` date default NULL,
`days` tinyint(4) default '0',
`datelastsend` date default NULL,
`messlastsend` int(11) default NULL,
`countsend` int(11) NOT NULL default '0',
`undelivered` tinyint(4) default NULL,
PRIMARY KEY (`pk_user`),
KEY `fk_account` (`fk_account`,`email`,`isact`),
KEY `email` (`email`)
) TYPE=MyISAM;
>>>>>>>>

[kkstar]

Dear Admin
Thank you for your time and modification.
Now I could create new account and installed form in my website. After test submitting forms the subcribe email is not being sent to the subscribers.
I test send the checked messages but only the 'susbcribe emails'and the message cycles are not being sent. However Test messages and sample message are reaching the subscribers'emails. Kindly advice.

Thanks

[drquek]

I don't fully understand your problem. Please explain clearly.

You must set up the 1 pixel activation link before messages will be sent.