FLEXIcontent Category menu item MariaDB error

marc.light
Topic Author
Offline
Elite Member

7 years 3 months ago - 7 years 3 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: 7 years 3 months ago by ggppdk.

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

ggppdk
Offline
Administrator

7 years 3 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...

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

marc.light
Topic Author
Offline
Elite Member

7 years 3 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

7 years 3 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

7 years 3 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

7 years 3 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.