Jump to content

Topic on Manual talk:Extensions

NormalRichard (talkcontribs)

This is the full message of what happened when I got Error 1146. The URL is: "http://objectshowpedia.com".

"Error 1146: Table 'vellewmy_objectshowpedia.objectshowpediaecho_event' doesn't exist

Function: MediaWiki\Extension\Notifications\Mapper\EventMapper::fetchUnreadByUserAndPage

Query: SELECT event_id,event_type,event_variant,event_agent_id,event_agent_ip,event_extra,event_page_id,event_deleted,notification_timestamp FROM `objectshowpediaecho_event` JOIN `objectshowpediaecho_notification` ON ((notification_event=event_id)) JOIN `objectshowpediaecho_target_page` ON ((etp_event=event_id)) WHERE event_deleted = 0 AND notification_user = 1 AND notification_read_timestamp IS NULL AND etp_page = 1

Backtrace:

from /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(1203)

#0 /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(1187): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)

#1 /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(1161): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#2 /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(652): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#3 /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(1350): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)

#4 /home1/vellewmy/public_html/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)

#5 /home1/vellewmy/public_html/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call(string, array)

#6 /home1/vellewmy/public_html/extensions/Echo/includes/Mapper/EventMapper.php(160): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)

#7 /home1/vellewmy/public_html/extensions/Echo/includes/Hooks.php(872): MediaWiki\Extension\Notifications\Mapper\EventMapper->fetchUnreadByUserAndPage(MediaWiki\User\User, integer)

#8 /home1/vellewmy/public_html/extensions/Echo/includes/Hooks.php(972): MediaWiki\Extension\Notifications\Hooks->processMarkAsRead(MediaWiki\User\User, MediaWiki\Request\WebRequest, MediaWiki\Title\Title)

#9 /home1/vellewmy/public_html/includes/HookContainer/HookContainer.php(159): MediaWiki\Extension\Notifications\Hooks->onSkinTemplateNavigation__Universal(MediaWiki\Skin\Timeless\SkinTimeless, array)

#10 /home1/vellewmy/public_html/includes/HookContainer/HookRunner.php(3581): MediaWiki\HookContainer\HookContainer->run(string, array, array)

#11 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(964): MediaWiki\HookContainer\HookRunner->onSkinTemplateNavigation__Universal(MediaWiki\Skin\Timeless\SkinTimeless, array)

#12 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(1357): SkinTemplate->runOnSkinTemplateNavigationHooks(MediaWiki\Skin\Timeless\SkinTimeless, array)

#13 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(607): SkinTemplate->buildContentNavigationUrlsInternal()

#14 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(594): SkinTemplate->getPortletsTemplateData()

#15 /home1/vellewmy/public_html/includes/skins/Skin.php(766): SkinTemplate->getCategoryLinks()

#16 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(212): Skin->getCategories()

#17 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(145): SkinTemplate->prepareQuickTemplate()

#18 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(176): SkinTemplate->generateHTML()

#19 /home1/vellewmy/public_html/includes/Output/OutputPage.php(3004): SkinTemplate->outputPage()

#20 /home1/vellewmy/public_html/includes/actions/ActionEntryPoint.php(162): MediaWiki\Output\OutputPage->output(boolean)

#21 /home1/vellewmy/public_html/includes/MediaWikiEntryPoint.php(199): MediaWiki\Actions\ActionEntryPoint->execute()

#22 /home1/vellewmy/public_html/index.php(58): MediaWiki\MediaWikiEntryPoint->run()

#23 {main}

Exception caught inside exception handler: [ZtTf-OMQz6Kc9GkW1PdExwAAAgk] /index.php/Main_Page Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1146: Table 'vellewmy_objectshowpedia.objectshowpediaecho_event' doesn't exist

Function: MediaWiki\Extension\Notifications\Mapper\EventMapper::fetchUnreadByUserAndPage

Query: SELECT event_id,event_type,event_variant,event_agent_id,event_agent_ip,event_extra,event_page_id,event_deleted,notification_timestamp FROM `objectshowpediaecho_event` JOIN `objectshowpediaecho_notification` ON ((notification_event=event_id)) JOIN `objectshowpediaecho_target_page` ON ((etp_event=event_id)) WHERE event_deleted = 0 AND notification_user = 1 AND notification_read_timestamp IS NULL AND etp_page = 1

Backtrace:

from /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(1203)

#0 /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(1187): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)

#1 /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(1161): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#2 /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(652): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#3 /home1/vellewmy/public_html/includes/libs/rdbms/database/Database.php(1350): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)

#4 /home1/vellewmy/public_html/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)

#5 /home1/vellewmy/public_html/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call(string, array)

#6 /home1/vellewmy/public_html/extensions/Echo/includes/Mapper/EventMapper.php(160): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)

#7 /home1/vellewmy/public_html/extensions/Echo/includes/Hooks.php(872): MediaWiki\Extension\Notifications\Mapper\EventMapper->fetchUnreadByUserAndPage(MediaWiki\User\User, integer)

#8 /home1/vellewmy/public_html/extensions/Echo/includes/Hooks.php(972): MediaWiki\Extension\Notifications\Hooks->processMarkAsRead(MediaWiki\User\User, MediaWiki\Request\WebRequest, MediaWiki\Title\Title)

#9 /home1/vellewmy/public_html/includes/HookContainer/HookContainer.php(159): MediaWiki\Extension\Notifications\Hooks->onSkinTemplateNavigation__Universal(MediaWiki\Skin\Timeless\SkinTimeless, array)

#10 /home1/vellewmy/public_html/includes/HookContainer/HookRunner.php(3581): MediaWiki\HookContainer\HookContainer->run(string, array, array)

#11 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(964): MediaWiki\HookContainer\HookRunner->onSkinTemplateNavigation__Universal(MediaWiki\Skin\Timeless\SkinTimeless, array)

#12 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(1357): SkinTemplate->runOnSkinTemplateNavigationHooks(MediaWiki\Skin\Timeless\SkinTimeless, array)

#13 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(607): SkinTemplate->buildContentNavigationUrlsInternal()

#14 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(594): SkinTemplate->getPortletsTemplateData()

#15 /home1/vellewmy/public_html/includes/skins/Skin.php(766): SkinTemplate->getCategoryLinks()

#16 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(212): Skin->getCategories()

#17 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(145): SkinTemplate->prepareQuickTemplate()

#18 /home1/vellewmy/public_html/includes/skins/SkinTemplate.php(176): SkinTemplate->generateHTML()

#19 /home1/vellewmy/public_html/includes/Output/OutputPage.php(3004): SkinTemplate->outputPage()

#20 /home1/vellewmy/public_html/includes/exception/MWExceptionRenderer.php(189): MediaWiki\Output\OutputPage->output()

#21 /home1/vellewmy/public_html/includes/exception/MWExceptionRenderer.php(106): MWExceptionRenderer::reportHTML(Wikimedia\Rdbms\DBQueryError)

#22 /home1/vellewmy/public_html/includes/exception/MWExceptionHandler.php(133): MWExceptionRenderer::output(Wikimedia\Rdbms\DBQueryError, integer)

#23 /home1/vellewmy/public_html/includes/exception/MWExceptionHandler.php(237): MWExceptionHandler::report(Wikimedia\Rdbms\DBQueryError)

#24 /home1/vellewmy/public_html/includes/MediaWikiEntryPoint.php(221): MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError, string)

#25 /home1/vellewmy/public_html/includes/actions/ActionEntryPoint.php(82): MediaWiki\MediaWikiEntryPoint->handleTopLevelError(Wikimedia\Rdbms\DBQueryError)

#26 /home1/vellewmy/public_html/includes/MediaWikiEntryPoint.php(205): MediaWiki\Actions\ActionEntryPoint->handleTopLevelError(Wikimedia\Rdbms\DBQueryError)

#27 /home1/vellewmy/public_html/index.php(58): MediaWiki\MediaWikiEntryPoint->run()

#28 {main}"


Does somebody know how to fix it? If it was an extension that broke the wiki, I don't know which one.

Samwilson (talkcontribs)

@NormalRichard: Is this the same issue that you reported at the support desk? Generally, it's best to just create one thread so that the discussion isn't fragmented.

Here, the error is that the database table 'vellewmy_objectshowpedia.objectshowpediaecho_event' doesn't exist, which is for the Echo extension. You probably need to run the update script.

Reply to "Error 1146"