What is the URL of your deployment?
http://aleph.inesc-id.pt/s3db/
What steps will reproduce the problem?
1.login with user name + password to retrieve a key
2. use that key in subsequent s3ql queries
3.some query return the expect result and others return
error, code:1, message:invalid key...
What is the expected output? What do you see instead?
3.some query return the expect result and others return
error, code:1, message:invalid key...
in the postgres log we can see:
STATEMENT: insert into s3db_deployment (deployment_id, url, publickey,
checked_on, checked_valid) values ('', '', '', now(), '')
ERROR: invalid input syntax for type timestamp: ""
What version of the product are you using? On what operating system?
S3DB-3.5.7; D1313779; linux; apache; postgres 8.3.3
Please provide any additional information below.
because s3db is deployed in different databases, it should use an
intermediary logic layer so when you are inserting
database values the intermediary layers would convert that datatype
from php to the right representation of that datatype for each
database.
cleary the check_valid field is of type timestamp and does not accept
'' (string) values on postgres 8.3.3. . Maybe in the other databases
it is accept.
the logic layer is usually called ORM when the logic code is on object
programming and does this conversion automatically.
It's a suggestion.
Original issue reported on code.google.com by mauro.ds...@gmail.com on 19 May 2010 at 10:29
Original issue reported on code.google.com by
mauro.ds...@gmail.comon 19 May 2010 at 10:29