Das deutsche Python-Forum

Code: Alles auswählen

{'PhpbbAclGroups': {'auth_setting': {'content': 'ACL_YES, ACL_NO or ACL_NEVER',
                                     'default': '0',
                                     'type (MySQL)': 'tinyint(2)'},
                    'description': 'Permission roles and/or individual permissions assigned to groups',
                    'page_name': 'Table.phpbb_acl_groups'},
 'PhpbbAclOptions': {'description': 'List of possible permissions',
                     'founder_only': {'content': 'only founders can have this permission',
                                      'default': '0',
                                      'type (MySQL)': 'tinyint(1) unsigned'},
                     'page_name': 'Table.phpbb_acl_options'},
 'PhpbbAclRoles': {'description': 'Permission roles (Standard Moderator, Simple Moderator etc.)',
                   'page_name': 'Table.phpbb_acl_roles',
                   'role_order': {'content': 'tbd',
                                  'default': '0',
                                  'type (MySQL)': 'smallint(4) unsigned'}},
...

Code: Alles auswählen

Exception Value: (1116, 'Too many tables; MySQL can only use 61 tables in a join')

Code: Alles auswählen

class PhpBBForeignKey(models.ForeignKey):
    """
    phpBB stores a None ForeignKey as a numeric 0
    """
    def get_db_prep_save(self, value, connection):
        if value in ("", None):
            value = 0
        return super(PhpBBForeignKey, self).get_db_prep_save(value, connection)