Last modified: 2012-12-28 01:39:49 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.

Bug 38930 - TestORMRowTest::testConstructor with data set #0 (array('Foobar', 42, 9000.1, true, array(13, 11, 7, 5, 3, 2), stdClass), true)


Summary:	TestORMRowTest::testConstructor with data set #0 (array('Foobar', 42, 9000.1,...

Status:	RESOLVED DUPLICATE of bug 37601

Product:	MediaWiki
Classification:	Unclassified
Component:	Unit tests (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-08-01 19:40 UTC by OverlordQ
Modified:	2012-12-28 01:39 UTC (History)
CC List:	4 users (show)

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

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

Description OverlordQ 2012-08-01 19:40:06 UTC

DBQueryError: A database error has occurred.  Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: CREATE TABLE IF NOT EXISTS "unittest_orm_test"(
				test_id                    INT unsigned        NOT NULL auto_increment PRIMARY KEY,
				test_name                  VARCHAR(255)        NOT NULL,
				test_age                   TINYINT unsigned    NOT NULL,
				test_height                FLOAT               NOT NULL,
				test_awesome               TINYINT unsigned    NOT NULL,
				test_stuff                 BLOB                NOT NULL,
				test_moarstuff             BLOB                NOT NULL,
				test_time                  varbinary(14)       NOT NULL
			);
Function: DatabaseBase::safeQuery
Error: 42601 ERROR:  syntax error at or near "unsigned"
LINE 2:     test_id                    INT unsigned        NOT NULL ...

Comment 1 OverlordQ 2012-08-01 19:40:51 UTC

                                           ^



/var/www/thedarkcitadel.com/w/includes/db/Database.php:972
/var/www/thedarkcitadel.com/w/includes/db/DatabasePostgres.php:468
/var/www/thedarkcitadel.com/w/includes/db/Database.php:939
/var/www/thedarkcitadel.com/w/includes/db/Database.php:1025
/var/www/thedarkcitadel.com/w/includes/db/Database.php:1050
/var/www/thedarkcitadel.com/w/tests/phpunit/includes/db/TestORMRowTest.php:82
/var/www/thedarkcitadel.com/w/tests/phpunit/MediaWikiTestCase.php:75
/var/www/thedarkcitadel.com/w/tests/phpunit/MediaWikiPHPUnitCommand.php:45
/var/www/thedarkcitadel.com/w/tests/phpunit/phpunit.php:103

(Forgot second part of error)

Comment 2 Antoine "hashar" Musso (WMF) 2012-08-02 14:07:53 UTC

Which database backend (and version) are you using?

I am CCing Jeroen De Dauw who wrote the ORM stuff.

Comment 3 OverlordQ 2012-08-02 15:06:53 UTC

Postgres, as given the postgres keyword tag, marking it a blocker of the postgres tracking bug, and the second line of the backtrace which is DatabasePostgres.php

Version is generally unimportant in this case, as the main issue is the datatypes in the CREATE statement which have been fairly invariant for the basic types. Although for giggles it's 9.1.4

INT unsigned => INT
varchar(255) => TEXT
TINYINT unsigned => SMALLINT
FLOAT => REAL
BLOB => BYTEA
varbinary(14) => BYTEA

I think are the general mappings.

Comment 4 Tim Landscheidt 2012-12-28 01:39:49 UTC


*** This bug has been marked as a duplicate of bug 37601 ***

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links