[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732 --- Comment #14 from Jack Phoenix j...@countervandalism.net --- *** Bug 28279 has been marked as a duplicate of this bug. *** -- 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
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Keywords||patch-reviewed -- 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
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732 Karun karun...@gmx.de changed: What|Removed |Added CC||karun...@gmx.de Blocks|384 | -- 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
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732 Andre Klapper a9016...@gmx.de changed: What|Removed |Added Attachment #8218|application/octet-stream|application/x-gzip mime type|| -- 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
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732 Andre Klapper a9016...@gmx.de changed: What|Removed |Added Attachment #8217|application/octet-stream|application/x-gzip mime type|| -- 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
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732
--- Comment #13 from Anton Yackushev yackushe...@gmail.com 2012-04-22
09:02:29 UTC ---
When installing SocialProfile get the error:
...
Creating user_status table...Could not
open/var/www/test/extensions/SocialProfile/UserStatus/userstatus.postgres.sql.
Backtrace:
#0 /var/www/test/includes/installer/DatabaseUpdater.php(362):
DatabaseBase-sourceFile('/var/www/test/e...')
#1 /var/www/test/includes/installer/DatabaseUpdater.php(379):
DatabaseUpdater-applyPatch('/var/www/test/e...', true)
#2 [internal function]: DatabaseUpdater-addTable('user_status',
'/var/www/test/e...', true)
#3 /var/www/test/includes/installer/DatabaseUpdater.php(233):
call_user_func_array(Array, Array)
#4 /var/www/test/includes/installer/DatabaseUpdater.php(201):
DatabaseUpdater-runUpdates(Array, true)
#5 /var/www/test/maintenance/update.php(119): DatabaseUpdater-doUpdates(Array)
#6 /var/www/test/maintenance/doMaintenance.php(105): UpdateMediaWiki-execute()
#7 /var/www/test/maintenance/update.php(145):
require_once('/var/www/test/m...')
#8 {main}
P.S. MediaWiki 1.18.2; PHP 5.3.3-7+squeeze8 (apache2handler); PostgreSQL
8.4.11; SocialProfile r92462
--
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
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732 --- Comment #12 from Anton Kochkov anton.koch...@gmail.com 2011-09-13 02:33:49 UTC --- btw, PostgreSQL 8.* series is now deprecated. -- 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
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732
--- Comment #11 from Anton Kochkov anton.koch...@gmail.com 2011-07-04
14:48:22 UTC ---
MW: trunk, SocialProfile: trunk
Warning: pg_query() [function.pg-query]: Query failed: ERROR: function
unix_timestamp(timestamp without 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. in /home/droid-dev/www/includes/db/DatabasePostgres.php on
line 253
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
Warning: Invalid argument supplied for foreach() in
/home/droid-dev/www/includes/resourceloader/ResourceLoaderWikiModule.php on
line 176
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
Warning: Invalid argument supplied for foreach() in
/home/droid-dev/www/includes/resourceloader/ResourceLoaderWikiModule.php on
line 176
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block in
/home/droid-dev/www/includes/db/DatabasePostgres.php on line 253
MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error
has occurred. Did you forget to run maintenance/update.php after upgrading?
See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
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 = 4) ORDER BY ug_id DESC LIMIT 4 OFFSET 0
Function: UserGifts::getUserGiftList
Error: 1 ERROR: function unix_timestamp(timestamp without 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.
' in /home/droid-dev/www/includes/db/Database.php:845
Stack trace:
#0 /home/droid-dev/www/includes/db/Database.php(812):
DatabaseBase-reportQueryError('ERROR: functio...', 1, 'SELECT ug_id,u...',
'UserGifts::getU...', false)
#1 /home/droid-dev/www/includes/db/Database.php(1281):
DatabaseBase-query('SELECT ug_id,u...', 'UserGifts::getU...')
#2
/home/droid-dev/www/extensions/SocialProfile/UserGifts/UserGiftsClass.php(332):
DatabaseBase-select(Array, Array, Array, 'UserGifts::getU...', Array, Array)
#3
/home/droid-dev/www/extensions/SocialProfile/UserProfile/UserProfilePage.php(1043):
UserGifts-getUserGiftList(0, 4)
#4
/home/droid-dev/www/extensions/SocialProfile/UserProfile/UserProfilePage.php(73):
UserProfilePage-getGifts('XVilka')
#5 /home/droid-dev/www/includes/Wiki.php(436): UserProfilePage-view()
#6 /home/droid-dev/www/includes/Wiki.php(211):
MediaWiki-performAction(Object(UserProfilePage))
#7 /home/droid-dev/www/includes/Wiki.php(586): MediaWiki-performRequest()
#8 /home/droid-dev/www/includes/Wiki.php(497): MediaWiki-main()
#9 /home/droid-dev/www/index.php(74): MediaWiki-run()
#10 {main}
Exception caught inside exception handler: exception 'DBUnexpectedError' with
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732 --- Comment #9 from Anton Yackushev yackushe...@gmail.com 2011-04-10 11:45:27 UTC --- (In reply to comment #8) I've rewritten the SQL queries used by UserActivity to use MediaWiki's Database class in r84804; can you please try updating your SocialProfile to that revision and see if it helps? If that doesn't fix the problem(s), then a PostgreSQL guru should take a look at this bug; I'm not familiar with PGSQL and how it works. It hasn't helped me -- 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
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732 --- Comment #8 from Jack Phoenix j...@countervandalism.net 2011-03-26 16:27:25 UTC --- I've rewritten the SQL queries used by UserActivity to use MediaWiki's Database class in r84804; can you please try updating your SocialProfile to that revision and see if it helps? If that doesn't fix the problem(s), then a PostgreSQL guru should take a look at this bug; I'm not familiar with PGSQL and how it works. -- 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
[Bug 27732] Support of PostgreSQL in SocialProfile
https://bugzilla.wikimedia.org/show_bug.cgi?id=27732 Greg Sabino Mullane g...@turnstep.com changed: What|Removed |Added CC||g...@turnstep.com Summary|Support of PostgreSQL |Support of PostgreSQL in ||SocialProfile -- 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
