*** SOLVED *** Plikli links doesn't exist | 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
*** SOLVED *** Plikli links doesn't exist
Avatar
Jiyath
Member
Members
Forum Posts: 3
Member Since:
March 8, 2018
sp_UserOfflineSmall Offline
1
April 24, 2018 - 10:08 am
sp_Permalink sp_Print

First of all thanks for your hard work to made an upgraded CMS.

I do not have any issue with installation. Once I completed my installation (installed in local server) error log is shown some errors.

[24-Apr-2018 05:47:28 UTC] PHP Warning: Table 'plikli.plikli_links' doesn't exist in C:\wamp64\www\Plikli\libs\db.php on line 479

[24-Apr-2018 05:47:28 UTC] PHP Stack trace:

[24-Apr-2018 05:47:28 UTC] PHP 1. {main}() C:\wamp64\www\Plikli\index.php:0

[24-Apr-2018 05:47:28 UTC] PHP 2. include() C:\wamp64\www\Plikli\index.php:31

[24-Apr-2018 05:47:28 UTC] PHP 3. ezSQLcore->get_results() C:\wamp64\www\Plikli\libs\smartyvariables.php:112

[24-Apr-2018 05:47:28 UTC] PHP 4. ezSQL_mysql->query() C:\wamp64\www\Plikli\libs\ez_sql_core.php:257

[24-Apr-2018 05:47:28 UTC] PHP 5. trigger_error() C:\wamp64\www\Plikli\libs\db.php:479

[24-Apr-2018 05:47:28 UTC] PHP Warning: Table 'plikli.plikli_links' doesn't exist in C:\wamp64\www\Plikli\libs\db.php on line 479

[24-Apr-2018 05:47:28 UTC] PHP Stack trace:

[24-Apr-2018 05:47:28 UTC] PHP 1. {main}() C:\wamp64\www\Plikli\index.php:0

[24-Apr-2018 05:47:28 UTC] PHP 2. include() C:\wamp64\www\Plikli\index.php:144

[24-Apr-2018 05:47:28 UTC] PHP 3. ezSQLcore->get_var() C:\wamp64\www\Plikli\libs\link_summary.php:26

[24-Apr-2018 05:47:28 UTC] PHP 4. ezSQL_mysql->query() C:\wamp64\www\Plikli\libs\ez_sql_core.php:166

[24-Apr-2018 05:47:28 UTC] PHP 5. trigger_error() C:\wamp64\www\Plikli\libs\db.php:479

[24-Apr-2018 05:47:28 UTC] PHP Warning: Table 'plikli.plikli_links' doesn't exist in C:\wamp64\www\Plikli\libs\db.php on line 479

[24-Apr-2018 05:47:28 UTC] PHP Stack trace:

[24-Apr-2018 05:47:28 UTC] PHP 1. {main}() C:\wamp64\www\Plikli\index.php:0

[24-Apr-2018 05:47:28 UTC] PHP 2. include() C:\wamp64\www\Plikli\index.php:144

[24-Apr-2018 05:47:28 UTC] PHP 3. ezSQLcore->get_col() C:\wamp64\www\Plikli\libs\link_summary.php:29

[24-Apr-2018 05:47:28 UTC] PHP 4. ezSQL_mysql->query() C:\wamp64\www\Plikli\libs\ez_sql_core.php:229

[24-Apr-2018 05:47:28 UTC] PHP 5. trigger_error() C:\wamp64\www\Plikli\libs\db.php:479

[24-Apr-2018 05:47:28 UTC] PHP Warning: Table 'plikli.plikli_links' doesn't exist in C:\wamp64\www\Plikli\libs\db.php on line 479

[24-Apr-2018 05:47:28 UTC] PHP Stack trace:

[24-Apr-2018 05:47:28 UTC] PHP 1. {main}() C:\wamp64\www\Plikli\index.php:0

[24-Apr-2018 05:47:28 UTC] PHP 2. Template_Lite->display() C:\wamp64\www\Plikli\index.php:155

[24-Apr-2018 05:47:28 UTC] PHP 3. Template_Lite->fetch() C:\wamp64\www\Plikli\class.template.php:514

[24-Apr-2018 05:47:28 UTC] PHP 4. Template_Lite->_fetch_compile() C:\wamp64\www\Plikli\class.template.php:554

[24-Apr-2018 05:47:28 UTC] PHP 5. include() C:\wamp64\www\Plikli\class.template.php:692

[24-Apr-2018 05:47:28 UTC] PHP 6. Template_Lite->_fetch_compile_include() C:\wamp64\www\Plikli\cache\c_1_bootstrap_plikli_tpl.php:156

[24-Apr-2018 05:47:28 UTC] PHP 7. template_fetch_compile_include() C:\wamp64\www\Plikli\class.template.php:668

[24-Apr-2018 05:47:28 UTC] PHP 8. Template_Lite->_fetch_compile() C:\wamp64\www\Plikli\internal\template.fetch_compile_include.php:30

[24-Apr-2018 05:47:28 UTC] PHP 9. include() C:\wamp64\www\Plikli\class.template.php:692

[24-Apr-2018 05:47:28 UTC] PHP 10. tpl_function_checkActionsTpl() C:\wamp64\www\Plikli\cache\c_1_bootstrap_sidebar2_tpl.php:6

[24-Apr-2018 05:47:28 UTC] PHP 11. check_actions_tpl() C:\wamp64\www\Plikli\plugins\function.checkActionsTpl.php:4

[24-Apr-2018 05:47:28 UTC] PHP 12. Template_Lite->display() C:\wamp64\www\Plikli\modules\modules_libs.php:144

[24-Apr-2018 05:47:28 UTC] PHP 13. Template_Lite->fetch() C:\wamp64\www\Plikli\class.template.php:514

[24-Apr-2018 05:47:28 UTC] PHP 14. Template_Lite->_fetch_compile() C:\wamp64\www\Plikli\class.template.php:554

[24-Apr-2018 05:47:28 UTC] PHP 15. include() C:\wamp64\www\Plikli\class.template.php:692

[24-Apr-2018 05:47:28 UTC] PHP 16. ezSQLcore->get_results() C:\wamp64\www\Plikli\cache\c_1____modules_sidebar_comments_templates_sidebar_comments_index_tpl.php:25

[24-Apr-2018 05:47:28 UTC] PHP 17. ezSQL_mysql->query() C:\wamp64\www\Plikli\libs\ez_sql_core.php:257

[24-Apr-2018 05:47:28 UTC] PHP 18. trigger_error() C:\wamp64\www\Plikli\libs\db.php:479

[24-Apr-2018 05:47:28 UTC] PHP Warning: Table 'plikli.plikli_links' doesn't exist in C:\wamp64\www\Plikli\libs\db.php on line 479

[24-Apr-2018 05:47:28 UTC] PHP Stack trace:

[24-Apr-2018 05:47:28 UTC] PHP 1. {main}() C:\wamp64\www\Plikli\index.php:0

[24-Apr-2018 05:47:28 UTC] PHP 2. Template_Lite->display() C:\wamp64\www\Plikli\index.php:155

[24-Apr-2018 05:47:28 UTC] PHP 3. Template_Lite->fetch() C:\wamp64\www\Plikli\class.template.php:514

[24-Apr-2018 05:47:28 UTC] PHP 4. Template_Lite->_fetch_compile() C:\wamp64\www\Plikli\class.template.php:554

[24-Apr-2018 05:47:28 UTC] PHP 5. include() C:\wamp64\www\Plikli\class.template.php:692

[24-Apr-2018 05:47:28 UTC] PHP 6. Template_Lite->_fetch_compile_include() C:\wamp64\www\Plikli\cache\c_1_bootstrap_plikli_tpl.php:156

[24-Apr-2018 05:47:28 UTC] PHP 7. template_fetch_compile_include() C:\wamp64\www\Plikli\class.template.php:668

[24-Apr-2018 05:47:28 UTC] PHP 8. Template_Lite->_fetch_compile() C:\wamp64\www\Plikli\internal\template.fetch_compile_include.php:30

[24-Apr-2018 05:47:28 UTC] PHP 9. include() C:\wamp64\www\Plikli\class.template.php:692

[24-Apr-2018 05:47:28 UTC] PHP 10. tpl_function_checkActionsTpl() C:\wamp64\www\Plikli\cache\c_1_bootstrap_sidebar2_tpl.php:6

[24-Apr-2018 05:47:28 UTC] PHP 11. check_actions_tpl() C:\wamp64\www\Plikli\plugins\function.checkActionsTpl.php:4

[24-Apr-2018 05:47:28 UTC] PHP 12. Template_Lite->display() C:\wamp64\www\Plikli\modules\modules_libs.php:144

[24-Apr-2018 05:47:28 UTC] PHP 13. Template_Lite->fetch() C:\wamp64\www\Plikli\class.template.php:514

[24-Apr-2018 05:47:28 UTC] PHP 14. Template_Lite->_fetch_compile() C:\wamp64\www\Plikli\class.template.php:554

[24-Apr-2018 05:47:28 UTC] PHP 15. include() C:\wamp64\www\Plikli\class.template.php:692

[24-Apr-2018 05:47:28 UTC] PHP 16. SidebarStories->show() C:\wamp64\www\Plikli\cache\c_1____modules_sidebar_stories_templates_sidebar_stories_index_tpl.php:46

[24-Apr-2018 05:47:28 UTC] PHP 17. ezSQLcore->get_col() C:\wamp64\www\Plikli\libs\sidebarstories.php:33

[24-Apr-2018 05:47:28 UTC] PHP 18. ezSQL_mysql->query() C:\wamp64\www\Plikli\libs\ez_sql_core.php:229

[24-Apr-2018 05:47:28 UTC] PHP 19. trigger_error() C:\wamp64\www\Plikli\libs\db.php:479

Avatar
redwine
Admin
Forum Posts: 240
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
2
April 24, 2018 - 9:26 pm
sp_Permalink sp_Print

Can you describe, step by step, what you have done after the installation? Did you find these warnings immediately after the installation and before you did anything else?

It is weird because it never happened on any of the localhost and live servers, to me or the 3 other people who tested and still testing!!!

Avatar
Jiyath
Member
Members
Forum Posts: 3
Member Since:
March 8, 2018
sp_UserOfflineSmall Offline
3
April 25, 2018 - 8:45 am
sp_Permalink sp_Print

I didn't change anything. After the fresh installation, I faced this error. I was manually checked in the database. There is no table for links.

Avatar
redwine
Admin
Forum Posts: 240
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
4
April 25, 2018 - 4:54 pm
sp_Permalink sp_Print

Do me a favor and delete all the tables, clear the cache from the cache folder and do a fresh install again and let me know.

Avatar
Jiyath
Member
Members
Forum Posts: 3
Member Since:
March 8, 2018
sp_UserOfflineSmall Offline
5
April 26, 2018 - 9:35 am
sp_Permalink sp_Print

I had a same problem with fresh installation.

When I insert the link table manually in database it can be solve.

Change this line: `link_url` varchar(512) to `link_url` varchar(255)

Avatar
redwine
Admin
Forum Posts: 240
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
6
April 26, 2018 - 1:21 pm
sp_Permalink sp_Print

Check your MySQL version, you have an older version than 5.0.3!
The reason I changed the VARCHAR to 512, is because some URLs, when encoded, where truncated.
MySQL Version older than 5.0.3, VARCHAR can be specified from 0 to 255. 5.0.3 and up, from 0 to 65,535.

Avatar
Techie
New Member
Members
Forum Posts: 2
Member Since:
March 8, 2018
sp_UserOfflineSmall Offline
7
April 26, 2018 - 4:02 pm
sp_Permalink sp_Print sp_EditHistory

How could an old mysql version be still installed on any system. Even localhost server have the most recent versions.

Avatar
redwine
Admin
Forum Posts: 240
Member Since:
February 21, 2018
sp_UserOfflineSmall Offline
8
April 26, 2018 - 5:11 pm
sp_Permalink sp_Print

Techie said
How could an old mysql version be still installed on any system. Even localhost server have the most recent versions.  

True. I have 2 different versions of Wamp servers installed on my computers and they have MySQL versions newer than 5.3

Forum Timezone: Asia/Beirut

Most Users Ever Online: 16

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

john: 47

Nishant kumar: 31

Mosage: 25

Martin Gold: 22

Punk: 17

StaticMove: 13

Hariom Balhara: 9

Zona Info: 8

Mark: 8

Marcus Vinicius: 7

Newest Members:

Mthobisi

Cesar

Cesar

omusubi

Nileshk

bars

Rahul Kumar

Nepal Hiking

karki

RFID4Ustore

Forum Stats:

Groups: 1

Forums: 8

Topics: 71

Posts: 475

 

Member Stats:

Guest Posters: 0

Members: 57

Moderators: 1

Admins: 1

Administrators: redwine

Moderators: Kshitij Kumar