Support

Pre-sales

#40373 Panopticon

Posted in ‘Pre-sales and Account Questions’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by nicholas on Tuesday, 19 March 2024 16:23 CDT

W13ear27

Β Please look at the bottom of this page (under Support Policy Summary) for our support policy summary, containing important information regarding our working hours and our support policy. Thank you!

Β 

Hi,

Β 

I have succesfully installed Panopticon.

However, it came with an error 500 after the first crontask has run.

As mentioned, I have put the error messages in three pdf files.

Hope you can help me out here.

Β 

Kind regards,

Winfried Buijen

nicholas
Akeeba Staff
Manager

You are using a version of MySQL which does not support the JSON data type. As a result, Panopticon has not been installed correctly.

Please note that even though MySQL 5.7.9 and later do support the JSON data type, the support is optional. Your host seems to have disabled this optional support, hence the problem.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

W13ear27

Hi Nicholas,

Β 

I have had a deep conversation with my provider (SiteGround)and they assured me that their servers MySQL, version 5.7.44-48, supports the JSON Data Type.

Is there anythng that I can do to give you more information to solve this problem?

Β 

Kind regards,

Winfried Buijen

nicholas
Akeeba Staff
Manager

Is reinstalling an option?

If it is, let me know and I will give you a developer's release which stops during installation if the JSON data type is not supported.

If not, I will make this a private ticket and ask you for information necessary to connect to your site and try to create the missing table myself. If there is a problem, I will tell you my findings.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

nicholas
Akeeba Staff
Manager

Important clarification: I just moved to a new house. Things are a bit chaotic (boxes everywhere!). Up until last night I did not even have a computer set up, and nowhere to work from my laptop. I ask for your understanding for my slow replies during this upcoming week. Panopticon is still something I handle on my own; the other software Davide is more than capable of answering questions for.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

W13ear27

Hi Nicholas,

Β 

There is no rush for this ticket, so use your time as you please.

I have the option to reinstall, I actually did this without any success though, so feel free to send me the developer's release.

If needed I can give you access to my site, just let me know what you need.

Again no hurries :)

nicholas
Akeeba Staff
Manager

Please download and install this dev release: https://www.akeeba.com/download/panopticon-dev/1-1-2-dev202403041828.htmlΒ 

If I am right in my hunch, the installation will fail. Let me know what the error message reads.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

W13ear27

Hi Nicholas,

Β 

Apologies for the delayed response.

The error message is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('{}') ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4' at line 5

Β 

Kind regards,

Winfried

nicholas
Akeeba Staff
Manager

Open the file src/schema/mysql.xml.

Find this line

`privileges` JSON         NOT NULL DEFAULT ('{}')

and change it to this

`privileges` JSON         NOT NULL

Then try to run the installation. Does it proceed correctly?

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

W13ear27

Hi Nicholas,

Β 

That worked great!

I have tried adding all my sites and most of them worked without any delay or problem.

However there are three sites that did have some errors.

This is weard to me, because all of my websites are hosted with the same provider and one of them is a subdomain who's main domain is working fine.

Β 

I have tried to whitelist the domains in Admin Tools Pro, but this had no effect at all.

Β 

All sites gives a http-500 error.

Β 

Hope you can help me.

Β 

Kind regards,

Winfried

Β 

PS: This is the mail I got from Admin Tools:

A PHP Exception occurred on your site. Here you can find the stack trace:

Exception Type: Joomla\CMS\Access\Exception\AuthenticationFailed
File: /home/customer/www/claim.games/public_html/libraries/src/Application/ApiApplication.php
Line: 306
Message:

#0 /home/customer/www/claim.games/public_html/libraries/src/Application/ApiApplication.php(106): Joomla\CMS\Application\ApiApplication->route()
#1 /home/customer/www/claim.games/public_html/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\ApiApplication->doExecute()
#2 /home/customer/www/claim.games/public_html/api/includes/app.php(53): Joomla\CMS\Application\CMSApplication->execute()
#3 /home/customer/www/claim.games/public_html/api/index.php(31): require_once('/home/customer/...')
#4 {main}
Request information GET variables
Array
(
)
POST variables
Array
(
)
COOKIE variables
Array
(
)
REQUEST variables
Array
(
)

nicholas
Akeeba Staff
Manager

The email only tells me that at some point there was a request to the Joomla! API which failed authentication. When setting up a site the first request is indeed unauthenticated to make sure that the Joomla! API is there, installed, and protected against direct access.

You need to tell me more about what "some errors" are so I can maybe help?

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

W13ear27

This was created when I got the message:

Could not connect with website

Process step: Unauthenticated access (can I even access the API at all?)

Β 

500
Β 

Server: nginx

Date: Tue, 19 Mar 2024 18:47:59 GMT

Content-Type: text/html; charset=UTF-8

Content-Length: 0

Connection: keep-alive

X-Frame-Options: SAMEORIGIN

Referrer-Policy:

unsafe-url

Cache-Control: no-cache, no-transform

X-Httpd-Modphp: 1

X-Content-Type-Options: nosniff

X-XSS-Protection: 1; mode=block

Host-Header: 6b7412fb82ca5edfd0917e3957f05d89

X-Proxy-Cache: MISS

X-Proxy-Cache-Info: 0 NC:000000 UP:

nicholas
Akeeba Staff
Manager

Correct, this means that you cannot access the API application at all. There is a PHP error, which means that a third party plugin is messing something up.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!