From: Randum I. <ia...@ra...> - 2003-05-09 18:08:56
|
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 |
From: Nyk C. <nc...@fo...> - 2003-05-09 19:36:04
|
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 > > |
From: Randum I. <ia...@ra...> - 2003-05-09 22:07:23
|
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 > > |
From: Nyk C. <nc...@fo...> - 2003-05-09 22:44:22
|
> 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. This is a warning that DBasis gives to remind you to tell Syntax where to store uploaded files and what base URL to give them. Use DBasis and select the Preferences tab. You need to add two preferences: 1. pref_name=datastore, pref_key=path, pref_value=/path/to/upload/files 2. pref_name=datastore, pref_key=url, pref_value=http://www.danceportal/files Nyk > -----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 > > > > > > > > > ------------------------------------------------------- > 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 > > |