Thank you both for your postings. DrByte - thank you for explaining what triggers the note...it wasn't the issue, but it allowed me to look at it in a different perspective, which then helped me...
Type: Posts; User: VS4Hire
Thank you both for your postings. DrByte - thank you for explaining what triggers the note...it wasn't the issue, but it allowed me to look at it in a different perspective, which then helped me...
Ok...I guess I don't know MySQL like I thought - but I know "how" it works...
If someone else wouldn't mind modifying the SQL file, basically it just needs to check to see if everything exists...
I ran into this last night myself - you keep getting the errors because the MySQL code that comes with Super Orders doesn't have an "IF" statement - it says "PUT THIS HERE" instead of "IF THIS...
I thought that was probably it too - but there's no other way to "attach" a payment with an order (that I found). The only reference to payment is in the "orders" table - it asks for payment method...
P.S. I also changed the values in the Downloads Manager - no change.
Thanks!
Michelle
Initially I believe they were set at -0- (unlimited for both) - but when that wasn't working I changed them to -365- and -365- and still no change.
Next?
Michelle
Thank you, but I'm fully aware of that part - I probably should have mentioned - I used "Credit Card" (module name of "cc") and "Set Order Status" to "3" (delivered).
Next?
Thanks!
Michelle
:Flush:
I've read the other postings for this particular situation and can't seem to figure out what's causing this.
Can someone please explain exactly WHAT (either one thing or a list) triggers...
I found the problem...
I didn't do the initial installation of Zen Cart 1.3.5 - but I DID perform the upgrade to 1.3.7 - I followed the instructions and replaced all files - or so I had thought....
Tried that and got:
#1064 - 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 'if...
Ok - just realized that won't work for PayPal payments - so I went back and changed it to
<td class="main"><?php echo $order->info['cc_type'] . ': ' . $order->info['cc_type']; ?></td>
...
That didn't work, but since I knew what to look for and what to replace it with, I went into admin/orders.php
I changed:
<td class="main"><strong><?php echo ENTRY_PAYMENT_METHOD;...
I guess what I meant was - is there somewhere else (besides my installation files) where I can go to download a new copy of the module?
Reason I ask this is because the cc_review file in question...
Just deleted the module and re-installed it - no changes.
I know I'm missing the lp.XXX tables - just not sure why or how to add them...
Is there a manual install of the linkpoint module that...
Which version of Zen Cart?
1.3.7
Which versions have you upgraded from?
I believe it was previously 1.3.5
How long have you had the Linkpoint module installed? ie: which version of Zen Cart?...
Linkpoint
Thanks!
Michelle
In the order detail screen it displays...
Invoice No. 2083Date Purchased:Thursday 27 September, 2007Payment Method:Credit Card
How do I get the "Credit Card" to show up as the actual credit card...
I'm getting the following error:
1054 Unknown column 'lp.customer_id' in 'where clause'
in:
[select count(*) as total from customers c, linkpoint_api lp where lp.customer_id = c.customers_id ]...
:clap: to SWGuy!!! Um...no :wacko: he he he
Ok, ok, ok...I'll use BT - wish me luck!
Thank you!!
Michelle
I saw that but was hoping there was a way to do it without installing an extra contribution...might just go ahead and try it (could be helpful in other areas too...)
Meanwhile, if anyone knows a...
I've searched all over the place, but the forum searcher doesn't like "1" or "one" or "get" so I only find answers that include "Buy" and "Free" - 2,000 posts later...
I would like to offer an...
I was able to do this using attributes...for every membership they purchase, they get a free calendar. The only downside is that if the free product is also one that you sell independantly, you will...
I have Linkpoint as a payment module...I use the Approval code to link ZenCart orders to the merchant account when reconciling cc transactions and entering into QuickBooks (it's the only number that...
This is exactly what I've been looking for as well...the only thing I would add is possibly the ability to trigger the member prices when the "membership item" is added to the cart...ie, sign up...
I finally realized that I couldn't search for "0 weight", but I searched the forum for "zero weight" and found 1 part of the problem...
Admin-> Configuration -> Shipping/Packaging -> Order Free...
Personally (from a shopper's perspective)...
Scenario 1: I would rather see purchase "X" # of mugs and "X" of jugs as seperate items. On the mug page I would like to see "Also purchased with this...
The file that you need to change is:
Includes/languages/english/product_info.php
Around line 16 look for
define('TEXT_PRODUCT_OPTIONS', 'Please Choose: ');
If you want to leave it...
Please forgive me if this has been said somewhere, I just couldn't find it...
We sell memberships (different levels with different prices.)
- Always Free Shipping: Yes
- Product Priced By...
Please forgive me if I missed it somewhere (I've been searching throug the forum for about an hour now...)
Is there a mod somewhere (I already have SuperOrders installed) that will allow you to...
I apologize -I should have tested it myself before taking the customers word for it - I was able to use that address to set up an account...sorry for the trouble!!!
Michelle
Only added 2 contributions that were plug-n-play meaning no changes to source code anywhere...PHP 4.4.4
I'm using 1.3.7 as well...is it an admin setting somewhere that might cause this?
Thanks!
Michelle
A potential customer cannot add her email address when trying to create an account - an example of the email address is [email protected]
I know for a fact that this is a valid email...
They ARE alpha sorted, which is exactly the problem...
For example, "Armed Forces America" (abbrev AA) is a very uncommon "state"...I would like that to show up at the end of the list rather...
Next question - would you know how to change the order of the abbreviations?
Such as sending AE (Armed Forces Eurpoe) to the end of the list?
Thanks!
Michelle
I just tried it with 1 state, and it worked like a charm - had a brainfart that the shipping I use is through USPS (so it uses the zip code I believe).
Thanks for the idea!
Michelle
I see what you mean - manually edit the database changing "Alabama" to AL
I can't really do that without knowing if it's gonna break the shipping calculation...not sure if shipping NEEDS to have...
I don't necessarily think it has anything to do with actual "Zones" because shipping calculates correctly and I only have NY set up in Zone Definitions (for sales tax - which also works properly).
...
I've done a search here for problems with state abbreviations and didn't find an answer, so here goes:
I would like US States & Canadian Provinces to show up in both admin as well as the customer...
Great, thank you so much!
Michelle
Basically the lines items of the cart...
Not sure how it would handle multi lines or even attributes...but basically what I'm looking for is a way to import the orders into a different database...
Thank you for sharing the contribution!
If you ever get around to adding order information, I would definitely be interested in receiving a copy!!
Again, THANK YOU!
Michelle
I'll give this a shot...
Thank you!
Michelle
Thanks for the info, but I don't seem to have that option in my version...
Dr Byte -
I'm having the same issue and definitely don't want to disable zones -
We have about 50% international, 50% in the US. It's been a very big problem - abandoned carts and tons of...
I'm having the same issue - and, although I appreciate your reply, I'm not very well knowledged in Java or php - so can you walk me through the process?
We can't be the only 2 using ZenCart that...
How do I set either side up so that when an order is placed through ZenCart (let's say the order # is 761), that same order # is referenced in LinkPoint?
Right now LinkPoint's order # shows up as...