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]

OK, here's store_debug.txt for a real order:

April 27, 2009, 3:31 pm
FOUND
April 27, 2009, 3:31 pm
Post Request1 REQ:cmd=_notify-validate&mc_gross=8.97&protection_eligibility=Eligible&address_status=unconfirmed&payer_id=SE8VZPCZBVSBJ&$
April 27, 2009, 3:31 pm
Verified
April 27, 2009, 3:31 pm
NM Value:0
April 27, 2009, 3:31 pm
Trans Type:web_accept
April 27, 2009, 3:31 pm
Begin query:SELECT
                                                        ID_ITEM, ID_CART, ID_MEMBER, date, quantity
                                                 FROM {db_prefix}store_CART
                                                 WHERE ID_CART = 34 LIMIT 1
April 27, 2009, 3:31 pm
Begin query:SELECT emailnote, price, ID_GROUPToMove, groupexpiredays, needsstock,qtyinstock,stocklow, productname
                                                 FROM {db_prefix}store_item
                                                 WHERE ID_ITEM = 111 LIMIT 1
April 27, 2009, 3:31 pm
Cart Item Number:111
April 27, 2009, 3:31 pm
MC Gross:8.97
April 27, 2009, 3:31 pm
Transaction Logged
April 27, 2009, 3:31 pm
Enter Complete Transaction for : 111
April 27, 2009, 3:31 pm
Member IP 72.29.250.1
April 27, 2009, 3:31 pm
Cart data
April 27, 2009, 3:31 pm
Checking Product Codes
April 27, 2009, 3:31 pm
Product Codes
April 27, 2009, 3:31 pm
End Code Check
April 27, 2009, 3:31 pm
Getting Email Template
April 27, 2009, 3:31 pm
Finished email template
April 27, 2009, 3:31 pm
Send email
April 27, 2009, 3:31 pm
Finshed mail
April 27, 2009, 3:31 pm
Mark Basetket completed

Other orders look the same, I believe.

Also, for the same order, in paypal_logs.txt

April 27, 2009, 3:31 pm
cmd=_notify-validate&mc_gross=8.97&protection_eligibility=Eligible&address_status=unconfirmed&payer_id=SE8VZPCZBVSBJ&tax=0.00&address_street=5102-62+street&payment_date=12%3A05%3A32+Apr+27%2C+2009+PDT&payment_status=Completed&charset=windows-1252&address_zip=T9V-2E4&first_name=kevin&mc_fee=0.65&address_country_code=CA&address_name=kevin+jurovich&notify_version=2.8&custom=16&payer_status=verified&business=billing%40fmvperformance.com&address_country=Canada&address_city=lloydminster&quantity=1&verify_sign=A2S1fniRGsoquzRDbs4f5rc383f8AcXITYkz2ZXYUPZK73GSDqKQTnIn&payer_email=kevinjurovich%40sasktel.net&contact_phone=&txn_id=54Y13048XE609391N&payment_type=instant&last_name=jurovich&address_state=Alberta&receiver_email=drhamad%40fmvperformance.com&payment_fee=0.65&receiver_id=BUR5MN6JC5UJ4&txn_type=web_accept&item_name=Checkout&mc_currency=USD&item_number=checkout&residence_country=CA&handling_amount=0.00&transaction_subject=16&payment_gross=8.97&shipping=0.00

[drhamad]

Also, I just checked the table smf_store_transactions in the database - the orders are there.

So the db IS storing the orders... so it's something wrong in the output...

[SMFHacks]

That's part one. The next step is to check the ID_BASKET field for each of those transactions.

It should not be zero ID_BASKET then links to the store_basket table.
Inside the store_basket for that transaction there is a field called cart_items
cart_items is a list of ID_CART's separated by comma's for each cart entry in the cart.

The ID_CART can then be looked up store_cart table which contains the ID_ITEM and other item qty information and custom fields etc.

[drhamad]

That's part one. The next step is to check the ID_BASKET field for each of those transactions.

It should not be zero ID_BASKET then links to the store_basket table.
Inside the store_basket for that transaction there is a field called cart_items
cart_items is a list of ID_CART's separated by comma's for each cart entry in the cart.

The ID_CART can then be looked up store_cart table which contains the ID_ITEM and other item qty information and custom fields etc.

ID_BASKET is not empty.

Let's take an example, order ID_TRANS = 9, ID_BASKET = 18, an order for one item (111) for value $8.97.
cart_items = 36
ID_CART 36 in smf_store_cart does exist.

So in terms of the database, everything seems correct?

[SMFHacks]

That seems correct that is good news. That means the basket id is passed and there is a cart item which we can find the item id.

[SMFHacks]

Check out template_view_basket()  in the Store.template.php file

That is where the logic of the order detail page is.
Basically the basket id is passed. Gets a list of cart items. Cart items are separated by a comma. Then for each cart item it joins with store_item table to get product description and qty.

Next it checks if there are any custom fields if so they are then shown.

[drhamad]

Almost more of a pain because there's no apparent problem, eh?

Anyway, I haven't made any alterations to Store2.template.php.  It never calls anything in /store/, /store_pro/, or storeipn2.php, so there was no reason for me to touch anything.

[SMFHacks]

And there is no errors in the error log or anything when you visit the order detail page?

[SMFHacks]

If you are still having issues I can take a look but it would require an admin account that has access to the store and the error log. I can't recreate this issue on my test smf 2.0 forum with the store installed and from what it looks like it above all the data looks like it is there.

[drhamad]

OK I think we can close this now per our PM convo.

Thanks again.

Help Support the SMFHacks.com mod making.