RE: [Websyntax-core] More Database Woes!!!

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

I have replicated this error:

It only happens if you have the 0.0.4 package files and have applied the changes to the database discussed a few days ago. If you
have the CVS version with those database changes applied everything is peachy.

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

> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...]On Behalf Of Randum
> Ian
> Sent: Wednesday, May 09, 2001 2:09 PM
> To: web...@li...
> Subject: [Websyntax-core] More Database Woes!!!
>
>
> 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
>
>
>
>
>
> -------------------------------------------------------
> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
> The only event dedicated to issues related to Linux enterprise solutions
> www.enterpriselinuxforum.com
>
> _______________________________________________
> Websyntax-core mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/websyntax-core
>
>