Paypal payments standard not recording orders in admin.

[dspeak35640]

Ok, I used oscommerce for many years, then found zencart. I love it. I have set up 3 other sites using this version V154. All the other sites work fine with paypal payments standard.

Now I have decided to migrate my main store from oscommerce to zencart. Using version 154. I have the new store in a sub directory of my main store. All works great except the payment. Like I said, I am using paypal payments standard on the other sites and they working fine. With this main store the orders are not being recorded in admin. I get notification from paypal, but thats it. Also after the checkout and payment at paypal I get a screen from paypal with the confirmation, but on my other sites it will go back to the stores checkout success page. I click on the paypal site to return to the store and when I do I get a white screen with this: WARNING: An Error occurred, please refresh the page and try again. I refresh the page and am taken to the checkout success page.

When I check orders in admin, I have no orders and the same warning just below the legend and above the column names: WARNING: An Error occurred, please refresh the page and try again.

I know everyone says not to use paypal payments standard, but the flow works great with my site and it is working on all my other sites.

Thanks for any and all help.

[DrByte]

It appears the order details aren't being saved because of PHP Fatal Errors occurring ... as evidenced by the error message you're seeing in various places.
Best to fix the errors as the first step.

The first place I turn for things like that is to type the error message into the search, especially the FAQs search. For this particular error that brings up this article:
http://www.zen-cart.com/content.php?...-and-try-again

And, that link also includes reference to this related guidance: http://www.zen-cart.com/content.php?124-dealing-with-errors

[dspeak35640]

Ok, now this really sucks.

I switched to paypal express checkout. Now no order is showing up. Not even in my paypal account. What the heck is up?

[dspeak35640]

When I use express checkout, I get no order. Not recorded at paypal and not my site. When I use express checkout and continue through my site, from step 2 to step 3 I get "server time out" if I refresh it will then go to step 3 to confirm.

This is really frustrating. I am using inmotionhosting also. Please help someone, anyone.

[DrByte]

Until you resolve the PHP errors you're getting, you're going to have undesired results. The links I posted tell you about what's wrong and how to investigate.

[dspeak35640]

Ok Dr. I am following orders.

I checked the log file and this is the error I am getting:

[10-May-2016 10:22:13 America/Los_Angeles] PHP Fatal error: 1054:Unknown column 'o.shipping_method' in 'field list' :: select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address from (orders_status s, orders o ) left join orders_total ot on (o.orders_id = ot.orders_id and ot.class = 'ot_total') where (o.orders_status = s.orders_status_id and s.language_id = '1') order by o.orders_id DESC limit 0, 1 ==> (as called by) /home/bestfa7/public_html/newzen/zcadmin/orders.php on line 871 <== in /home/bestfa7/public_html/newzen/includes/classes/db/mysql/query_factory.php on line 155

[dspeak35640]

Ok Doctor, I will follow what you have prescribed.

These are two of my log files:

Cannot redeclare class base in /home/bestfa7/public_html/newzen/includes/classes/class.base.php on line 17

[10-May-2016 11:52:23 America/Los_Angeles] PHP Fatal error: 1054:Unknown column 'o.shipping_method' in 'field list' :: select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address from (orders_status s, orders o ) left join orders_total ot on (o.orders_id = ot.orders_id and ot.class = 'ot_total') where (o.orders_status = s.orders_status_id and s.language_id = '1') order by o.orders_id DESC limit 0, 1 ==> (as called by) /home/bestfa7/public_html/newzen/zcadmin/orders.php on line 871 <== in /home/bestfa7/public_html/newzen/includes/classes/db/mysql/query_factory.php on line 155

[DrByte]

[10-May-2016 10:22:13 America/Los_Angeles] PHP Fatal error: 1054:Unknown column 'o.shipping_method' in 'field list' :: select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address from (orders_status s, orders o ) left join orders_total ot on (o.orders_id = ot.orders_id and ot.class = 'ot_total') where (o.orders_status = s.orders_status_id and s.language_id = '1') order by o.orders_id DESC limit 0, 1 ==> (as called by) /home/bestfa7/public_html/newzen/zcadmin/orders.php on line 871 <== in /home/bestfa7/public_html/newzen/includes/classes/db/mysql/query_factory.php on line 155

The "unknown column" error means that your database query is looking for data from the mentioned field name (o.shipping_method refers to a field called "shipping_method" on the "orders" table) but the field is missing from that table in your database.

So, you'll need to put that field back (it's normally there in a fresh install of v1.5.4). Not sure how you ended up deleting it from your database table. It's pretty important.

Now, while this particular example of the error is showing up when using the Admin orders screen, the same problem will definitely affect checkouts, meaning you'll not have any sales recorded until you fix your database.

[dspeak35640]

Thank you Doctor.

I just compared the orders table in the db with the site that is working. Several columns missing. Not sure how that happened, but at least I am now heading somewhere productive.

Thanks for putting up with a newb like me.

[DrByte]

Cannot redeclare class base in /home/bestfa7/public_html/newzen/includes/classes/class.base.php on line 17

Without the rest of the context it's hard to nail down what's triggering this.
Zen Cart normally automatically loads the class.base file as part of its configuration in the /includes/auto_loaders/ folder (or for Admin, it's in the admin/includes/auto_loaders).
If you're getting an error like that it means you've added something that's causing the existing list of files to load to be duplicated. So, either you've added files in those folders that are from badly-written plugins, or you've duplicated a file to make a backup of it, but left its filename matching the "config.XXXXXXX.php" pattern so even though you thought you were being smart to make a backup, you made the backup wrong. If that's what you did, then use .bak instead of .php for files that you're leaving behind as backups.

Another cause for "cannot redeclare" is when a PHP file has an "include" statement in it to load up the specified file. And in the case of class.base.php there's no good reason for any file in Zen Cart to mention that file's name other than the default files in the auto_loaders folders.
One other possibility is that you've got a script that loads itself recursively, ie: over and over it calls itself and restarts the Zen Cart core code over and over in an endless loop. That's hard to track down, but the best place to start is by identifying everything that's different from the original Zen Cart core files. Here's a process outlining how to identify what's been altered on your server: http://www.zen-cart.com/wiki/index.p...Obscure_Issues