NukeCoder

Joined: Jun 19, 2008 Posts: 28

First off I'm getting the following error now:

Code:

[03-16-09 12:57:54 pm][2](Line:208) mysql_fetch_array(): supplied argument is not a valid MySQL result resource [/home/koshy/public_html/mm/db/mysql.php]

It shows up on any of the digital shop pages, for example: http://mm.vorlondesigns.com/modules.php?name=Digital_Shop (it is in top left hand, when logged in)

I have talked to my provider about this first problem and they ran some die() tests and found the issue to be with: modules/Digital_Shop/app/Shop/public/main.php

Please fix this... as it is totally ruining my clients database and sales tracking...

I'm also unable to edit: function.paypalform.php it is showing jibberish in the latest version where as .7 showed the actual text.... and I NEED access to this page for adding a steamid section to the paypal form...

Please help !

Thanks,
- Koshy

Site Admin Joined: Oct 25, 2004 Posts: 921

That error message shown does not come from the shop, but from your nuke installation(I'm guessing your using either platinum or evo). The shop's error reporting picks up the message and displays it because you didn't turn the error reporting off in the lib/constants.php. If your provider thinks that error comes from the file you posted, they are way wrong. Also, as a guest, this error does not show up for me on your site.

To turn the debug messages off in lib/constants.php...Change

Code:

define('SHOP_DEBUG', true);

To

Code:

define('SHOP_DEBUG', false);

About the function.paypalform.php, I will send you a copy of that via PM.

Also in your email, you say that clients aren't being added. For this problem you need to make sure the following are true.

1. Make sure you uploaded the new lib/constants.php and you aren't using the old one.
2. You did not add any code to the lib/constants.php, this is no longer needed in 2.0.8
3. If you updated any other parts of your site, like nukesentinel, you made the edits outlined in the shop manual.

You also said in your email and another post that the shop isn't working with the latest version of MYSQL although you don't site any specific reason why you think this is the case. It is highly unlikely that any of these problems are due to your version of MYSQL.

Joined: Jun 19, 2008 Posts: 28

gotcha wrote:

That error message shown does not come from the shop, but from your nuke installation(I'm guessing your using either platinum or evo). The shop's error reporting picks up the message and displays it because you didn't turn the error reporting off in the lib/constants.php. If your provider thinks that error comes from the file you posted, they are way wrong. Also, as a guest, this error does not show up for me on your site.

To turn the debug messages off in lib/constants.php...Change

Code:

define('SHOP_DEBUG', true);

To

Code:

define('SHOP_DEBUG', false);

About the function.paypalform.php, I will send you a copy of that via PM.

Also in your email, you say that clients aren't being added. For this problem you need to make sure the following are true.

1. Make sure you uploaded the new lib/constants.php and you aren't using the old one.
2. You did not add any code to the lib/constants.php, this is no longer needed in 2.0.8
3. If you updated any other parts of your site, like nukesentinel, you made the edits outlined in the shop manual.

You also said in your email and another post that the shop isn't working with the latest version of MYSQL although you don't site any specific reason why you think this is the case. It is highly unlikely that any of these problems are due to your version of MYSQL.

Heya, thank you for responding.

Yea when your a guest it doesn't show errors, and I'm using PNC's latest version Razz

Thanks for sending me the file so that I can add the steamids part ;P

You know that date probably makes sense for when I updated sentinel because there were some hack threats which probably means I updated it around that time which would suggest why it stopped working. As for the MYSQL turns out another admin corrected him and mentioned that it was still the same version it use to be, so no worries there.

If I still have the problem after doing all you suggested above I will post back here and toss you another e-mail to let you know.

Thanks so very much,
- Koshy

Joined: Jun 19, 2008 Posts: 28

Heya,

Well your fixes worked all except one thing:

When a person makes a payment and it takes them back to the website page they get the following message:

Your purchase failed to complete. Paypal sent the following reason:
CUSTOMER INFORMATION
Name:
Email:

Transaction ID:
Total

But I still receive the funds. Can you help?

Thanks,
- Koshy

Code Authors · Joined: Dec 09, 2006 Posts: 335

Are you using your primary PayPal email address for the shop?

Joined: Jun 19, 2008 Posts: 28

Guardian wrote:

Are you using your primary PayPal email address for the shop?

Yes I am.

Site Admin Joined: Oct 25, 2004 Posts: 921

This can sometimes be caused by the browser warning for going to an unencrypted page and the user clicks no. This is something I will looking to work around in the future, but for now, I suggest editing the following template file...
templates/xxx/shop/return_txn.tpl

And put some sort of thank you message with a link to the "Your Purchases" page.

Code Authors · Joined: Dec 09, 2006 Posts: 335

Thats what I did with mine - added a message for the user to actually check their account before contacting me and included a link.
Some still don't read the message even though it is on the page and the emails Sad