Last modified: 2014-08-20 19:25:28 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 T66970, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 64970 - errors using Oracle DB with oci8
errors using Oracle DB with oci8
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.22.5
PC Linux
: Normal blocker (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: oracle
  Show dependency treegraph
 
Reported: 2014-05-06 20:10 UTC by Haroldo Sotomayor
Modified: 2014-08-20 19:25 UTC (History)
4 users (show)

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


Attachments
setup info and error related info (672.15 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2014-05-06 20:10 UTC, Haroldo Sotomayor
Details

Description Haroldo Sotomayor 2014-05-06 20:10:32 UTC
Created attachment 15308 [details]
setup info and error related info

Several errors in DatabaseOracle.php related BLOB Oracle data type
errors during setup:
Warning - strpos() expects parameter 1 to be string on removeIdentifierQuotes and isQuotedIdentifier

I fixed these errors checking data type for parameter before call to strpos()

Also:
Error: 1400 ORA-01400: cannot insert NULL into ("WIKI"."WIKI_INTERWIKI"."IW_API")

I fixed this error redefining WIKI_INTERWIKI so columns IW_API, IW_LOCAL and IW_TRANS now accepting null values

After both changes I made, the configuration ran OK without warnings

Basic operation is OK (content added without problems)

Problems begins when attempt to delete an image stored. Update operation fails with this message

Warning: OCI-Lob::writetemporary() expects parameter 1 to be string, object given in /usr/local/apache2/htdocs/wiki/includes/db/DatabaseOracle.php on line 1327

Until now, cannot solve this problem.

Attached detailed info
Comment 1 Gerrit Notification Bot 2014-05-15 05:52:42 UTC
Change 133412 had a related patch set uploaded by Withoutaname:
Fetch string to pass through writeTemporary() in DatabaseOracle.php

https://gerrit.wikimedia.org/r/133412
Comment 2 Gerrit Notification Bot 2014-06-10 22:24:14 UTC
Change 133412 merged by jenkins-bot:
Fetch string to pass through writeTemporary() in DatabaseOracle.php

https://gerrit.wikimedia.org/r/133412
Comment 3 db [inactive,noenotif] 2014-07-31 07:23:28 UTC
*** Bug 68874 has been marked as a duplicate of this bug. ***
Comment 4 db [inactive,noenotif] 2014-07-31 07:26:24 UTC
Should be backported to 1.22 and 1.23 to allow better Oracle support, see links on bug 68874
Comment 5 db [inactive,noenotif] 2014-07-31 08:49:52 UTC
*** Bug 68877 has been marked as a duplicate of this bug. ***
Comment 6 Jesús Martínez Novo (Ciencia Al Poder) 2014-07-31 19:12:16 UTC
This patch doesn't address bug 68874 comment 1. See stack trace on that comment and analysis

Reopening
Comment 7 db [inactive,noenotif] 2014-07-31 19:31:21 UTC
You should reopen the other bug.
Comment 8 Gerrit Notification Bot 2014-08-17 13:34:44 UTC
Change 154461 had a related patch set uploaded by Umherirrender:
Fetch string to pass through writeTemporary() in DatabaseOracle.php

https://gerrit.wikimedia.org/r/154461
Comment 9 Gerrit Notification Bot 2014-08-19 20:42:38 UTC
Change 154461 merged by jenkins-bot:
Fetch string to pass through writeTemporary() in DatabaseOracle.php

https://gerrit.wikimedia.org/r/154461
Comment 10 Gerrit Notification Bot 2014-08-20 17:17:46 UTC
Change 155298 had a related patch set uploaded by Umherirrender:
Fetch string to pass through writeTemporary() in DatabaseOracle.php

https://gerrit.wikimedia.org/r/155298
Comment 11 Gerrit Notification Bot 2014-08-20 19:25:28 UTC
Change 155298 merged by jenkins-bot:
Fetch string to pass through writeTemporary() in DatabaseOracle.php

https://gerrit.wikimedia.org/r/155298

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links