Hello Bill which web2py version? Can you try 2.1.1? On Thursday, 18 October 2012 19:19:40 UTC-5, Bill Thayer wrote: > > > Using the auth.wiki I am defining my menu. When I hit submit I get the > error below. The menu I wrote in is currently long I guess but it couldn't > be more than 4000 bytes (oracle CLOB length) could it? Perhaps it's the > HTML that gets stored in the DB?...That's what I suspected then I > remembered that in WIKI_MEDIA I added a blob field to store files on the > database and the 3 jpg images all larger that 4kb loaded with no problem. > > > > 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 283, 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 22, 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 4697, in __call__ > return self.edit(request.args(1) or 'index') > File "C:\web2py_src_2.1.1\web2py\gluon\tools.py", line 4791, in edit > formstyle='table2cols',showid=False).process() > File "C:\web2py_src_2.1.1\web2py\gluon\html.py", line 2135, in process > self.validate(**kwargs) > File "C:\web2py_src_2.1.1\web2py\gluon\html.py", line 2075, in validate > if self.accepts(**kwargs): > File "C:\web2py_src_2.1.1\web2py\gluon\sqlhtml.py", line 1439, in accepts > self.table._db(self.table._id == self.record[self.id_field_name]).update > (**fields) > File "C:\web2py_src_2.1.1\web2py\gluon\dal.py", line 8814, in update > ret = db._adapter.update(tablename,self.query,fields) > File "C:\web2py_src_2.1.1\web2py\gluon\dal.py", line 1371, in update > 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-01704: string literal too long > > > > > This article explains how to define a LOB field > http://www.dba-oracle.com/t_table_blob_lob_storage.htm in SQL. The SQL I > am reading in SQL developer from tables created by web2py is different but > should work. Then I got to messing with my menu markmin and discovered if I > remove the @//// from two of my menu items then it submits fine. > > - Request > @////request > - - Measurement > @////order-measurment > - - Model > @////model > - Product > @////Product > - - Measurements > Measurements > - - - S-Parameters > @////S-Parameters > - - - DC-IV > DC-IV > - - - Load Pull > @////Load-Pull > - - Models > @////Models > . > . > . > > > > https://groups.google.com/d/msg/web2py/f66R-f3QvDo/gZR40A87SJ4J - > Discussion from September 09 where Massimo posted a fix to sql.py (a file > only used for backward compatibility) but I'm not convinced it's a CLOB > problem. > > -Bill >
--
