On Tuesday, October 11, 2016 at 9:22:39 PM UTC-7, Kirill Shatalaev wrote:
>
>
>
>
>> What version of web2py is this happening on?
>>
>
> web2py Web Framework
> Created by Massimo Di Pierro, Copyright 2007-2016
> Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
>
>
>
>> Does this happen just with your app, or with the welcome app as well?
>>
>
> With my app. Welcome is not affected, but it uses sqlite, and my app uses
> mysql. Backticks is mysql special chars, you can use it if you want to use
> mysql reserved words in your table name of field name (i.e., "select", but
> I do not have such names on my model.
>
> So there is a setting on scaffolding db.py:
>
> db = DAL(myconf.get('db.uri'),
> pool_size=myconf.get('db.pool_size'),
> migrate_enabled=myconf.get('db.migrate'),
> check_reserved=['all'])
>
>
> check_reserved = all, not sure if this trouble related with it? Maybe my
> table or field names intersect with reserved words in other databases?
>
> This is a part of my sql.log, so 2016-10-06 everything is OK.
>
> 2016-10-12, I defined some additional tables in model, nothing more
> changed. And now I'm in this tick troubles.
>
>
Can you post your table declarations? Taking a quick look at the sql.log
(and I'm not a mysql user), but the index declarations look different
between Oct 06 and Oct 10:
> timestamp: 2016-10-06T22:50:05.440741
>
>
> [...]
>
> CREATE TABLE component(
> id INT AUTO_INCREMENT NOT NULL,
> name VARCHAR(50),
> alcoholic CHAR(1),
> alcohol_by_vol INT,
> component_group INT , INDEX component_group__idx (component_group),
> FOREIGN KEY (component_group) REFERENCES component_group (id) ON DELETE
> CASCADE,
> component_manufacturer INT , INDEX component_manufacturer__idx
> (component_manufacturer), FOREIGN KEY (component_manufacturer) REFERENCES
> component_manufacturer (id) ON DELETE CASCADE,
> PRIMARY KEY (id)
> ) ENGINE=InnoDB CHARACTER SET utf8;
> success!
> [...]
>
> timestamp: 2016-10-12T00:08:22.874621
> ALTER TABLE `component` ADD `component_state` INT , ADD INDEX
> `component_state__idx` (`component_state`), ADD FOREIGN KEY
> (`component_state`) REFERENCES `component_state` (`id`) ON DELETE CASCADE;
> success!
> [...]
>
> timestamp: 2016-10-12T00:08:28.920658
> CREATE TABLE `component_measurements`(
> `id` INT AUTO_INCREMENT NOT NULL,
> `name` VARCHAR(15),
> `component_state` INT , INDEX `component_state__idx`
> (`component_state`), FOREIGN KEY (`component_state`) REFERENCES
> `component_state` (`id`) ON DELETE CASCADE,
> PRIMARY KEY (`id`)
> ) ENGINE=InnoDB CHARACTER SET utf8;
> success!
> timestamp: 2016-10-12T00:08:28.932209
> CREATE TABLE `measurement_plurals`(
> `id` INT AUTO_INCREMENT NOT NULL,
> `plural_form` VARCHAR(15),
> `component_measurement` INT , INDEX `component_measurement__idx`
> (`component_measurement`), FOREIGN KEY (`component_measurement`) REFERENCES
> `component_measurements` (`id`) ON DELETE CASCADE,
> PRIMARY KEY (`id`)
> ) ENGINE=InnoDB CHARACTER SET utf8;
> success!
> timestamp: 2016-10-12T01:13:15.007933
> CREATE TABLE `plural_case`(
> `id` INT AUTO_INCREMENT NOT NULL,
> `name` VARCHAR(15),
> PRIMARY KEY (`id`)
> ) ENGINE=InnoDB CHARACTER SET utf8;
> success!
> timestamp: 2016-10-12T01:13:15.053358
> ALTER TABLE `measurement_plurals` ADD `plural_case` INT , ADD INDEX
> `plural_case__idx` (`plural_case`), ADD FOREIGN KEY (`plural_case`)
> REFERENCES `plural_case` (`id`) ON DELETE CASCADE;
> success!
>
>
>
>
/dps
--
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.
