drop the table and recreate it. It's a known issue with sqlite.
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#SQLite
On Thursday, May 29, 2014 9:34:28 PM UTC+2, Tom Russell wrote:
>
> I am getting the following error when inserting a new record for a table I
> have. I cannot seem to pinpoint what the cause is at this time.
>
> The error is:
>
> Traceback (most recent call last):
> File
> "/home/tsrdatatech/web2py/applications/ttheorydataextractor/controllers/appadmin.py",
> line 270, in select
> *fields, limitby=(start, stop))
> File "/home/tsrdatatech/web2py/gluon/dal.py", line 10525, in select
> return adapter.select(self.query,fields,attributes)
> File "/home/tsrdatatech/web2py/gluon/dal.py", line 2458, in select
> return super(SQLiteAdapter, self).select(query, fields, attributes)
> File "/home/tsrdatatech/web2py/gluon/dal.py", line 1882, in select
> return self._select_aux(sql,fields,attributes)
> File "/home/tsrdatatech/web2py/gluon/dal.py", line 1847, in _select_aux
> self.execute(sql)
> File "/home/tsrdatatech/web2py/gluon/dal.py", line 1969, in execute
> return self.log_execute(*a, **b)
> File "/home/tsrdatatech/web2py/gluon/dal.py", line 1963, in log_execute
> ret = self.cursor.execute(command, *a[1:], **b)
> File "/usr/lib/python2.7/sqlite3/dbapi2.py", line 63, in convert_date
> return datetime.date(*map(int, val.split("-")))
> ValueError: invalid literal for int() with base 10: '12/02/2013'
>
>
> And my table looks like:
>
> db.define_table("daily_data",
> Field("startdate","date",requires=IS_DATE(), label="Date",
> readable=True, writable=False),
> Field("vol_total","double", label="Vol Total", readable=True,
> writable=False),
> Field("wsj_date","string", label="WSJ Date", readable=True,
> writable=False),
> Field("trin","double", label="TRIN", readable=True, writable=False),
> Field("gold","double", readable=True, writable=False),
> Field("vix","double", label="VIX", readable=False, writable=False),
> Field("advances","double", readable=True, writable=False),
> Field("declines","double", readable=True, writable=False),
> Field("adv_vol","double", readable=True, writable=False),
> Field("dec_vol","double", readable=True, writable=False),
> Field("sp_hi","double", readable=True, writable=False),
> Field("sp_low","double", readable=True, writable=False),
> Field("sp_close","double", readable=True, writable=False),
> Field("spy","double", label="SPY", readable=False, writable=False),
> Field("csj","double", label="CSJ", readable=False, writable=False),
> Field("bnd","double", label="BND", readable=False, writable=False),
> Field("cwb","double", label="CWB", readable=False, writable=False),
> Field("bond","double", label="BOND", readable=False, writable=False),
> Field("hys","double", label="HYS", readable=False, writable=False),
> Field("flot","double", label="FLOT", readable=False, writable=False),
> Field("hyg","double", label="HYG", readable=False, writable=False),
> Field("bkln","double", label="BKLN", readable=False, writable=False),
> Field("emb","double", label="EMB", readable=False, writable=False),
> Field("efa","double", label="EFA", readable=False, writable=False),
> Field("fex","double", label="FEX", readable=False, writable=False),
> Field("mdy","double", label="MDY", readable=False, writable=False),
> Field("fnx","double", label="FNX", readable=False, writable=False),
> Field("vti","double", label="VTI", readable=False, writable=False),
> Field("iwd","double", label="IWD", readable=False, writable=False),
> Field("fta","double", label="FTA", readable=False, writable=False),
> Field("iwm","double", label="IWM", readable=False, writable=False),
> Field("dvy","double", label="DVY", readable=False, writable=False),
> Field("iyr","double", label="IYR", readable=False, writable=False),
> Field("ijr","double", label="IJR", readable=False, writable=False),
> Field("tlt","double", label="TLT", readable=False, writable=False),
> Field("ief","double", label="IEF", readable=False, writable=False),
> Field("vustx","double", label="VUSTX", readable=False,
> writable=False),
> Field("fagix","double", label="FAGIX", readable=False,
> writable=False),
> Field("qqq","double", label="QQQ", readable=False, writable=False),
> )
>
> I know the error refers to a date and actually I had wsj_date as a date
> field but changed it to a string since I really did not need the date
> requirement for it.
>
> Any suggestions?
>
> Thanks.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
