Last modified: 2009-07-20 02:00:13 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 T21372, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 19372 - updateSearchIndex has MySQLisms
updateSearchIndex has MySQLisms
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Maintenance scripts (Other open bugs)
1.16.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-06-24 02:53 UTC by OverlordQ
Modified: 2009-07-20 02:00 UTC (History)
2 users (show)

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


Attachments

Description OverlordQ 2009-06-24 02:53:27 UTC
First off the strencode's for the timestamps on lines 63 && 64 dont call $dbw->timestamp to get a correctly formatted timestamp for various DB's.

Secondly, I know for sure MySQL and PG both have different LOCK TABLE syntax so locking tables might need abstracted out into the various database classes.

The very unhelpful lock/unlock methods already there only seem to check for named locks, not actually implementing locking and unlocking.
Comment 1 Chad H. 2009-06-24 17:52:08 UTC
(In reply to comment #0)
> The very unhelpful lock/unlock methods already there only seem to check for
> named locks, not actually implementing locking and unlocking.
> 

Are you looking at the methods in DatabaseBase? lock() clearly acquires a lock (probably needs moving to DatabaseMysql and abstraction to other classes), and unlock() does the opposite.
Comment 2 Chad H. 2009-06-25 00:40:55 UTC
Cleaned this up somewhat in r52.

I couldn't find the strencode() issue you mentioned, is this on trunk? Also, the SELECT query probably needs abstracting too, just didn't do that yet.
Comment 3 Chad H. 2009-06-25 00:41:53 UTC
r52382 :D
Comment 4 OverlordQ 2009-06-25 14:50:40 UTC
Lines 23&24 of updateSearchIndex.inc r52398

---

    # Select entries from recentchanges which are on top and between the specified times
    $start = $dbw->strencode( $start );
    $end = $dbw->strencode( $end );

---
Comment 5 Dan Jacobson 2009-06-28 01:11:59 UTC
More mysqlisms in bug 18291?
Comment 6 Chad H. 2009-07-20 02:00:13 UTC
Fixed as of r52477. Bug 18291 is not a blocker to this at all.

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


Navigation
Links