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

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

That's great, I appreciate it. I have got it up and running finally.

The only problem is when I go to edit some data in the data part of
Dbasis and it crops up with this error which I have forgotten how to
solve. Can anyone shed any light on this?

----------[snip]----------
Warning: [PxDB] You have not set the pxdb_pref for datastore[path] or
datastore[url]. File uploads will not work. in
/home/danceportal/PxDB/classes/pxdb.class.php on line 151
----------[snip]----------

Cheers, Ian.


-----Original Message-----
From: Nyk Cowham [mailto:nc...@fo...] 
Sent: 09 May 2003 20:36
To: Randum Ian; web...@li...
Subject: RE: [Websyntax-core] More Database Woes!!!

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
>
>