Last modified: 2014-11-19 11:55:33 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T40607, the corresponding Phabricator task for complete and up-to-date bug report information.

Bug 38607 - Error in getCreateTempIDTableSQL during PostgreSQL upgrade


Summary:	Error in getCreateTempIDTableSQL during PostgreSQL upgrade

Status:	RESOLVED FIXED

Product:	MediaWiki extensions
Classification:	Unclassified
Component:	Semantic MediaWiki (Other open bugs)
Version:	unspecified
Hardware:	All All

Importance:	Unprioritized normal (vote)
Target Milestone:	---
Assigned To:	Nobody - You can work on this!

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:	postgres
	Show dependency tree / graph

Reported:	2012-07-23 19:36 UTC by Michael Allan
Modified:	2014-11-19 11:55 UTC (History)
CC List:	4 users (show)

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

Attachments
workaround patch (2.97 KB, patch) 2012-07-23 19:36 UTC, Michael Allan	Details
Add an attachment (proposed patch, testcase, etc.)

Description Michael Allan 2012-07-23 19:36:25 UTC

Created attachment 10875 [details]
workaround patch

Upgrading to 1.7.1, SMW_refreshData.php dies on a PostgreSQL syntax error:

   PHP Warning:  pg_query(): Query failed: ERROR:  syntax error at or near ""t0""
   LINE 1: ...teQueries 127.0.0.1 */ OR REPLACE FUNCTION create_"t0"() RET...

John Morton reported this earlier to the list along with a workaround: http://sourceforge.net/mailarchive/forum.php?thread_name=CAMhmagAUSe7wAXTw5HVX1eiOfvk4yfQgVxMizyFPQqsTaVC8JA%40mail.gmail.com&forum_name=semediawiki-devel

I did something similar and it got me through the upgrade.  I attached it as a patch.

Comment 1 Hajo Thelen 2013-01-11 10:22:18 UTC

seems to be related or duplicate Bug 34855

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

Comment 2 MWJames 2014-11-19 11:55:33 UTC

Expected to be solved by [0].

[0] https://github.com/SemanticMediaWiki/SemanticMediaWiki/pull/638

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links