https://bugzilla.wikimedia.org/show_bug.cgi?id=28279
Summary: PostgreSQL 8.4.7 don't work extension
Product: MediaWiki extensions
Version: any
Platform: PC
URL: http://thesecretworld.ru
OS/Version: Linux
Status: NEW
Keywords: postgresql
Severity: critical
Priority: Normal
Component: SocialProfile
AssignedTo: j...@countervandalism.net
ReportedBy: yackushe...@gmail.com
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}
--
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
