in need of major help

[theanalogkid]

the store i set up has gone crazy it seems. the owner of the company i set the store up for is getting notices of payment through paypal, but isn't getting an e-mail anymore about orders. also, when i go to get info on what a customer ordered, or to search for the customer, i get this error: "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 '-20, 20' at line 1

 

select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.customers_id = '3' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20

 

[TEP STOP]"

 

i've gotta this fix, any help will be great.

[jpweber]

Please read pages 1 and 2 from this link: http://www.oscommerce.com/forums/index.php?sho...144095&st=0

[theanalogkid]

ok cool, looks like that will address the error I'm getting. however, what about first part?:

 

"the owner of the company i set the store up for is getting notices of payment through paypal, but isn't getting an e-mail anymore about orders"

[jpweber]

Did you

 

(1) Download the only paypal contribution that works? The OSC default won't work. You need to download and install: The Correct Paypal Contribution.

 

(2) Set up a business account on paypal.com.

 

(3) Go into paypal, and log in. Then go to "profile". Then go to "instant payment notification preferences", and then set the correct path to your ipn.php file? This means do that, then set the correct URL to your ipn.php, for instance, http://www.johndoewebsite.com/catalog/ext/...modules/ipn.php, or something.

 

(4) Go to your newly installed paypal contribution in your ADMIN tool (www.yoursite.com/admin, or www.yoursite.com/catalog/admin, or soemthing, and configure your paypal properly?

 

All of the aforementioned steps need to be taken if you want to get paypal to work effectively on your website.

[theanalogkid]

Gosh, it's been toooo long since I've done any of this. I can't even figure out how to upgrade my OSCommerce store, nor can I get this PayPal contribution installed.

 

Incidentally, the PayPal thing I had been using seemed to have been working, it just seems that now the store owner, nor myself, are getting order e-mails, just e-mails saying the PayPal payment was recieved.

[theanalogkid]

anyone have any ideas about:

 

"Incidentally, the PayPal thing I had been using seemed to have been working, it just seems that now the store owner, nor myself, are getting order e-mails, just e-mails saying the PayPal payment was recieved."

 

It seems the PayPal plugin stuff had been working correctly previously, it just seems that now it isn't.

[jpweber]

You CAN install the above-mentioned PayPal contribution, and you must install it. It's just a matter of following the readme instructions, which any "php dummy" can do. I installed mine myself -- no problems -- and I knew nothing of PHP at the time -- and knew nothing of paypal at the time.

 

As the slogan for Nike goes, "Just Do It!" -- it will take 1 hour but it'll be worth it. Download and install the contribution, and modify Paypal's business account of yours, and modify Paypal -- the newly installed one -- in your admin (and delete/remove all other payment modules).