PDOException: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'ij': SELECT DISTINCT p.result_publication_id,YEAR(jn.published_on) AS pub_year FROM ibn_person_result_publications p INNER JOIN ibn_result_publications rp ON rp.id=p.result_publication_id INNER JOIN ibn_journal_numbers jn ON jn.id=rp.journal_number_id LEFT JOIN ibn_journals_categories ijc ON ijc.journal_id =jn.journal_id LEFT JOIN ibn_journals ij ON ij.id = jn.journal_id LEFT JOIN ibn_journals ij ON ij.id = jn.journal_id WHERE person_id = 11919 AND ij.country_id = 100 AND ((jn.published_on) between (ijc.begin_date) and (ijc.end_date)) AND ijc.category_id = 3 AND ij.country_id = 100 AND YEAR(jn.published_on) > 2009 AND rp.id NOT IN(20486,24634,24705,29045,46935,46780,49867,45181,45183,45203,46877,55676,65077,75407,109227,117220,117235,130902,130935,152111) AND rp.classification_id NOT IN(8,12) ORDER BY pub_year DESC; Array ( ) in author_view_article() (line 469 of /var/www/sites/idsi/ibn2014/trunk/sites/all/modules/author_view/author_view.page.inc).
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'idsi_ibn2014.drupal_watchdog' doesn't exist: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:1017:"SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'ij': SELECT DISTINCT p.result_publication_id,YEAR(jn.published_on) AS pub_year FROM ibn_person_result_publications p INNER JOIN ibn_result_publications rp ON rp.id=p.result_publication_id INNER JOIN ibn_journal_numbers jn ON jn.id=rp.journal_number_id LEFT JOIN ibn_journals_categories ijc ON ijc.journal_id =jn.journal_id LEFT JOIN ibn_journals ij ON ij.id = jn.journal_id LEFT JOIN ibn_journals ij ON ij.id = jn.journal_id WHERE person_id = 11919 AND ij.country_id = 100 AND ((jn.published_on) between (ijc.begin_date) and (ijc.end_date)) AND ijc.category_id = 3 AND ij.country_id = 100 AND YEAR(jn.published_on) > 2009 AND rp.id NOT IN(20486,24634,24705,29045,46935,46780,49867,45181,45183,45203,46877,55676,65077,75407,109227,117220,117235,130902,130935,152111) AND rp.classification_id NOT IN(8,12) ORDER BY pub_year DESC; Array ( ) ";s:9:"%function";s:21:"author_view_article()";s:5:"%file";s:84:"/var/www/sites/idsi/ibn2014/trunk/sites/all/modules/author_view/author_view.page.inc";s:5:"%line";i:469;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => https://ibn.idsi.md/author_articles/11919?other_journ=2&page=1&rev_cat=3&rev_cat=3 [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => 3.145.69.74 [:db_insert_placeholder_9] => 1719572785 ) in dblog_watchdog() (line 157 of /var/www/sites/idsi/ibn2014/trunk/modules/dblog/dblog.module).