An installation problem?
| Project: | TBase - Connecting the Nodes |
| Version: | 5.x-5.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | mcfroggie |
| Status: | active |
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
