the same error ( previous email i deleted the sql.log)
Traceback (most recent call last):
File "/home/ubuntu/web2py/gluon/restricted.py", line 212, in restricted
exec ccode in environment
File "/home/ubuntu/web2py/applications/EMPRE/models/db.py"
<http://localhost/admin/default/edit/EMPRE/models/db.py>, line 134, in
<module>
represent=lambda x, row:x and A('%s'%(db.t_docs.f_doc.retrieve(x)[0]),
File "/home/ubuntu/web2py/gluon/dal.py", line 7755, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File "/home/ubuntu/web2py/gluon/dal.py", line 7792, in lazy_define_table
polymodel=polymodel)
File "/home/ubuntu/web2py/gluon/dal.py", line 963, in create_table
self.create_sequence_and_triggers(query,table)
File "/home/ubuntu/web2py/gluon/dal.py", line 1781, in
create_sequence_and_triggers
self.execute(query)
File "/home/ubuntu/web2py/gluon/dal.py", line 1798, in execute
return self.log_execute(*a, **b)
File "/home/ubuntu/web2py/gluon/dal.py", line 1792, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
File "/home/ubuntu/web2py/gluon/contrib/pymysql/cursors.py", line
117, in execute
self.errorhandler(self, exc, value)
File "/home/ubuntu/web2py/gluon/contrib/pymysql/connections.py",
line 202, in defaulterrorhandler
raise errorclass, errorvalue
InternalError: (1005, u"Can't create table 'empre.t_docs' (errno: 150)")
2013/7/11 António Ramos <[email protected]>
> here the new log
>
>
> timestamp: 2013-07-11T11:46:35.319760
>
> CREATE TABLE t_docs(
> id INT AUTO_INCREMENT NOT NULL,
> f_trab_ref INT, INDEX f_trab_ref__idx (f_trab_ref), FOREIGN KEY
> (f_trab_ref) REFERENCES trabalhador (id) ON DELETE CASCADE,
>
>
> f_titulo VARCHAR(512),
> f_doc VARCHAR(512),
> PRIMARY KEY(id)
> ) ENGINE=InnoDB CHARACTER SET utf8;
>
>
>
> 2013/7/11 António Ramos <[email protected]>
>
>> Il try that.
>> Thank you Niphold for your time, as always :)
>>
>> Best regards
>> António
>>
>>
>> 2013/7/11 Niphlod <[email protected]>
>>
>>> as you can see it holds all the commands issued to the database. It will
>>> be more helpful if you move databases/sql.log to sql.log.bak and let web2py
>>> recreate to see what commands are indeed failing. your current one shows
>>> ALL the history including the creation of the tables in your previous dbs.
>>>
>>> --
>>>
>>> ---
>>> 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 [email protected].
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
