FLEXIcontent Category menu item MariaDB error

marc.light
Topic Author
Offline
Elite Member

8 years 7 months ago - 8 years 7 months ago #69608 by marc.light

FLEXIcontent Category menu item MariaDB error was created by marc.light

Hi.

I get the following error in the frontend when I access a FLEXIcontent Category menu item:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

Joomla: 3.8.0
FLEXIcontent: 3.2.1.2

Thanks for your help.

Last edit: 8 years 7 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

8 years 7 months ago #69610 by ggppdk

Replied by ggppdk on topic FLEXIcontent Category menu item MariaDB error

Hello

update to v3.2.1.4

and edit file
administrator/templates/isis/error.php

find

Code:

<span class="label label-inverse"><?php echo $this->error->getCode(); ?></span> <?php echo htmlspecialchars($this->error->getMessage(), ENT_QUOTES, 'UTF-8');?>

and immediately after the above add:

Code:

<?php if ($this->error instanceof JDatabaseExceptionExecuting) : ?>
 <br/><?php echo htmlspecialchars($this->error->getQuery(), ENT_QUOTES, 'UTF-8');?>
<?php endif; ?>

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

marc.light
Topic Author
Offline
Elite Member

8 years 7 months ago #69612 by marc.light

Replied by marc.light on topic FLEXIcontent Category menu item MariaDB error

Where can I get v3.2.1.4 ?

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

8 years 7 months ago #69615 by ggppdk

Replied by ggppdk on topic FLEXIcontent Category menu item MariaDB error

Hello

use install from URL

github.com/FLEXIcontent/flexicontent-cck/archive/v3.2.1.4.zip

Please Log in or Create an account to join the conversation.

marc.light
Topic Author
Offline
Elite Member

8 years 7 months ago #69616 by marc.light

Replied by marc.light on topic FLEXIcontent Category menu item MariaDB error

I have downloaded it and installed without issues. I have modified the file but I still get the same error.

I noticed the you made me modify a file for the backend, my error is on the frontend.

Thanks again.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

8 years 7 months ago #69618 by ggppdk

Replied by ggppdk on topic FLEXIcontent Category menu item MariaDB error

Hello

i thought you were talking of backend categories manager

and edit file
templates/MYJoomlaTemplateName/error.php

find

Code:

<span class="label label-inverse"><?php echo $this->error->getCode(); ?></span> <?php echo htmlspecialchars($this->error->getMessage(), ENT_QUOTES, 'UTF-8');?>

and immediately after the above add:

Code:

<?php if ($this->error instanceof JDatabaseExceptionExecuting) : ?>
 <br/><?php echo htmlspecialchars($this->error->getQuery(), ENT_QUOTES, 'UTF-8');?>
<?php endif; ?>

Please Log in or Create an account to join the conversation.

marc.light
Topic Author
Offline
Elite Member

8 years 7 months ago #69620 by marc.light

Replied by marc.light on topic FLEXIcontent Category menu item MariaDB error

I have a very simple error.php in my template. I just added:

if ($this->error instanceof JDatabaseExceptionExecuting) {
echo htmlspecialchars($this->error->getQuery(), ENT_QUOTES, 'UTF-8');

and it worked!

Thanks a lot.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

8 years 7 months ago - 8 years 7 months ago #69621 by ggppdk

Replied by ggppdk on topic FLEXIcontent Category menu item MariaDB error

Hello

so the error SQL message was shown

but since you have not provided the error message here
it is not by FLEXIcontent code ?

e.g. is the SQL error in some 3rd party content plugin ?

Last edit: 8 years 7 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

marc.light
Topic Author
Offline
Elite Member

8 years 7 months ago #69622 by marc.light

Replied by marc.light on topic FLEXIcontent Category menu item MariaDB error

That was it, SEOSimple plugin. It's weird because it works well on the native Joomla menu items. I removed it.

Thanks.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

8 years 7 months ago #69623 by ggppdk

Replied by ggppdk on topic FLEXIcontent Category menu item MariaDB error

Hello

we trigger content prepare on category description text

- and SEOSimple plugin tries to use variable 'id' without checking if it is set

i have alread made a change for avoiding this error

also i see this plugin has not been update for long time ... since 2015

Please Log in or Create an account to join the conversation.