From: Sandy S. <ss...@fo...> - 2004-01-26 16:54:49
|
There are a couple of possibilities: 1) You've created the DBFields entry for Organization_Types but the=20 actual picktable itself. To verify this, see if it's listed under the=20 "pick lists" tab in DBasis. Also you can use PHPMyAdmin or the command=20= line to see if the table exists on your database (command is "SHOW=20 TABLES" on the command line). 2) There's a bug in Context. We haven't seen it, but the relevant code=20= in Context is in "display/picktables.php", assuming this bug happens on=20= every page. A quick note about *types tables. Generally Syntax expects them to be=20 mapped to the "type" field in dbfields, and named with the name from=20 the "type" field in the "datatypes" tab in DBasis, contatenated with=20 "types". So an "organisation" object with a list of types of=20 organizations would have a picklist called "organisationtypes". That=20 spares you having to create a field in the records table to store the=20 value. HTH, Sandy On Jan 21, 2004, at 9:00 PM, Adrian Columb wrote: > Hi Syntax team, > =A0 > We have just reinstalled Syntax from CVS so we are working with the=20 > latest version... There is a strange issue where Context isn't finding=20= > all the picktables - eg, when you click on the 'Organization_Types'=20 > picklist in Context it says "Fatal error: mysql error: [1146: Table > 'pxdb.Organization_Types' doesn't exist] in EXECUTE("SHOW COLUMNS FROM=20= > Organization_Types") in > /home/danceportal/PxDB/resources/adodb/adodb-errorhandler.inc.php on=20= > line 76", however when in DBasis I can see that the=20 > 'Organization_Types' picklist is alive and well, though apparently=20 > invisible to Context. Any ideas how to fix this problem? > =A0 > Also, while I was adding 'sunrise' and 'sunset' as=A0'dbfields'=20 > and=A0adding them both to the=A0'contact' data object type that was = asking=20 > for=A0them, I firstly created a 'preferences' entry for both=A0of = them=A0by=20 > mistake - can I just delete these from the 'preferences' section or=20 > are there things that now depend on them/will I break something if I=20= > do? > =A0 > Best, > =A0 > Adrian > !DSPAM:400f2d38168861732337885! -- Sandy Smith, Senior Programmer Forum One Communications, Inc. ss...@fo... tel. 703-548-1855 x28 http://www.forumone.com/ |