Last modified: 2014-07-07 10:36:14 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T41064, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 39064 - Database returned error "1: RIGHT and FULL OUTER JOINs are not currently supported".
Database returned error "1: RIGHT and FULL OUTER JOINs are not currently supp...
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
LiquidThreads (Other open bugs)
unspecified
All All
: Low minor with 1 vote (vote)
: ---
Assigned To: Nobody - You can work on this!
http://localhost/mw/index.php/Special...
:
Depends on:
Blocks: sqlite
  Show dependency treegraph
 
Reported: 2012-08-06 00:52 UTC by Helder
Modified: 2014-07-07 10:36 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Helder 2012-08-06 00:52:19 UTC
I got the following when I accessed Special:Watchlist in my copy of MW+LQT:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
SELECT * FROM thread RIGHT JOIN user_message_state ON ((ums_user IS NULL OR (ums_user = '1' AND (ums_thread=thread_id)))) WHERE ums_read_timestamp IS NULL AND ((thread_article_title = 'MyUserName' AND thread_article_namespace = '3'))
from within function "NewMessages::newUserMessages". Database returned error "1: RIGHT and FULL OUTER JOINs are not currently supported".
Backtrace:
#0 /var/www/mw/includes/db/Database.php(939): DatabaseBase->reportQueryError('RIGHT and FULL ...', 1, 'SELECT * FROM...', 'NewMessages::ne...', false)
#1 /var/www/mw/includes/db/Database.php(1412): DatabaseBase->query('SELECT * FROM...', 'NewMessages::ne...')
#2 /var/www/mw/extensions/LiquidThreads/classes/NewMessagesController.php(442): DatabaseBase->select(Array, '*', Array, 'NewMessages::ne...', Array, Array)
#3 /var/www/mw/extensions/LiquidThreads/classes/Hooks.php(121): NewMessages::newUserMessages(Object(User))
#4 [internal function]: LqtHooks::beforeWatchlist(Array, Array, Array, Array)
#5 /var/www/mw/includes/Hooks.php(216): call_user_func_array('LqtHooks::befor...', Array)
#6 /var/www/mw/includes/GlobalFunctions.php(3969): Hooks::run('SpecialWatchlis...', Array)
#7 /var/www/mw/includes/specials/SpecialWatchlist.php(304): wfRunHooks('SpecialWatchlis...', Array)
#8 /var/www/mw/includes/SpecialPage.php(611): SpecialWatchlist->execute(NULL)
#9 /var/www/mw/includes/SpecialPageFactory.php(493): SpecialPage->run(NULL)
#10 /var/www/mw/includes/Wiki.php(290): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#11 /var/www/mw/includes/Wiki.php(536): MediaWiki->performRequest()
#12 /var/www/mw/includes/Wiki.php(446): MediaWiki->main()
#13 /var/www/mw/index.php(58): MediaWiki->run()
#14 {main}
Comment 1 Helder 2012-08-06 01:02:01 UTC
I was able to access
http://localhost/mw/index.php/special:Watchlist/raw
without problem and then I removed all pages from my watchlist.

It seems the problem only happens if my watchlist contains some thread which was deleted.
Comment 2 Sam Reed (reedy) 2012-08-07 00:07:10 UTC
This is a limitation of sqlite
Comment 3 Gerrit Notification Bot 2013-12-13 21:43:10 UTC
Change 101055 had a related patch set uploaded by Nemo bis:
Use LEFT JOIN for SQLite compatibility

https://gerrit.wikimedia.org/r/101055
Comment 4 Gerrit Notification Bot 2013-12-21 21:22:57 UTC
Change 101055 merged by Alex Monk:
Use LEFT JOIN for SQLite compatibility

https://gerrit.wikimedia.org/r/101055
Comment 5 Waldir 2014-05-12 10:38:39 UTC
Helder, does the patch at https://gerrit.wikimedia.org/r/101055 solve the issue?
Comment 6 Andre Klapper 2014-07-05 21:33:07 UTC
Helder: Can you answer comment 5, please?
Comment 7 Helder 2014-07-07 10:36:14 UTC
(In reply to Waldir from comment #5)
> Helder, does the patch at https://gerrit.wikimedia.org/r/101055 solve the
> issue?

I think so.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links