#3 DBasis throws SQL error when updating datatypes


When I attempted to update an existing datatype using
the "Datatypes" tab in DBasis, I got the following
fatal error message:

Fatal error: mysql error: [1054: Unknown column 'dt1'
in 'where clause'] in EXECUTE("SELECT id FROM
relationships WHERE (dt1 = 2 OR dt2 = 2) ORDER BY
weight") in
on line 77

When I then attempted to move on to another datatype by
clicking the Edit button for that one, I received a
screen with the same error -- only now the datatype
that had thrown the first error was completely gone
from the datatypes list.

I managed to clear nearly all the datatypes out of the
list just by clicking Edit on a new one as each
previous one threw the error.

The data does not appear to be completely gone: the
"Current datatype" drop-down in the Objects tab is
still correctly populated. However, the Datatypes tab
seems to have completely lost track of what datatypes
actually exist.

Screenshot (from Mozilla 1.3b, Windows 2000) attached.


  • Jason Lefkowitz

    Jason Lefkowitz - 2003-02-26
    • priority: 5 --> 7
  • Nyk Cowham

    Nyk Cowham - 2003-03-11
    • assigned_to: nobody --> ncowham
  • Sandy Smith

    Sandy Smith - 2003-04-23

    Logged In: YES

    This appears to be fixed in the latest CVS version.

  • Sandy Smith

    Sandy Smith - 2003-05-05

    Logged In: YES

    Spoke too soon, it bit me again.

  • Sandy Smith

    Sandy Smith - 2003-05-05
    • status: open --> open-fixed
  • Sandy Smith

    Sandy Smith - 2003-05-05

    Logged In: YES

    Update your copy of /DBasis/datatypes/datatypes.disp.php
    from CVS. I eliminated the 'parent relid' column as this
    feature was not fully implemented and should be eliminated
    from the user interface until we decide it would be useful
    and commit to implementing it.

  • Sandy Smith

    Sandy Smith - 2003-05-05
    • status: open-fixed --> closed-fixed

Log in to post a comment.