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 --