Closed rija closed 5 months ago
rija
commented
2 years ago @only1chunts probably will notice this to, but I've stumbled upon this issue now while working on #742, and it's not related to the issue that task is for, so putting it here: it seems github links are not appearing. See http://staging.gigadb.org/dataset/100640
only1chunts
commented
2 years ago n1 - CDbException when trying to update user password or register an account
CONVERTED THIS COMMENT TO TICKET #859
/var/www/vendor/yiisoft/yii/framework/db/CDbCommand.php(358)
346 { 347 if($this->_connection->enableProfiling) 348 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute'); 349 350 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; 351 $message=$e->getMessage(); 352 Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.', 353 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 354 355 if(YII_DEBUG) 356 $message.='. The SQL statement executed was: '.$this->getText().$par; 357 358 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 359 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 360 } 361 } 362 363 /** 364 * Executes the SQL statement and returns query result. 365 * This method is for executing an SQL query that returns result set. 366 * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative 367 * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing 368 * them in this way can improve the performance. Note that if you pass parameters in this way, 369 * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa. 370 * Please also note that all values are treated as strings in this case, if you need them to be handled as
rija
commented
2 years ago Another problem I noticed, iframe in tabs that are not of type "Protocols.io","JBrowse","3D Models", "Code Ocean" won't load due to limitation of server side code. I discovered it as part of #742, but it's not related to CSP configuration so it won't be tackled in that issue.
only1chunts
commented
2 years ago n2 - Dataset Admin table sort not working.
CONVERTED COMMENT TO TICKET #860
None of the admin-dataset page table headers actually sort when clicked. The URL changes, but the table order remains the same, e.g. https://staging.gigadb.org/adminDataset/admin gives the same ordered table as all of these: https://staging.gigadb.org/adminDataset/admin/Dataset_sort/publication_date https://staging.gigadb.org/adminDataset/admin/Dataset_sort/identifier https://staging.gigadb.org/adminDataset/admin/Dataset_sort/manuscript_id https://staging.gigadb.org/adminDataset/admin/Dataset_sort/title https://staging.gigadb.org/adminDataset/admin/Dataset_sort/publication_date https://staging.gigadb.org/adminDataset/admin/Dataset_sort/modification_date
only1chunts
commented
2 years ago n3 - On the tables in most of the Admin pages the text filters do not work in any columns. the space is there at the top of the column to type in, but nothing happens when you click enter.
CONVERTED THIS COMMENT TO TICKET #861
Dataset_author - sort works, filters do not Dataset_Files - sort works, filters do not Dataset_Project - sort work, filters do not Dataset_Links - sort works (not DOI - but thats the same as the current live page!), filters do not Dataset_relations - sork works (not related_DOI - but thats the same as the current live page!), filters do not Dataset_Funders - sort work, filters do not Dataset_manuscript - sort works (not DOI - but thats the same as the current live page!), filters do not Authors - sort work, filters do not Species - sort work, filters do not Projects - sort work, filters do not External_links - sort work (as well as live), filters do not Link_prefixes - sort work, filters do not Funder - sort work, filters do not Attribute - sort work, filters do not Dataset_types - sort work (as well as live), filters do not Data_types - sort work, filters do not File_formats - sort work, filters do not Users - sort work, filters do not News_items - sort work, filters do not RSS_Messages - no data in table - probably do not even need this table in admin pages! Publishers - sort work, filters do not Update_logs - sort work (as well as live), filters do not
rija
commented
5 months ago This has served its purpose
Updated table with results of 20th Jan 2022 checks