Empty list of terms in vocabularies

Update: Forums are affected

Forums are still there, topics can be posted and allocated to forums and containers
However, the page admin/content/ reports "There are no existing containers or forums. Containers and forums may be added using the add container and add forum pages."

Update

1) Even if I create new terms, the list of terms remains empty
2) This seems to be related to the D6.9 release. A backup site still in D6.8 is correct

I ran an additional update.php after updating to i18n dev
Got a lot of errors, and then everything seems OK now.

So I consider the problem isn't exist actually. Reopening later if necessary

Closing the issue.

The bug is back.

I hapend to get back the taxonomy term lists for sometime, but they have gone again.

Even the forums disappeartotally: I can get them back by opening and saving the "Modules" page. They last for sometime and disappear.

Can someone look at this issue?
(seems to be from D6.9

Update:
What is quite interesting is that depending of the number of terms that are actually defined (but not appearing in the term list), the pager appears in the bottom and allows to browse the several - empty! - pages.
What can prevent this page to display the terms, but being aware of those terms?

Note: Taxonomy translation is not set in the Module page

Enabling or disabling i18n doesn't fix
Taxonomy terms have gone as explain above
Forums are present at ?q=forum, however?q=admin/content/forum report "There are no existing containers or forums. Containers and forums may be added using the add container and add forum pages."

I first suspected D6.8 > D6.9, but nejo at #5 thought it was from i18n

I disabled absolutely all contributed modules and core options but forum and taxonomy.
Still the same:
- no forums in admin/content/forum
though several forums exist and appear in the "forum" page
- no taxonomy terms in admin/content/taxonomy/1...
though several vocabularies exist and appear in admin/content/taxonomy and terms actually exist (even the pager appears on the public tags -empty - list)

So this seems a bug related to the core 6.9

Can someone help?

I suspect that this problem coudl come from an dev version of the i18n pacakge or other contributing module that could have broken something.
Which datbase tables should I look into to diagnose, and possibly repair this problem, as I seem to be alone in this situation?

I've already investigated a lot...
1) I just checked everything in the database that is related to taxonomy. Nothing is wrong. A pair site under D6.8 works correctly wth exactly the same data in all "term_*" tables.

2) I tried to create a new vocabulary and adding new terms. Same behaviour: the term is in the database, but not on the display.

3) I defined a view for displaying terms like this:
SELECT term_data.tid AS tid, term_data.weight AS term_data_weight, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.description AS term_data_description, vocabulary.name AS vocabulary_name FROM term_data term_data LEFT JOIN vocabulary vocabulary ON term_data.vid = vocabulary.vid

It works perfectly.

So my conclusion is that the databas is OK, no modules interfer on this, and this has something to do with the Drupal core, maybe D6.9.

Please help!!!

Some news.
I defined a new user with vocabulary admin permission.

This time, I get errors when trying to list free tagging vocabularies. (I did not got any error as admin):

Example for admin/content/taxonomy/2 (public tags)

1) Selecting the English language:

user warning: Unknown column 'n.language' in 'where clause' query: SELECT count(*) FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access') OR (na.gid = 14 AND na.realm = 'term_access'))) AND (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( t.vid = 100) in /home/controlc/www/modules/taxonomy/taxonomy.admin.inc on line 282.

2) Selecting the French language:

user warning: Unknown column 'n.language' in 'where clause' query: SELECT count(*) FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access') OR (na.gid = 14 AND na.realm = 'term_access'))) AND (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( t.vid = 100) in /home/controlc/www/modules/taxonomy/taxonomy.admin.inc on line 282.

Could this have something to do with my issue?

Also, I ran the query that seems to gather the list of term:
SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 1 ORDER BY weight, name

It returns the correct values of course.

What you mean by "forcing an update" ?
I already tried several times to run update.php

May be you mean selected the latest version of some modules instead of keeping "No update available"?
Is there any risk doing so?

Is "Core module" called "system" ?

Thanks a lot

I tried to update the different modules that seem to be related to the issue.
I got the warnings about the dupplicate columns.

However, I got other errors that seem abnormal:

user warning: Table 'ccg1.i18n_node' doesn't exist query: UPDATE node n INNER JOIN i18n_node i ON n.nid = i.nid SET n.language = i.language, n.tnid = i.trid in /home/controlc/www/sites/all/modules/i18n/i18n.install on line 81.

user warning: Table 'ccg1.i18n_node' doesn't exist query: UPDATE node n SET n.tnid = (SELECT MIN(i.nid) FROM i18n_node i WHERE i.trid = n.tnid) WHERE n.tnid > 0 in /home/controlc/www/sites/all/modules/i18n/i18n.install on line 83.

(note that this i18n_node table is not in the database of my other site that works correctly)

Anyway, this did not help to solve my problem

In this post, you told that they were no important warning
http://drupal.org/node/294915

This is a long standing issue, starting from Drupal core, going to i18n, back to Drupal core, now again i18n

Though taxonomy and forums are affected, we did not found anything on this side.

Can you look if this can come from the latest update of i18n

Can I try to downgrade this module? If so, how to proceed?

I just made a fresh install, run update.php, import the data base. Still the same behaviour
I got the same warning about the missing i18n tables during the install/update

Thanks for your help

I did so, and I finally recovered the taxonomy terms lists and forums by re-enabling the modules one by one.
However, the database appeared to be totally corrupted by all these manipulations.
(forcing updates seems rather destructive)

I restored a 5 days old database, and everything seems fine now. I hope it will stay so...

Thank you for your attention and your patience