YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

2 Pages 12>
Free Members area for your website Options
dwalker
#1 Posted : Wednesday, March 16, 2005 1:49:43 PM
Rank: Starting Member

Groups: Registered

Joined: 3/16/2005
Posts: 22
Location: ,
Hi Everyone, If you are considering a members area for your website where members pay to join via PayPal then look no further. Get your Free Automated members area integrated with PayPal: http://www.dwalker.co.uk/phpautomembersarea/ phpAutoMembersArea - just got better! Now integrated with PayPal, automated join and renewal system means you reap the rewards with the least effort. Fully automated management of your members both new and existing. If you try it let me have your feedback.... All the best Dave Walker
Sponsor  
 
digitism
#2 Posted : Friday, April 22, 2005 9:33:40 AM
Rank: Starting Member

Groups: Registered

Joined: 4/22/2005
Posts: 2
Location: ,
How come it's free? What's the catch.

I'm looking into this for a site and am open to everything from free to membergate. I don't need all the membergate features as it's going to be a fairly simple site. Articles some free some not. I'll use paypal for subscriptions so this free management system seems very good to me.

I have ok web skills as far as html/css etc go but no php skills. What are the pro's and cons of phpAutoMember vs the competition? How secure is it etc too? I guess I'm just concerned as it's free and things never are...

Thanks for any info,

digit.
dwalker
#3 Posted : Friday, April 22, 2005 10:04:02 AM
Rank: Starting Member

Groups: Registered

Joined: 3/16/2005
Posts: 22
Location: ,
Hi,

It is FREE, but carries a small ad on the footer, but registation will remove.

Read more on this here:
http://dwalker.co.uk/forum/viewtopic.php?t=80

Thanks for your interest.

Dave
mkorenchuk
#4 Posted : Thursday, January 01, 2009 11:41:00 PM
Rank: Starting Member

Groups: Registered

Joined: 1/1/2009
Posts: 2
Location: ,
Having trouble installing; unable to get the tables generated in the database. Is there a troubleshooting guide?
dwalker
#5 Posted : Friday, January 02, 2009 7:12:06 AM
Rank: Starting Member

Groups: Registered

Joined: 3/16/2005
Posts: 22
Location: ,
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by mkorenchuk
[br]Having trouble installing; unable to get the tables generated in the database. Is there a troubleshooting guide?
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
Yes:
http://www.dwalker.co.uk...als/#phpAutoMembersArea

Hope that helps.

All the best

Dave

Get your Free Automated members area integrated with PayPal:
http://www.dwalker.co.uk/phpautomembersarea/
bigdavid
#6 Posted : Saturday, January 24, 2009 2:45:53 PM
Rank: Starting Member

Groups: Registered

Joined: 1/24/2009
Posts: 13
Location: ,
i have just been asked to build a site with an admin area
i have downloaded phpautomembersarea to handle it but i am having problems installing it
this is wot i get

Attempting to create new tables...
There has been a problem creating the required tables, and/or inserting data (error message: 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 'range varchar(7) default NULL, PRIMARY KEY (total), UNIQUE KEY range (ran' at line 3).

<< Click here to go back <<CREATE TABLE pama_blocked_ranges ( total tinyint(4) NOT NULL auto_increment, range varchar(7) default NULL, PRIMARY KEY (total), UNIQUE KEY range (range)) TYPE=MyISAM

i dont know wot to do
could anyone help please thank you
dwalker
#7 Posted : Sunday, January 25, 2009 6:47:04 AM
Rank: Starting Member

Groups: Registered

Joined: 3/16/2005
Posts: 22
Location: ,
Hi Bigdavid,

Please let me know if you are using the installer (installer-phpAMA.zip) or the source code?

All the best

Dave

Get your Free Automated members area integrated with PayPal:
http://www.dwalker.co.uk/phpautomembersarea/
bigdavid
#8 Posted : Monday, January 26, 2009 1:31:26 AM
Rank: Starting Member

Groups: Registered

Joined: 1/24/2009
Posts: 13
Location: ,
i used the installer and it put all the files on the server
its asking for the database details
when i put the details in it adds 3 tables to the database and stops
could you help thank you
dwalker
#9 Posted : Monday, January 26, 2009 6:32:32 AM
Rank: Starting Member

Groups: Registered

Joined: 3/16/2005
Posts: 22
Location: ,
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by bigdavidi used the installer and it put all the files on the server its asking for the database details when i put the details in it adds 3 tables to the database and stops<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
Hi again Bigdavid,

Many thanks for getting back to me with the details and using the installer.

It seems there is a minor issue with the SQL within the install.php file which makes it fail on some versions of MySQL. There is a modifed version of the file here:
http://www.dwalker.co.uk...install-version3.51.zip

Download and please replace your own file:
/phpautomembersarea/install.php

Or download the whole installer again which will include the modified install.php file from:
http://www.dwalker.co.uk/phpautomembersarea/

Thanks

Dave.
bigdavid
#10 Posted : Monday, January 26, 2009 6:49:07 AM
Rank: Starting Member

Groups: Registered

Joined: 1/24/2009
Posts: 13
Location: ,
i downloaded the install.php and replaced the one on the server and i am still getting the same error

Attempting to create new tables...
There has been a problem creating the required tables, and/or inserting data (error message: 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 'range varchar(7) default NULL, PRIMARY KEY (total)) TYPE=MyISAM' at line 3).

<< Click here to go back <<CREATE TABLE pama_blocked_ranges ( total tinyint(4) NOT NULL auto_increment, range varchar(7) default NULL, PRIMARY KEY (total)) TYPE=MyISAM


so i dont know wot to do

Thank you
bigdavid
#11 Posted : Monday, January 26, 2009 7:07:01 AM
Rank: Starting Member

Groups: Registered

Joined: 1/24/2009
Posts: 13
Location: ,
i just found in one of the databases that i made to hold the info for phpautomembersarea that there is 8 tables in it but i am still getting the same error
dwalker
#12 Posted : Monday, January 26, 2009 7:11:52 AM
Rank: Starting Member

Groups: Registered

Joined: 3/16/2005
Posts: 22
Location: ,
Try changing the install.php at line 93
From:
total tinyint(4) NOT NULL auto_increment,

to:
total int(4) NOT NULL auto_increment,


Let me know if that fixes it!


bigdavid
#13 Posted : Monday, January 26, 2009 7:37:54 AM
Rank: Starting Member

Groups: Registered

Joined: 1/24/2009
Posts: 13
Location: ,
no
Attempting to create new tables...
There has been a problem creating the required tables, and/or inserting data (error message: 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 'range varchar(7) default NULL, PRIMARY KEY (total)) TYPE=MyISAM' at line 3).

CREATE TABLE pama_blocked_ranges ( total int(4) NOT NULL auto_increment, range varchar(7) default NULL, PRIMARY KEY (total)) TYPE=MyISAM

think thats still the same
dwalker
#14 Posted : Monday, January 26, 2009 7:43:07 AM
Rank: Starting Member

Groups: Registered

Joined: 3/16/2005
Posts: 22
Location: ,
Please let me know your MySQL and PHP version?
Also, who the host is?

Thanks
bigdavid
#15 Posted : Monday, January 26, 2009 7:53:35 AM
Rank: Starting Member

Groups: Registered

Joined: 1/24/2009
Posts: 13
Location: ,
ok i am the host
MySQL
Server: localhost via TCP/IP
Server version: 5.1.30-community
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)

PHP Version 5.2.8
hope that helps
dwalker
#16 Posted : Monday, January 26, 2009 8:04:05 AM
Rank: Starting Member

Groups: Registered

Joined: 3/16/2005
Posts: 22
Location: ,
It must be the newer version of MySQL that is stopping the install!
Not yet tested on that version of MySQL.

I will upgrade our test server and get back to you.



All the best

Dave

Get your Free Automated members area integrated with PayPal:
http://www.dwalker.co.uk/phpautomembersarea/
bigdavid
#17 Posted : Monday, January 26, 2009 8:11:21 AM
Rank: Starting Member

Groups: Registered

Joined: 1/24/2009
Posts: 13
Location: ,
will i am not far from you i am in bradford
i am just starting to host some site and one person has just asked me for a members area that she gets paid for people to join
but i think more people would want it when they see it running
and i think we will be paying to remove the adverts
if there is any more info you need about my server just let me know or email me david@davidscomputers.co.uk thanks
dwalker
#18 Posted : Monday, January 26, 2009 11:41:17 AM
Rank: Starting Member

Groups: Registered

Joined: 3/16/2005
Posts: 22
Location: ,
Found the issue! Having upgraded MySQL on our test server. It occurs when using the MySQL version 5.1.30

It will not execute the SQL on line 94:
range varchar(8) default NULL,

Change this to:
pama_range varchar(8) default NULL,

And it will be fine :--)))))

The new version of MySQL must have "range" as a reserved word (what a dummer and time wasting exercise).

There are minor ramifications: you are unable to block IP address ranges in admin. I am working on this and hope to have a fix soon.

All the best

Dave

Get your Free Automated members area integrated with PayPal:
http://www.dwalker.co.uk/phpautomembersarea/
bigdavid
#19 Posted : Monday, January 26, 2009 12:04:18 PM
Rank: Starting Member

Groups: Registered

Joined: 1/24/2009
Posts: 13
Location: ,
thank you so much it installed at last
now i just got to work out how to work with it
as even when people get in to the members i dont want then to right click and download the photos

Thanks for getting that sorted so quick
bigdavid
#20 Posted : Monday, January 26, 2009 12:20:26 PM
Rank: Starting Member

Groups: Registered

Joined: 1/24/2009
Posts: 13
Location: ,
i just tried to add a user and i got this
update_expire_date($join_date,$day,$month,$year); js_msg("New member added, you now need to activate the new account."); include("header.html"); include("activate.php"); ?>
Users browsing this topic
Guest
2 Pages 12>
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFVision Theme by Jaben Cargman (Tiny Gecko)
Powered by YAF | YAF © 2003-2009, Yet Another Forum.NET
This page was generated in 0.889 seconds.