[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] Subject management



Hi all,

In my 3.3.10 repository when i access to Admin --> Config tools --> Edit 
Subjects i notice a big amount of select error in the apache logs. I 
tried to export and reimport the subject trees without any effect. 
Generally Subject trees seems to work well, both in italian and in english.
Analyzing the first SELECT you can see that changing in the last row 
784773520subject_ancestorswith 784768448subject_ancestorsthe select 
seems to execute.
Any idea ?

Best regards,
Paolo Tealdi


DBD::mysql::st execute failed: Unknown column 
'784773520subject_ancestors.ancestors' in 'where clause' at 
/dati/eprints/perl_lib/EPrints/Database.pm line 3210.
SQL ERROR (execute): SELECT `eprint`.`eprintid` FROM `eprint`, (SELECT 
`eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint_divisions` AS 
`eprint_divisions`, `su
bject_ancestors` AS `784803132subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_divisions`.`eprintid` AND 
`eprint_divisions`.`divisions`=`784803132subject_ancesto
rs`.`subjectid` AND (`784803132subject_ancestors`.`ancestors` = 'ROOT') 
UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, 
`eprint_ssd` AS `eprint_ssd`, `
subject_ancestors` AS `784822952subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_ssd`.`eprintid` AND 
`eprint_ssd`.`ssd`=`784822952subject_ancestors`.`subjectid`
AND (`784822952subject_ancestors`.`ancestors` = 'ROOT') UNION SELECT 
`eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint_userdep` AS 
`eprint_userdep`, `subject_
ancestors` AS `784768488subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_userdep`.`eprintid` AND 
`eprint_userdep`.`userdep`=`784768488subject_ancestors`.`subject
id` AND (`784768488subject_ancestors`.`ancestors` = 'ROOT') UNION SELECT 
`eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint_subjects` AS 
`eprint_subjects`, `su
bject_ancestors` AS `784789288subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_subjects`.`eprintid` AND 
`eprint_subjects`.`subjects`=`784789288subject_ancestors`
.`subjectid` AND (`784789288subject_ancestors`.`ancestors` = 'ROOT') 
UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, 
`eprint_language` AS `eprint_langu
age`, `subject_ancestors` AS `784768808subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_language`.`eprintid` AND 
`eprint_language`.`language`=`784768808subject_a
ncestors`.`subjectid` AND (`784768808subject_ancestors`.`ancestors` = 
'ROOT') UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, 
`eprint` AS `eprint_78476
8448` INNER JOIN `subject_ancestors` AS `784768448subject_ancestors` ON 
`eprint_784768448`.`phd`=`784768448subject_ancestors`.`subjectid` WHERE 
`eprint`.`eprintid`=`
eprint_784768448`.`eprintid` AND 
(`784768448subject_ancestors`.`ancestors` = 'ROOT' OR 
`784773520subject_ancestors`.`ancestors` = 'ROOT')) AS `or_784793780` 
WHERE `e
print`.`eprintid`=`or_784793780`.`eprintid` GROUP BY `eprint`.`eprintid`
SQL ERROR (execute): Unknown column 
'784773520subject_ancestors.ancestors' in 'where clause'
DBD::mysql::st fetch failed: fetch() without execute() at 
/dati/eprints/perl_lib/EPrints/Search/Condition.pm line 587.
DBD::mysql::st execute failed: Unknown column 
'784775660subject_ancestors.ancestors' in 'where clause' at 
/dati/eprints/perl_lib/EPrints/Database.pm line 3210.
SQL ERROR (execute): SELECT `eprint`.`eprintid` FROM `eprint`, (SELECT 
`eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint_divisions` AS 
`eprint_divisions`, `su
bject_ancestors` AS `784785648subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_divisions`.`eprintid` AND 
`eprint_divisions`.`divisions`=`784785648subject_ancesto
rs`.`subjectid` AND (`784785648subject_ancestors`.`ancestors` = 'ssd') 
UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, 
`eprint_ssd` AS `eprint_ssd`, `s
ubject_ancestors` AS `784767048subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_ssd`.`eprintid` AND 
`eprint_ssd`.`ssd`=`784767048subject_ancestors`.`subjectid` A
ND (`784767048subject_ancestors`.`ancestors` = 'ssd') UNION SELECT 
`eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint_userdep` AS 
`eprint_userdep`, `subject_an
cestors` AS `784775580subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_userdep`.`eprintid` AND 
`eprint_userdep`.`userdep`=`784775580subject_ancestors`.`subjectid
` AND (`784775580subject_ancestors`.`ancestors` = 'ssd') UNION SELECT 
`eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint_subjects` AS 
`eprint_subjects`, `subje
ct_ancestors` AS `784803892subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_subjects`.`eprintid` AND 
`eprint_subjects`.`subjects`=`784803892subject_ancestors`.`s
ubjectid` AND (`784803892subject_ancestors`.`ancestors` = 'ssd') UNION 
SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, 
`eprint_language` AS `eprint_language`
, `subject_ancestors` AS `784767748subject_ancestors` WHERE 
`eprint`.`eprintid`=`eprint_language`.`eprintid` AND 
`eprint_language`.`language`=`784767748subject_ances
tors`.`subjectid` AND (`784767748subject_ancestors`.`ancestors` = 'ssd') 
UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint` 
AS `eprint_784776360`
  INNER JOIN `subject_ancestors` AS `784776360subject_ancestors` ON 
`eprint_784776360`.`phd`=`784776360subject_ancestors`.`subjectid` WHERE 
`eprint`.`eprintid`=`eprin
t_784776360`.`eprintid` AND (`784776360subject_ancestors`.`ancestors` = 
'ssd' OR `784775660subject_ancestors`.`ancestors` = 'ssd')) AS 
`or_784800536` WHERE `eprint`.
`eprintid`=`or_784800536`.`eprintid` GROUP BY `eprint`.`eprintid`


-- 
Ing. Paolo Tealdi         Area IT - Politecnico Torino
Telefono/Phone : +39-011-0906714 , FAX : +39-011-0906799
Indirizzo/Address : C.so Duca degli Abruzzi,  24 - 10129 Torino - ITALY
Skype : tealdi.paolo
Please consider your environmental responsibility before printing this e-mail