[Akonadi] [Bug 331867] mysql: column 'name' can not be null when migrating PartTable

[Brendan Barry]

https://bugs.kde.org/show_bug.cgi?id=331867

Brendan Barry <mailinglist at endosquid.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mailinglist at endosquid.com

--- Comment #21 from Brendan Barry <mailinglist at endosquid.com> ---
mysql> use akonadi
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------------------------+
| Tables_in_akonadi                |
+----------------------------------+
| collectionattributetable         |
| collectionmimetyperelation       |
| collectionpimitemrelation        |
| collectiontable                  |
| flagtable                        |
| mimetypetable                    |
| parttable                        |
| parttypetable                    |
| pimitemflagrelation              |
| pimitemtable                     |
| pimitemtagrelation               |
| resourcetable                    |                                            
| schemaversiontable               |                                            
| tagattributetable                |                                            
| tagremoteidresourcerelationtable |                                            
| tagtable                         |                                            
+----------------------------------+                                            
16 rows in set (0.00 sec)                                                       

mysql> DELETE FROM parttable WHERE name = 'GID';                                
ERROR 1054 (42S22): Unknown column 'name' in 'where clause'
mysql> desc part
partTypeId            parttable.data        parttable.external   
parttable.partTypeId  parttable.version     parttypetable.id     
parttypetable.ns      
parttable             parttable.datasize    parttable.id         
parttable.pimItemId   parttypetable         parttypetable.name    
mysql> desc parttable;
+------------+------------+------+-----+---------+----------------+
| Field      | Type       | Null | Key | Default | Extra          |
+------------+------------+------+-----+---------+----------------+
| id         | bigint(20) | NO   | PRI | NULL    | auto_increment |
| pimItemId  | bigint(20) | NO   | MUL | NULL    |                |
| partTypeId | bigint(20) | NO   | MUL | NULL    |                |
| data       | longblob   | YES  |     | NULL    |                |
| datasize   | bigint(20) | NO   |     | NULL    |                |
| version    | int(11)    | YES  |     | 0       |                |
| external   | tinyint(1) | YES  |     | 0       |                |
+------------+------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

mysql> select * from partable;
ERROR 1146 (42S02): Table 'akonadi.partable' doesn't exist
mysql> Bye


Yeah, I'm at the limit on this one.

-- 
You are receiving this mail because:
You are the assignee for the bug.