Closed (duplicate)
Project:
Taxonomy Lineage
Version:
5.x-1.4
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
26 Feb 2008 at 14:06 UTC
Updated:
1 Sep 2008 at 04:25 UTC
Hello. (This issue is a little different than the other).
I think it's because a bug: Lineage.module creates term_lineage table. But without prefix, althoug the rest of the entire Data Base is created with prefix: Example: "sitio3blocks", "sitio3access". So lineage.module may create sitio3term_lineage.
¿The error I have is because that?. I explain in the following lines:
I can't enable the Lineage module. Or better said, I can enable the module but I get some Warnings:
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: DELETE FROM sitio2term_lineage WHERE tid = '1' in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: INSERT INTO sitio2term_lineage (tid, lineage, depth) VALUES ('1', '10Term 1\n', '0') in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: DELETE FROM sitio2term_lineage WHERE tid = '2' in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: INSERT INTO sitio2term_lineage (tid, lineage, depth) VALUES ('2', '10Term 2\n', '0') in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: DELETE FROM sitio2term_lineage WHERE tid = '3' in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: INSERT INTO sitio2term_lineage (tid, lineage, depth) VALUES ('3', '10Term 3\n', '0') in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: DELETE FROM sitio2term_lineage WHERE tid = '4' in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: INSERT INTO sitio2term_lineage (tid, lineage, depth) VALUES ('4', '10term 4\n', '0') in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: DELETE FROM sitio2term_lineage WHERE tid = '5' in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: INSERT INTO sitio2term_lineage (tid, lineage, depth) VALUES ('5', '10Foro raiz\n', '0') in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: DELETE FROM sitio2term_lineage WHERE tid = '6' in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: INSERT INTO sitio2term_lineage (tid, lineage, depth) VALUES ('6', '10Publico\n', '0') in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: DELETE FROM sitio2term_lineage WHERE tid = '7' in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: INSERT INTO sitio2term_lineage (tid, lineage, depth) VALUES ('7', '10Privado\n', '0') in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: DELETE FROM sitio2term_lineage WHERE tid = '8' in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
user warning: Table 'sitio2.sitio2term_lineage' doesn't exist query: INSERT INTO sitio2term_lineage (tid, lineage, depth) VALUES ('8', '10administracion\n', '0') in C:\xampp\htdocs\drupal-5.7\includes\database.mysql.inc on line 172.
What's I'm doing wrong?. I tried with different test sites, with different modules installed, but always I have the same warnings, or similar warnings.
I expect your answers. Thank you
Comments
Comment #1
ingacosta commentedIt's me again. Sorry.
I resolved the problem. With SQL (RENAME TABLE) I changed the table name, from 'term_lineage' to 'prefixterm_lineage' ('prefix' is a particular site prefix). It works OK
bye
Comment #2
agileware commentedThanks,
As you said, this is because the prefix wasn't being added to the table correctly. This has been fixed.
It's actually a duplicate of #216220: Install broken on installs with prefixed tables.