Page MenuHomePhabricator

Mediawiki Upload Error and Search not working in Oracle due to DB account rights, works byenabling Oracle Text
Closed, DeclinedPublic

Description

Author: rgherrera.meralco

Description:
Hi,

My mediawiki 1.19 has some bugs running with Oracle. 1. When trying to upload a file I get an ora error (table/view) 2. and when using search it wont work unless you type an exact string for the title (it appears the title is the only thing being searched)

You can also check our thread at http://www.mediawiki.org/wiki/Project:Support_desk#MediWiki_with_Oracle_1647

Please help me I really need to solve this ASAP!

System:
IIS 6

Mediawiki 1.19

Oracle

Thank you.


Version: 1.19
Severity: critical
OS: Windows Server 2003
Platform: PC

Details

Reference
bz36726

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 12:26 AM
bzimport added a project: MediaWiki-Search.
bzimport set Reference to bz36726.
bzimport added a subscriber: Unknown Object (MLST).

I'm adding a couple of people who work with Oracle DB and can probably help you to the CC of this bug.

rgherrera.meralco wrote:

Thank you very much. Hope to hear from you soon.

jfehrman wrote:

Raymond,
I was out last week because of graduation. I should be able to look at the problem more tonight. I will see if I can replicate the problem today on my Oracle MediaWiki install.

jfehrman wrote:

Raymond,
I am going to have to build a new wiki to troubleshoot your problem. I don't currently have file uploads available to my users and I don't want to enable it. I will let you know when I have created the new wiki to be tested.

freak wrote:

Raymond,
first of all, sorry for delay ... was a bit swamped at work last few weeks ...

I just tried this procedure on both 1.19beta2 (from git) and 1.19rc1 (from tarball):

  • fresh install (no errors)
  • upload of an image (no errors)
  • search for partial name of that image ... image found

So to debug this i would need:

  • how was exactly was MW installed (all DB related options selected)
  • list of all if any errors during the installation
  • exact error message during file upload

if you can, try to find me on irc ... i'm usually online 9-18 CET.

LP, Jure

rgherrera.meralco wrote:

Hi Jure,

Thank you very much for helping me with this.

What if, could you tell me how you installed your wiki and then i'll replicate it on my end.

As for what I did,

  1. I created a schema for my oracle 10g named dbwikidv
  2. I have dba administrator privileges
  3. extracted mediawiki 1.19 on my iis6 web server (windows server 2003)
  4. accessed the address of the wiki install, saw the setting up page
  5. Next got, The environment has been checked. You can install MediaWiki.
  6. next, clicked oracle, entered the database tns: dbwikidv created from no. 1, entered a prefix: wiki, entered tablespace: users, entered temporary tablespace: temp, entered user acount for installation in number 2, clicked use the same account for installation.
  7. i cant remember the preceeding part but its just simply creating my entire wiki that I think wouldn't affect the performance
  8. i got an error the first time I created it but I can't remember it anymore

Is there a way to reinstall localsettings without touching the database?
What I'm doing is moving local settings.php to a different folder but I always get stuck in the upgrading section. Please see attachment.

rgherrera.meralco wrote:

local settings reinstallation

Attached:

reinstallation_of_local_settings.png (665×1 px, 44 KB)

rgherrera.meralco wrote:

Upload error

Attached:

upload_error.png (666×1 px, 30 KB)

rgherrera.meralco wrote:

search error 1 and 2

Attached:

search_error.png (665×1 px, 34 KB)

rgherrera.meralco wrote:

search error 2 of 2

Attached:

search_error_2.png (665×1 px, 75 KB)

rgherrera.meralco wrote:

Hi Jure,

local settings reinstllation is for the one above.

the error messages i got using wiki on oracle are attached as upload error and search error 1-2

Raymond: Is this still an issue or did you find a way to resolve / work around this?

Jure: Did you have time to get back to this?

Raymond: Is this still an issue or did you find a way to resolve / work around
this?

Jure: Did you have time to get back to this?

freak wrote:

Andre:

To be honest i don't remember what happened in this case, all i do remember is that i couldn't replicate the error in any of my MW setups.

If you have any additional info on how to replicate this bug, please post it, but as you can see i have a bit of lag this year.

If you need faster reply, poke my mail, i tend to reply quicker ...

Jure: I understand. No problem. :)

Raymond: If this is still a problem, which exact MediaWiki version is this about (see Special:Version )?

Raymond: If this is still a problem, which exact MediaWiki version is this
about (see Special:Version )?

rgherrera.meralco wrote:

Hi Andre,

Sorry for the very late reply. I was able to solve the problem. It was because of db account rights in Oracle. I was able to use the search function too by enabling Oracle Text.

Thank you very much to you guys for all of the help.

Glad to hear you found the reason! Closing as WORKSFORME.