Last modified: 2013-09-02 20:21:43 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 28279 - PostgreSQL 8.4.7 don't work with SocialProfile extension
PostgreSQL 8.4.7 don't work with SocialProfile extension
Status: RESOLVED DUPLICATE of bug 27732
Product: MediaWiki extensions
Classification: Unclassified
SocialProfile (Other open bugs)
PC Linux
: Normal normal (vote)
: ---
Assigned To: Jack Phoenix
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2011-03-27 17:59 UTC by Anton Yackushev
Modified: 2013-09-02 20:21 UTC (History)
2 users (show)

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


Description Anton Yackushev 2011-03-27 17:59:03 UTC
I have SocialProfile from SVN (84866), PostgreSQL 8.4.7 and Mediawiki 1.16.2 Tables in base are created, but at calling on page of the user I receive an error:

A database error has occurred Query: SELECT ug_id,ug_user_id_from,ug_user_name_from,ug_gift_id,ug_date,ug_status,gift_name,gift_description,gift_given_count,UNIX_TIMESTAMP(ug_date) AS unix_time FROM user_gift INNER JOIN gift ON ((ug_gift_id = gift_id)) WHERE (ug_user_id_to = 2) ORDER BY ug_id DESC LIMIT 4 OFFSET 0 Function: UserGifts::getUserGiftList Error: 1 ERROR: function unix_timestamp(timestamp with time zone) does not exist LINE 1: ...tatus,gift_name,gift_description,gift_given_count,UNIX_TIMES... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Backtrace:
0 /var/www/site/public_html/includes/db/Database.php(538): DatabasePostgres->reportQueryError('ERROR: functio...', 1, 'SELECT ug_id,u...', 'UserGifts::getU...', false)
1 /var/www/site/public_html/includes/db/Database.php(874): DatabaseBase->query('SELECT ug_id,u...', 'UserGifts::getU...')
2 /var/www/site/public_html/extensions/SocialProfile/UserGifts/UserGiftsClass.php(327): DatabaseBase->select(Array, Array, Array, 'UserGifts::getU...', Array, Array)
3 /var/www/site/public_html/extensions/SocialProfile/UserProfile/UserProfilePage.php(920): UserGifts->getUserGiftList(0, 4)
4 /var/www/site/public_html/extensions/SocialProfile/UserProfile/UserProfilePage.php(69): UserProfilePage->getGifts('DuskMan')
5 /var/www/site/public_html/includes/Wiki.php(493): UserProfilePage->view()
6 /var/www/site/public_html/includes/Wiki.php(70): MediaWiki->performAction(Object(OutputPage), Object(UserProfilePage), Object(Title), Object(User), Object(WebRequest))
7 /var/www/site/public_html/index.php(117): MediaWiki->performRequestForTitle(Object(Title), Object(UserProfilePage), Object(OutputPage), Object(User), Object(WebRequest))
8 {main}
Comment 1 Jack Phoenix 2011-03-27 18:03:50 UTC
This is a known issue. Mark suggested in using a Database method (Database::unixTimestamp) instead of UNIX_TIMESTAMP, and I implemented his suggestion in, but the said method was removed in r79345 so I had to revert my changes in r79748. I'm not aware of a replacement for Database::unixTimestamp() though. :-(
Comment 2 Anton Yackushev 2011-09-10 07:09:19 UTC
svn 96716, PostgreSQL 8.4.8, Mediawiki 1.17
There was other error:

PHP Parse error:  syntax error, unexpected T_ELSE, expecting T_FUNCTION in /var/www/mediawiki/public_html/extensions/SocialProfile/UserProfile/UserProfilePage.php on line 885, referer:
Comment 3 Jack Phoenix 2011-09-10 12:51:33 UTC
That'd be a serious issue, except that I'm not getting it; my local copy of UserProfilePage.php (r96720) passes php -l. Have you done any local customizations? What version of PHP are you using?
Comment 4 Anton Yackushev 2011-09-10 12:54:21 UTC
(In reply to comment #3)
> That'd be a serious issue, except that I'm not getting it; my local copy of
> UserProfilePage.php (r96720) passes php -l. Have you done any local
> customizations? What version of PHP are you using?

PHP 5.3.3 (Debian squeeze).
Have you done any local customizations - No.
Comment 5 Anton Yackushev 2012-05-27 05:24:25 UTC
Now everything is working
Comment 6 Tim Landscheidt 2012-09-19 00:53:41 UTC
(In reply to comment #5)
> Now everything is working

Does that mean that this bug can be closed?
Comment 7 Jack Phoenix 2013-09-02 20:21:43 UTC

*** This bug has been marked as a duplicate of bug 27732 ***

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