ConLite

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.

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

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

Update Readme for release 2.0.3

...

Check all folders and remove dev stuff from folders or folders with sources

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)

I often use the same entries for client settings. It would be helpful if often used ones could be added via click. Examples:
tinymce|forced_root_block|
articles|show-new-window-checkbox|true
...

If you have a categorie filled with many articles - e.g. for a newslist - and you want to delete several articles, you have to do that one by one. It would be quite useful, if there'd be the possibility to select those articles via checkboxes - like it is in filemanagement - and, after confirmation of course ;O) - delete them at one step.

If you first install the sample client and tidy it up for making up your own website, you first delete all articles and then the not further used categories. So I first throwed out all articles in (sub)categories of the tree "hauptnavigation". Then I went on deleting those (sub)categories. After that, only "Hauptnavigation" was left and I decided to remove the assigned template and rename it to "Startseite". After saving, there appeared this errormessage:

Fatal error: Call to a member function get() on a non-object in /var/www/web244/html/2/contenido/plugins/mod_rewrite/includes/functions.mod_rewrite.php on line 130

Add a plugin or better a chain in backend filemanager. Configuration has to be done with client-settings.

This task has two parts:
- Add link to onlina article: see http://forum.contenido.org/viewtopic.php?f=36&t=31922 - Configurable mailer: see http://forum.contenido.org/viewtopic.php?f=36&t=31584

For now the table mod_history is leaved as is and not migrated to filesystem. Add a step to setup where this is done and unused db-table is removed after successfull migration.

If you use a htaccess to redirect your host like

#www Rewrite
RewriteCond %{HTTP_HOST} !^www\.domain\.de
RewriteRule (.*) http://www.domain.de/$1 [L,R=301]

and you have entries in config.php without subdomain www, you can't login in backend. The reason is that login post is redirected.

Maybe we shall throw a little info-message for that. So if somebody tries to login with different host to config-entry and gets a login-error, error-message schould also give a hint. We can also add an entry to errorlog.

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.

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).

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

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.

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.

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

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

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.

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

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

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.

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.

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

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.

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

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

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

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.

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.

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

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

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.

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

Update PHPMailer lib to newest version.

PHPMailer on Github

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.

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.

Calling the info-page by clicking on the button in main menu causes an error entry in logfile.

[13-Nov-2015 12:04:30 Europe/Berlin] PHP Warning:  include_once(/path/conlite/includes/include.subnav_blank.php): failed to open stream: Datei oder Verzeichnis nicht gefunden in /path/conlite/main.php on line 255
[13-Nov-2015 12:04:30 Europe/Berlin] PHP Warning:  include_once(): Failed opening '/path/conlite/includes/include.subnav_blank.php' for inclusion (include_path='.:/usr/local/lib/php/') in /path/conlite/main.php on line 255

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

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

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

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

Remove PEAR library after building needed classes in the Core (was: Update PEAR files and remove all Con-related code if possible).

Adding a Modulrepo part to BE. There are different startpoints to do that, so we have to discuss how we wanna do it. We may use just local repos or we can use one central repo.

So if you have any ideas around adding a modul repo, please add them as comment.

For some versions back, the category list is not updated when e.g. changing the status of the start article into "non start article" - icon in the category tree should change to red. Same thing when you delete all articles in a branch - no changes left.
Correct behaviour is shown in the file system - as soon as the last file is taken out of a branch/folder, it changes to red and you can delete it.

I will add a new Stats Plugin which will use the new statistic class from semmelstatzR for wordpress as base class. Also a Chain is integrated for getting and reading the agent and user data's

1)
I quite often use my netbook to update my webcontent. One category contains more than 70 articles and the next is always a copy of the last one which will be altered. So I have to select page 4 first, which is not a problem. But humans are normally lazy - so am I - and I always have to scroll to the bottom to see the page-selector. So it would be great to have that selector not only below, but also above the article-listing. Like it is in filemanagement.

2)
At the moment you can sort the articles of a category by using the dropdown above the listing. It would be nice if you could do that by clicking on the columns header.

http://forum.contenido.org/viewtopic.php?p=154761#p154761

One should be able to move files in the file manager.
Needed functionality for this:
- move the file in the file system
- correct the path in the database table con_upl
Articles using the file through modules aren't infected, because they only save the id of the entry in con_upl.
Only articles using the file inside the TinyMCE editor will have a problem.
For this case, we should consider correcting those paths too, or showing a warning message on trying to move the file.

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

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.

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

All plugins and their files have to be moved to pluginfolder and subfolders so we may install them within the new pluginmanager.

Add/enhance missing infile docu always if your working with or at core files.

cHTML have to be restructured to meet OOP in PHP 5.3 and above using E_STRICT error mode.
Also some work todo with infile docu. Maybe it's a good idea to update PEAR also.

Some people told me that it will be a good idea if there is a possibilty to use a deeplink in backend. Due to the nested frameset there was no easy way to do. Contenido itself uses a javascript construct to change multiple frames in BE.

So we will try to enhance the lower mainframeset with it's 4 frames to only one, using div-areas instead of the frames. This has to be done in a parallel way to existing backend so we can change it area by area.

More planing for this new feature has to be done for further versions.

The behaviour if a login error occurs or if the return-param is set should be reconsidered. For example if you use the login_error_page client-setting there is no information after redirect where we come from, so how can we check for wrong login or redirections? Also i miss a custom login form or a solution for multiple loginform usage within the same client.

Please add all done classes in list Check all db-table related classes and move or create if not exists as cApi-class using genericdb. Also port to PHP5 if needed. Move all new classes to a new cApi-folder in class-folder. Merge classes if possible.

List of classes to check:

• class.activeusers.php
• class.client.php
• contenido/class.client.php

...to be continued

List of already done classes (add classname when ready):

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

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

see contenido forum Frage zur Rechten bei Artikelversionierung