ConLite

ConLite will still produce this ghost categories. Reproduce this bug by deleting a second language which has categories that are not or no more in the other category. Table cl_cat_tree will not cleaned up proper. One has to check the whole generation procedure for cl_cat_tree and all areas which create or edit categories. (see screenshot)

The following DB-Error occured

[12-Aug-2018 15:43:27 Europe/Berlin] ConLite DB error: 1406 (Data too long for column 'visitdate' at row 1) - info: /cl21x/conlite/main.php?area=mycontenido&frame=4&contenido=6e1631fd7125aa77c779ee3b9969fe67 INSERT INTO
                          cl_stat_archive
                          ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate)
                      VALUES
                          (1,
                           201807,
                           3,
                           1,
                           1,
                           4,
                           '2018-07-22 20:24:50')

PHP 7.0 / MariaDB 5.5

We need to add a check and a switchable function to change mysql-mode if the server is running in strict mode.

todo:

• add test for mode

• add switch and maybe a conf for mode

• Give user an info in Backend if switch is used, maybe under system

see Changing MySQL mode per session

If you update an older 4.8.x to CL 2.0 using a newer MySQL-version, you may encounter problems with automatic disactivation of frontendusers. The reason is the datetime entry of feusers with newer db-clients, that will not correct recognized.
We have to check the whole feature of timemanagement and rebuild it to work with new db-versions.

Add an area to im- and export user and group rights.

see contenido forum Frage zur Rechten bei Artikelversionierung

If you use the setup type migration differences between real client path and path in db has to be shown and corrected. That behavior is not working. Just try a migration with total different path and you will see bug in text-fields with new path.
Fix that to show correct new path in text field.

Routing of URL using AMR-Plugin not working. See topic in forum.

I’ ve got a feedback from a customer that AMR in 4.8.20 under PHP 5.6 using redirects defined in Backend-Area is not working.

See forum → External Link

This Task collects all task of recoding or fixing behaviours to fit needs for PHP 7 and MySQL 5.7 or MariaDB 10.1

Check whole behaviour. Maybe we need to change protocol for dbfs a little. Take care of backwards compatibility.

We need to remove EditArea from Core. There are no new versions since over 6 years for it.

So the question is, which actual js-based editor we should use. Con 4.9 uses Codemirror. But i think it’ s also a good idea to use Ace.

Maybe we can also enhance editing by giving the user the possibility to choose among different editors an make editable areas switchable between editors.

So please let me know your thoughts about. Maybe this article could help you to find a decision - CodeMirror vs Ace Editor

There are still rules for contenido in this files. Fix it to fit conlite path and folders before release of 2.0.0

Add possibility to use folders in style-areas like templates, css, and javascript

today if you reset alias with amr-function all aliases in db will be resetted. Add selection for client and language.
See forum → http://forum.contenido.org/viewtopic.php?f=89&t=36558&hilit=button+formular

In the moment classes in pluginfolder have to be loaded using function plugin_include. Add autoload-config to all plugins to autoload classes if plugin is active/installed.

If you still have opened an article (edit, configuration) and your backend session timed out that article is inuse by yourself after relogin.
We have to clear inuse table for user which login and have still inuse entries.

Read first comment!!!

• put container tag without mode param in layout
• make a template using layout
• dont select a module
• make an article using this template
• visit article in frontend and show source

You’ ll find container-tag in source. Fix that behavior to show nothing if container-tag misses needed param.
We may show an info for needed and missing param in backend template view.

Update PHPMailer lib to newest version.

PHPMailer on Github

We have to check rightsmanagement. For con49 there is a bugreport that as restricted beuser with the right to create/edit beusers you can give yourself more rights and create new user with higher rights than yours.

If this is the same for ConLite we have to change this behaviour to the following

• dont give right to modifiy own rights
• dont give right to create user with more rights

see con forum - http://forum.contenido.org/viewtopic.php?f=92&t=36469

Due to changing the backend foldername the htaccess file of AMR-plugin is out of date. Add new backend folder for conlite and set old path as deprecated.
Add some docs to htaccess and also to AMR-plugins info and htaccess page.
Check all other apperances of contenido path for AMR-plugin.

At the moment no sync of modules is done without any info for user. Add area to show which modules are synced and which one are skipped.
Maybe it’ s a good idea to use ajax to sync modules. Check if easy adding this functionality is given in CL or if we need to recode ajax handling in the future.

For further releases we need the releasetool for easy getting DB-Data. Check, and recode if needed, the existing tool. DB must be cleaned up and ALL needed entries pushed to file system. Try to use generated files with setup.

Got the following error while testing ConLite with PHP 5.6 and MySQL 5.5.5

[05-May-2015 11:58:20 UTC]  error: 1265 (Data truncated for column 'visited' at row 1) - info: /ConLite/conlite/main.php?area=client&frame=1&contenido=cef3c97414c53bf7fe3f292d2cdac331 INSERT INTO
                          cl_stat
                          ( idstat, idcatart, idlang, idclient, visited )
                      VALUES (
                          24,
                          23,
                          1,
                          1,
                          '0000-00-00 00:00:00')

Error based on wrong field value in cl db for field visited (varchar(14)).
Change field type to datetime, write api class for db-table and change all calls to use the api class.

We have to write a little Doku for output compression, possible config values and where to set.

Add a language column to user log if more than 1 language is used.

This is an old bug, since 4.6 i think, growing up sequencely while working with categories in a second language. Customer has moved, deleted and add categories in english (1. lang german) and now the old master category is still visible in article-categorie-view with all subcategories but not in categorie area.

So we have to check out which function causes that behaviour. Needed sql-dump for searching is uploaded in dev-file-area, so please only use it for bugtracking and delete it afterwards.

If a be-user login again after timeout or closing browser delete old inuse entries for this user. Otherwise we will get a message for used areas for this user.

Update PHPMailer to newest version https://github.com/Synchro/PHPMailer

Add a debug user in frontend to show frontend debugging features. So code view and everything else could be used to in live web.

If you empty frontend cache folder using output_compressor output method throws an error due to the missing cached file.

PHP Warning:  filesize(): stat failed for cache/6a6a912d0c7b55b537768da77803284920140117153927.css in /var/www/vhosts/xxx/conlite/classes/class.output_compressor.php on line 190

Entwicklung eines neuen Sessionmanagements auf Basis der vorhandenen ConLib. Zu beachten ist dabei auch die Verknüpfung anderer Funktionen, so z.B. der InUse-Funktionen.

Das Aufräumen der inUse-Tabellen funktioniert nicht korrekt. Die im Contenidoforum empfohlene Lösung löst zwar das Problem in diesem Fall, ist aber keine Primärlösung. Hier gehört Sessionmanagement etc. überdacht und geäandert.

Quelle: http://forum.contenido.org/viewtopic.php?f=64&t=23854

Some permissions on permission-page have to be checked for naming and logic. Check all permissions for backend and plugins, also do a test for each permission with a restricted user in backend/frontend.

If you copy a modulefolder to a new installed system a initial creation into db is needed. Add a function that reads foldername and create a db-entry. Later we can add also a loop for all folders and/or an overview page which will also show modules in repo.

Remove the lower 4 frames frameset and use an ajaxed single frame using jquery and ui. Therefor add needed jquery-plugins to be and rewrite be ui-classes and tpl-class.

Adding jquery and ui to be will help to improve usebility of be

see http://forum.contenido.org/viewtopic.php?f=62&t=34072

If you remove CMS_Types from article template the content is still present in DB if not deleted before remove. It would be nice if there is a page where i can see all used and not used content types with their content and with a possibility for removing it from DB.

We have to discuss about a whole side feature, showing all not used content types or a per article feature.

Removal of private/external PHP function or class libraries. CL should provide its own functions and classes, licensed under GPL or LGPL.

If you delete a folder using ftp it isn’t deleted in db. For files u have to call the folder in filemanager, but if u also delete the folder that cannot work.
We have to check if we can enhance the checks in filemanager to check for missing folders.

Also we have to remember that for the new version of filemanager.

see con forum http://forum.contenido.org/viewtopic.php?f=62&t=32693

see http://forum.contenido.org/viewtopic.php?f=66&t=31229

see contenido forum http://forum.contenido.org/viewtopic.php?f=62&t=32660

If, in a module, you connect to an external database, all modules after that one in the template won’t work.
The configuration for those following modules says “-unnamed module-”.
If you close the connection to the external database in the module, the following modules work as they should.

If you have the module with the external database connection more than once in the template, directly following eachother, then each second one won’t connect to that database even if you use different variables for the connection, but only in the backend (configuration).
In the frontend everything works as it should even with the same variable for the external database connection, but only while closing the connection in the module (every instance).

Question/Problem:
Why does ConLite try to get the module information over the last opened database connection instead of using it’s own connection $db?

Attached is a module for showing a Modified Shopsoftware article in ConLite for testing.

Due to the changes in class genericdb some of the API-classes no longer update fields modified or author. Also some create-methods do not fill fields for create date and author.
Check all cApi-classes for right behaviour and add to create- and store-method of this classes if missing.
Add method if needed and also write a short dev-info.

Zumindest tritt dieses Problem auf, wenn Backend auf Subdomain ist.

Seit Contenido 4.8.18 werden auch transparente PNG unterstützt. Das wäre eine sinvolle Erweiterung.

Die Vorschaubilder (die erscheinen wenn man auf die Minivorschau mit der Maus fährt) in der Dateiverwaltung werden beschnitten (links/oben fehlt) und gestaucht (4:3).

This handling is inconsistent. We have some entries within id < 10000 and some are outside. I’m just writing a release tool and i can’t handle that in the moment. SO we need to discuss if we exclude all plugin entries in db from id range under 10000. Maybe it’s a good idea to install buildin plugins with the new plugininstaller during setup.

We need to recode all used modules in democlient to use buildin amr-plugin and create correct url. Also check behaviour if amr is configured to generate url in modules and/or plugins

If AMR is configured to prevent duplicated content, url percent is set to 100% and redirect to errorpage is choosen, old url calls to front_content.php will not work any more.

I tried to fix that with info from con-forum http://forum.contenido.org/viewtopic.php?p=155402#p155402 but that still let the possibility of duplicated content. We need to find a better solution.