Subscription System Problems

[helkoryo]

Hello there

We have recently attempted to get the subscription system on our site (Perfectly Captured Gallery - Main Index) up and running. We have followed the following instructions:

6.2 paid subscriptions

Posts numbered 16 and 22 in the above thread.

We have got a subscription set up. We can edit this subscription in the admin pannel and in the subscriptions section on the site.

Whenever a member attempts to subscribe however, they were recieving this error message:

Warning: require_once(/HOMEDIR/languages/english/emails.php) [function.require-once]: failed to open stream: No such file or directory in /HOMEDIR/payment_verification.php on line 75

Fatal error: require_once() [function.require]: Failed opening required '/HOMEDIR/languages/english/emails.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /HOMEDIR/payment_verification.php on line 75

To solve the above error we changed line 75 in payment_verification from

require_once("{$Globals['PP_PATH']}/languages/{$Globals['pplang']}/emails.php");

To

require_once("{$Globals['PP_PATH']}/languages/{$Globals['pplang']}.php");

My freind testing our system refreshed once and got a success message of some sort.

After this i checked in the database through PHPMyAdmin and the Photopost list subscribers option. there are three users in there (id 1-3) with NO userid's. Each users start and end dates are the same (but not to each other, i.e. users 1 start and end dates are not the same as users 2 or 3's sttart and end dates) and my freinds profile does NOT show him as being in a subscription.

I am completely stumpped on what to try next, your advice would be greatly apprechiated.

[Chuck S]

In payment_verification.php this

Content visible to verified customers only.

should be

Content visible to verified customers only.

[helkoryo]

Ok, we have followed the step you suggested above, and tested the system again

When our test subject bought a subscription he recieved this error:

"Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in HOMEDIR/payment_verification.php on line 55"

The whole of line 55 is below

" list( $adid, $admount, $subid, $subuser, $subname, $subgroup, $subdays ) = mysql_fetch_row($rows);"

the "$rows" variable in line 55 is below

" $rows = ppmysql_query("SELECT p.id,p.amount,p.sub_id,p.user_id,s.name,s.gid,s.days
FROM {$Globals['pp_db_prefix']}payments p
LEFT JOIN {$Globals['pp_db_prefix']}subscriptions s ON s.id=p.sub_id
WHERE p.ad_key='$item_number'", $link);
"

Now after the user registers, it appears that nothing is entered into the database at all.

Please advise

also - what is "ppmysql_query"? i have never heard of this.

[Chuck S]

Reapply that change. ad_key should be pmt_key in that query.

[helkoryo]

Thanks that appears to have solved the issues of the subscription system not entering the information into the database.

However - when i look at the test users profile (that just registered), it states that there are no gallery subscriptions for this member, even though the user is in the database and the photopost list subscriptions page as subscribed.

[Chuck S]

Yes this before or after your last change?

[Chuck S]

There is a list subscribers function in admin that shows who is subscribed

[helkoryo]

Originally Posted by Chuck S

There is a list subscribers function in admin that shows who is subscribed

yes we know - but we would like to be able to see this when we look at a users profile page on photopost, under "statistics".

[Chuck S]

Thats just not a feature in the software at this point.

[helkoryo]

Originally Posted by Chuck S

Thats just not a feature in the software at this point.

so what is the "Gallery Subscriptions" list in the users profile for? am i mis-reading what its supposed to do?

[Chuck S]

It is for users to click to list the subscriptions you list so they can purchase one.