https://bugzilla.wikimedia.org/show_bug.cgi?id=27732
--- Comment #7 from Anton Kochkov <[email protected]> 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
