Second and third lines of order missing.

[MikeyG]

I am trying to resolve an ongoing issues which I am not sure whether it relates to paypal express or another bug regarding orders and possibly super orders module or the stock by attributes.

Problem 1) If an order has more than one product line it appears to be sent over to paypal but are not accepted back when the order is put on to the order system in zencart.

Logs and payment in paypal seem to have the full order details but only the first line of the order is seen in the admin orders area. It might be that this is related to product lines attributes such as size.

Problem 2) Payment received in paypal using paypal express check out but order has not confirmed on our site.

Log file have shown this which has confused me.

[06-May-2016 07:27:09 Europe/London] PHP Warning: mysql_query(): Access denied for user 'username'@'localhost' (using password: NO) in /......../admindirectory/orders.php on line 1220
[06-May-2016 07:27:09 Europe/London] PHP Warning: mysql_query(): A link to the server could not be established in /........./admindirectory/orders.php on line 1220
[06-May-2016 07:27:09 Europe/London] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /......../admindirectory/orders.php on line 1221


There is a password for the database and surely if it could not contact the database we could not get anything going through and errors allround. not sure if this is related to the earlier problems as this is the admin part.

What leads me to wonder about the attributes part is that I have this log

[06-May-2016 10:16:53 Europe/London] PHP Warning: Invalid argument supplied for foreach() in /.........../includes/classes/observers/class.products_with_attributes_stock.php on line 107

Hoping some one can steer me in the right direction as I do not see others having this issue so not been able to find the answeer from other across the forum.

Thank you in advance.

MG

[mc12345678]

Php version?

Zc 1.5.4 was written to use mysqli_ related functions which require the $db related resource information. There should not be any mysql_ related code that is expected to execute in this configuration. It could be that you have an older version of any/all of your other plugins installed which could be a problem.

[MikeyG]

version 5.4.45 on my live server

[mc12345678]

version 5.4.45 on my live server

Whatever code is in your admin/orders.php has not been updated/modified to support ZC 1.5.4 and is still using old calls to mysql_ functions.

Would recommend reviewing that file for mysql_, identifying the source of the code (at one point I thought super orders had such hard coded in the file) and seeking out the latest version of that software and incorporating it.