https://bugzilla.wikimedia.org/show_bug.cgi?id=27732

--- Comment #7 from Anton Kochkov <anton.koch...@gmail.com> 2011-02-26 16:29:32 
UTC ---
And here an example of some error with LIMIT and OFFSET:

A database error has occurred
Query: SELECT UNIX_TIMESTAMP(rc_timestamp) AS item_date, rc_title,
rc_user, rc_user_text, rc_comment, rc_id, rc_minor, rc_new,
rc_namespace, rc_cur_id, rc_this_oldid, rc_last_oldid,
rc_log_action
FROM recentchanges

ORDER BY rc_id DESC LIMIT 0,50
Function: UserActivity::setEdits
Error: 1 ERROR: LIMIT #,# syntax is not supported
LINE 7: ORDER BY rc_id DESC LIMIT 0,50
^
HINT: Use separate LIMIT and OFFSET clauses.
Backtrace:

#0 /usr/home/droid-dev/www/includes/db/Database.php(538):
DatabasePostgres->reportQueryError('ERROR: LIMIT #...', 1, 'SELECT
UNIX_TIM...', 'UserActivity::s...', false)
#1
/usr/home/droid-dev/www/extensions/SocialProfile/UserActivity/UserActivityClass.php(85):
DatabaseBase->query('SELECT UNIX_TIM...', 'UserActivity::s...')
#2
/usr/home/droid-dev/www/extensions/SocialProfile/UserActivity/UserActivityClass.php(605):
UserActivity->setEdits()
#3
/usr/home/droid-dev/www/extensions/SocialProfile/UserActivity/UserActivityClass.php(639):
UserActivity->getActivityList()
#4
/usr/home/droid-dev/www/extensions/SocialProfile/UserActivity/UserActivity.body.php(75):
UserActivity->getActivityListGrouped()
#5 /usr/home/droid-dev/www/includes/SpecialPage.php(559):
UserHome->execute(NULL)
#6 /usr/home/droid-dev/www/includes/Wiki.php(254):
SpecialPage::executePath(Object(Title))
#7 /usr/home/droid-dev/www/includes/Wiki.php(64):
MediaWiki->handleSpecialCases(Object(Title), Object(OutputPage),
Object(WebRequest))
#8 /usr/home/droid-dev/www/index.php(117):
MediaWiki->performRequestForTitle(Object(Title), NULL, Object(OutputPage),
Object(User), Object(WebRequest))
#9 {main}

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to