I added the "timestamp" field to the table:
{
*db.define_table("auction_item_bids_lexa",*
* Field("bidder"),*
* Field("block_size"),*
* Field("bid_per_block","integer", default = 0),*
* Field("number_of_blocks"),*
* Field("timestamp","datetime"),*
* ) #CDN-000275*
}
the started having issues - - -does anyone here understand what the fix to
the following could be?
Here is the traceback:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted
exec ccode in environment
File "/home/www-data/web2py/applications/omniavx/models/db.py"
<https://www.omniavx.com/admin/edit/omniavx/models/db.py>, line 148, in <module>
Field("timestamp","datetime"),
File "/home/www-data/web2py/gluon/dal.py", line 7788, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File "/home/www-data/web2py/gluon/dal.py", line 7825, in lazy_define_table
polymodel=polymodel)
File "/home/www-data/web2py/gluon/dal.py", line 991, in create_table
fake_migrate=fake_migrate)
File "/home/www-data/web2py/gluon/dal.py", line 1094, in migrate_table
self.execute(sub_query)
File "/home/www-data/web2py/gluon/dal.py", line 1784, in execute
return self.log_execute(*a, **b)
File "/home/www-data/web2py/gluon/dal.py", line 1778, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
File "/home/www-data/web2py/gluon/contrib/pg8000/dbapi.py", line 246, in _fn
return fn(self, *args, **kwargs)
File "/home/www-data/web2py/gluon/contrib/pg8000/dbapi.py", line 317, in
execute
self._execute(operation, args)
File "/home/www-data/web2py/gluon/contrib/pg8000/dbapi.py", line 322, in
_execute
self.cursor.execute(new_query, *new_args)
File "/home/www-data/web2py/gluon/contrib/pg8000/interface.py", line 398, in
execute
self._stmt = PreparedStatement(self.connection, query, statement_name="",
*[{"type": type(x), "value": x} for x in args])
File "/home/www-data/web2py/gluon/contrib/pg8000/interface.py", line 138, in
__init__
self._parse_row_desc = self.c.parse(self._statement_name, statement, types)
File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 943, in
_fn
return fn(self, *args, **kwargs)
File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 1104, in
parse
return reader.handle_messages()
File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 929, in
handle_messages
raise exc
ProgrammingError: ('ERROR', '42804', 'column "bid_per_block__tmp" is of type
integer but expression is of type character varying')
--
---
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/groups/opt_out.
