General informations about JotCache extension

TOPIC: Error -- Unknown column 'domain' in 'field list'

Error -- Unknown column 'domain' in 'field list' 27 Mar 2018 01:38 #2139

Hello,

I just installed JotCache on the given website.

The error is displayed on the index.php?option=com_jotcache page.

Jotcache doesn't generate any cache.

Please let me know how the problem can be addressed.

Regards,
Tom


Joomla version : 3.8
JotCache version : 6.2
site template: custom bootstrap
system plugins :
The administrator has disabled public write access.

Error -- Unknown column 'domain' in 'field list' 27 Mar 2018 07:11 #2140

Which error message is written in php error log related to this problem?
Please give full details.
The administrator has disabled public write access.

Error -- Unknown column 'domain' in 'field list' 27 Mar 2018 17:35 #2143

Thank you for your follow-up.

I switched on the JotCache debug -- verbose setting -- and it seems, the plg_jotcache.debug.log.php file repeats similar following blocks of lines similar to the following:
###
2018-03-27 15:16:52 immediate exit on [XMLHttpRequest if.staging-exquison.info /administrator/index.php?cleancache=1&break=1&src=button&time=2018-03-27T15:16:50.260Z]
2018-03-27 15:16:57 current browser in common group [Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36]
2018-03-27 15:16:57 READ CACHE start [www.if.staging-exquison.info/flooring-so...ood-flooring-kelowna]
2018-03-27 15:16:57 READ CACHE after exclude check
2018-03-27 15:16:57 READ CACHE no data
2018-03-27 15:16:57 WRITE CACHE start
2018-03-27 15:16:57 WRITE CACHE allowed domain [www.if.staging-exquison.info]
2018-03-27 15:16:57 WRITE CACHE set browser cache expire time [Tue, 27 Mar 2018 08:16:57 -0700]
2018-03-27 15:16:57 WRITE CACHE after save in storage [true]
2018-03-27 15:16:57 WRITE CACHE stored data [06b93b2cf1130415dc98fabb43fb7afc]
###
In the error_log, I get the repeats of the following warning:
[27-Mar-2018 08:12:09 America/Vancouver] PHP Notice: Undefined variable: maxlength in /home/ifstag/public_html/templates/ot_furnite/html/mod_finder/default.php on line 23
[27-Mar-2018 08:12:09 America/Vancouver] PHP Notice: Undefined variable: label in /home/ifstag/public_html/templates/ot_furnite/html/mod_finder/default.php on line 32
[27-Mar-2018 08:12:09 America/Vancouver] PHP Notice: Undefined variable: moduleclass_sfx in /home/ifstag/public_html/templates/ot_furnite/html/mod_finder/default.php on line 81

Regards,
Tom
The administrator has disabled public write access.

Error -- Unknown column 'domain' in 'field list' 27 Mar 2018 17:53 #2144

JotCache debug log shows that JotCache page cache is working well:
2018-03-27 15:16:57 WRITE CACHE after save in storage [true]
2018-03-27 15:16:57 WRITE CACHE stored data [06b93b2cf1130415dc98fabb43fb7afc]

but you have probably Browser caching set YES (in JotCache system plugin setup). Set browser caching to No or leave it YES if you exactly know how browser caching is working.

First message:
2018-03-27 15:16:52 immediate exit on [XMLHttpRequest if.staging-exquison.info /administrator/index.php?cleancache=1&break=1&src=button&time=2018-03-27T15:16:50.260Z]

is OK - normal operation of JotCache with exclusion of all ajax calls from caching.

Problems described in php error log are not severe errors (they have error type NOTICE) and they no not relate to:
Error -- Unknown column 'domain' in 'field list'

but anyway they shows that module mod_finder has problematic php code.
The administrator has disabled public write access.
Time to create page: 0.287 seconds
We have 42 guests and no members online
Copyright © 2015 JotComponents
We have 42 guests and no members online
Copyright © 2018 JotComponents