Extension talk:Echo

Jump to navigation Jump to search

About this board

Problems Setting up Echo on my MediaWiki

10
Summary by KHarlan (WMF)

There is a phab task for this problem, and also a patch (just uploaded). Let's continue the discussion on that phab task. Thanks!

MasterBanri (talkcontribs)

I followed the installation step by step but when i load the wfLoadExtension( 'Echo' ); then when i load my wiki page, i get the following. I did run the update script through the web option. But it didnt do anything, can i get any help?

MediaWiki internal error.

Original exception: [XjeZihQ@PlaIURwVhWHuVAAAANc] /Special:Version Wikimedia\Rdbms\DBQueryError from line 1587 of /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT COUNT(*) AS `rowcount` FROM (SELECT 1 FROM `wikiecho_notification` LEFT JOIN `wikiecho_event` ON ((notification_event=event_id)) WHERE notification_user = '4' AND notification_read_timestamp IS NULL AND event_deleted = '0' AND event_type IN ('edit-user-talk','reverted','mention','mention-summary','mention-failure','mention-failure-too-many','mention-success','user-rights','emailuser','foreign') LIMIT 100 ) `tmp_count`

Function: EchoUserNotificationGateway::getCappedNotificationCount

Error: 1146 Table 'gemwiki.wikiecho_notification' doesn't exist (localhost)


Backtrace:

#0 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1556): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#1 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1784): Wikimedia\Rdbms\Database->query(string, string)

#3 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1929): Wikimedia\Rdbms\Database->select(array, array, array, string)

#4 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/gateway/UserNotificationGateway.php(171): Wikimedia\Rdbms\Database->selectRowCount(array, string, array, string, array, array)

#5 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/NotifUser.php(543): EchoUserNotificationGateway->getCappedNotificationCount(integer, array, integer)

#6 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/NotifUser.php(502): MWEchoNotifUser->computeLocalCountsAndTimestamps()

#7 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/objectcache/WANObjectCache.php(1414): MWEchoNotifUser->{closure}(boolean, integer, array, NULL)

#8 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/objectcache/WANObjectCache.php(1275): WANObjectCache->doGetWithSetCallback(string, integer, Closure, array)

#9 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/NotifUser.php(503): WANObjectCache->getWithSetCallback(string, integer, Closure)

#10 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/NotifUser.php(182): MWEchoNotifUser->getCountsAndTimestamps(boolean)

#11 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/NotifUser.php(134): MWEchoNotifUser->getNotificationCount(string)

#12 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/EchoHooks.php(966): MWEchoNotifUser->getMessageCount()

#13 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/Hooks.php(174): EchoHooks::onPersonalUrls(array, Title, SkinVector)

#14 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/Hooks.php(234): Hooks::callHook(string, array, array, NULL, string)

#15 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/skins/SkinTemplate.php(762): Hooks::runWithoutAbort(string, array)

#16 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/skins/SkinTemplate.php(463): SkinTemplate->buildPersonalUrls()

#17 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/skins/SkinTemplate.php(228): SkinTemplate->prepareQuickTemplate()

#18 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/OutputPage.php(2723): SkinTemplate->outputPage()

#19 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/MediaWiki.php(872): OutputPage->output(boolean)

#20 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/MediaWiki.php(884): MediaWiki->{closure}()

#21 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/MediaWiki.php(515): MediaWiki->main()

#22 /var/www/vhosts/geministation.com/wiki.geministation.com/index.php(42): MediaWiki->run()

#23 {main}

Exception caught inside exception handler: [XjeZihQ@PlaIURwVhWHuVAAAANc] /Special:Version Wikimedia\Rdbms\DBQueryError from line 1587 of /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT COUNT(*) AS `rowcount` FROM (SELECT 1 FROM `wikiecho_notification` LEFT JOIN `wikiecho_event` ON ((notification_event=event_id)) WHERE notification_user = '4' AND notification_read_timestamp IS NULL AND event_deleted = '0' AND event_type IN ('edit-user-talk','reverted','mention','mention-summary','mention-failure','mention-failure-too-many','mention-success','user-rights','emailuser','foreign') LIMIT 100 ) `tmp_count`

Function: EchoUserNotificationGateway::getCappedNotificationCount

Error: 1146 Table 'gemwiki.wikiecho_notification' doesn't exist (localhost)

KHarlan (WMF) (talkcontribs)

What configuration values do you have in place related to Echo?

Do you have multiple wikis (and databases) served from this one document root?

It certainly looks like update.php didn’t run. KHarlan (WMF) (talk) 08:18, 3 February 2020 (UTC)

MasterBanri (talkcontribs)

I only have 1 wiki and wont need multiple.

I dont have any config values, just the loading code: wfLoadExtension( 'Echo' );

Is that the issue?

I ran the web updater but yeah...

MasterBanri (talkcontribs)

I guess this thread isnt active enough to provide help.

KHarlan (WMF) (talkcontribs)

@MasterBanri it looks like update.php didn't run. Can you try via the command-line, if you have access?

MasterBanri (talkcontribs)

MediaWiki internal error.

Original exception: [XjsztnVLTtZUulTtYuz-1AAAAQs] /Main_Page Wikimedia\Rdbms\DBQueryError from line 1587 of /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT event_id,event_type,event_variant,event_agent_id,event_agent_ip,event_extra,event_page_id,event_deleted,notification_timestamp FROM `wikiecho_event` INNER JOIN `wikiecho_notification` ON ((notification_event=event_id)) INNER JOIN `wikiecho_target_page` ON ((etp_event=event_id)) WHERE event_deleted = '0' AND notification_user = '3' AND notification_read_timestamp IS NULL AND etp_page = '1'

Function: EchoEventMapper::fetchUnreadByUserAndPage

Error: 1146 Table 'gemwiki.wikiecho_event' doesn't exist (localhost)

Backtrace:

#0 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1556): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#1 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1784): Wikimedia\Rdbms\Database->query(string, string)

#3 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/mapper/EventMapper.php(151): Wikimedia\Rdbms\Database->select(array, array, array, string, NULL, array)

#4 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/EchoHooks.php(885): EchoEventMapper->fetchUnreadByUserAndPage(User, integer)

#5 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/EchoHooks.php(962): EchoHooks::processMarkAsRead(User, WebRequest, Title)

#6 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/Hooks.php(174): EchoHooks::onPersonalUrls(array, Title, SkinVector)

#7 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/Hooks.php(234): Hooks::callHook(string, array, array, NULL, string)

#8 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/skins/SkinTemplate.php(762): Hooks::runWithoutAbort(string, array)

#9 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/skins/SkinTemplate.php(463): SkinTemplate->buildPersonalUrls()

#10 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/skins/SkinTemplate.php(228): SkinTemplate->prepareQuickTemplate()

#11 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/OutputPage.php(2723): SkinTemplate->outputPage()

#12 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/MediaWiki.php(872): OutputPage->output(boolean)

#13 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/MediaWiki.php(884): MediaWiki->{closure}()

#14 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/MediaWiki.php(515): MediaWiki->main()

#15 /var/www/vhosts/geministation.com/wiki.geministation.com/index.php(42): MediaWiki->run()

#16 {main}

Exception caught inside exception handler: [XjsztnVLTtZUulTtYuz-1AAAAQs] /Main_Page Wikimedia\Rdbms\DBQueryError from line 1587 of /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT event_id,event_type,event_variant,event_agent_id,event_agent_ip,event_extra,event_page_id,event_deleted,notification_timestamp FROM `wikiecho_event` INNER JOIN `wikiecho_notification` ON ((notification_event=event_id)) INNER JOIN `wikiecho_target_page` ON ((etp_event=event_id)) WHERE event_deleted = '0' AND notification_user = '3' AND notification_read_timestamp IS NULL AND etp_page = '1'

Function: EchoEventMapper::fetchUnreadByUserAndPage

Error: 1146 Table 'gemwiki.wikiecho_event' doesn't exist (localhost)

Backtrace:

#0 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1556): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#1 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/libs/rdbms/database/Database.php(1784): Wikimedia\Rdbms\Database->query(string, string)

#3 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/mapper/EventMapper.php(151): Wikimedia\Rdbms\Database->select(array, array, array, string, NULL, array)

#4 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/EchoHooks.php(885): EchoEventMapper->fetchUnreadByUserAndPage(User, integer)

#5 /var/www/vhosts/geministation.com/wiki.geministation.com/extensions/Echo/includes/EchoHooks.php(962): EchoHooks::processMarkAsRead(User, WebRequest, Title)

#6 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/Hooks.php(174): EchoHooks::onPersonalUrls(array, Title, SkinVector)

#7 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/Hooks.php(234): Hooks::callHook(string, array, array, NULL, string)

#8 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/skins/SkinTemplate.php(762): Hooks::runWithoutAbort(string, array)

#9 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/skins/SkinTemplate.php(463): SkinTemplate->buildPersonalUrls()

#10 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/skins/SkinTemplate.php(228): SkinTemplate->prepareQuickTemplate()

#11 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/OutputPage.php(2723): SkinTemplate->outputPage()

#12 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/exception/MWExceptionRenderer.php(134): OutputPage->output()

#13 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/exception/MWExceptionRenderer.php(53): MWExceptionRenderer::reportHTML(Wikimedia\Rdbms\DBQueryError)

#14 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/exception/MWExceptionHandler.php(98): MWExceptionRenderer::output(Wikimedia\Rdbms\DBQueryError, integer)

#15 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/exception/MWExceptionHandler.php(172): MWExceptionHandler::report(Wikimedia\Rdbms\DBQueryError)

#16 /var/www/vhosts/geministation.com/wiki.geministation.com/includes/MediaWiki.php(542): MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError)

#17 /var/www/vhosts/geministation.com/wiki.geministation.com/index.php(42): MediaWiki->run()

#18 {main}

Lostraven (talkcontribs)

I'm having a similar problem. Apparently multiple people over the years have had similar issues. Yes, I ran the updater.


MediaWiki internal error.

Original exception: [Xjyg-XCz3wOr8mEEXQNjgwAAAAk] 2020-02-06 23:27:57: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Exception caught inside exception handler.

Lostraven (talkcontribs)

Apparently this problem has been happening for more than four years! I wish I could understand why this isn't yet resolved in all that time. Yes, the web updater isn't creating the tables. Yes, I'm on a hosted solution. No, I have no clue how to do this: "So I went to phpMyAdmin and imported the echo.sql to create the new tables." I'm going to try the trick mentioned by AhmadF.Cheema here:


UPDATE: Ahmad's method seems to have worked for me.

Step 1. Add this to the bottom of your LocalSettings.php:

# Schema updates for update.php
$wgHooks['LoadExtensionSchemaUpdates'][] = 'fnMyHook';
function fnMyHook( DatabaseUpdater $updater ) {
$updater->addExtensionTable( 'echo_target_page',
__DIR__ . '/echo.sql' );
return true;
}

Step 2. Go to Extensions/Echo and copy echo.sql to both the base directory (where LocalSettings.php resides) and to the Maintenance folder. (Ahmad wasn't sure which folder it pulls from.)


Step 3. Run the web updater again. Walla! The tables are created. Presumably I can then remove the added material from Step 1 and 2.

Lustiger seth (talkcontribs)

thanks!
i installed a mediawiki 1.31 LTS today and had a similar problem with the Echo extension (1_31 branch).

update.php did not work, but printed (and still prints) error messages all the time, such as:

 Wikimedia\Rdbms\DBConnectionError from line 1004 of .../includes/libs/rdbms/database/Database.php: Cannot access the database: No such file or directory (localhost)

your solution solved my problem, too! Echo works fine now. :-)

Iamchenzetian (talkcontribs)

it works by the method above


Thanks!

Reply to "Problems Setting up Echo on my MediaWiki"
Chopin2712 (talkcontribs)

Hello, I have just installed Echo on my Mediawiki install but the mentions are not working. I don't receive any notifications when I use format. Can you help me? I don't know what to do. I will also add that I didn't setted up any config. This is my only configuration for this extension:

wfLoadExtension( 'Echo' );
105.112.50.57 (talkcontribs)

Did you get solution?

Chopin2712 (talkcontribs)

No, sorry

Reply to "Mentions doesn't work"

My site breaks when logging in after installing echo

2
2601:601:9A80:26B0:2D85:B2E1:AB74:F8EA (talkcontribs)

MediaWiki internal error.

Original exception: [X1VXyH0qFBPD7urcbpcUrgAAOjk] /index.php?title=User:68duck Wikimedia\Rdbms\DBQueryError from line 1603 of /home4/anskidsc/public_html/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT event_id,event_type,event_variant,event_agent_id,event_agent_ip,event_extra,event_page_id,event_deleted,notification_timestamp FROM `mwu2_echo_event` INNER JOIN `mwu2_echo_notification` ON ((notification_event=event_id)) INNER JOIN `mwu2_echo_target_page` ON ((etp_event=event_id)) WHERE event_deleted = '0' AND notification_user = '1' AND notification_read_timestamp IS NULL AND etp_page = '11'

Function: EchoEventMapper::fetchUnreadByUserAndPage

Error: 1146 Table 'anskidsc_mw19395.mwu2_echo_event' doesn't exist (localhost)

Backtrace:

#0 /home4/anskidsc/public_html/wiki/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#1 /home4/anskidsc/public_html/wiki/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 /home4/anskidsc/public_html/wiki/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query(string, string)

#3 /home4/anskidsc/public_html/wiki/extensions/Echo/includes/mapper/EventMapper.php(171): Wikimedia\Rdbms\Database->select(array, array, array, string, NULL, array)

#4 /home4/anskidsc/public_html/wiki/extensions/Echo/includes/EchoHooks.php(872): EchoEventMapper->fetchUnreadByUserAndPage(User, integer)

#5 /home4/anskidsc/public_html/wiki/extensions/Echo/includes/EchoHooks.php(949): EchoHooks::processMarkAsRead(User, WebRequest, Title)

#6 /home4/anskidsc/public_html/wiki/includes/Hooks.php(174): EchoHooks::onPersonalUrls(array, Title, SkinMinerva)

#7 /home4/anskidsc/public_html/wiki/includes/Hooks.php(234): Hooks::callHook(string, array, array, NULL, string)

#8 /home4/anskidsc/public_html/wiki/includes/skins/SkinTemplate.php(744): Hooks::runWithoutAbort(string, array)

#9 /home4/anskidsc/public_html/wiki/includes/skins/SkinTemplate.php(446): SkinTemplate->buildPersonalUrls()

#10 /home4/anskidsc/public_html/wiki/skins/MinervaNeue/includes/skins/SkinMinerva.php(150): SkinTemplate->prepareQuickTemplate()

#11 /home4/anskidsc/public_html/wiki/includes/skins/SkinTemplate.php(215): SkinMinerva->prepareQuickTemplate()

#12 /home4/anskidsc/public_html/wiki/includes/OutputPage.php(2574): SkinTemplate->outputPage()

#13 /home4/anskidsc/public_html/wiki/includes/MediaWiki.php(907): OutputPage->output(boolean)

#14 /home4/anskidsc/public_html/wiki/includes/MediaWiki.php(919): MediaWiki->{closure}()

#15 /home4/anskidsc/public_html/wiki/includes/MediaWiki.php(527): MediaWiki->main()

#16 /home4/anskidsc/public_html/wiki/index.php(44): MediaWiki->run()

#17 {main}

Exception caught inside exception handler: [X1VXyH0qFBPD7urcbpcUrgAAOjk] /index.php?title=User:68duck Wikimedia\Rdbms\DBQueryError from line 1603 of /home4/anskidsc/public_html/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT event_id,event_type,event_variant,event_agent_id,event_agent_ip,event_extra,event_page_id,event_deleted,notification_timestamp FROM `mwu2_echo_event` INNER JOIN `mwu2_echo_notification` ON ((notification_event=event_id)) INNER JOIN `mwu2_echo_target_page` ON ((etp_event=event_id)) WHERE event_deleted = '0' AND notification_user = '1' AND notification_read_timestamp IS NULL AND etp_page = '11'

Function: EchoEventMapper::fetchUnreadByUserAndPage

Error: 1146 Table 'anskidsc_mw19395.mwu2_echo_event' doesn't exist (localhost)

Backtrace:

#0 /home4/anskidsc/public_html/wiki/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#1 /home4/anskidsc/public_html/wiki/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 /home4/anskidsc/public_html/wiki/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query(string, string)

#3 /home4/anskidsc/public_html/wiki/extensions/Echo/includes/mapper/EventMapper.php(171): Wikimedia\Rdbms\Database->select(array, array, array, string, NULL, array)

#4 /home4/anskidsc/public_html/wiki/extensions/Echo/includes/EchoHooks.php(872): EchoEventMapper->fetchUnreadByUserAndPage(User, integer)

#5 /home4/anskidsc/public_html/wiki/extensions/Echo/includes/EchoHooks.php(949): EchoHooks::processMarkAsRead(User, WebRequest, Title)

#6 /home4/anskidsc/public_html/wiki/includes/Hooks.php(174): EchoHooks::onPersonalUrls(array, Title, SkinMinerva)

#7 /home4/anskidsc/public_html/wiki/includes/Hooks.php(234): Hooks::callHook(string, array, array, NULL, string)

#8 /home4/anskidsc/public_html/wiki/includes/skins/SkinTemplate.php(744): Hooks::runWithoutAbort(string, array)

#9 /home4/anskidsc/public_html/wiki/includes/skins/SkinTemplate.php(446): SkinTemplate->buildPersonalUrls()

#10 /home4/anskidsc/public_html/wiki/skins/MinervaNeue/includes/skins/SkinMinerva.php(150): SkinTemplate->prepareQuickTemplate()

#11 /home4/anskidsc/public_html/wiki/includes/skins/SkinTemplate.php(215): SkinMinerva->prepareQuickTemplate()

#12 /home4/anskidsc/public_html/wiki/includes/OutputPage.php(2574): SkinTemplate->outputPage()

#13 /home4/anskidsc/public_html/wiki/includes/exception/MWExceptionRenderer.php(134): OutputPage->output()

#14 /home4/anskidsc/public_html/wiki/includes/exception/MWExceptionRenderer.php(53): MWExceptionRenderer::reportHTML(Wikimedia\Rdbms\DBQueryError)

#15 /home4/anskidsc/public_html/wiki/includes/exception/MWExceptionHandler.php(121): MWExceptionRenderer::output(Wikimedia\Rdbms\DBQueryError, integer)

#16 /home4/anskidsc/public_html/wiki/includes/exception/MWExceptionHandler.php(195): MWExceptionHandler::report(Wikimedia\Rdbms\DBQueryError)

#17 /home4/anskidsc/public_html/wiki/includes/MediaWiki.php(558): MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError)

#18 /home4/anskidsc/public_html/wiki/index.php(44): MediaWiki->run()

#19 {main}

KHarlan (WMF) (talkcontribs)

How did you install Echo? Did you run update.php?

Reply to "My site breaks when logging in after installing echo"

How to configure Echo to work with DPLForum?

1
80.128.144.188 (talkcontribs)

I have planed to install this extension, because some of our users complained, that they have problems to follow forum posts or our maintenance post. Unfortunately it seems, that there's no (direct) way to configure Echo to work with the Forum Namespace of DPLForum.

So: What configuration is needed, that Echo displays notifications from the Forum?

Reply to "How to configure Echo to work with DPLForum?"

Can this be installed without command line access to manually update schema at all?

6
CayceP (talkcontribs)

I'm on shared hoster, which means I have no command line access to run any php script besides whatever Extension:MainanceShell does (or pretends do be doing) I tried to install the extensions, did run /mw-config/ but it doesn't seem to create the necessary tables via this. If I activate the extension it throws exceptions because the tables are missing (no surprise there):


[89cc3e61a284ed2f4a851274] 2018-06-08 09:48:03: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

MediaWiki internal error.

Original exception: [3ce14ff778f71f0be6b696d4] /wiki/Hauptseite Wikimedia\Rdbms\DBQueryError from line 1149 of /home/webpages/server/user/html/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT * FROM `w1_echo_event` INNER JOIN `w1_echo_notification` ON ((notification_event=event_id)) INNER JOIN `w1_echo_target_page` ON ((etp_event=event_id)) WHERE event_deleted = '0' AND notification_user = '13' AND notification_read_timestamp IS NULL AND etp_page = '1' Function: EchoEventMapper::fetchUnreadByUserAndPage Error: 1146 Table 'db_12345_3.w1_echo_event' doesn't exist (mysql.server.de)

Backtrace:

  1. 0 /home/webpages/server/user/html/w/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
  2. 1 /home/webpages/server/user/html/w/includes/libs/rdbms/database/Database.php(1343): Wikimedia\Rdbms\Database->query(string, string)
  3. 2 /home/webpages/server/user/html/w/extensions/Echo/includes/mapper/EventMapper.php(155): Wikimedia\Rdbms\Database->select(array, string, array, string, NULL, array)
  4. 3 /home/webpages/server/user/html/w/extensions/Echo/Hooks.php(883): EchoEventMapper->fetchUnreadByUserAndPage(User, integer)
  5. 4 [internal function]: EchoHooks::onPersonalUrls(array, Title, SkinDarkVector)
  6. 5 /home/webpages/server/user/html/w/includes/Hooks.php(177): call_user_func_array(string, array)
  7. 6 /home/webpages/server/user/html/w/includes/Hooks.php(205): Hooks::callHook(string, string, array, NULL)
  8. 7 /home/webpages/server/user/html/w/includes/skins/SkinTemplate.php(732): Hooks::run(string, array)
  9. 8 /home/webpages/server/user/html/w/includes/skins/SkinTemplate.php(475): SkinTemplate->buildPersonalUrls()
  10. 9 /home/webpages/server/user/html/w/includes/skins/SkinTemplate.php(249): SkinTemplate->prepareQuickTemplate()
  11. 10 /home/webpages/server/user/html/w/includes/OutputPage.php(2442): SkinTemplate->outputPage()
  12. 11 /home/webpages/server/user/html/w/includes/MediaWiki.php(858): OutputPage->output(boolean)
  13. 12 /home/webpages/server/user/html/w/includes/MediaWiki.php(870): MediaWiki->{closure}()
  14. 13 /home/webpages/server/user/html/w/includes/MediaWiki.php(523): MediaWiki->main()
  15. 14 /home/webpages/server/user/html/w/index.php(43): MediaWiki->run()
  16. 15 {main}

Exception caught inside exception handler: [3ce14ff778f71f0be6b696d4] /wiki/Hauptseite Wikimedia\Rdbms\DBQueryError from line 1149 of /home/webpages/server/user/html/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT * FROM `w1_echo_event` INNER JOIN `w1_echo_notification` ON ((notification_event=event_id)) INNER JOIN `w1_echo_target_page` ON ((etp_event=event_id)) WHERE event_deleted = '0' AND notification_user = '13' AND notification_read_timestamp IS NULL AND etp_page = '1' Function: EchoEventMapper::fetchUnreadByUserAndPage Error: 1146 Table 'db_12345_3.w1_echo_event' doesn't exist (mysql.server.de)

Backtrace:

  1. 0 /home/webpages/server/user/html/w/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
  2. 1 /home/webpages/server/user/html/w/includes/libs/rdbms/database/Database.php(1343): Wikimedia\Rdbms\Database->query(string, string)
  3. 2 /home/webpages/server/user/html/w/extensions/Echo/includes/mapper/EventMapper.php(155): Wikimedia\Rdbms\Database->select(array, string, array, string, NULL, array)
  4. 3 /home/webpages/server/user/html/w/extensions/Echo/Hooks.php(883): EchoEventMapper->fetchUnreadByUserAndPage(User, integer)
  5. 4 [internal function]: EchoHooks::onPersonalUrls(array, Title, SkinDarkVector)
  6. 5 /home/webpages/server/user/html/w/includes/Hooks.php(177): call_user_func_array(string, array)
  7. 6 /home/webpages/server/user/html/w/includes/Hooks.php(205): Hooks::callHook(string, string, array, NULL)
  8. 7 /home/webpages/server/user/html/w/includes/skins/SkinTemplate.php(732): Hooks::run(string, array)
  9. 8 /home/webpages/server/user/html/w/includes/skins/SkinTemplate.php(475): SkinTemplate->buildPersonalUrls()
  10. 9 /home/webpages/server/user/html/w/includes/skins/SkinTemplate.php(249): SkinTemplate->prepareQuickTemplate()
  11. 10 /home/webpages/server/user/html/w/includes/OutputPage.php(2442): SkinTemplate->outputPage()
  12. 11 /home/webpages/server/user/html/w/includes/exception/MWExceptionRenderer.php(135): OutputPage->output()
  13. 12 /home/webpages/server/user/html/w/includes/exception/MWExceptionRenderer.php(54): MWExceptionRenderer::reportHTML(Wikimedia\Rdbms\DBQueryError)
  14. 13 /home/webpages/server/user/html/w/includes/exception/MWExceptionHandler.php(75): MWExceptionRenderer::output(Wikimedia\Rdbms\DBQueryError, integer)
  15. 14 /home/webpages/server/user/html/w/includes/exception/MWExceptionHandler.php(130): MWExceptionHandler::report(Wikimedia\Rdbms\DBQueryError)
  16. 15 /home/webpages/server/user/html/w/includes/MediaWiki.php(550): MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError)
  17. 16 /home/webpages/server/user/html/w/index.php(43): MediaWiki->run()
  18. 17 {main}


So this means I can't use this since it requires to run update.php via command line to update the schema? Or should the tables be created via /mw-config/ as well (as it usual does for other Extension with databases changes) and it's just not working for me? I'm using a custom skin but it didn't work with one from of the bundled ones either.

Software Version
MediaWiki 1.30.0
PHP 5.6.36 (apache2handler)
MySQL 5.6.39-83.1-log
ICU 4.8.1.1
177.184.220.229 (talkcontribs)

I have the same problem.

104.142.125.214 (talkcontribs)

Same issue here also.

104.142.125.214 (talkcontribs)

Another user (S3r3nd1) pointed towards the fix to this for ppl without command line access:

"If you look inside the Echo extension directory, you'll see a nice "echo.sql".

I opened it and saw there were just the queries to create Echo missing tables which are indeed not created with the Update script.

So I went to phpMyAdmin and imported the echo.sql to create the new tables.

For me, this worked. I don't think this is quite regular, but it works, so...

PS : if you have prefix to your wiki installation, don't forget to add it for the echo_email_batch, echo_event, echo_notification, and echo_target_page"

Addshore (talkcontribs)
Reply to "Can this be installed without command line access to manually update schema at all?"

Error on Echo after installation

1
WikiGamee (talkcontribs)

Hey there,

I recently installed echo extension on my wiki and I get error like this:

[XtnxGA5HlhkDk-tPralCPwAAABI] /wiki/Main_Page MWException from line 588 of /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/cache/localisation/LocalisationCache.php: LocalisationCache::readJSONFile: Invalid JSON file: /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/extensions/Echo/i18n/hi.json


Backtrace:

#0 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/cache/localisation/LocalisationCache.php(918): LocalisationCache->readJSONFile(string)

#1 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/cache/localisation/LocalisationCache.php(489): LocalisationCache->recache(string)

#2 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/cache/localisation/LocalisationCache.php(363): LocalisationCache->initLanguage(string)

#3 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/cache/localisation/LocalisationCache.php(304): LocalisationCache->loadItem(string, string)

#4 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/languages/Language.php(4413): LocalisationCache->getItem(string, string)

#5 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/languages/Language.php(265): Language::getFallbacksFor(string)

#6 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/languages/Language.php(225): Language::newFromCode(string)

#7 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/ServiceWiring.php(163): Language::factory(string)

#8 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/libs/services/ServiceContainer.php(458): Wikimedia\Services\ServiceContainer->{closure}(MediaWiki\MediaWikiServices)

#9 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/libs/services/ServiceContainer.php(427): Wikimedia\Services\ServiceContainer->createService(string)

#10 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/MediaWikiServices.php(540): Wikimedia\Services\ServiceContainer->getService(string)

#11 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/Setup.php(801): MediaWiki\MediaWikiServices->getContentLanguage()

#12 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/includes/WebStart.php(81): require_once(string)

#13 /home/vol5_4/epizy.com/epiz_25902755/htdocs/wiki/index.php(41): require(string)

#14 {main}


I follow all the instructions for avoid this error but, nothing happens. This is very important extension for me please help. I set my wiki to Hindi language.

Thanks

Reply to "Error on Echo after installation"

Configuration: $wgEchoNotifications

3
Silkwood (talkcontribs)
Product Version
MediaWiki 1.32.5
PHP 7.2.17-0ubuntu0.18.04.1 (apache2handler)
MariaDB 10.1.38-MariaDB-0ubuntu0.18.04.1

Hello,

my skin

Skin Version License Description Authors
Metrolook 7.0 alpha 2 (578ddcf) 19:13, October 11, 2018 GPL-2.0-or-later Metrolook is a Metro-inspired fork of the Vector skin immewnity, Paladox, Craig Davison and lagleki

does not show the tray icon next to the bell icon in the top-bar of my wiki, so I managed to show all the notifications in one place (the bell).

Despite every attempt, I haven't been able to redirect notifications to "alerts" (instead of "messages").

I tried (as suggested below by @Roan Kattouw (WMF)) with:

$wgExtensionFunctions[] = function () {

    global $wgEchoNotifications;

    // To change individual notification types:

    $wgEchoNotifications['welcome']['section'] = 'alert';

    // To change all notification types at once:

    foreach ( $wgEchoNotificationTypes as &$data ) {

        $data['section'] = 'alert';

    }

};

in LocalSettings.php, and also to modify the file .../extensions/Echo/extension.json (as explained in Echo Extension Configuration section) like this:

"thank-you-edit": {

                                        "user-locators": [

                                                "EchoUserLocator::locateEventAgent"

                                        ],

                                        "category": "system",

                                        "notify-type-availability": {

                                                "email": false

                                        },

                                        "group": "positive",

                                        "presentation-model": "EchoEditThresholdPresentationModel",

                                        "section": "alert"

},

but without success.

What should I do?

Varlin (talkcontribs)

Hi, I don't know if you're still looking for an answer, but I managed to display all notifications under the bell icon (so I can hide the tray icon, I don't see the point of having two icons), with this code :

$wgExtensionFunctions[] = function () {
    global $wgEchoNotifications;
    foreach ( $wgEchoNotifications as &$data ) {
        $data['section'] = 'alert';
    }
};

Thanks, your messages helped.

Silkwood (talkcontribs)

Thank you so much.

Reply to "Configuration: $wgEchoNotifications"

Installing the version from git broke my wiki

1
Sergiidumyk (talkcontribs)

Did exactly this:

cd extensions/

git clone https://gerrit.wikimedia.org/r/mediawiki/extensions/Echo.git

then wfLoadExtension( 'Echo' ); in LocalSettings.php.

Running update.php suspiciously did not provide any output. Then my wiki did not open. Remedy: deleting Echo folder and getting it via usual (for me) download extension feature. Then all worked fine.

Reply to "Installing the version from git broke my wiki"

Can I get notifications list using oauth token?

1
WeekThor (talkcontribs)

Can I get notifications list using oauth token?

Reply to "Can I get notifications list using oauth token?"

How to configure Echo to notification on all changes with daily digest?

4
Deletedaccount4567435 (talkcontribs)

Same problem raised 2 year ago and its 2017 now.

Does the $wgDefaultUserOptions['echo-email-frequency'] setting server for this purpose?

Deletedaccount4567435 (talkcontribs)

OK I got it: in includes/EmailBatch.php it says:

* user based on the user setting, this assumes the following value for

* member setting for echo-email-frequency

* -1 - no email

*  0 - instant

*  1 - once everyday

* 7 - once every 7 days

So $wgDefaultUserOptions['echo-email-frequency'] = 1; should send email daily

Deletedaccount4567435 (talkcontribs)

Unfortunately this setting will not create daily digest. Instead, it just store notification emails in jobs, and then send many emails out at midnight. :(

Deletedaccount4567435 (talkcontribs)

It seems that jobs need to be stored in Redis. But not sure whether will it bundle email or not.


wfLoadExtension( 'Echo' );

$wgEchoUseJobQueue = true;


// 1 means 1 day here, see https://github.com/wikimedia/mediawiki-extensions-Echo/blob/c7bd07fc0c53c52184b308d220a42cd416626e24/includes/EmailBatch.php for info

$wgDefaultUserOptions['echo-email-frequency'] = 1;


//4 hours,see https://gerrit.wikimedia.org/r/#/c/translatewiki/+/267873/1/TranslatewikiSettings.php

$wgEchoBundleEmailInterval = 14400;


// See https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/Echo/+/52319/

$wgJobTypeConf['MWEchoNotificationEmailBundleJob'] = array(

'class'       => 'JobQueueRedis',

'redisServer' => '127.0.0.1:6379',

'redisConfig' => array( 'connectTimeout' => 1 ),

'claimTTL'    => 3600,

'checkDelay'  => true

);

Reply to "How to configure Echo to notification on all changes with daily digest?"