Niphlod,
this is the log. The test table, that I created, passes fine, but the
"campaign" table doesn't say "success". Is it about the FOREIGN KEY?
<<<<< sql.log
timestamp: 2013-10-13T12:23:25.789598
CREATE TABLE tests(
id INTEGER PRIMARY KEY AUTOINCREMENT,
auth_table INTEGER REFERENCES auth_user (id) ON DELETE CASCADE,
path2 TEXT
);
success!
timestamp: 2013-10-13T12:29:03.020292
CREATE TABLE campaign(
id INT AUTO_INCREMENT NOT NULL,
uuid VARCHAR(64),
name VARCHAR(512),
pagename VARCHAR(512),
description LONGTEXT,
created_by_auth INT, INDEX created_by_auth__idx (created_by_auth),
FOREIGN KEY (created_by_auth) REFERENCES auth_user (id) ON DELETE CASCADE,
created_by_participant INT, INDEX created_by_participant__idx
(created_by_participant), FOREIGN KEY (created_by_participant) REFERENCES
participant (id) ON DELETE CASCADE,
cctype VARCHAR(512),
privacy VARCHAR(512),
registration VARCHAR(512),
idea_submit VARCHAR(512),
campaign_logo VARCHAR(512),
campaign_start DATE,
campaign_end DATE,
creation_date DATETIME,
twitter_feed CHAR(1),
weekly_newsletter VARCHAR(512),
weekly_contributor_status CHAR(1),
weekly_contributor_nro INT,
weekly_contributor_prize_description LONGTEXT,
overall_contributor_status CHAR(1),
overall_contributor_nro INT,
overall_contributor_prize_description LONGTEXT,
registered_participant_status CHAR(1),
registered_participant_tasks INT,
registered_participant_description LONGTEXT,
free_prize_description LONGTEXT,
status VARCHAR(512),
nro_of_participants INT,
nro_of_ideas INT,
nro_of_ratings INT,
nro_of_comments INT,
additional_settings LONGTEXT,
credits_settings LONGTEXT,
rating_settings LONGTEXT,
process_settings LONGTEXT,
cpath LONGTEXT,
PRIMARY KEY(id)
) ENGINE=InnoDB CHARACTER SET utf8;
Ykä
On Sunday, October 13, 2013 3:47:36 PM UTC+3, Niphlod wrote:
>
> inspect databases/sql.log, there are the statements used to create the
> table there
>
> On Sunday, October 13, 2013 2:42:03 PM UTC+2, Ykä Marjanen wrote:
>>
>> Hi guys,
>>
>> I thought of using pythonanywhere for the next level of development, so
>> deployed my code there. I had been using sqlite as a test environment, and
>> wanted to move to the mysql database that pythonanywhere provides.
>>
>> I created a new mysql database and then switched the DAL connection to:
>> db =
>> DAL('mysql://ykamarjanen:PASS@mysql.server/ykamarjanen$DBNAME',pool_size=1,check_reserved=['all'])
>>
>> After running the web2py I got an error about the database (1005, can't
>> create table, errno:150). I tried different variations, but could figure
>> out what is wrong with my table.
>>
>> Here's my table, that is not created (it has some reserved names, which I
>> changed):
>>
>> db.define_table('campaign',
>> Field('uuid', length=64, default=lambda:str(uuid4())),
>> Field('name'),
>> Field('pagename'),
>> Field('description','text', requires=IS_LENGTH(minsize=20,
>> maxsize=500)),
>> Field('created_by_auth','reference auth_user', default=auth.user_id,
>> readable=False, writable=False),
>> Field('created_by_participant','reference participant',
>> readable=False, writable=False),
>> Field('campaign_type', readable=False, writable=False),
>> Field('privacy',requires=IS_IN_SET(['open','closed'],zero=T('Choose
>> privacy')),default='open'),
>>
>> Field('registration',requires=IS_IN_SET(['open','invitation'],zero=T('Choose
>> registration')),default='open'),
>>
>> Field('idea_submit',requires=IS_IN_SET(['anonymous','registered'],zero=T('Choose
>>
>> how ideas can be sent')),default='anonymous'),
>> Field('campaign_logo',requires=IS_EMPTY_OR(IS_URL())),
>> Field('campaign_start','date',requires=IS_DATE(),default=request.now),
>> Field('campaign_end','date',requires=IS_DATE()),
>> Field('creation_date','datetime',default=request.now),
>> Field('twitter_feed','boolean',default=False),
>>
>> Field('weekly_newsletter',requires=IS_IN_SET(['Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday'],zero=T('Pick
>>
>> a day for newsletter')),default='Monday'),
>> Field('weekly_contributor_status','boolean',default=True),
>>
>> Field('weekly_contributor_nro','integer',requires=IS_IN_SET(range(0,20),zero=T('Select
>>
>> the number of participants included in the raffle'))),
>> Field('weekly_contributor_prize_description','text'),
>> Field('overall_contributor_status','boolean',default=True),
>>
>> Field('overall_contributor_nro','integer',requires=IS_IN_SET(range(0,20),zero=T('Select
>>
>> the number of participants included in the raffle'))),
>> Field('overall_contributor_prize_description','text'),
>> Field('registered_participant_status','boolean',default=True),
>>
>> Field('registered_participant_tasks','integer',requires=IS_IN_SET(range(0,20),zero=T('Select
>>
>> the number of minimum tasks for the prize raffle'))),
>> Field('registered_participant_description','text'),
>> Field('free_prize_description','text'),
>> Field('status',
>> requires=IS_IN_SET(['waiting','running','halted','ended']), readable=False,
>> writable=False), #waiting, running, halted, ended
>> Field('nro_of_participants','integer',default=0, readable=False,
>> writable=False),
>> Field('nro_of_ideas','integer',default=0, readable=False,
>> writable=False),
>> Field('nro_of_ratings','integer',default=0, readable=False,
>> writable=False),
>> Field('nro_of_comments','integer',default=0, readable=False,
>> writable=False),
>> Field('additional_settings','text', filter_in=(lambda x:
>> pickle.dumps(x)), filter_out=(lambda s: s and
>> pickle.loads(s)),default=None, readable=False, writable=False),
>> Field('credits_settings','text', filter_in=(lambda x:
>> pickle.dumps(x)), filter_out=(lambda s: s and
>> pickle.loads(s)),default=None, readable=False, writable=False),
>> Field('rating_settings','text', filter_in=(lambda x:
>> pickle.dumps(x)), filter_out=(lambda s: s and
>> pickle.loads(s)),default=None, readable=False, writable=False),
>> Field('process_settings','text', filter_in=(lambda x:
>> pickle.dumps(x)), filter_out=(lambda s: s and
>> pickle.loads(s)),default=None, readable=False, writable=False),
>> Field('path','text', filter_in=(lambda x: pickle.dumps(x)),
>> filter_out=(lambda s: s and pickle.loads(s)),default=None, readable=False,
>> writable=False))
>>
>> Ykä
>>
>
--
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/groups/opt_out.
