[SPT/CWIS] wpoison

[Edward Almasy]

On Jun 7, 2006, at 3:19 PM, Cornejo, Luis A. wrote:
> I was able to upgrade to 1.4.0, but this is what I get now
>
> SQL Statement: select ControlledNames.ControlledName,
> ControlledNames.ControlledNameId, ControlledNames.ControlledNameTypeId
> from ControlledNames, ControlledNameTypes, ResourceNameInts where
> ResourceNameInts.ResourceId=690 and
> ResourceNameInts.ControlledNameId=ControlledNames.ControlledNameId and
> ControlledNameTypes.ControlledNameTypeId=ControlledNames.ControlledNam 
> eT
> ypeId and (ControlledNameTypes.ControlledNameTypeName='Audience' or
> ControlledNameTypes.ControlledNameTypeName='Format');
> SQL Error: Table 'ENC2.ControlledNameTypes' doesn't exist

    I believe the ControlledNameTypes table went away a couple
    of years ago and doesn't appear anywhere in 1.4.0 except for
    possibly the upgrade code that's run during installation, so
    my guess would be that you've got some old PHP code hanging
    around in an HTML file that you customized, that makes use of
    that table.

    Ed


---
    Edward Almasy                                      
ealmasy at scout.wisc.edu
    Co-Director                                         1210 W Dayton  
Street
    Internet Scout                                          Madison  
WI 53706
    Computer Sciences Department                        608-262-6606  
(voice)
    University of Wisconsin - Madison                      
608-265-9296 (fax)