PLIKLI CMS 4.1.5 is now available for download.
October 2, 2019
Where can I find the instructions to create plikli_users table? I'm receiving this error on a fresh install
Additional Instructions to follow!
There was a problem creating all the tables!
Table: plikli_users was not successfully created!
MySQL Server version is: 5.7.25
Please check the apache error log and the CMS error log in /logs/error.log
copy from line 756 to 788 (start from CREATE TABLE) don't copy the $sql =
CREATE TABLE `" . table_users . "`
with the table prefix that you used. so it would become
CREATE TABLE `bla_users`
after that paste the entire block you cpoied in your phpmyadmin and run it.
report any error you might get.
October 2, 2019
These two columns were missing default values despite being "NOT NULL"
I fixed by adding " DEFAULT CURRENT_TIMESTAMP,"
Most of it is working though I'm getting errors with groups:[02-Oct-2019 23:13:54 UTC] PHP Warning: Expression #1 of ORDER BY clause is not in SELECT list, references column 'databasename.plikli_groups.group_status' which is not in SELECT list; this is incompatible with DISTINCT in /app/data/public/libs/db.php on line 478
[02-Oct-2019 23:14:51 UTC] PHP Warning: Incorrect integer value: '' for column 'link_category' at row 1 in /app/data/public/libs/db.php on line 478
[02-Oct-2019 23:19:21 UTC] PHP Warning: Expression #1 of ORDER BY clause is not in SELECT list, references column 'databasename.plikli_groups.group_status' which is not in SELECT list; this is incompatible with DISTINCT in /app/data/public/libs/db.php on line 478
Also, admin_index.php is a blank page but I can use admin dashboard by visiting another link such as admin_links.php
That's weird!!! Another user has the same specs of MySQL, PHP and Ubuntu and installed and is running flawlessly.
I thoroughly tested it on different platforms and nothing of this came up. Anyway, I have a solution. I will put the site on maintenance mode for a couple of days to fix the issues.
After further investigation, I concluded the following:
For the below fields in the users table:
They are set as NOT NULL (no DEFAULT is specified, so the default is 0
Now, if you are working on localhost, the sql_mode is set and has many modes for the MySQL to abide by. For example:
if you run this query in your phpmuadmin: SELECT @@GLOBAL.sql_mode;
you might find the sql_mode empty or most likely containing a string of modes similar to this one:
for the users fields containing a timestamp NOT NULL and no default set, it defaults to 0 and the sql_mode "NO_ZERO_IN_DATE,NO_ZERO_DATE" will generate an error.
For the ORDER BY clause is not in SELECT list warning, as of MySQL version 5.7, again, the "ONLY_FULL_GROUP_BY" mode generates a warning when order by a field is not in the select query.
To counter measure that, and due to the difficulty of editing the "my.cnf" or "my.ini" files to set/modify the sql_mode permanently, I added some code to set the modes to an empty string FOR THE DURATION OF SESSION. The sql mode will be rest to its default as soon as the session is terminated.
If you wish to download and install the latest 4.1.5 version that has the latest code, you will be doing me a favour to see if errors you encountered previously were eliminated for good.
if not, just extract these files and replace the ones you have in folders of the installed CMS:
Please let me know.
As for the "Also, admin_index.php is a blank page but I can use admin dashboard by visiting another link such as admin_links.php"
No one encountered this issue. Check all the error logs to see if there is anything related to admin_index.php and let me know.
October 20, 2018
sorry, but I don't understand how to update from 4.1.
Do I have to copy all the files? Or just those inside the install directory? do I have to create the install folder?
You have the full instructions here
and when you start the upgrade it tells you the same things like backup the databse, copy the 2 files that are needed:
October 20, 2018
OK. I upgraded without problems. Thanks.
I already sent you 2 messages to rectify the issue I mentioned to you. If I don't hear from you from here to the end of the day, I will take the necessary measures according to the Terms and Conditions you agreed upon !!!
Most Users Ever Online: 118
Currently Browsing this Page:
Nishant kumar: 33
Martin Gold: 22
Guest Posters: 0