[Websyntax-core] Re: [Websyntax-users] Database problems

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

I assume this is in the relationships table. I'm not sure why the 
fields dt1 and dt2 should be deleted, but they were never used by the 
system--it was an experimental feature that was never completed, so I 
took it out. It should be fine to leave them out of that table as they 
don't do anything.

Now, if this is causing you database errors, be sure of two things:

a) that the CVS copies are really overwriting these files. The most 
offensive ones are in PxDB/classes/metadata and in DBasis/datatypes.

b) that you re-name the 'unique' field in typesfields to 'is_unique'. 
That isn't caught by the upgrade script currently.

I have that code working on three sites in-house. If you still get 
errors, post the text of them here and I'll take a look at them.

On Thursday, May 8, 2003, at 04:21 AM, Randum Ian wrote:

> Morning guys,
>
> We are in the process of implementing Syntax on our server now and we 
> have
> updated to the latest version on CVS as of Tuesday. We are having 
> serious
> problems with fields not being found in our database when we try to add
> records with Dbasis namely dt1 and dt2. We add these fields back but 
> they
> disappear just as fast. I noticed that this problem was noted and a 
> fix was
> implemented so would it be best to just delete the db and apply the sql
> file and make a fresh instance of the tables. Would the errors go away 
> are
> is it something else that we should be noting?
>
> 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-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/websyntax-users
>
>
--
Sandy Smith, Senior Programmer
Forum One Communications
<ss...@fo...>
http://www.forumone.com/
tel. (703) 548-1855 x28