EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #01099

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[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