Using i18n I can create a sliteshow node, but I cannot create a slide. I'am getting the error:

# user warning: Unknown column 'n.language' in 'where clause' query: SELECT vid, title FROM node WHERE (n.language ='nl' OR n.language ='' OR n.language IS NULL) AND ( type = 'fpss_slideshow') in /home/cmseasyn/public_html/drupal-6/sites/all/modules/fpss/fpss.module on line 361.
# You must create a slideshow before you can create a slide.

The slideshow roldown menu in the slide edit page stay's empty.
I did some tests with different i18n settings (als with 1 language) in the settings of the slideshow node and slide node, with no results.

Comments

wilco’s picture

wilco CreditAttribution: wilco commented
Status: Active » Needs review

Ah, this is quite interesting. I've not done any testing for this.

I'll have to look into it.

Thanks for the heads up.

dddave’s picture

dddave CreditAttribution: dddave commented

I confirm this error. Explains my problems at #397976: Unable to add slide.

dddave’s picture

dddave CreditAttribution: dddave commented

The system is Drupal 6.10, I18n 6x-1.0.

dddave’s picture

dddave CreditAttribution: dddave commented

With one month between these postings: Is there any progress or at least hope for progress?

If not you should at the very least put a big warning onto the project page.

Burhank’s picture

Burhank CreditAttribution: Burhank commented

Hey guys...
I have the very same problem and I havent sleep in the past 3 days and I didnt find a solution.. SO finally i had to change something in the fpss.module at line 361 so it can work and ignore the language field but I have the Slideshow mixed with all my nodes now and I cant even use it on other languages interface (Cant translate it) but still I guess its something you can use until the Frontpage Slideshow guys release a more stable module and give us some attention...

Open fpss.module and go to line 360 and find:
$sql = "SELECT vid, title FROM {node} WHERE type = '%s'";

Replace it with:
$sql = "SELECT vid, title FROM {node} as n ";

-----------------------------------------------------------------------------

I hope someone can find a solution how to enable this module to other languages.

Blessings,
Burhan

cmseasy’s picture

cmseasy CreditAttribution: cmseasy commented

There is a new module development: http://drupal.org/project/views_showcase, it is a views solution and looks like fpss. Maybe an other solution and maybe working together with i18n. Sorry, I did not test views showcase.

dddave’s picture

dddave CreditAttribution: dddave commented

Just for the record:

I am using the Dynamic Display Block module and rue paying for fpss. DDB works fine and although it is not as easy to set up it is well documented and superbly maintained.

DVD_GR’s picture

DVD_GR CreditAttribution: DVD_GR commented

i get the same for drupal 5

user warning: Column 'status' in where clause is ambiguous query: SELECT vid, title FROM node n LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='el' OR i18n.language ='' OR i18n.language IS NULL) AND ( type = 'fpss_slideshow' AND status = 1) in /home/dividee/public_html/includes/database.mysql.inc on line 174.

i made the fix Burhank told but still doesnt work for me :(((
i dont care for the multilanguage just to get it work !!

the error after Burhank fix in module for drupal 5 is

user warning: 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 status = 0 LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language' at line 1 query: SELECT vid, title FROM node as n AND status = 0 LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='el' OR i18n.language ='' OR i18n.language IS NULL) in /home/dividee/public_html/includes/database.mysql.inc on line 174.