CMS Made Simple Forums

Hi there,

CMSMS 2.2.14

I upgraded to LISE 1.4 yesterday. Since that I have some issues by duplicating or importing instances:

Duplicating with PHP 7.4: White page.

Duplicating with older PHP versions:
Fatal error: Uncaught ## 00002: LISE Database error: 1054 - Unknown column 'module_mode' in 'field list' - Query: INSERT INTO cms_module_lise_instances (module_name, module_mode) VALUES ('LISEmyinstance',0)! @ /www/htdocs/username/mydomain.com/modules/LISE/lib/class.LISEInstance.php (817) ## thrown in /www/htdocs/username/mydomain.com/modules/LISE/lib/class.LISEInstance.php on line 817

Importing instance:

First I had the same issue which is reported in the bug tracker. After the fix I get the notice "Could not create a directory named LISEmyinstance". But if I take a look into my module directory, there is an instance named LISEmyinstance. And if I take a look into the module manager, there is a module named LISEmyinstance - but it is not installed. Trying to install it produces another white page.

There are a couple of reasons for this:

• The released version was not the latest one committed to SVN;
• The clone and import routines had a few bugs on their own;

I probably mixed up the working copies... I'm working on a recovery upgrade;
There are already fixes committed to SVN for the import and clone, and I'll be releasing an updated version shortly.
Thanks for the report.

Okay. For now I downgrade to 1.3.1 and wait for the fixes.

New version released: 1.4.1.

Jo Morg wrote: ↑Thu Oct 01, 2020 4:38 pm New version released: 1.4.1.

Thanks Jo,

but updating to 1.4.1 didn't fix the errors

Existing instance will be updated fine - but new instances or importing causes the same errors and white pages as before.

Remove the old LISE instances, before trying to import them again!

kierweb wrote: ↑Fri Oct 02, 2020 10:12 am before trying to import them again!

I didn't try to import existing instances. I had two existing instances before the update and they work fine. The errors appear when trying to import another instance from vs. 1.3.1 or duplicate a new instance.

Remove the instances you have created since upgrading ... The issue you are having is that when you tried it on v1.4 the clone didn't work, but created the files .. now when you try again, the clone can't create the files because their already exist. So goto Module Manager and remove the LISE Instances which didn't import/clone correctly.

kierweb wrote: ↑Fri Oct 02, 2020 11:30 am Remove the instances you have created since upgrading ...

I cannot duplicate or import any instances since upgrading. That is the problem.

It is exactly the way you say it: After importing the files are created, but no instance is available.

kierweb wrote: ↑Fri Oct 02, 2020 11:30 am So goto Module Manager and remove the LISE Instances which didn't import/clone correctly.

I swear: I did not only remove them in the module manager or in the directory - I even removed all related tables from the database manually. So there is nothing left to remove. And finally the errors are caused also with absolutely fresh and new instances with different names which cannot already exist.

kierweb wrote: ↑Fri Oct 02, 2020 11:30 am
clone

I'm not talking about cloning. A clone is making a 1:1 copy of an existing instance via the LISE module. The errors appear while duplicating (=creating a fresh instance) and importing (=uploading xml file from the locale drive).

What error exactly are you getting? Also, what version of PHP are you running?
I have tested this exhaustively before and after releasing 1.4.1 and haven't been able to reproduce any further errors. However I haven't tried to import from 1.3.1 yet. And I don't think that should be an issue, but I'll review it ASAP.

Jo Morg wrote: ↑Fri Oct 02, 2020 12:42 pm What error exactly are you getting? Also, what version of PHP are you running?
I have tested this exhaustively before and after releasing 1.4.1 and haven't been able to reproduce any further errors.

Meanwhile I am back to LISE 1.3.1 an cannot check again.

According to the release notes I've checked PHP 7.4 first. Then step by step down to 7.1. with LISE 1.4. With 1.4.1 I've checked only PHP 7.4 and PHP 7.1. As I remember with 7.4 I get more white pages and in earlier PHP versions the errors as reported in my first posting "Unknown column 'module_mode' in 'field list' ".

Which PHP version did you use when checking it?

Jo Morg wrote: ↑Fri Oct 02, 2020 12:42 pm However I haven't tried to import from 1.3.1 yet. And I don't think that should be an issue, but I'll review it ASAP.

I was also thinking that maybe only importing from 1.3.1 instances causes trouble. But 1.4 is so brand new that I do not have any 1.4 xml files to import yet.

I'm gonna try this the next days:

1. Upgrading project with an instance I need to 1.4.1
2. Exporting the instance
3. Importing the instance into a another project with 1.4.1

But before I upgrade other projects I have to find out why duplicating a new instance also does not work.

Seems that I'm the only one who gets this error. Another user reportet the same issue in the bug tracker for LISE 1.4.1.

antibart wrote: ↑Tue Oct 06, 2020 7:24 am Seems that I'm the only one

Sorry. NOT the only one. No matter: the bug report has been deleted from the forge anyway.

antibart wrote: ↑Tue Oct 06, 2020 9:56 am

antibart wrote: ↑Tue Oct 06, 2020 7:24 am Seems that I'm the only one

Sorry. NOT the only one. No matter: the bug report has been deleted from the forge anyway.

if it was deleted it was by the OP However even though I didn't have time yet to test that with an import from 1.3.x I cannot reproduce any of the other behaviors described in that BR after a 1.4.1 upgrade, which means it possibly was an upgrade that has gone South for some reason.
I'll test that import as soon as I have some time to chase that issue.

Jo Morg wrote: ↑Tue Oct 06, 2020 10:16 am
if it was deleted it was by the OP

I guess that too. Maybe because he published some private data in his error report (directories not anonymized). Or maybe he could fix ist.

It was the same report as in my first post when trying to duplicate instances.

Fatal error: Uncaught ## 00002: LISE Database error: 1054 - Unknown column 'module_mode' in 'field list' - Query: INSERT INTO cms_module_lise_instances (module_name, module_mode) VALUES ('LISEmyinstance',0)! @ /www/htdocs/username/mydomain.com/modules/LISE/lib/class.LISEInstance.php (817) ## thrown in /www/htdocs/username/mydomain.com/modules/LISE/lib/class.LISEInstance.php on line 817