when updated the dev version to the latest version i got this error

user warning: Unknown column 'nodeslocales' in 'field list' query: SELECT nodeslocales, switch_uicontent FROM localizeruser WHERE uid = 1 in /home/iblogger/public_html/includes/database.mysql.inc on line 172.

Comments

sun’s picture

sun
Primary language German
Location Karlsruhe
commented

@Roberto: Seems like database update is screwed up. http://drupal.org/node/115306 reported by ray007 was exactly the negation of this issue.

@ahmedshoukry: Could you please try the latest development snapshot of 5.x? I couldn't find an instance of 'nodeslocales' in there, so it might be fixed already.

Roberto Gerola’s picture

Roberto Gerola commented

It seems that you have updated correctly the database but not some localizer modules.
I have made a search through all the sources and they are all updated.

Be sure you have overwritten correctly all the files of localizer.

Let me know.

abqaria’s picture

abqaria commented

i uploaded all the localizer module again
user warning: Unknown column 'nodeslocales' in 'field list' query: SELECT nodeslocales, switch_uicontent FROM localizeruser WHERE uid = 1 in /home/iblogger/public_html/includes/database.mysql.inc on line 172.

abqaria’s picture

abqaria commented

during update i chose update no 1

i got this

localizer module
Update #1

* UPDATE {variable} SET name='localizer_usernodeslocales' WHERE name='localizer_usernodeslocale'
* UPDATE {variable} SET name='localizer_anonymousnodeslocales' WHERE name='localizer_anonymousnodeslocale'

but i still get the error

maybe something got wrong because i updated my site while not in the offline mode ?

sun’s picture

sun
Primary language German
Location Karlsruhe
commented

Please ensure that you have replaced all files with the files from the latest version. You also need to remove any files that are no longer in the latest development snapshot. You may ensure this by creating a backup of your old localizer module directory, deleting all files in this directory and extracting the new version into it.

If you system complains about unknown column 'nodeslocales' (which is 'contentlocales' now), then you're definitely using old or orphan files. Please also ensure that you do not have installed localizer twice, f.e. once in /sites/all and another one somewhere else.

abqaria’s picture

abqaria commented

i deleted the old directory, uploaded new localizer, reinstalled..same errors

Roberto Gerola’s picture

Roberto Gerola commented

What version are you using now ?

If you have upgrade from 1.7 to a dev version, probably you have updated your db
and now it is no more compatible with 1.7 version.

In phpmyadmin go to the table localizeruser and rename the column contentslocales
to nodeslocale.

Let me know.

caligari’s picture

caligari commented

I have resolved this problem:

Before copy localizer-1.7 backport module: delete records in 'system' table where filename like 'modules/localizer/%'. Deploy localizer and active it in modules administration...

abqaria’s picture

abqaria commented

i do not understand localizer backport module

i originally used the dev version before the 1.7

the problem started after upgrading to 1.7 final version

Roberto Gerola’s picture

Roberto Gerola commented

Can you try this ?

>In phpmyadmin go to the table localizeruser and rename the column
> contentslocales to nodeslocale.

abqaria’s picture

abqaria commented

i did change the colum now i get this in the update

user warning: Unknown column 'nodeslocales' in 'field list' query: SELECT nodeslocales, switch_uicontent FROM localizeruser WHERE uid = 1 in /home/iblogger/public_html/includes/database.mysql.inc on line 172.

Roberto Gerola’s picture

Roberto Gerola commented

Sorry, my mistake

The name of the column if the table is nodeslocales and not nodeslocale.

abqaria’s picture

abqaria commented

the error disappeared in the update process

thanks

Roberto Gerola’s picture

Roberto Gerola commented
Status: Active » Closed (fixed)