About 6 days ago I posted my "saga" of failed attempts to get plugin_wiki to work with oracle and to add the blob field. You told me to put return auth.wiki() in my controller and use the built in auth wiki but I needed a bit more information and Oracle was still complaining.
Alan told me to add auth.wiki(resolve=False) to my db.py file. Which eventually worked. But by that time the tables were created. Looks like it's working as expected, even storing and retrieving the data with a blob field. So far so good except when I click on the search link for the wiki (/default/index/_search) I did get this error that I haven't yet dug into very deeply but here it is: Traceback (most recent call last): File "C:\web2py_src_2.1.1\web2py\gluon\restricted.py", line 209, inrestricted exec ccode in environment File "C:/web2py_src_2.1.1/web2py/applications/TAMOTO/controllers/default.py"<http://127.0.0.1:8000/admin/default/edit/TAMOTO/controllers/default.py> , line 240, in <module> File "C:\web2py_src_2.1.1\web2py\gluon\globals.py", line 187, in <lambda> self._caller = lambda f: f() File "C:/web2py_src_2.1.1/web2py/applications/TAMOTO/controllers/default.py"<http://127.0.0.1:8000/admin/default/edit/TAMOTO/controllers/default.py> , line 20, in index return auth.wiki() File "C:\web2py_src_2.1.1\web2py\gluon\tools.py", line 3227, in wiki return self._wiki.read(slug)['content'] if slug else self._wiki() File "C:\web2py_src_2.1.1\web2py\gluon\tools.py", line 4705, in __call__ return self.search() File "C:\web2py_src_2.1.1\web2py\gluon\tools.py", line 4990, in search content.append(self.cloud()['content']) File "C:\web2py_src_2.1.1\web2py\gluon\tools.py", line 5001, in cloud orderby = ~count, limitby=(0,20)) File "C:\web2py_src_2.1.1\web2py\gluon\dal.py", line 8790, in select return adapter.select(self.query,fields,attributes) File "C:\web2py_src_2.1.1\web2py\gluon\dal.py", line 1615, in select return self._select_aux(sql,fields,attributes) File "C:\web2py_src_2.1.1\web2py\gluon\dal.py", line 1580, in _select_aux self.execute(sql) File "C:\web2py_src_2.1.1\web2py\gluon\dal.py", line 2856, in execute return self.log_execute(command, args) File "C:\web2py_src_2.1.1\web2py\gluon\dal.py", line 1687, in log_execute ret = self.cursor.execute(*a, **b) DatabaseError: ORA-00904: "WIKI_TAG"."WIKI_PAGE": invalid identifier On Tuesday, October 16, 2012 12:20:30 PM UTC-5, Massimo Di Pierro wrote: > > On Tuesday, 16 October 2012 11:23:29 UTC-5, Bill Thayer wrote: > >> Note for future searchers & people as foolish as I am to try and use >> Oracle for web site backend. >> .... >> I did not have this issue with tables created by web2py. >> > > so why did you create the wiki tables manually? I am missing something. > --