RE: [Websyntax-core] Syntax Datatypes, Relationships dropdown and Context problems

[Nyk C. <nc...@fo...>]

> Firstly, when I log in to dbasis, then go to 'data', then select
> 'organisation' from
> the dropdown menu, then click 'add record' I get the following error:
>
> Fatal error: mysql error: [1146: Table 'pxdb.organisationtypes' doesn't
> exist] in EXECUTE("SHOW COLUMNS FROM organisationtypes") in
> /home/danceportal/www/dbasis/includes/errorhandler.inc.php on line 77
>
> That error reffers to the 'organisationtypes' datatype that I had
> previously created in the datatypes section of dbasis, and then subsequently
> deleted when I realised it wasn't needed. Should allow us to delete
> datatypes without it getting messed up like that? How can we fix it when it
> does?

Normatively it should delete all references to a table that has been deleted, but positively it probably isn't doing that currently.
Anyhoo, you need to remove any reference to the deleted table from your datatype definition (you probably have a field defined that
is using that table - or maybe it is a field defined in dbfields.

> Secondly, when I go to the 'objects' section and try to create a field in a
> datatype in that is a relationship, the relationships dropdown menu doesn't
> display the list of relationship types (which are defined in the
> Relationships section of dbasis) However, when I try to edit one of the
> fileds that is predefined as a relationship the dropdown list of
> Relationships shows up just fine.

This seems to be a new bug that has formed. Probably something to do with session persistance. I will put it in the bug tracker.

> Thirdly, we can't log in to context with the default username/password
> details even though we haven't changed the details.

Don't know why that should happen. Seems fine on the new instances that I have installed recently.

Nyk Cowham, Systems Architect
Forum One Communications
http://www.forumone.com/
Communicate Collaborate Change the world