language 'undefined' after upgrading to PRO

  • slingshotsean
  • Topic Author
  • Visitor
  • Visitor
11 years 6 months ago #1683 by slingshotsean
language 'undefined' after upgrading to PRO was created by slingshotsean
Hiya

I recently upgraded an extension from a free version to the pro version and now all the items (160x) are showing with language 'undefined' instead of 'all'. No solutions to be found on your website, unfortunately :(

My searching revealed the following solution;

joomlacode.org/gf/project/feedgator/foru...owse&thread_id=21280

2011-11-01 08:48:36 Re: Problem with Undefined Language
Posted By: Phil Bauer
Join Date: 2010-06-09
Location: UNITED STATES
Message ID: 59141

Until this is fixed as promised in the next feedgator version (??? if that ever happens ???)...

Use your mySQL utility (e.g. phpMyAdmin) to manually edit the #__content table and set a default (as defined) for the “language” column to an asterisk *.
Problem solved. The language will now show as "All" when editing articles in Joomla Maybe this should be the way the table is created to begin with in Joomla?

To fix the entire table run this query from your mySQL utility...
Update #__content SET language='*' WHERE language=''

Don't forget to suplment your Joomla table prefix for the #__ prefix used in each of the cases above.

In phpMyAdmin > DB > SQL I tried to execute this command:
Update j25_gmapfp SET language='*' WHERE language=''

When I pressed UPDATE, this was reported on the screen;

UPDATE `j25_gmapfp` SET `id`=[value-1],`nom`=[value-2],`alias`=[value-3],`adresse`=[value-4],`adresse2`=[value-5],`ville`=[value-6],`departement`=[value-7],`codepostal`=[value-8],`pay`=[value-9],`tel`=[value-10],`tel2`=[value-11],`fax`=[value-12],`email`=[value-13],`web`=[value-14],`img`=[value-15],`album`=[value-16],`introtext`=[value-17],`fulltext`=[value-18],`horaires_prix`=[value-19],`link`=[value-20],`article_id`=[value-21],`icon`=[value-22],`icon_label`=[value-23],`affichage`=[value-24],`marqueur`=[value-25],`glng`=[value-26],`glat`=[value-27],`gzoom`=[value-28],`catid`=[value-29],`created_by`=[value-30],`published`=[value-31],`access`=[value-32],`checked_out`=[value-33],`metadesc`=[value-34],`metakey`=[value-35],`metadata`=[value-36],`hits`=[value-37],`version`=[value-38],`modified`=[value-39],`modified_by`=[value-40],`created`=[value-41],`publish_up`=[value-42],`publish_down`=[value-43],`ordering`=[value-44],`attribs`=[value-45],`index_marqueur`=[value-46],`language`=[value-47],`classements`=[value-48],`labels`=[value-49],`pictos`=[value-50] WHERE 1


When I clicked GO, it showed an error, so I tried a slight variation;
Update j25_gmapfp SET language='*' WHERE language='NULL'

... and clicked GO, but this has not resolved the issue.

Please could you tell me why this SQL command is not working to change all the items in GMapFP from 'undefined' to 'all' or give me an alternative solution.

Many thanks, Sean

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

More
11 years 6 months ago #1689 by gmapfp
Hi,

The Pro version of GMapFP is encoded for accept the language field at ''.

What is your default ?

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

Time to create page: 0.089 seconds
Powered by Kunena Forum
FaLang translation system by Faboba