Issue with new orders

[Phil]

Hmm..

It sounds like this goes fine: https://github.com/CE-PhoenixCart/Phoen ... _order.php

Suggesting that it is the $order Global that lacks something. Maybe something goes wrong here: https://github.com/CE-PhoenixCart/Phoen ... er.php#L89

I have no good ideas for what to try, sorry. I'll try thinking some more

//Daniel

Interestingly, the "versioned" directories are different between the local Phoenix 1.0.8.20 and the ones on the server that went through upgrades

versioned_.png

There is also order.php in 1.0.5.3, etc.
But I don't know what I am looking at/for


Here is a screenshot of the orders table end:

orders_table.png

customer IDs up to 3498 are from the old osCommerce store. Order IDs up to 4964 are from the old store as well.

Orders with empty customer data: 4995, 4996, 5001, 5002, 5004. (4996, 5001, 5002 are same repeated order we made customer #3492 retry).

Other orders seem fine, strangely. Missing order IDs are me deleting orders where I was testing, and a repeated order by same customer. All other columns past "customers_address_format_id" seem to be populated fine for all orders.


There are some PHP notices/warnings that I see in the log, not sure if they're related:

Code: Select all

[07-Sep-2023 13:27:31 America/New_York] PHP Notice:  Trying to access array offset on value of type null in /store/includes/modules/customer_data/cd_traditional_address.php on line 141
[07-Sep-2023 13:46:58 America/New_York] PHP Notice:  Trying to access array offset on value of type null in /store/includes/modules/customer_data/cd_traditional_address.php on line 141
[07-Sep-2023 13:47:07 America/New_York] PHP Notice:  Trying to access array offset on value of type null in /store/includes/modules/customer_data/cd_traditional_address.php on line 141
[07-Sep-2023 14:35:01 America/New_York] PHP Notice:  Trying to access array offset on value of type null in /store/includes/modules/customer_data/cd_traditional_address.php on line 141
[07-Sep-2023 15:01:28 America/New_York] PHP Notice:  Trying to access array offset on value of type null in /store/includes/modules/customer_data/cd_traditional_address.php on line 141
[07-Sep-2023 15:06:37 America/New_York] PHP Warning:  array_filter() expects parameter 1 to be array, null given in /store/includes/system/versioned/1.0.5.1/customer.php on line 52
[07-Sep-2023 15:06:41 America/New_York] PHP Warning:  array_filter() expects parameter 1 to be array, null given in /store/includes/system/versioned/1.0.5.1/customer.php on line 52
[07-Sep-2023 15:47:38 America/New_York] PHP Notice:  Trying to access array offset on value of type null in /store/includes/modules/customer_data/cd_traditional_address.php on line 141
[08-Sep-2023 09:25:37 America/New_York] PHP Notice:  Trying to access array offset on value of type null in /store/includes/modules/customer_data/cd_traditional_address.php on line 141
[08-Sep-2023 13:24:35 America/New_York] PHP Notice:  Trying to access array offset on value of type null in /store/includes/modules/customer_data/cd_traditional_address.php on line 141

[burt]

1.0.8.20 / includes/system/versioned/ should be only;

fghy.jpg

You say there is an orders.php in 1.0.5.3 ? That's a massive red flag!

I suppose it's possible to have extra folders in here for addons, but there should not be anything other than core files and folders. Suggest;

Pre Step. DOWNLOAD & Unzip a new 1.0.8.20
Then
1. DOWNLOAD all these folders as a backup (in case you have made some weird changes in any of them).
2. DELETE all these folders from your live site.
3. From the Newly downloaded 1.0.8.20, upload all the folders [and contents thereof] in /includes/system/versioned/ so that it exactly matches the image I posted above.

Make a Test Order

[burt]

Contents of /includes/system/versioned/
should be 22 Folders with 85 files. Not more not less.

[Omar_one]

there was same king of issue and @ecartz give a fix for it viewtopic.php?p=6123#p6121

I am not sure if this will help with your issue

[Phil]

Contents of /includes/system/versioned/
should be 22 Folders with 85 files. Not more not less.

Done. I am not sure where the extra versioned folders came from, possibly from old upgrades.

1. Removed the old "versioned/..." directories, replaced with a fresh copy from 1.0.8.20.
2. Placed an order, all seemed to work fine so far (but I couldn't recreate the issue before either).

Will report if I get issues again. Thanks for all the help!

[Phil]

there was same king of issue and @ecartz give a fix for it viewtopic.php?p=6123#p6121

I am not sure if this will help with your issue

Thanks, but I'm not authorized to view the VIP forum I suppose

[burt]

You need to be a PRO member to access that part of the forum.

However the link contained in the post is publically available, as all core code is;
https://github.com/CE-PhoenixCart/Updat ... te.sql#L35

[burt]

I'm slightly concerned that you have upgraded, but not followed the upgrade steps in order, so you might have unwanted files and DB entries, or missing files and DB entries. Because of the way that Phoenix works, any unwanted files and DB entries may be causing issues, and obviously any missing files and DB entries would be causing major issues.

It would be a bit of work, my suggestion for the quickest option;

1. Install a brand new 1.0.8.20 test shop.
2. Make a dump of the DB structure in full
3. Make a dump of the DB structure of the live 108.20
4. Compare the two.

Then do the same for the configuration table data. It is this table which controls a lot of Phoenix.

Then do the same for the file structure, using a program such as "win merge" - this type of program scans two different locations and tells you what is different. There should be very little difference between a new 108.20 and your live 108.20 (maybe images, maybe some extra modules etc in your live one).

[Phil]

I'm slightly concerned...

I have a couple of new orders that have all customer info now, and one new order with empty customer info.

I am somewhat concerned as well, even though I thought I've followed upgrade instructions. I will work on following your suggestions above in comparing databases and configuration data, thank you for the help.

[Phil]

Following up on this, after comparing the databases they seem almost identical. There are a couple of small differences:

1. utf8 vs. utf8mb4
Live install is: utf8_unicode_ci
Fresh install: utf8mb4_unicode_ci

2. in customers table password default NULL vs NOT NULL:
Live: `customers_password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
Fresh: `customers_password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

3. A couple of indexes seem to be "USING HASH" or have a length limit on the fresh install:
Live: ADD UNIQUE KEY `uq_configuration_key` (`configuration_key`);
Fresh: ADD UNIQUE KEY `uq_configuration_key` (`configuration_key`) USING HASH;

Other than that databases seem the same.