DB error with joomfish / translate url

Welcome, Guest

(1 viewing) (1) Guest

Support forum for users using free edition of JoomSEF 3 (Joomla 1.5 compatible). These forums are mainly for mutual help between users.

Please note that due to our capacity limitations, we do not monitor these forums regularly.

Reply Topic

New Topic

Page:
1

TOPIC: DB error with joomfish / translate url

DB error with joomfish / translate url 16 years, 9 months ago #3907

AndreasST
OFFLINE
Posts: 2

Griaß eich!

PROBLEM:

DB function failed with error number 1064
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 'AND jf_content.published=1 AND jf_content.reference_id IN(136,137,135,138,139' at line 4 SQL=SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos1012_jf_content AS jf_content WHERE jf_content.language_id= AND jf_content.published=1 AND jf_content.reference_id IN(136,137,135,138,139,140,141) AND jf_content.reference_table='menu'

IF
\"JoomFish language selection\" is published and \"Translate URLs\" is to NO
OR
\"JoomFish language selection\" is unpublished and \"Translate URLs\" is to YES
THERE IS
no DB error

BUT:
I need the language selection AND the translated URLs
In the future we will have 4 languages on our site humimeter.com

Does somebody know how to solve the problem?

Greetings from Austria!
Andreas

Reply Quote

Re:DB error with joomfish / translate url 16 years, 9 months ago #3939

dglite
OFFLINE
Posts: 2

Hi!: here is one solution:

www.joomlacat.org/index.php?option=com_k...id=4&id=1135

I translate here That solution:

-open the file...

components/com_joomfish/includes/joomfish.class.php

and edit this line...

. \&quot;\nWHERE jf_content.language_id=\&quot;.$languages[$language]-&gt;id

Change it for this line...

. \&quot;\nWHERE jf_content.language_id=\&quot;.( $languages[$language]-&gt;id!=0 ? $languages[$language]-&gt;id : 2)

It should work, at least worked for them. Regards...

Reply Quote

Re:DB error with joomfish / translate url 16 years, 9 months ago #3945

AndreasST OFFLINE Posts: 2	Thanks a lot dglite! This works for our site too. Greetings from Austria! Andreas
	Reply Quote

Re:DB error with joomfish / translate url 16 years, 9 months ago #3949

dglite OFFLINE Posts: 2	Your are welcome Andreas, grettings from Argentina... Craion.com
	Reply Quote

Re:DB error with joomfish / translate url 16 years, 8 months ago #3970

skelle OFFLINE Posts: 5	this fix works great indeed!! Thanks for your help during a stressful go-live day :) Greetings from Belgium!
	Reply Quote

Reply Topic

New Topic

Page:
1

Support