Listit2 1.2.2 to 1.3.2 gives fatal sql error on clone update

[faglork]

Hi!

I am about to update a site previously running cmsms 1.10.3 / listit2 1.2.2.
I upgraded both to 1.11.10 / 1.3.2

Now, in Module Manager, the three listit clones are marked as needing an update. When I click on "update", I get a FATAL SQL ERROR:

FATAL SQL ERROR: Table 'yyyy.cms_module_listit2clonexxx_instances' doesn't exist
QUERY: INSERT INTO cms_module_listit2clonexxx_instances (module_name) VALUES ('ListIt2Clonexxx')

Same happens when I go to Extensions->Listit2->Instances and click on "update".

Of course the table does not exist ... why should it? 1.2.2 did not create this table.

What went wrong? Any ideas to go from here?

Cheers,
Alex

[Stikki]

ListIt is trying to create control tables and actual ListIt Core tables,

Unfortunately it is trying to register on clone tables instead of master.

This maybe cause of original ListIt instance was renamed to something else and it didnt exists during upgrade process.

Some other SQL failure during upgrade.

Check into database that cms_module_listit2_instances table exists

Could be many other things hard to say.

Does ListIt2 core module exists?

[faglork]

ListIt is trying to create control tables and actual ListIt Core tables,

Unfortunately it is trying to register on clone tables instead of master.

This maybe cause of original ListIt instance was renamed to something else and it didnt exists during upgrade process.

Thats interesting, because it was renamed to "Listenverwaltung" and moved to "content" section of admin interface before update. After update, its name is "Listit2" again and it resides in the "Extensions" section.

Some other SQL failure during upgrade.

Check into database that cms_module_listit2_instances table exists

Could be many other things hard to say.

Does ListIt2 core module exists?

Yes.

Cheers,
Alex

[Stikki]

Empty all instance folders, in modules directory.

Leave controller file tho.

Revert all instances back to 1.2.2 in database cms_modules.

ONLY instances not ListIt2

Re-run upgrade processes for each instance.

[uniqu3]

Name in Backend menu is irrelevant, therefore Listenverwaltung or ListIt2 is wrong or not of importance, but what is important is Module Class name in XX.module.php, so look in modules folder and search for your instance folders, make sure Module Class name and Filename match, since 1.2 a module filename and class name would be ListIt2WhateverNameyouPicked and after 1.2.2 ListIt2CloneWhateverNameyouPicked (if my memory serves me well).

ListIt2 core module will attempt to copy DB entries to ListIt2Clone.
Possibly something went wrong in upgrade process, you can have a look at upgrade guide in ListIt2CloneUpgrade package, as folders should not contain any files beside images and main single module Class file.

Edit: or what Stikki suggested, faster once again

[faglork]

Empty all instance folders, in modules directory.

Leave controller file tho.

"controller file" ??

Revert all instances back to 1.2.2 in database cms_modules.

They are still on 1.2.2

Cheers,
Alex

[faglork]

Name in Backend menu is irrelevant, therefore Listenverwaltung or ListIt2 is wrong or not of importance, but what is important is Module Class name in XX.module.php, so look in modules folder and search for your instance folders, make sure Module Class name and Filename match,

They match.

since 1.2 a module filename and class name would be ListIt2WhateverNameyouPicked and after 1.2.2 ListIt2CloneWhateverNameyouPicked (if my memory serves me well).

I never installed 1.2, I startet with 1.2.2

ListIt2 core module will attempt to copy DB entries to ListIt2Clone.
Possibly something went wrong in upgrade process, you can have a look at upgrade guide in ListIt2CloneUpgrade package,

AFAIK ListIt2CloneUpgrade package refers only to the 1.2-to-1.2.2 upgrade?

as folders should not contain any files beside images and main single module Class file.

clone folders contain only
/images
/templates
Listit2CloneXXX.module.php

Cheers,
Alex

[faglork]

In the /Listit2Original folder, there is a file named "c8cb70a0b4bfaa504bc4870628b20872" - no file extension.

Is this correct? It is a php file, first entry is

class c8cb70a0b4bfaa504bc4870628b20872 extends ListIt2

Cheers,
Alex

[Stikki]

Does ListIt2Original.module.php exists?

If no, then something went badly wrong.

This file is only mandatory controller for instance folder,

Rest is read from framework folder of LI Core

[faglork]

Does ListIt2Original.module.php exists?

If no, then something went badly wrong.

This file is only mandatory controller for instance folder,

Rest is read from framework folder of LI Core

The file exists in /htdocs/modules/ListIt2Original

Cheers,
Alex

[Stikki]

Well i can't guess more can be anything.

Something went wrong with upgrade, i would fix it in 5 minutes probably but hard to throw ideas when i don't see complete case.

Sorry.

[faglork]

Well i can't guess more can be anything.

Something went wrong with upgrade, i would fix it in 5 minutes probably but hard to throw ideas when i don't see complete case.

Sorry.

What do you need?

Cheers,
Alex