Page MenuHomePhabricator
Create Task
Maniphest T40607

Error in getCreateTempIDTableSQL during PostgreSQL upgrade
Closed, ResolvedPublic
Actions

Description

Author: mike

Description:
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.

Version: unspecified
Severity: normal

Attached:

patch.txt2 KBDownload

Details

Reference
bz38607

Related Objects
Search...

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
· · ·
InvalidNoneT2384 [REPLACED BY TAG] PostgreSQL/pgsql support (tracking)
ResolvedNoneT40607 Error in getCreateTempIDTableSQL during PostgreSQL upgrade
· · ·

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 12:56 AM
• bzimport added a project: MediaWiki-extensions-Semantic-MediaWiki.
• bzimport set Reference to bz38607.
• bzimport added a subscriber: Unknown Object (MLST).
• bzimport created this task.Jul 23 2012, 7:36 PM
• bzimport added a comment.Jan 11 2013, 10:22 AM

hajo.thelen wrote:

seems to be related or duplicate Bug 34855

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

Unknown Object (User) added a comment.Nov 19 2014, 11:55 AM

Expected to be solved by [0].

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

Jdforrester-WMF added a project: PostgreSQL.Nov 2 2016, 8:16 PM
Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits