PLIKLI CMS 4.1.5 is now available for download. | General Support | Forum

Avatar

Please consider registering
Guest

Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_TopicIcon
PLIKLI CMS 4.1.5 is now available for download.
Avatar
redwine
Admin
Forum Posts: 381
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
1
October 2, 2019 - 5:48 am
sp_Permalink sp_Print

PLIKLI CMS 4.1.5 is now available for download.

https://www.plikli.com/download-plikli/

Avatar
sharkie
New Member
Members
Forum Posts: 2
Member Since:
October 2, 2019
sp_UserOfflineSmall Offline
2
October 2, 2019 - 9:06 pm
sp_Permalink sp_Print

Hello,

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
PHP 7.2.19-0ubuntu0.18.04.1

Avatar
redwine
Admin
Forum Posts: 381
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
3
October 2, 2019 - 10:02 pm
sp_Permalink sp_Print

Please check the apache error log and the CMS error log in /logs/error.log

Open /install/installtables.php

copy from line 756 to 788 (start from CREATE TABLE) don't copy the $sql =

replace this
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.

Avatar
sharkie
New Member
Members
Forum Posts: 2
Member Since:
October 2, 2019
sp_UserOfflineSmall Offline
4
October 3, 2019 - 2:24 am
sp_Permalink sp_Print sp_EditHistory

user_date
last_reset_request

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

Avatar
redwine
Admin
Forum Posts: 381
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
5
October 3, 2019 - 3:02 am
sp_Permalink sp_Print

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.

Avatar
redwine
Admin
Forum Posts: 381
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
6
October 3, 2019 - 6:59 pm
sp_Permalink sp_Print

After further investigation, I concluded the following:

For the below fields in the users table:
user_date
last_reset_request

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:
"STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,ONLY_FULL_GROUP_BY"

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:

/install/installtables.php
/libs/db.php

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.

Avatar
Offertalink
Member
Members
Forum Posts: 12
Member Since:
October 20, 2018
sp_UserOfflineSmall Offline
7
October 4, 2019 - 6:13 pm
sp_Permalink sp_Print

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?

Avatar
redwine
Admin
Forum Posts: 381
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
8
October 4, 2019 - 6:18 pm
sp_Permalink sp_Print

Offertalink said
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
https://www.plikli.com/migrating-to-plikli-cms/

and when you start the upgrade it tells you the same things like backup the databse, copy the 2 files that are needed:
/settings.php
/libs/dbconnect.php

Avatar
redwine
Admin
Forum Posts: 381
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
9
October 4, 2019 - 7:00 pm
sp_Permalink sp_Print

Let me know ho it goes and if you need assistance.

Avatar
Offertalink
Member
Members
Forum Posts: 12
Member Since:
October 20, 2018
sp_UserOfflineSmall Offline
10
October 5, 2019 - 10:55 am
sp_Permalink sp_Print

OK. I upgraded without problems. Thanks.

Avatar
redwine
Admin
Forum Posts: 381
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
11
October 5, 2019 - 2:04 pm
sp_Permalink sp_Print

Offertalink said
OK. I upgraded without problems. Thanks.  

I sent you a private message on your profile. Please read it and respond!

Avatar
redwine
Admin
Forum Posts: 381
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
12
October 5, 2019 - 6:16 pm
sp_Permalink sp_Print

Offertalink said
OK. I upgraded without problems. Thanks.  

@Offertalink

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 !!!

Forum Timezone: Asia/Beirut

Most Users Ever Online: 118

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

john: 47

Nishant kumar: 33

Mosage: 25

Punk: 23

Martin Gold: 22

Felipe: 22

Phelix: 17

yami: 16

StaticMove: 13

Hiro: 13

Newest Members:

Smith John

saiteja

yugo

Sagar Gola

sharkie

Mohit Mittal

Gyan

Mila

Riya

Daniel

Forum Stats:

Groups: 1

Forums: 8

Topics: 131

Posts: 762

 

Member Stats:

Guest Posters: 0

Members: 162

Moderators: 0

Admins: 1

Administrators: redwine