[Websyntax-core] More Database Woes!!!

[Randum I. <ia...@ra...>]

Right, more woes lie ahead!

I re-installed Syntax from the ground up, cleared the db out and put the
SQL file in and reinstalled all the various components. I specifically
checked that the relationships table was correct which it was. I then
went into Dbasis and tried to modify one of the Datatypes and I got this
error

----------[snip]----------
Fatal error: mysql error: [1054: Unknown column 'dt1' in 'where clause']
in EXECUTE("SELECT id FROM relationships WHERE (dt1 = 1 OR dt2 = 1)
ORDER BY weight") in
/home/danceportal/www/dbasis/includes/errorhandler.inc.php on line 77
----------[snip]----------

I then went back and checked the database and the relationships table
had shrunk to just "id", "description" and "weight".

Can anyone shed any light on what is happening?

Regards,
Randum Ian
ia...@ra...
DancePortalGlobal Webmaster
http://www.danceportalglobal.com