Last modified: 2013-10-30 11:30:15 UTC
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.
I'm adding a couple of people who work with Oracle DB and can probably help you to the CC of this bug.
Thank you very much. Hope to hear from you soon.
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.
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.
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
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.
Created attachment 10592 [details] local settings reinstallation
Created attachment 10593 [details] Upload error
Created attachment 10594 [details] search error 1 and 2
Created attachment 10595 [details] search error 2 of 2
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?
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 )?
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.
