Re: [Websyntax-core] Context picktables issues and deleting preferences questions

[Sandy S. <ss...@fo...>]

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/