[ABD] Membership Management with Paypal IPN

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Locked
User avatar
Bruno36
Registered User
Posts: 287
Joined: Fri Mar 02, 2007 2:16 pm
Location: france
Name: bruno astie
Contact:

Re: [BETA] Membership Management with Paypal IPN

Post by Bruno36 »

Hello!

When I click on http://www.scooter-chinois-4t.com/board ... &mode=list
I have a nice error message
Erreur générale
SQL ERROR [ mysqli ]

Unknown column 'm.date_joined' in 'field list' [1054]

SQL

SELECT u.user_id, user_colour, username, user_lastvisit, user_posts, m.reminderdate, m.remindercount, m.date_joined, pfd.*, m.renewal_date, ug.user_id as in_group, m.user_id as in_membership, g.group_name FROM (phpbb_users u) LEFT JOIN phpbb_membership m ON (m.user_id = u.user_id) LEFT JOIN phpbb_profile_fields_data pfd ON (pfd.user_id = u.user_id) LEFT JOIN phpbb_user_group ug ON (ug.user_id = m.user_id AND ug.group_id=m.group_id) LEFT JOIN phpbb_groups g ON (g.group_id=m.group_id) WHERE user_type=0 AND m.user_id IS NOT NULL AND m.group_id IN (5) ORDER BY renewal_date ASC LIMIT 20

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 224
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: [ROOT]/includes/functions_membership.php
LINE: 429
CALL: dbal->sql_query_limit()

FILE: [ROOT]/includes/acp/acp_membership.php
LINE: 514
CALL: view_members()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_membership->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
Excuse me for my poor English, I speak french
Bruno36
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [BETA] Membership Management with Paypal IPN

Post by the pips »

MydnyteSyn wrote:Also, the instructions say:
If you want to use the Payments system with this mod yo will also need to run createPayment.php. This will set up the configs and create the modules.
Once you've finished installing everything please remember to purge your cache when you've finished.
But there is no createPayment.php file.
That's right. I'm splitting the mod into two, membership & payment. I'll modify the instructions to that effect.
MydnyteSyn wrote: In the instructions it says:

Find
Tip: This may be a partial find and not the whole line.

Code: Select all

				$message = $message . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>');
Replace with
Tip: Replace the preceding line(s) to find with the following lines.

Code: Select all

				if ($premium_sub_option==1)
				{
					$auth->login($data['username'], $data['new_password']);
					if (empty($user->lang['CONTINUE_APPLICATION']))
					{
						redirect(append_sid("{$phpbb_root_path}application.$phpEx","mode=apply&member=1&r=1&i={$user_id}&g={$config['ms_subscription_group']}"));
					}
					else
					{
						$message = sprintf($user->lang['CONTINUE_APPLICATION'], '<a href="' . append_sid("{$phpbb_root_path}application.$phpEx","mode=apply&member=1&r=1&i={$user_id}&g={$config['ms_subscription_group']}") . '">', '</a>');
					}
				}
				else
				{
					if ($premium_sub_option==2)
					{
						redirect(append_sid("{$phpbb_root_path}application.$phpEx","mode=apply&member=1&r=1&i={$user_id}&g={$config['ms_subscription_group']}"));
					}
					$message = $message . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>');
				}
				trigger_error($message);
But, this line:

Code: Select all

trigger_error($message);
is already there. Should there be two instances of trigger_error($message); ? If there should only be the single instance, you might want to remove that line from the instructions to avoid confusion :)

Thanks for that, I'll amend the install file.

Regards
Doug
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [BETA] Membership Management with Paypal IPN

Post by the pips »

MydnyteSyn wrote:After restoring my forum and making fresh back ups of both the files and the database, I tried installing this mo one more time as it's perfect for the non-profit organization I'm designing a site and forum for. These are the results:
  • createMembership.php doesn't do anything. It's just a blank white page.

    Cannot access the forum/acp/portal - all blank white pages
That normally means there's an error in php but I can't reproduce it. I'm guessing you're using Internet Explorer? If so, try Firefox as it's a little more helpful in debugging software.
MydnyteSyn wrote: Should include edits for subSilver2. I know I'm not the only person using a theme that is based on subSilver2.[/list]

I'm going to continue watching this topic as I hope the bugs all get worked out. I really like/need a mod like this. :)
I'm not using subsilver2 and as this is still developing I've no plans to include edits for it at this stage.

Regards
Doug
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [BETA] Membership Management with Paypal IPN

Post by the pips »

alterastro wrote:
the pips wrote:Wow, I can only assume the package is corrupt. I'm currently working on splitting the module into two. Membership and payments. I've already uploaded the membership component (see 1st post) and I'm hoping to get the payment mod tidied away very quickly.

I'd recommend you install the membership element first and get that working the way you want before delving into the mysteries of Paypal :lol:

Regards
Doug
Many thanks Doug

I uninstalled to original and the Membership component seemed to install without errors but when I click Membership on the board index I get:
General Error
SQL ERROR [ mysql4 ]

Unknown column 'shopping_basket' in 'field list' [1054]

SQL

SELECT shopping_basket FROM phpbb_sessions WHERE session_id = "cfc6ef64b3db4d2b9faf0ca8d4eb54b2"

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/payment_class.php
LINE: 243
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/payment_class.php
LINE: 53
CALL: payment_class->retrieve_shopping_basket()

FILE: [ROOT]/application.php
LINE: 101
CALL: payment_class->__construct()
Any ideas?

Thanks

Nick
Hi Nick,
That's very odd. There's an entry in createMembership that adds the shopping basket column to the sessions table. Could you check lines 163 and 164. They should read

Code: Select all

		'table_column_add' => array(
			array(SESSIONS_TABLE, 'shopping_basket', array('TEXT', '')),
		),
Regards
Doug
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [BETA] Membership Management with Paypal IPN

Post by the pips »

Bruno36 wrote:Hello!

When I click on http://www.scooter-chinois-4t.com/board ... &mode=list
I have a nice error message
Erreur générale
SQL ERROR [ mysqli ]

Unknown column 'm.date_joined' in 'field list' [1054]

/quote]
Hi Bruno,
Which version are you installing? I've just checked version 0.1.0 again and the column date_joined is definitely being added. Could you check createMembership.php at line 153. it should be

Code: Select all

					'date_joined' => array('INT:11',0),
Regards
Doug
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [BETA] Membership Management with Paypal IPN

Post by the pips »

LATEST NEWS!

I'm splitting the mod into two parts Membership Management and a Payments Module. As a result version 0.1.0 and newer will be completely new and not an update of earlier versions. Please uninstall earlier versions before trying to install v0.1.0.

Thanks
Doug
User avatar
Bruno36
Registered User
Posts: 287
Joined: Fri Mar 02, 2007 2:16 pm
Location: france
Name: bruno astie
Contact:

Re: [BETA] Membership Management with Paypal IPN

Post by Bruno36 »

the pips wrote:
Bruno36 wrote:Hello!

When I click on http://www.scooter-chinois-4t.com/board ... &mode=list
I have a nice error message
Erreur générale
SQL ERROR [ mysqli ]

Unknown column 'm.date_joined' in 'field list' [1054]

/quote]
Hi Bruno,
Which version are you installing? I've just checked version 0.1.0 again and the column date_joined is definitely being added. Could you check createMembership.php at line 153. it should be

Code: Select all

					'date_joined' => array('INT:11',0),
Regards
Doug
Membership Management 0.1.0 Beta

My code is at line 305

Code: Select all

										'date_joined' => array('INT:11',0),
Excuse me for my poor English, I speak french
Bruno36
alterastro
Registered User
Posts: 131
Joined: Wed Jul 30, 2008 7:21 am
Location: Surrey, UK

Re: [BETA] Membership Management with Paypal IPN

Post by alterastro »

the pips wrote: Hi Nick,
That's very odd. There's an entry in createMembership that adds the shopping basket column to the sessions table. Could you check lines 163 and 164. They should read

Code: Select all

		'table_column_add' => array(
			array(SESSIONS_TABLE, 'shopping_basket', array('TEXT', '')),
		),
Regards
Doug
Hi Doug

OK, checked that and yes its there. So I unistalled it all again and reinstalled - this time I do get an error:
Adding a new column named shopping_basket to table phpbb_sessions
SQL ERROR The used table type doesn't support BLOB/TEXT columns
Is there a way around this?

Cheers

Nick
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [BETA] Membership Management with Paypal IPN

Post by the pips »

alterastro wrote:
the pips wrote: Hi Nick,
That's very odd. There's an entry in createMembership that adds the shopping basket column to the sessions table. Could you check lines 163 and 164. They should read

Code: Select all

		'table_column_add' => array(
			array(SESSIONS_TABLE, 'shopping_basket', array('TEXT', '')),
		),
Regards
Doug
Hi Doug

OK, checked that and yes its there. So I unistalled it all again and reinstalled - this time I do get an error:
Adding a new column named shopping_basket to table phpbb_sessions
SQL ERROR The used table type doesn't support BLOB/TEXT columns
Is there a way around this?

Cheers

Nick
That's a bit mad. UMIL definitely supports type text. Can I ask which db version you're running?

Regards
Doug
alterastro
Registered User
Posts: 131
Joined: Wed Jul 30, 2008 7:21 am
Location: Surrey, UK

Re: [BETA] Membership Management with Paypal IPN

Post by alterastro »

the pips wrote:
That's a bit mad. UMIL definitely supports type text. Can I ask which db version you're running?

Regards
Doug
Yes, of course... Here's the error log:
Membership Management
PHP Version: 5.2.17
DBMS: MySQL 5.0.91-log
phpBB3 Version: 3.0.11

Adding a new column named shopping_basket to table phpbb_sessions
SQL ERROR The used table type doesn't support BLOB/TEXT columns
Is that what you need?

Cheers

Nick
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [BETA] Membership Management with Paypal IPN

Post by the pips »

Hmm, Can't see anything wrong there. If you're ok with phpmyadmin could you try adding the column yourself?

Let me know how you get on.

Doug
alterastro
Registered User
Posts: 131
Joined: Wed Jul 30, 2008 7:21 am
Location: Surrey, UK

Re: [BETA] Membership Management with Paypal IPN

Post by alterastro »

I can do the basics, but I'm not sure from those errors what I've got to add where?

Also, if the install failed with that error would everything else have installed or does it 'stop on error'?

Thanks Doug

Nick
alterastro
Registered User
Posts: 131
Joined: Wed Jul 30, 2008 7:21 am
Location: Surrey, UK

Re: [BETA] Membership Management with Paypal IPN

Post by alterastro »

OK, I tried manually adding the column, but get the same error. But I think I know why. The phpbb_sessions table is a type 'Memory' which doesn't support TEXT

Image

I did try setting it as CHAR, which did allow me to add it, but then I couldn't log in to my board - it would say I was logged in and then drop me back out again. When I removed the shopping_basket column I could log in again?

Help!?!

Thanks

Nick
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [BETA] Membership Management with Paypal IPN

Post by the pips »

Ah, that explains it! I've not come across the use of Database engine type Memory before but it doesn't support text or blob. I can't think of an alternative to putting it back to the mySql default of myISAM.

Regards
Doug
alterastro
Registered User
Posts: 131
Joined: Wed Jul 30, 2008 7:21 am
Location: Surrey, UK

Re: [BETA] Membership Management with Paypal IPN

Post by alterastro »

the pips wrote:Ah, that explains it! I've not come across the use of Database engine type Memory before but it doesn't support text or blob. I can't think of an alternative to putting it back to the mySql default of myISAM.

Regards
Doug

Do you know if it will have an effect on anything else if I change the type?
Locked

Return to “[3.0.x] Abandoned MODs”