Last modified: 2012-02-04 10:50:50 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 T31555, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 29555 - PostgreSQL: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "ENGINE"
PostgreSQL: pg_query() [function.pg-query]: Query failed: ERROR: syntax erro...
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
unspecified
All All
: Unprioritized normal (vote)
: ---
Assigned To: Markus Krötzsch
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2011-06-23 20:28 UTC by Anton Kochkov
Modified: 2012-02-04 10:50 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Anton Kochkov 2011-06-23 20:28:43 UTC 
Setting up standard database configuration for SMW ...

Selected storage engine is "SMWSQLStore2" (or an extension thereof)

Checking table smw_ids ...
   Table already exists, checking structure ...
   ... field smw_id is fine.
   ... field smw_namespace is fine.
   ... field smw_title is fine.
   ... field smw_iw is fine.
   ... field smw_sortkey is fine.
   ... done.
Checking table smw_conccache ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking table smw_rels2 ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... changing type of field o_id from 'SERIAL NOT NULL' to 'SERIAL' ... done.
   ... done.
Checking table smw_atts2 ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field value_xsd is fine.
   ... field value_num is fine.
   ... deleting obsolete field value_unit ... done.
   ... done.
Checking table smw_text2 ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field value_blob is fine.
   ... done.
Checking table smw_spec2 ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field value_string is fine.
   ... done.
Checking table smw_subs2 ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... changing type of field o_id from 'SERIAL NOT NULL' to 'SERIAL' ... done.
   ... done.
Checking table smw_subp2 ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... changing type of field o_id from 'SERIAL NOT NULL' to 'SERIAL' ... done.
   ... done.
Checking table smw_inst2 ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... changing type of field o_id from 'SERIAL NOT NULL' to 'SERIAL' ... done.
   ... done.
Checking table smw_redi2 ...
   Table already exists, checking structure ...
   ... field s_title is fine.
   ... field s_namespace is fine.
   ... changing type of field o_id from 'SERIAL NOT NULL' to 'SERIAL' ... done.
   ... done.
Checking table smw_conc2 ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field concept_txt is fine.
   ... field concept_docu is fine.
   ... changing type of field concept_features from 'INTEGER' to 'BIGINT' ... 

Warning:  pg_query() [function.pg-query]: Query failed: ERROR:  syntax error at or near "ENGINE"
LINE 1: .../ TABLE smw_conc2 ALTER COLUMN "concept_features" ENGINE BIG...
                                                             ^ in /home/droid-dev/www/includes/db/DatabasePostgres.php on line 237
Comment 1 Anton Kochkov 2011-06-23 20:37:27 UTC 
Here error messages for "usual" pages:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "sm_coords" does not exist LINE 1: ...:deleteSemanticData::deleteById Wikiadmin */ FROM sm_coords ... ^ in /home/droid-dev/www/includes/db/DatabasePostgres.php on line 237

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 237

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 237

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 237

Warning: Cannot modify header information - headers already sent by (output started at /home/droid-dev/www/includes/OutputPage.php:1729) in /home/droid-dev/www/includes/WebResponse.php on line 22

Warning: Cannot modify header information - headers already sent by (output started at /home/droid-dev/www/includes/OutputPage.php:1729) in /home/droid-dev/www/includes/WebResponse.php on line 22

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 237

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 237

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 237

Warning: Cannot modify header information - headers already sent by (output started at /home/droid-dev/www/includes/OutputPage.php:1729) in /home/droid-dev/www/includes/WebResponse.php on line 22

Warning: Cannot modify header information - headers already sent by (output started at /home/droid-dev/www/includes/OutputPage.php:1729) in /home/droid-dev/www/includes/WebResponse.php on line 22

Warning: Cannot modify header information - headers already sent by (output started at /home/droid-dev/www/includes/OutputPage.php:1729) in /home/droid-dev/www/includes/WebResponse.php on line 22

Warning: Cannot modify header information - headers already sent by (output started at /home/droid-dev/www/includes/OutputPage.php:1729) in /home/droid-dev/www/includes/WebResponse.php on line 22
Comment 2 Jeroen De Dauw 2011-06-23 22:48:55 UTC 
I cannot reproduce this locally error. I have PostGres 8.4, MW trunk and SMW trunk.

The second error you are getting because of missing table for geocoords. I very recently added this one, so if you ran the SMW setup before I did this you'll need to run it again.
Comment 3 Anton Kochkov 2011-07-04 08:43:44 UTC 
This error still exist on PostgreSQL 9.05, MW and SMW trunk
Comment 4 Anton Kochkov 2011-07-04 09:17:49 UTC 
Here is full log:

Setting up standard database configuration for SMW ...

Selected storage engine is "SMWSQLStore2" (or an extension thereof)

Checking table "smw_ids" ...
   Table already exists, checking structure ...
   ... field smw_id is fine.
   ... field smw_namespace is fine.
   ... field smw_title is fine.
   ... field smw_iw is fine.
   ... field smw_sortkey is fine.
   ... done.
Checking table "smw_conccache" ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking table "smw_rels2" ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... changing type of field o_id from 'SERIAL NOT NULL' to 'SERIAL' ... done.
   ... done.
Checking table "smw_atts2" ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field value_xsd is fine.
   ... field value_num is fine.
   ... deleting obsolete field value_unit ... 

Warning:  pg_query() [function.pg-query]: Query failed: ERROR:  zero-length delimited identifier at or near """"
LINE 1: ... /* SMWSQLHelpers::updateTable Wikiadmin */ TABLE ""smw_atts...
                                                             ^ 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
Comment 5 Anton Kochkov 2011-07-27 20:42:33 UTC 
updated SemanticMediaWiki to trunk: this error still here:

Setting up standard database configuration for SMW ...

Selected storage engine is "SMWSQLStore2" (or an extension thereof)

Checking table "smw_ids" ...
   Table already exists, checking structure ...
   ... field smw_id is fine.
   ... field smw_namespace is fine.
   ... field smw_title is fine.
   ... changing type of field smw_iw from 'TEXT' to 'TEXT NOT NULL' ... done.
   ... creating field smw_subobject ... 

Warning:  pg_query() [function.pg-query]: Query failed: ERROR:  column "smw_subobject" contains null values 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: column "smw_subobject" does not exist LINE 1: ...kiadmin */ smw_id,smw_title,smw_namespace,smw_iw,smw_subobj... ^ 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: Cannot modify header information - headers already sent by (output started at /home/droid-dev/www/includes/OutputPage.php:1934) in /home/droid-dev/www/includes/WebResponse.php on line 23

Warning: Cannot modify header information - headers already sent by (output started at /home/droid-dev/www/includes/OutputPage.php:1934) in /home/droid-dev/www/includes/WebResponse.php on line 23

Warning: Cannot modify header information - headers already sent by (output started at /home/droid-dev/www/includes/OutputPage.php:1934) in /home/droid-dev/www/includes/WebResponse.php on line 23

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
Comment 6 Jeroen De Dauw 2011-07-27 22:05:36 UTC 
I'm still at version 8.4, which is the most recent one in the Ubuntu repositories. If possible, try downgrade and see if that allows you to successfully install SMW.
Comment 7 Anton Kochkov 2011-09-13 02:11:20 UTC 
MediaWiki and SemanticMediaWiki - both from current trunk:

Setting up standard database configuration for SMW ...

Selected storage engine is "SMWSQLStore2" (or an extension thereof)

Checking table "smw_ids" ...
   Table already exists, checking structure ...
   ... field smw_id is fine.
   ... field smw_namespace is fine.
   ... field smw_title is fine.
   ... changing type of field smw_iw from 'TEXT' to 'TEXT NOT NULL' ... done.
   ... creating field smw_subobject ... 

Warning:  pg_query() [function.pg-query]: Query failed: ERROR:  column "smw_subobject" contains null values 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
Comment 8 Anton Kochkov 2012-02-04 09:45:27 UTC 
Trunk Mediawiki 110689 rev, trunk SemanticMediaWiki, PostgreSQL 9.1.1:

Setting up standard database configuration for SMW ...
Selected storage engine is "SMWSQLStore2" (or an extension thereof)
Checking table "smw_ids" ...
   Table already exists, checking structure ...
   ... field smw_id is fine.
   ... field smw_namespace is fine.
   ... field smw_title is fine.
   ... changing type of field smw_iw from 'TEXT' to 'TEXT NOT NULL' ... done.
   ... creating field smw_subobject ... 

Warning:  pg_query() [function.pg-query]: Query failed: ERROR:  column "smw_subobject" contains null values in /home/droid-dev/www/includes/db/DatabasePostgres.php on line 254

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 254

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 254

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 254
Comment 9 Anton Kochkov 2012-02-04 10:50:50 UTC 
Fixed after removing all SMW tables and recreating them from scratch.
Only need to add schema prefix 'mediawiki.' into tables names in file SMW_Postgres_Schema.sql
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links