Problem with the order log

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
  
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   HostRocket Webhosting for SMF
  
   Site Showcase

Advanced search

[drhamad]

Namely, when people order, the transaction goes through but nothing is appearing in the order log to tell me what they ordered.

Ideas?

[SMFHacks]

Click on the order number or the order detail link under transactions.

[drhamad]

Click on the order number or the order detail link under transactions.

Yeah, that's the problem - there's no orders in there.

I just edited one thing, waiting on someone to make another order to see if it works.

[SMFHacks]

If you setup a paypal developer sandbox account you can test the store using paypal's sandbox mode and use fake money to make test transactions.

[drhamad]

Unfortunately it looks like this problem is still occuring.  Any ideas what would cause this, assuming that PayPal IPN is pointing to the correct URL? (storeipn2.php, which in my case is in the Themes folder - I replace all instances of homedir and homeurl in SMF STore with themedir and themeurl).

[SMFHacks]

Just ran a test with RC1 and works ok on myside with a test item.

That could be it if you moved the storeipn.php to the themes folder.
storeipn2.php does call SSI.php which is normally located in main root folder of SMF.

Also check the the code of the store.template.php and store2.php since it does also set the notify_url which points to the ipn file.

[drhamad]

Just ran a test with RC1 and works ok on myside with a test item.

That could be it if you moved the storeipn.php to the themes folder.
storeipn2.php does call SSI.php which is normally located in main root folder of SMF.

Also check the the code of the store.template.php and store2.php since it does also set the notify_url which points to the ipn file.

I changed the call to SSI.php in storeipn2.php to ../../storeipn2.php, so that should be good.
It says in Payment Modules:

IPN Url: http://www.fordfusionclub.com/Themes/default/storeipn2.php

So notify_url is correct then, right?

Also if I go to that URL, I get:

Array ( [fault] => [storeipn2_php] => [start] => 0 ) Verified

Which looks like correct output to me?

Also, it is the same URL that is in the PayPal IPN settings.

[SMFHacks]

Inside storeipn2.php there is an option to turn on debugging. set STORE_DEBUG to 1 and inside that file in the StoreDebugLog function I belive make sure that the file it is writing to exists and is writable.

[drhamad]

Inside storeipn2.php there is an option to turn on debugging. set STORE_DEBUG to 1 and inside that file in the StoreDebugLog function I belive make sure that the file it is writing to exists and is writable.

Is this what you mean?  I changed paypal_debug to true from false.

Code:

// Enable Paypal debug
// Notes: make sure paypal_logs.txt exists and is writable
$paypal_debug = true;
StoreDebugLog('FOUND');
// Email address to which debug emails are sent to
$notify_email = $modSettings['store_set_contact_email'];

I also created paypal_logs.txt in both the root level and in /Themes/default, since I wasn't sure where it belonged.

[SMFHacks]

Also do

Code:

define('DEBUG_STORE','0');

Change to

Code:

define('DEBUG_STORE','0');

And create and make writable store_debug.txt

[drhamad]

Great, done (I assume you mean change that to '1')

[drhamad]

I just noticed this in the SMF Error log:

http://www.mazda6drivers.com/index.php?http://www.fordfusionclub.com/Themes/default/storeipn2.php
Database Error: 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 'LIMIT 1' at line 4
File: /home/ffc/public_html/Themes/default/storeipn2.php
Line: 235

235 is:

                                                $cartResult = $smcFunc['db_query']('', "
                                                SELECT
                                                         ID_ITEM, ID_CART, ID_MEMBER, date, quantity
                                                 FROM {db_prefix}store_cart
                                                 WHERE ID_CART = $id_cart LIMIT 1");
                                                $cartRow = $smcFunc['db_fetch_assoc']($cartResult);
                                                $smcFunc['db_free_result']($cartResult);

[SMFHacks]

Check the store log file. store_debug.txt the $id_cart should always be present unless if for some reason the cart id was not passed.

[drhamad]

From store_debug.txt:

April 21, 2009, 9:50 pm
FOUND
April 21, 2009, 9:50 pm
Post Request1 REQ:cmd=_notify-validate&transaction_subject=&payment_date=04%3A42%3A10+Apr+21%2C+2009+PDT&txn_type=subscr_payment&subscr$
April 21, 2009, 9:51 pm
Verified
April 21, 2009, 9:51 pm
NM Value:0
April 21, 2009, 9:51 pm
Trans Type:subscr_payment
April 21, 2009, 9:51 pm
Begin query:SELECT
                                                        ID_ITEM, ID_CART, ID_MEMBER, date, quantity
                                                 FROM {db_prefix}store_CART
                                                 WHERE ID_CART =  LIMIT 1
April 21, 2009, 11:09 pm
FOUND
April 21, 2009, 11:09 pm
Post Request1 REQ:cmd=_notify-validate&mc_gross=234.00&protection_eligibility=Eligible&address_status=confirmed&payer_id=88NR6LVXWXA5E&$
April 21, 2009, 11:09 pm
Verified
April 21, 2009, 11:09 pm
NM Value:0
April 21, 2009, 11:09 pm
Trans Type:send_money

Also, the error found in the SMF error log (that I reported above) occurred at 9:51:00

Lastly, I didn't receive any payments in PayPal around that time, so this doesn't seem to be a completed order...

Edit:  The 9:50 information in the log above isn't about the store at all - it's a recurring payment that has nothing to do with the store or even with SMF.

[SMFHacks]

That would cause that sql error. I will add some filtering for the next update to help reduce those errors from non Store payments.

Help Support the SMFHacks.com mod making.