#0  SQL->sqlDie(Table 'uhydro_db1.wkx_countsAr' doesn't exist, 
[SQL ERROR] SELECT `resourceId`, `creatorSurname`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcetextId`, `resourcetextNote`, `resourcetextAbstract`, `resourcetextUrls`, `resourcetextUrlText`, `resourcetextEditUserIdNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdAbstract`, `resourcetextAddUserIdAbstract`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEND`, `resourcesummaryId`, `resourcesummaryQuotes`, `resourcesummaryParaphrases`, `resourcesummaryMusings`, `resourcetimestampId`, `resourcetimestampTimestamp`, `resourcetimestampTimestampAdd`, `publisherId`, `publisherName`, `publisherLocation`, `publisherType`, `collectionId`, `collectionTitle`, `collectionTitleShort`, `collectionType`, `usersId`, `usersUsername`, `usersFullname`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcecreatorCreatorSurname`, `index` FROM (SELECT `rId`, ROUND(((`accessRatio` / 2.054) * 0.25) + ((`downloadRatio` / 1.035) * 0.75), 4) AS `index` FROM wkx_countsAr LEFT OUTER JOIN wkx_countsDR ON `raId` = `rId` ORDER BY `index` DESC LIMIT 0, 10) AS wkx_t1 LEFT OUTER JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT OUTER JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT OUTER JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` LEFT OUTER JOIN wkx_resource_timestamp ON `resourcetimestampId` = `resourceId` LEFT OUTER JOIN wkx_resource_year ON `resourceyearId` = `resourceId` LEFT OUTER JOIN wkx_resource_text ON `resourcetextId` = `resourceId` LEFT OUTER JOIN wkx_resource_page ON `resourcepageId` = `resourceId` LEFT OUTER JOIN wkx_resource_summary ON `resourcesummaryId` = `resourceId` LEFT OUTER JOIN wkx_resource_metadata ON `resourcemetadataResourceId` = `resourceId` LEFT OUTER JOIN wkx_publisher ON `resourcemiscPublisher` = `publisherId` LEFT OUTER JOIN wkx_collection ON `resourcemiscCollection` = `collectionId` LEFT OUTER JOIN wkx_users ON usersId = CASE WHEN (`resourcemiscEditUserIdResource` IS NOT NULL) THEN (`resourcemiscEditUserIdResource`) ELSE (`resourcemiscAddUserIdResource`) END GROUP BY `resourceId` ORDER BY `index` DESC, IF(`resourcecreatorCreatorSurname` IS NOT NULL, `resourcecreatorCreatorSurname`, `resourceTitleSort`) DESC, `resourceTitleSort` DESC, REPLACE( REPLACE(CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'proceedings' OR `resourceType` = 'proceedings_article') AND `resourceyearYear1` IS NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')) THEN `resourceyearYear2` WHEN ((`resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article') AND `resourceyearYear3` IS NOT NULL ) THEN `resourceyearYear3` ELSE (`resourceyearYear1`) END, '{', ''), '}', '') DESC
) called at [/usr/www/users/uhydro/wikindx/core/libs/SQL.php:3177] #1 SQL->internalQuery(SELECT `resourceId`, `creatorSurname`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcetextId`, `resourcetextNote`, `resourcetextAbstract`, `resourcetextUrls`, `resourcetextUrlText`, `resourcetextEditUserIdNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdAbstract`, `resourcetextAddUserIdAbstract`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcesummaryId`, `resourcesummaryQuotes`, `resourcesummaryParaphrases`, `resourcesummaryMusings`, `resourcetimestampId`, `resourcetimestampTimestamp`, `resourcetimestampTimestampAdd`, `publisherId`, `publisherName`, `publisherLocation`, `publisherType`, `collectionId`, `collectionTitle`, `collectionTitleShort`, `collectionType`, `usersId`, `usersUsername`, `usersFullname`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcecreatorCreatorSurname`, `index` FROM (SELECT `rId`, ROUND(((`accessRatio` / 2.054) * 0.25) + ((`downloadRatio` / 1.035) * 0.75), 4) AS `index` FROM wkx_countsAr LEFT JOIN wkx_countsDR ON `raId` = `rId` ORDER BY `index` DESC LIMIT 0, 10) AS wkx_t1 LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `resourceId` LEFT JOIN wkx_resource_year ON `resourceyearId` = `resourceId` LEFT JOIN wkx_resource_text ON `resourcetextId` = `resourceId` LEFT JOIN wkx_resource_page ON `resourcepageId` = `resourceId` LEFT JOIN wkx_resource_summary ON `resourcesummaryId` = `resourceId` LEFT JOIN wkx_resource_metadata ON `resourcemetadataResourceId` = `resourceId` LEFT JOIN wkx_publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN wkx_collection ON `resourcemiscCollection` = `collectionId` LEFT JOIN wkx_users ON usersId = CASE WHEN (`resourcemiscEditUserIdResource` IS NOT NULL) THEN (`resourcemiscEditUserIdResource`) ELSE (`resourcemiscAddUserIdResource`) END GROUP BY `resourceId` ORDER BY `index` DESC, IF(`resourcecreatorCreatorSurname` IS NOT NULL, `resourcecreatorCreatorSurname`, `resourceTitleSort`) DESC, `resourceTitleSort` DESC, REPLACE( REPLACE(CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'proceedings' OR `resourceType` = 'proceedings_article') AND `resourceyearYear1` IS NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')) THEN `resourceyearYear2` WHEN ((`resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article') AND `resourceyearYear3` IS NOT NULL ) THEN `resourceyearYear3` ELSE (`resourceyearYear1`) END, '{', ''), '}', '') DESC, ) called at [/usr/www/users/uhydro/wikindx/core/libs/SQL.php:255] #2 SQL->query(SELECT `resourceId`, `creatorSurname`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcetextId`, `resourcetextNote`, `resourcetextAbstract`, `resourcetextUrls`, `resourcetextUrlText`, `resourcetextEditUserIdNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdAbstract`, `resourcetextAddUserIdAbstract`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcesummaryId`, `resourcesummaryQuotes`, `resourcesummaryParaphrases`, `resourcesummaryMusings`, `resourcetimestampId`, `resourcetimestampTimestamp`, `resourcetimestampTimestampAdd`, `publisherId`, `publisherName`, `publisherLocation`, `publisherType`, `collectionId`, `collectionTitle`, `collectionTitleShort`, `collectionType`, `usersId`, `usersUsername`, `usersFullname`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcecreatorCreatorSurname`, `index` FROM (SELECT `rId`, ROUND(((`accessRatio` / 2.054) * 0.25) + ((`downloadRatio` / 1.035) * 0.75), 4) AS `index` FROM wkx_countsAr LEFT JOIN wkx_countsDR ON `raId` = `rId` ORDER BY `index` DESC LIMIT 0, 10) AS wkx_t1 LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `resourceId` LEFT JOIN wkx_resource_year ON `resourceyearId` = `resourceId` LEFT JOIN wkx_resource_text ON `resourcetextId` = `resourceId` LEFT JOIN wkx_resource_page ON `resourcepageId` = `resourceId` LEFT JOIN wkx_resource_summary ON `resourcesummaryId` = `resourceId` LEFT JOIN wkx_resource_metadata ON `resourcemetadataResourceId` = `resourceId` LEFT JOIN wkx_publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN wkx_collection ON `resourcemiscCollection` = `collectionId` LEFT JOIN wkx_users ON usersId = CASE WHEN (`resourcemiscEditUserIdResource` IS NOT NULL) THEN (`resourcemiscEditUserIdResource`) ELSE (`resourcemiscAddUserIdResource`) END GROUP BY `resourceId` ORDER BY `index` DESC, IF(`resourcecreatorCreatorSurname` IS NOT NULL, `resourcecreatorCreatorSurname`, `resourceTitleSort`) DESC, `resourceTitleSort` DESC, REPLACE( REPLACE(CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'proceedings' OR `resourceType` = 'proceedings_article') AND `resourceyearYear1` IS NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')) THEN `resourceyearYear2` WHEN ((`resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article') AND `resourceyearYear3` IS NOT NULL ) THEN `resourceyearYear3` ELSE (`resourceyearYear1`) END, '{', ''), '}', '') DESC, 1) called at [/usr/www/users/uhydro/wikindx/core/lists/LISTCOMMON.php:230] #3 LISTCOMMON->display(SELECT `resourceId`, `creatorSurname`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcetextId`, `resourcetextNote`, `resourcetextAbstract`, `resourcetextUrls`, `resourcetextUrlText`, `resourcetextEditUserIdNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdAbstract`, `resourcetextAddUserIdAbstract`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcesummaryId`, `resourcesummaryQuotes`, `resourcesummaryParaphrases`, `resourcesummaryMusings`, `resourcetimestampId`, `resourcetimestampTimestamp`, `resourcetimestampTimestampAdd`, `publisherId`, `publisherName`, `publisherLocation`, `publisherType`, `collectionId`, `collectionTitle`, `collectionTitleShort`, `collectionType`, `usersId`, `usersUsername`, `usersFullname`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcecreatorCreatorSurname`, `index` FROM (SELECT `rId`, ROUND(((`accessRatio` / 2.054) * 0.25) + ((`downloadRatio` / 1.035) * 0.75), 4) AS `index` FROM wkx_countsAr LEFT JOIN wkx_countsDR ON `raId` = `rId` ORDER BY `index` DESC LIMIT 0, 10) AS wkx_t1 LEFT JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` LEFT JOIN wkx_resource_timestamp ON `resourcetimestampId` = `resourceId` LEFT JOIN wkx_resource_year ON `resourceyearId` = `resourceId` LEFT JOIN wkx_resource_text ON `resourcetextId` = `resourceId` LEFT JOIN wkx_resource_page ON `resourcepageId` = `resourceId` LEFT JOIN wkx_resource_summary ON `resourcesummaryId` = `resourceId` LEFT JOIN wkx_resource_metadata ON `resourcemetadataResourceId` = `resourceId` LEFT JOIN wkx_publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN wkx_collection ON `resourcemiscCollection` = `collectionId` LEFT JOIN wkx_users ON usersId = CASE WHEN (`resourcemiscEditUserIdResource` IS NOT NULL) THEN (`resourcemiscEditUserIdResource`) ELSE (`resourcemiscAddUserIdResource`) END GROUP BY `resourceId` ORDER BY `index` DESC, IF(`resourcecreatorCreatorSurname` IS NOT NULL, `resourcecreatorCreatorSurname`, `resourceTitleSort`) DESC, `resourceTitleSort` DESC, REPLACE( REPLACE(CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'proceedings' OR `resourceType` = 'proceedings_article') AND `resourceyearYear1` IS NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')) THEN `resourceyearYear2` WHEN ((`resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article') AND `resourceyearYear3` IS NOT NULL ) THEN `resourceyearYear3` ELSE (`resourceyearYear1`) END, '{', ''), '}', '') DESC, list) called at [/usr/www/users/uhydro/wikindx/core/modules/list/LISTRESOURCES.php:183] #4 LISTRESOURCES->processGeneral() called at [/usr/www/users/uhydro/wikindx/index.php:110]


[SQL ERROR] SELECT `resourceId`, `creatorSurname`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceBibtexKey`, `resourceDoi`, `resourcetextId`, `resourcetextNote`, `resourcetextAbstract`, `resourcetextUrls`, `resourcetextUrlText`, `resourcetextEditUserIdNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdAbstract`, `resourcetextAddUserIdAbstract`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEND`, `resourcesummaryId`, `resourcesummaryQuotes`, `resourcesummaryParaphrases`, `resourcesummaryMusings`, `resourcetimestampId`, `resourcetimestampTimestamp`, `resourcetimestampTimestampAdd`, `publisherId`, `publisherName`, `publisherLocation`, `publisherType`, `collectionId`, `collectionTitle`, `collectionTitleShort`, `collectionType`, `usersId`, `usersUsername`, `usersFullname`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscTag`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcemiscQuarantine`, `resourcecreatorCreatorSurname`, `index` FROM (SELECT `rId`, ROUND(((`accessRatio` / 2.054) * 0.25) + ((`downloadRatio` / 1.035) * 0.75), 4) AS `index` FROM wkx_countsAr LEFT OUTER JOIN wkx_countsDR ON `raId` = `rId` ORDER BY `index` DESC LIMIT 0, 10) AS wkx_t1 LEFT OUTER JOIN wkx_resource_creator ON `resourcecreatorResourceId` = `resourceId` LEFT OUTER JOIN wkx_creator ON `creatorId` = `resourcecreatorCreatorId` LEFT OUTER JOIN wkx_resource_misc ON `resourcemiscId` = `resourceId` LEFT OUTER JOIN wkx_resource_timestamp ON `resourcetimestampId` = `resourceId` LEFT OUTER JOIN wkx_resource_year ON `resourceyearId` = `resourceId` LEFT OUTER JOIN wkx_resource_text ON `resourcetextId` = `resourceId` LEFT OUTER JOIN wkx_resource_page ON `resourcepageId` = `resourceId` LEFT OUTER JOIN wkx_resource_summary ON `resourcesummaryId` = `resourceId` LEFT OUTER JOIN wkx_resource_metadata ON `resourcemetadataResourceId` = `resourceId` LEFT OUTER JOIN wkx_publisher ON `resourcemiscPublisher` = `publisherId` LEFT OUTER JOIN wkx_collection ON `resourcemiscCollection` = `collectionId` LEFT OUTER JOIN wkx_users ON usersId = CASE WHEN (`resourcemiscEditUserIdResource` IS NOT NULL) THEN (`resourcemiscEditUserIdResource`) ELSE (`resourcemiscAddUserIdResource`) END GROUP BY `resourceId` ORDER BY `index` DESC, IF(`resourcecreatorCreatorSurname` IS NOT NULL, `resourcecreatorCreatorSurname`, `resourceTitleSort`) DESC, `resourceTitleSort` DESC, REPLACE( REPLACE(CASE WHEN ((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article') AND `resourceyearYear2` IS NOT NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'proceedings' OR `resourceType` = 'proceedings_article') AND `resourceyearYear1` IS NULL ) THEN `resourceyearYear2` WHEN ((`resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')) THEN `resourceyearYear2` WHEN ((`resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article') AND `resourceyearYear3` IS NOT NULL ) THEN `resourceyearYear3` ELSE (`resourceyearYear1`) END, '{', ''), '}', '') DESC

Table 'uhydro_db1.wkx_countsAr' doesn't exist