Simple SEO URL (OLD version) [support thread]

giuly:

a question,
I have installed a demo version because I am doing the restyle of my site in a folder, and I read that I have to insert the path without subfolder...
so for example
www.mysite.com

but in mysite.com exists a functional site, it is safe for this site?
I modify something of this site?

Because I would do only a test on this subfolder to pass after at true installation

Thanks
:smile:
I think you misunderstood the installation note. What it meant is that, the
HTTP_SERVER And HTTPS_SERVER should not contain subfolder. If you use subfolder, put it in DIR_WS_CATALOG And DIR_WS_HTTPS_CATALOG

yes I misunderstood.
Ok I understood, thank you very much
:smile:

I've had the debug on since day one except for about a week where I had it off and in that time I had some errors that would have been real handy to have the logs for lol so I just leave it on now.

The orders are recorded correctly in the cart, the main problem is them being recorded as unique and going through the pdt twice, I activated the pdt so I could have them recorded as web_accept so the reward point mod would work correctly and I really want to get this fixed if I can, there HAS to be a reason it changed as I described, and if it's not PP and it's not the SSU then I don't know what it is cos nothing else changed in those 2 days lol but I need to at least rule out SSU so I can maybe post in the Paypal section and maybe get some help there :)

This is one of my more recent pp logs, there's two separate blocks of info, one with the web_accept and one with the unique a bit further down:

Jan 26 2009 9:44 -- IPN PROCESSING INITIATED. 
*** Originating IP: 66.211.170.66  notify.paypal.com

Jan 26 2009 9:44 -- IPN INFO - POST VARS received (sorted):
Array
(
    [business] => [email protected]
    [charset] => windows-1252
    [custom] => zenid=501c907147933c09d33885f03ac7b889
    [first_name] => Olive
    [handling_amount] => 0.00
    [item_name] => Haven Designz DigiScraps Purchase
    [item_number] => Store Receipt
    [last_name] => Bailey
    [mc_currency] => USD
    [mc_fee] => 0.37
    [mc_gross] => 2.00
    [notify_version] => 2.6
    [payer_email] => [email protected]
    [payer_id] => FZRCZN3DZDNSC
    [payer_status] => unverified
    [payment_date] => 06:44:10 Jan 26, 2009 PST
    [payment_fee] => 0.37
    [payment_gross] => 2.00
    [payment_status] => Completed
    [payment_type] => instant
    [protection_eligibility] => Ineligible
    [quantity] => 1
    [receiver_email] => [email protected]
    [receiver_id] => 775GBUTAAZW26
    [residence_country] => GB
    [shipping] => 0.00
    [tax] => 0.00
    [transaction_subject] => zenid=501c907147933c09d33885f03ac7b889
    [txn_id] => 3GR55745Y46903056
    [txn_type] => web_accept
    [verify_sign] => AQU0e5vuZCvSg-XJploSa.sGUDlpAACRvuExcZ3CWhZ6XCiTwDPsOXuo
)


Jan 26 2009 9:44 -- IPN INFO - POST VARS to be sent back for validation: 
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 866
Connection: close

Array
(
    [transaction_subject] => zenid=501c907147933c09d33885f03ac7b889
    [payment_date] => 06:44:10 Jan 26, 2009 PST
    [txn_type] => web_accept
    [last_name] => Bailey
    [residence_country] => GB
    [item_name] => Haven Designz DigiScraps Purchase
    [payment_gross] => 2.00
    [mc_currency] => USD
    [business] => [email protected]
    [payment_type] => instant
    [protection_eligibility] => Ineligible
    [verify_sign] => AQU0e5vuZCvSg-XJploSa.sGUDlpAACRvuExcZ3CWhZ6XCiTwDPsOXuo
    [payer_status] => unverified
    [tax] => 0.00
    [payer_email] => [email protected]
    [txn_id] => 3GR55745Y46903056
    [quantity] => 1
    [receiver_email] => [email protected]
    [first_name] => Olive
    [payer_id] => FZRCZN3DZDNSC
    [receiver_id] => 775GBUTAAZW26
    [item_number] => Store Receipt
    [handling_amount] => 0.00
    [payment_status] => Completed
    [payment_fee] => 0.37
    [mc_fee] => 0.37
    [shipping] => 0.00
    [mc_gross] => 2.00
    [custom] => zenid=501c907147933c09d33885f03ac7b889
    [charset] => windows-1252
    [notify_version] => 2.6
    [cmd] => _notify-validate
)


Jan 26 2009 9:44 -- IPN INFO - Confirmation/Validation response 
SUCCESS

Jan 26 2009 9:44 -- Breakpoint: 1 - Collected data from PayPal notification

Jan 26 2009 9:44 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

Jan 26 2009 9:44 -- Breakpoint: 2 - Validated transaction components

Jan 26 2009 9:44 -- Breakpoint: 3 - Communication method verified

Jan 26 2009 9:44 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us. 

Jan 26 2009 9:44 -- Breakpoint: 4 - Details:  txn_type=unique    ordersID = 0  IPN_id=0

   Relevant data from POST:
     txn_type = unique
     parent_txn_id = None
     txn_id = 3GR55745Y46903056

Jan 26 2009 9:44 -- Breakpoint: 5 - Transaction type (txn_type) = unique

Jan 26 2009 9:44 -- IPN INFO :: Currency/Amount Details: 
PayPal email address = [email protected]
 | mc_currency = USD
 | submitted_currency = USD
 | order_currency = USD
 | mc_gross = 2.00
 | converted_amount = 2.00
 | order_amount = 2

Jan 26 2009 9:44 -- Breakpoint: 5a - built order -- OID:504

Jan 26 2009 9:44 -- Breakpoint: 5b - PP table OID:Array
(
    [order_id] => 504
    [txn_type] => unique
    [module_name] => paypal (ipn-handler)
    [module_mode] => IPN
    [reason_code] => 
    [payment_type] => instant
    [payment_status] => Completed
    [pending_reason] => 
    [invoice] => 
    [mc_currency] => USD
    [first_name] => Olive
    [last_name] => Bailey
    [payer_business_name] => 
    [address_name] => 
    [address_street] => 
    [address_city] => 
    [address_state] => 
    [address_zip] => 
    [address_country] => 
    [address_status] => 
    [payer_email] => [email protected]
    [payer_id] => FZRCZN3DZDNSC
    [payer_status] => unverified
    [payment_date] => 2009-01-26 06:44:10
    [business] => [email protected]
    [receiver_email] => [email protected]
    [receiver_id] => 775GBUTAAZW26
    [txn_id] => 3GR55745Y46903056
    [parent_txn_id] => 
    [num_cart_items] => 
    [mc_gross] => 2.00
    [mc_fee] => 0.37
    [settle_amount] => 
    [settle_currency] => 
    [exchange_rate] => 
    [notify_version] => 2.6
    [verify_sign] => AQU0e5vuZCvSg-XJploSa.sGUDlpAACRvuExcZ3CWhZ6XCiTwDPsOXuo
    [date_added] => now()
    [memo] => 
)


Jan 26 2009 9:44 -- Breakpoint: 5c - PP table OID saved

Jan 26 2009 9:44 -- Breakpoint: 5d - PP hist ID:2198

Jan 26 2009 9:44 -- Breakpoint: 5e - PP hist_data:Array
(
    [paypal_ipn_id] => 2198
    [txn_id] => 3GR55745Y46903056
    [parent_txn_id] => 
    [payment_status] => Completed
    [pending_reason] => 
    [date_added] => now()
)


Jan 26 2009 9:44 -- Breakpoint: 5f - PP hist saved

Jan 26 2009 9:44 -- Breakpoint: 5g - new status code3

Jan 26 2009 9:44 -- Breakpoint: 5j - order stat hist update:Array
(
    [orders_id] => 504
    [orders_status_id] => 3
    [date_added] => now()
    [comments] => PayPal status: Completed  @ 06:44:10 Jan 26, 2009 PST
 Trans ID:3GR55745Y46903056
 Amount: 2.00 USD
    [customer_notified] => 
)


Jan 26 2009 9:44 -- Breakpoint: 5k - OSH update done

Jan 26 2009 9:44 -- Breakpoint: 5L - adding products

Jan 26 2009 9:44 -- Breakpoint: 5m - emailing customer

Jan 26 2009 9:44 -- Breakpoint: 5n - emptying cart

Jan 26 2009 9:44 -- Breakpoint: 6 - Completed IPN order add.    ordersID = 504  IPN_id =2198
```Paypal Tech said: *It is somewhere further down in the script processing (Breakpoint: 4) that the  txn_type is different, which leads me to believe it is being changed by the  script.
*
So I dunno lol *shrugs* I just would like to get it fixed if possible

Turn off SSU, place a test order, see how it goes.

If it goes as expected then we know where the problem is and can resolve it.

I've turned off SSU and created a 1 cent test product here: http://www.havendesignz.com/store/index.php?main_page=product_info&cPath=100&products_id=522

I only have the one PP account so I can't test this myself and would be grateful if you could lol, I never deleted the test account you created last time LOL

christon26:

I've turned off SSU and created a 1 cent test product here: http://www.havendesignz.com/store/index.php?main_page=product_info&cPath=100&products_id=522

I only have the one PP account so I can't test this myself and would be grateful if you could lol, I never deleted the test account you created last time LOL
Huhm, I have this
Sorry, we are not shipping to your region at this time.
Please contact us for alternate arrangements.

growls at self sorry I just fixed that lol

christon26:

growls at self sorry I just fixed that lol
Order placed.

[Attachment no longer available]Duplicated the order this time LOL but at least one shows up as web_accept LOL

christon26:

Duplicated the order this time LOL but at least one shows up as web_accept LOL
Okie I see it, please remove the attachment since i didnt use my paypal but a friend's and i dont want to have his info exposed.

Since you have duplicated even without ssu turns on, first you should investigate which other module that may result in this. Please note that when you turn ssu off then it is completely off, it does not interfere with anything at all. So if you turn it off and still see the duplicated content then you should fix that first.

Sorry about that, I should have smudged it out, removed :oops:

I am still confused though, the logs look pretty much the same, it seems to me that SSU in actuality prevented the order from being recorded twice rather than being the cause of the duplicate in the first place? Or am I totally off base LOL

christon26:

Sorry about that, I should have smudged it out, removed :oops:

I am still confused though, the logs look pretty much the same, it seems to me that SSU in actuality prevented the order from being recorded twice rather than being the cause of the duplicate in the first place? Or am I totally off base LOL
First, are you on 1.3.8a? Can you make sure all PP patches if any is applied?

Then do you have any other modification that may affect this? Search forum for paypal duplicate order and you will find a number of threads regarding this problem, you may want to go through that and try the solutions suggested.

Yep I'm on 1.3.8a, I will check and make sure I have all the patches applied though I'm pretty sure I do lol

Starting to read all the threads I can find now, lotta ppl been having this, I just don't know why it started right out of the blue, unless I go back to my original theory of Paypal making a change but it's like beating my head against a brick wall even getting any answers out of them lol

Thanx for all your help, nice to know SSU can be ruled out, I love this mod LOL

sorry because it needs module manager, where I find a guide to install step by step module manager?
please
:frusty:

giuly:

sorry because it needs module manager, where I find a guide to install step by step module manager?
please
:frusty:
Download it here
http://code.google.com/p/zencart-module-manager/downloads/list

Install note is inside

thank found and installed.
:clap:

I installed a clean version of ZC 1.3.8 on a PHP 5.2 server with MySQL 5
I've read your installment instructions and installed the newest SSU 3-5-8 I but then realized later i did not have module manager installed (step 1), So I got that installed and uploaded the SSU files again.
Now I am getting this error message:
1146 Table 'satur_zc1.configuration' doesn't exist
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('File extension', 'SSU_FILE_EXTENSION', '', 'Set the file extension you want (without the dot). Recommend: leave it blank. For more info please read the docs', @t4, 1, NOW(), NOW(), NULL, NULL), ('Name delimiter', 'SSU_NAME_DELIMITER', '-', 'Set delimiter to replace all non alpha-numeric characters in product/category names', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('-', '.'),'), ('ID delimiter', 'SSU_ID_DELIMITER', '-', 'Set delimiter separate product/category names and their ids', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('-', '.'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I tried to run the above SQL query in phpMyadmin manually with the prefix zen_ in front but I still get the same error.
I read somewhere it is because I installed module manager after installing SSU
What would you suggest?

This is a very very rare error, but I think you use a prefix for your tables and somehow the module could not pick it up and append to the query. Let me know if I'm wrong here, we will then proceed to resolve it.

Yes, the prefix is zen_ for all my tables thats why I tried to manualy run the script to the zen_configuration table.