drquek
10-12-2007, 11:24 AM
If you come across problems installing FMLP Lite v4.1, please read this carefully.
There is no bug in the above script which has been installed on thousands of servers across the world!
Most of the time, the problem is due to users not knowing how to install scripts.
Only about 5% of the time, the problem is due to incompatibility with older versions of perl/mysql or server configuration.
I suggest that you follow the steps below to install:
#1. Read the instructions given in the readme.txt file which is inside the zip folder you downloaded. Follow the steps carefully especially when setting file permissions.
Click here (http://www.doctorquek.com/adtz/go.php?c=amlmmanual&s=d) to read the comprehensive AMLM Pro manual.
#2. Watch the two-part videos on how to install and set up the Autoresponder. You can choose from the Yahoo, Google and Youtube video links below (This is for you to select the best download speed):
Google Videos:
http://www.doctorquek.com/googlefmlplitevideo1.html
http://www.doctorquek.com/googlefmlplitevideo2.html
Yahoo Videos:
http://www.doctorquek.com/yahoofmlplitevideo1.html
http://www.doctorquek.com/yahoofmlplitevideo2.html
Youtube Videos:
http://www.doctorquek.com/youtubefmlplitevideo1.html
http://www.doctorquek.com/youtubefmlplitevideo2.html
#3. Make sure you are using Auto mode in your ftp client when you upload the files to the cgi-bin of your host.
Do not upload the zip file without unzipping first ie, do not upload the zip file to the cgi bin and then unzip using the file manager in your cpanel.
Some FTP clients e.g., Smartftp may cause problem.
#4. Make sure ALL files have been uploaded to your cgi-bin correctly.
#5. If you receive this error message when trying to run install.cgi in your browser:
Internal Server Error 500
Add to the first line of the install.cgi and to responder.cgi
#!/usr/bin/perl -w
The addition of the switch -w cured the problems in some servers.
#6. On some server you may get this error message:
Software Error:
Can not write to file cnf.rd - Permission denied at /home/opbizcom/public_html/cgi-bin/amlmlite4/install.cgi line 110.
For help please contact AMLM Lite Support (admin@drquek.com)
Please contact your host quoting the above.
Please change the file permission for cnf.rd from 644 to 666,
#7. 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:
Set 1>>>>>>>>
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;
Set 2>>>>>>>>
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;
end set 2>>>>>>>>
e. Click go.
f. Notice we are using the default prefix swd_ in the database. If you are not using default value, change it accordingly.
#8. If you get Null error like:
SQL error: INSERT INTO swd_conf (`conf_value` , `fk_account` , `pk_conf`) VALUES (NULL , '1' , 'ispurge') : ERROR: 1048 - Column 'conf_value' cannot be nullContent-Type: text/html; charset=ISO-8859-1
Use phpmyadmin, go and change the column conf_value to allow null value.
#9. If you get the following messages when sending test messages (global options/performance test):
Software error:
Can't locate Email/Date.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i686-linux /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl .) at /usr/lib/perl5/site_perl/5.8.8/MIME/Lite.pm line 1097.
Please ask your host to install the following modules:
http://search.cpan.org/~msergeant/Time-Piece-1.11/ (http://search.cpan.org/%7Emsergeant/Time-Piece-1.11/)
and
http://search.cpan.org/~roode/Time-Format-1.02/ (http://search.cpan.org/%7Eroode/Time-Format-1.02/)
#10. Use phpmyadmin to automatically repair your database. This is found inside the mysql icon in cpanel.
#11. Following are the tests you may perform:
a. Try using the test send message feature to send yourself say 50 email messages.
b. Try subscribing yourself using an email address on your own server eg., webmaster@mydomainname.com
c. Check the log to see if cron was activated.
d. If you using the 1 pixel activation link, copy the link into your browser and view it. This will activate the link:
http://www.mydomainname.com/cgi-bin/fmlplite/starter.cgi
#12. If everything fails, try to install FMLP Lite on a different server.
If you do not have another server, try to sign up with a free host that provide cgi access.
Type "free hosts" into your search engines, you will find lots of them.
The last step is the easiest and usually solve the problem!
As stated above, there is no bug in FMLP Lite. Most of the time, the problem is due to users not knowing how to install scripts. Only about 5% of the time, the problem is due to incompatibility with older versions of perl.
If you buy the FMLP Pro which has a more robust script, you will not run into this problem.
If you need help with installation, we can install for you for $25. Please fill up the information required below with your payment via PayPal to this email:
drquek2 @ gmail.com (please remove the empty space before and after @)
We can also host it for you at a very competitive rate starting from $6 per month. Click here for details (http://doctorquek.com/forums/showthread.php?t=61).
You can request for them by copying and pasting the following items marked with an * into an email and send it to your host.
*1. Ftp server
*2. Ftp username and password
*3. Domain url
*4. Absolute path to your directory eg., /home/yourname/public_html/cgi-bin/maillist
*5. Mail Program Setting:
Sendmail path (eg, /usr/sbin/sendmail):___________________
Send through (eg, sendmail):______________________________
SMTP server (eg, mail.mydomain.com):______________________
6. Either one of the following:
a) Login details to your web host's control panel. This allows us to login and create the mysql for you.
Control Panel URL: _________________________________
Login name: ______________________________________
Password:________________________________________
*b) Supply the following to us:
MYSQL:
Database server:_________________________
Database name:___________________________
Database username:_______________________
Database password:_______________________
Database prefix (optional):___________________
7. Give us the email you want to use as admin email
Regards,
Dr. Daniel Quek @ The Software Guy.
updated: 20080727
There is no bug in the above script which has been installed on thousands of servers across the world!
Most of the time, the problem is due to users not knowing how to install scripts.
Only about 5% of the time, the problem is due to incompatibility with older versions of perl/mysql or server configuration.
I suggest that you follow the steps below to install:
#1. Read the instructions given in the readme.txt file which is inside the zip folder you downloaded. Follow the steps carefully especially when setting file permissions.
Click here (http://www.doctorquek.com/adtz/go.php?c=amlmmanual&s=d) to read the comprehensive AMLM Pro manual.
#2. Watch the two-part videos on how to install and set up the Autoresponder. You can choose from the Yahoo, Google and Youtube video links below (This is for you to select the best download speed):
Google Videos:
http://www.doctorquek.com/googlefmlplitevideo1.html
http://www.doctorquek.com/googlefmlplitevideo2.html
Yahoo Videos:
http://www.doctorquek.com/yahoofmlplitevideo1.html
http://www.doctorquek.com/yahoofmlplitevideo2.html
Youtube Videos:
http://www.doctorquek.com/youtubefmlplitevideo1.html
http://www.doctorquek.com/youtubefmlplitevideo2.html
#3. Make sure you are using Auto mode in your ftp client when you upload the files to the cgi-bin of your host.
Do not upload the zip file without unzipping first ie, do not upload the zip file to the cgi bin and then unzip using the file manager in your cpanel.
Some FTP clients e.g., Smartftp may cause problem.
#4. Make sure ALL files have been uploaded to your cgi-bin correctly.
#5. If you receive this error message when trying to run install.cgi in your browser:
Internal Server Error 500
Add to the first line of the install.cgi and to responder.cgi
#!/usr/bin/perl -w
The addition of the switch -w cured the problems in some servers.
#6. On some server you may get this error message:
Software Error:
Can not write to file cnf.rd - Permission denied at /home/opbizcom/public_html/cgi-bin/amlmlite4/install.cgi line 110.
For help please contact AMLM Lite Support (admin@drquek.com)
Please contact your host quoting the above.
Please change the file permission for cnf.rd from 644 to 666,
#7. 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:
Set 1>>>>>>>>
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;
Set 2>>>>>>>>
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;
end set 2>>>>>>>>
e. Click go.
f. Notice we are using the default prefix swd_ in the database. If you are not using default value, change it accordingly.
#8. If you get Null error like:
SQL error: INSERT INTO swd_conf (`conf_value` , `fk_account` , `pk_conf`) VALUES (NULL , '1' , 'ispurge') : ERROR: 1048 - Column 'conf_value' cannot be nullContent-Type: text/html; charset=ISO-8859-1
Use phpmyadmin, go and change the column conf_value to allow null value.
#9. If you get the following messages when sending test messages (global options/performance test):
Software error:
Can't locate Email/Date.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i686-linux /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl .) at /usr/lib/perl5/site_perl/5.8.8/MIME/Lite.pm line 1097.
Please ask your host to install the following modules:
http://search.cpan.org/~msergeant/Time-Piece-1.11/ (http://search.cpan.org/%7Emsergeant/Time-Piece-1.11/)
and
http://search.cpan.org/~roode/Time-Format-1.02/ (http://search.cpan.org/%7Eroode/Time-Format-1.02/)
#10. Use phpmyadmin to automatically repair your database. This is found inside the mysql icon in cpanel.
#11. Following are the tests you may perform:
a. Try using the test send message feature to send yourself say 50 email messages.
b. Try subscribing yourself using an email address on your own server eg., webmaster@mydomainname.com
c. Check the log to see if cron was activated.
d. If you using the 1 pixel activation link, copy the link into your browser and view it. This will activate the link:
http://www.mydomainname.com/cgi-bin/fmlplite/starter.cgi
#12. If everything fails, try to install FMLP Lite on a different server.
If you do not have another server, try to sign up with a free host that provide cgi access.
Type "free hosts" into your search engines, you will find lots of them.
The last step is the easiest and usually solve the problem!
As stated above, there is no bug in FMLP Lite. Most of the time, the problem is due to users not knowing how to install scripts. Only about 5% of the time, the problem is due to incompatibility with older versions of perl.
If you buy the FMLP Pro which has a more robust script, you will not run into this problem.
If you need help with installation, we can install for you for $25. Please fill up the information required below with your payment via PayPal to this email:
drquek2 @ gmail.com (please remove the empty space before and after @)
We can also host it for you at a very competitive rate starting from $6 per month. Click here for details (http://doctorquek.com/forums/showthread.php?t=61).
You can request for them by copying and pasting the following items marked with an * into an email and send it to your host.
*1. Ftp server
*2. Ftp username and password
*3. Domain url
*4. Absolute path to your directory eg., /home/yourname/public_html/cgi-bin/maillist
*5. Mail Program Setting:
Sendmail path (eg, /usr/sbin/sendmail):___________________
Send through (eg, sendmail):______________________________
SMTP server (eg, mail.mydomain.com):______________________
6. Either one of the following:
a) Login details to your web host's control panel. This allows us to login and create the mysql for you.
Control Panel URL: _________________________________
Login name: ______________________________________
Password:________________________________________
*b) Supply the following to us:
MYSQL:
Database server:_________________________
Database name:___________________________
Database username:_______________________
Database password:_______________________
Database prefix (optional):___________________
7. Give us the email you want to use as admin email
Regards,
Dr. Daniel Quek @ The Software Guy.
updated: 20080727