X-Cart forums

[alru111]

Originally Posted by moneysaver67

You may have grabbed the previous version of the code. I noticed this error and updated my first post.

Please check that your code contains

          if( empty( $orderid ) ) $orderid = $GLOBALS[secure_oid][0];  

So it should look like this:

function func_order_details( $orderid )
      {
          global $sql_tbl;
          // Grab the encrypted details
             
          if( empty( $orderid ) ) $orderid = $GLOBALS[secure_oid][0];  

          ...

I checked the code, it looks just like you advised but still the error
It appears in the 'Order initial notification' email sent to the merchant, not the customer copy though


Payment method:
Credit Card INVALID SQL: 0 :
SQL QUERY FAILURE: SELECT details FROM xcart_orders WHERE orderid =
: N/AxxN/A

[moneysaver67]

Originally Posted by carpeperdiem

I'm going to Firefox right now... well WHADDA YOU KNOW! Wow, that's a great mod! Moneysaver, you now have 2 superb mods -- any others?

In fact, I have a great mod I just made for decreasing the load time of product pages. This mod is mainly good for products with MULTIPLE detailed images, which basically doesn't load any detailed images, even the first, until the product descriptions, etc are fully loaded. Then, only the first is loaded, and the rest are displayed only when the user chooses to advance to the next image in the list. The images queue using a preloader, and display proper image on success or "Image Could Not be Found" on an error.

I'll probably post this one soon. It's a quick/easy mod, too

[moneysaver67]

What ACTIVE payment methods do you offer?

What are their names, as defined in the admin section of x-cart?

In short, the error is that the SQL statement does not know the ORDER # of the last order, which is kind of odd. There is a check that sees if the order_id param sent is empty, to reference from GLOBALS, but still coming up blank. I could modify to error cleanly and simply display the original onError, but I'd like to see if we can't figure out what's going in your situation...

[carpeperdiem]

Originally Posted by moneysaver67

What ACTIVE payment methods do you offer?

What are their names, as defined in the admin section of x-cart?

- Credit Card
- Gift Certificate

I have not enabled the gateway yet, still only testing (manual processing mode).

I had to pull the mod for now.

Could this still be a whitespace issue (not just safari, but all macintosh handling of text) ?

I've learned the hard way that php is sensitive to whitespace... I use the gold-standard of text editors for the mac - Text Wrangler - textwrangler has unix and dos and mac and unicode modes (and of course, I'm in unix mode)

Any ideas? Thanks!

[carpeperdiem]

Originally Posted by moneysaver67

In fact, I have a great mod I just made for increasing the load time of product pages.

Surely, you mean increasing load SPEED (or conversely, REDUCING load time - yes?

At first I thought you were joking, until I kept reading...

[alru111]

Originally Posted by moneysaver67

In fact, I have a great mod I just made for increasing the load time of product pages. This mod is mainly good for products with MULTIPLE detailed images, which basically doesn't load any detailed images, even the first, until the product descriptions, etc are fully loaded. Then, only the first is loaded, and the rest are displayed only when the user chooses to advance to the next image in the list. The images queue using a preloader, and display proper image on success or "Image Could Not be Found" on an error.

I'll probably post this one soon. It's a quick/easy mod, too

That one I could use too
I used a custom template for my store and the way I placed the tables when loading it first shows side boxes, they are kind of collapsed into the middle. It makes the whole site look distorted esp on slow connections.

[moneysaver67]

Originally Posted by carpeperdiem

Surely, you mean increasing load SPEED (or conversely, REDUCING load time - yes?

At first I thought you were joking, until I kept reading...

OK OK..you caught me. ( I've editted the post )

[ecommerce]

carpe, does the payment options determine if this works or not?


I will like to have paypal API, but it should just read credit card.
(paypal should be invisible)

fax order

phone order

money order

gift certificate

will it work with those options?

[carpeperdiem]

Originally Posted by ecommerce

carpe, does the payment options determine if this works or not?

I have no idea... it does not work for me, with only "Credit Card" and "Gift Certificate" enabled.

Maybe moneysaver or another expert will chime in... this should be standard-issue, and I am willing to buy this from x-cart if the community doesn't have a solution.

It is against visa/mastercard rules to print the card number on a receipt -- but without some kind of card reference for the customer, they may not remember which card they used for refunds or basic accounting -- it's a common courtesy to give the customer this info... and sending an un-encrypted card number via email is simply reckless.

Hopefully someone will step forward. I'm taking this to x-cart next week.

Thanks!

Jeremy

[moneysaver67]

Originally Posted by ecommerce

carpe, does the payment options determine if this works or not?


I will like to have paypal API, but it should just read credit card.
(paypal should be invisible)

fax order

phone order

money order

gift certificate

will it work with those options?

In short, the error is that the SQL statement does not know the ORDER # of the last order, which is kind of odd. There is a check that sees if the order_id param sent is empty, to reference from secure_oid, but still coming up blank.

This should be an easy fix... Does anyone know the best way to reference the Order ID of the order that just occurred?

The following returns the decoded order details from the orders table. Details for a given Order ID are returned based on the order_id parameter, $GLOBALS[orderid].

$dec_details = func_order_details( $GLOBALS[orderid] );

If

$orderid

is not the correct value to pass, please let us know.

There is a check to see if the param passed is empty, to pull from

$secure_oid[0]

In summary, the issues experienced are all a result of the missing orderid, which in turn causes the SQL to crash, which reports the 'N/A', etc...

What's more interesting is that it has been working perfectly fine on my end, but not for others?