Topic on Extension talk:Echo

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

I have the same problem.

Same issue here also.

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"

This was so helpful, thank you very much!

I filed https://phabricator.wikimedia.org/T249883