Litecart 2.2.4 attribute groups problem

Hi Tim.

I've got a problem after updating a 1.3.7 to 2.2.4 litecart website.
The migration of a non-empty site was quite hard and it was impossible to use the upgrade scripts.
The database had to be updated manually. But I succeeded. Now I've got a problem with attributes groups that don't work anymore.
Those created with 1.3.7 were not updated at all to 2.2.4 release, and my customer uses them a lot.

So here's the process :

• creation of a new attribute groups with group value : ok
• creation of a new article : ok
• modification of the new product : Options / add predefined option with price adjustment : ok
• modification of the new product : Stock / add stock option with quantites : ok

When going to the frontend on the specific new product, I've got 2 errors:

• one PHP notice : Notice: Undefined index: name in ~/vqmod/vqcache/vq2-pages_product.inc.php (Line 330) => problem with group['name']
• when adding prouct to cart with options, error box saying : Could not find attribute (ID: 0) in database. However the attribute id is not 0.
  Note : when replacing 'name' => $group['name'], in pages/product.inc.php line 327, by 'name' => 'a standard string', this string appears twice in the product page, and there's no more php notice !

Behaviour after removing attributes of a product : the page product is ok, but adding it to cart gives the same error !!! Have to remove fully the product and recreate it.
Same problem with imports of production products with attributes.
Products without any attributes are ok.
Seems to be working on demo litecart... grrr So I spent a lot of hours on it and I didn't find any solution, except using an empty database... (and it's not the solution)...

In log, same error, repeated many times :
[22-Sep-2020 17:11:11 Europe/Paris] Notice: Undefined index: name in ~/vqmod/vqcache/vq2-pages_product.inc.php (Line 330)
← ~/index.php (Line 40) in process()
Request: GET /brocante-et-vide-grenier-c-13/son-image-c-11/disques-45-tours-c-18/45-tours-au-choix-p-184 HTTP/1.1
Host: www.toile-popart.fr
Client: ****
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36
Referer: https://www.toile-popart.fr/brocante-et-vide-grenier-c-13/son-image-c-11/disques-45-tours-c-18/

Only one mod for the moment, official product_reviews 2.0 (seems to be working).
product_file_attachment 2.1.1 doesn't work either with 2.2.4 litecart release.

So I'm stuck with these attributes. Thanks a lot for helping.

Why couldn't you use the upgrade scripts? Did they halt with an error? What was the error?

The PHP notice indicates LiteCart was trying to grab the attribute group or value name for a certain language. But it did not exist.

As for the addons I have updates to be released.

I tried to use the upgrade scripts. But, unfortunately, the scripts stop working and do nothing in my case. No error, but no response either... timeout. No matter for this point actually.
I'm very embarrassed with the attributes.
I've just tried in english language, both French and English are present, same result. I'll try tomorrow again.

It could be that your webhost doesn't allow you to display php errors. LiteCart always tries to unlock this before performing the upgrade. No matter which, they should always be logged in logs/errors.log.

4Perhaps it could be a provider problem for the database update, each provider has its own rules and configuration. However I verified each time the database in real time, and nothing was happening while executing the script. I had to update the database with each sql patch manually, and sometimes there were some errors and mismatching fields. The problem is that some mods need also database columns adds and it can be a problem during migration. The database has really significant modifications through the different patches. With a production website, this migration seems to be sometimes quite difficult. I've already had sometimes problems with the 1.x releases. My own litecart website could not be updated after a 2.1.5 release, it just stopped working and I had to come back to previous release, cause database modifications again.

Indeed, for my attributes problem on official 2.2.4 stock release, the logs/errors.log gives the expected error lines shown above and repeats them continuously, with a vqmod error that I really don't understand, even if I remove vqmods. As I've said above, with a replacement of the $name var with plain text, there's no more php notice on the product page and no error in the log, but I can't add the product to the cart : the error is given as a standard web "alert" box.

If you have a backup of your 1.x database and files. Send it to me and I will upgrade it for you.

What comes to your attribute group and values name. Are you sure they all are translated? I will let you create a support ticket if you feel this is entirely a program error.

Hi Tim. Here's the 1.3.7 fully fonctional database. Please don't leave it here when you get it. It's not mine, it's my customer's database. Thanks U in advance. If I mistake somewhere, or if the database is corrupted, don't hesitate to tell me. I'd like to understand why the attribute groups don't work. In fact, this functionality is not easy to use.

--attachment removed by tim--

There's also an error shown at top of home page of 2.2.4 admin panel, and same are in logs/error.logs :

[quote]Deprecated: The method cache::cache_id() is deprecated, use instead cache::token() in ~/includes/library/lib_cache.inc.php (Line 56)
Notice: Trying to access array offset on value of type null in ~/includes/library/lib_cache.inc.php (Line 307)
Notice: Trying to access array offset on value of type null in ~/includes/library/lib_cache.inc.php (Line 192)
Notice: Trying to access array offset on value of type null in ~/includes/library/lib_cache.inc.php (Line 236)
Warning: Invalid cache storage () in ~/includes/library/lib_cache.inc.php (Line 236)
Notice: Trying to access array offset on value of type null in ~/includes/library/lib_cache.inc.php (Line 316)
Notice: Trying to access array offset on value of type null in ~/includes/library/lib_cache.inc.php (Line 317)
Notice: Trying to access array offset on value of type null in ~/includes/library/lib_cache.inc.php (Line 318)[/quote]

And, in the same page

[quote]Warning: Illegal offset type in isset or empty in ~/includes/library/lib_cache.inc.php (Line 335)
Warning: Could not end buffer recording as token id doesn't exist in ~/includes/library/lib_cache.inc.php (Line 336)[/quote]

New test this morning with 2.2.4 :

• new attribute group creation : ok
• new activated product creation with price, options and stock well set, but without image or category : ok
  Product page is ok, no error, I can add the product to the cart.

Product modification : add image or change category => errors as shown above (cart not ok and errors with $group['name']

Do not post material that holds other people's private information on a public forum. And if you do, at least password protect it.

You are entitled to create a support ticket. Click here to begin.