Jump to content


Photo

Free Members area for your website


  • This topic is locked This topic is locked
28 replies to this topic

#1 dwalker

dwalker

    Member

  • Members
  • PipPip
  • 22 posts

Posted 16 March 2005 - 08:49 AM

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.c...utomembersarea/
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

#2 digitism

digitism

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 22 April 2005 - 04:33 AM

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.

#3 dwalker

dwalker

    Member

  • Members
  • PipPip
  • 22 posts

Posted 22 April 2005 - 05:04 AM

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...wtopic.php?t=80

Thanks for your interest.

Dave

#4 mkorenchuk

mkorenchuk

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 01 January 2009 - 06:41 PM

Having trouble installing; unable to get the tables generated in the database. Is there a troubleshooting guide?

#5 dwalker

dwalker

    Member

  • Members
  • PipPip
  • 22 posts

Posted 02 January 2009 - 02:12 AM

<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.c...AutoMembersArea

Hope that helps.

All the best

Dave

Get your Free Automated members area integrated with PayPal:
http://www.dwalker.c...utomembersarea/

#6 bigdavid

bigdavid

    Member

  • Members
  • PipPip
  • 13 posts

Posted 24 January 2009 - 09:45 AM

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

#7 dwalker

dwalker

    Member

  • Members
  • PipPip
  • 22 posts

Posted 25 January 2009 - 01:47 AM

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.c...utomembersarea/

#8 bigdavid

bigdavid

    Member

  • Members
  • PipPip
  • 13 posts

Posted 25 January 2009 - 08:31 PM

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

#9 dwalker

dwalker

    Member

  • Members
  • PipPip
  • 22 posts

Posted 26 January 2009 - 01:32 AM

<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.c...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.c...utomembersarea/

Thanks

Dave.

#10 bigdavid

bigdavid

    Member

  • Members
  • PipPip
  • 13 posts

Posted 26 January 2009 - 01:49 AM

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

#11 bigdavid

bigdavid

    Member

  • Members
  • PipPip
  • 13 posts

Posted 26 January 2009 - 02:07 AM

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

#12 dwalker

dwalker

    Member

  • Members
  • PipPip
  • 22 posts

Posted 26 January 2009 - 02:11 AM

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!




#13 bigdavid

bigdavid

    Member

  • Members
  • PipPip
  • 13 posts

Posted 26 January 2009 - 02:37 AM

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

#14 dwalker

dwalker

    Member

  • Members
  • PipPip
  • 22 posts

Posted 26 January 2009 - 02:43 AM

Please let me know your MySQL and PHP version?
Also, who the host is?

Thanks

#15 bigdavid

bigdavid

    Member

  • Members
  • PipPip
  • 13 posts

Posted 26 January 2009 - 02:53 AM

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

#16 dwalker

dwalker

    Member

  • Members
  • PipPip
  • 22 posts

Posted 26 January 2009 - 03:04 AM

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.c...utomembersarea/

#17 bigdavid

bigdavid

    Member

  • Members
  • PipPip
  • 13 posts

Posted 26 January 2009 - 03:11 AM

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

#18 dwalker

dwalker

    Member

  • Members
  • PipPip
  • 22 posts

Posted 26 January 2009 - 06:41 AM

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.c...utomembersarea/

#19 bigdavid

bigdavid

    Member

  • Members
  • PipPip
  • 13 posts

Posted 26 January 2009 - 07:04 AM

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

#20 bigdavid

bigdavid

    Member

  • Members
  • PipPip
  • 13 posts

Posted 26 January 2009 - 07:20 AM

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"); ?>





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users