An installation problem?

mcfroggie - February 25, 2008 - 23:10
Project:TBase - Connecting the Nodes
Version:5.x-5.x-dev
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:mcfroggie
Status:active
Description

Hi!

This seems to be just what I need. The problem is that I can't get it to work.

The following is what I get, when I install the module and create some data (1 group + 1 person + their relationship) to try it out. When I try to enter Tbase under the person or the group, I get:

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT DISTINCT(tbase_temptable.tbd_id) FROM tbase_temptable LEFT JOIN tbase_term_descriptions ON tbase_temptable.tbd_id = tbase_term_descriptions.tbd_id WHERE tbase_term_descriptions.tbd_id IS NULL OR tid IN () in C:\xampplite\htdocs\webs\newsite\includes\database.mysql.inc on line 172.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ))' at line 1 query: SELECT DISTINCT(tbase_temptable.nid) FROM tbase_temptable LEFT JOIN node_access ON tbase_temptable.nid = node_access.nid WHERE ( (node_access.nid IS NULL) OR ( realm = 'tac_lite' AND gid IN () )) in C:\xampplite\htdocs\webs\newsite\includes\database.mysql.inc on line 172.
* user warning: Unknown column 'tbt_timestamp' in 'field list' query: CREATE TEMPORARY TABLE tbase_temptable SELECT tbt_id, tbt_uid, tbt_timestamp, tbt_did, CASE WHEN tbt_nid1 = 2 THEN tbd_ntype1 ELSE tbd_ntype2 END AS type, CASE WHEN tbt_nid1 = 2 THEN tbd_des1 ELSE tbd_des2 END AS des, CASE WHEN tbt_nid1 = 2 THEN tbt_nid2 ELSE tbt_nid1 END AS nid FROM tbase_transactions, tbase_descriptions WHERE tbt_did = tbd_id && ((tbt_nid1 = 2 AND tbd_ntype2 = 'person') OR (tbt_nid2 = 2 AND tbd_ntype1 = 'person')) in C:\xampplite\htdocs\webs\newsite\includes\database.mysql.inc on line 172.
* user warning: Table 'newsite.tbase_temptable' doesn't exist query: SELECT COUNT(*) FROM tbase_temptable in C:\xampplite\htdocs\webs\newsite\includes\database.mysql.inc on line 172.

I did this on a plain drupal 5.7 and installed only tbase + tac_lite, nothing else. Do I need something else to get it working?

Thanks

 
 

Drupal is a registered trademark of Dries Buytaert.