FLEXIContent and ACESEF

More
14 years 8 months ago #4235 by chrisflow
Hello,

I just tried to make AceSEF, Joomfish and Flexicontent work together and when I enable the extension, I receive that message everywhere on the page:

No valid database connection 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 '' at line 1 SQL=SELECT catid FROM jos_content WHERE id =


I use the last version of each component. Any idea?

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

More
14 years 8 months ago #4236 by kenmcd
Replied by kenmcd on topic FLEXIContent and ACESEF
.
The "last version" is not useful information.
Please state actual versions.

Versions needed for:
- Joomla
- FLEXIcontent
- AceSEF
- FLEXIcontent extension for AceSEF
- Joom!Fish
- PHP
- MySQL

"No valid database connection You have an error in your SQL syntax"
This could be because of your MySQL version.


.

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

More
14 years 8 months ago #4239 by chrisflow
Replied by chrisflow on topic FLEXIContent and ACESEF
Thank you very much for the quick reply!

Here are the full info if it can help:
- Joomla 1.5.14
FLEXIcontent 1.5 beta5
AceSEF 1.3.2
- FLEXIcontent extension for AceSEF 1.3.2
- Joom!Fish 2.0.3
- PHP 5+
- MySQL 5+

I don't think that the MySQL version is the origin of the problem here. the most important part of the error that I receive is more likely to be "SQL=SELECT catid FROM jos_content WHERE id ="

The problem does not occur anymore if I:

1. Disable the FLEXIcontent extension for AceSEF
2. Uninstall Joomfish.

Is there any information page available for Joomfish/AceSEF/Flexicontent versions compatibility?

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

More
14 years 8 months ago #4241 by chrisflow
Replied by chrisflow on topic FLEXIContent and ACESEF
The error occur when this function is executed:
Code:
function getItemCatId($id) { $database =& JFactory::getDBO(); $database->setQuery("SELECT catid FROM #__content WHERE id =".$id); $rows = $database->loadResult(); return $rows; }

Here, $id is null.

Anybody with the same issue?

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

More
14 years 8 months ago #4291 by chrisflow
Replied by chrisflow on topic FLEXIContent and ACESEF
The problem was due to a bug in the ACESEF extension.

It is now solved and working well with the new 1.3.5 version.

Thanks

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.785 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline