Bilingual product issue

[netshine]

It seems something has changed in Joomfish 2.0.4. It works ok in 2.0.3. I am looking into it.

[G.deangeli]

Thanks a lot!
I appreciate
G ?rard

[netshine]

Ok, Joomfish now requires a column alias if the same column is used in the criteria for a query. I have amended the code to take account of this, and applied the change to your site, which seems to be working ok now. For the benefit of anyone else who wants to take advantage of this, here is a replacement /administrator/components/com_nbill/admin.proc/invoices.php file (which will be included in the next release of nBill).

[attachment deleted by admin]

[netshine]

...and here is a replacement /components/com_nbill/proc/invoices.php file (for showing the correct text on the invoice list in the front end).

[attachment deleted by admin]

[G.deangeli]

Hi
Works fine now.
Thanks a lot for your help.
Regards
G ?rard

[G.deangeli]

...and here is a replacement /components/com_nbill/proc/invoices.php file (for showing the correct text on the invoice list in the front end).

Hi Russell
I have an error message on front-end in relation to Joomfish :
No valid database connection La table 'global2009_globalnet.jos_gwesys_mlmenu' n'existe pas SQL=Select * from jos_gwesys_mlmenu where menuid in (53)
I raised a ticket with Joomfish support, but I was wondering if this had anything to do with the change made recently in the code for the issue at hand?

Regards.
G ?rard
 

[netshine]

No, that is not coming from nBill. Looks like a custom menu module is missing a table in the database.

[G.deangeli]

No, that is not coming from nBill. Looks like a custom menu module is missing a table in the database.

From what I have read in the forums, it has something to do with Joomfish menu localisation plugin (and the conditions for using it).
Anyhow, when I disable this plugin, the message disappears.
But I will check further with them
Thanks
G ?rard