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

2014-04-28 Thread jajaX
https://bugs.kde.org/show_bug.cgi?id=331867

jajaX jaja...@gmail.com changed:

   What|Removed |Added

 CC||jaja...@gmail.com

--- Comment #24 from jajaX jaja...@gmail.com ---
Hi ! (sorry for my bad english)

it'sn't solved forum after upgrade 4.12 to 4.13.

these is the konsole result :

jajax@portable:~$ akonadictl start
Starting Akonadi Server... 
   done. 
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
jajax@portable:~$ search paths:  (/usr/lib/lightdm/lightdm,
/usr/local/sbin, /usr/local/bin, /usr/sbin, /usr/bin, /sbin, /bin,
/usr/games, /usr/local/games, /usr/sbin, /usr/local/sbin,
/usr/local/libexec, /usr/libexec, /opt/mysql/libexec,
/opt/local/lib/mysql5/bin, /opt/mysql/sbin) 
Found mysql_install_db:  /usr/bin/mysql_install_db 
Found mysqlcheck:  /usr/bin/mysqlcheck 
akonadi.collectionattributetable   OK
akonadi.collectionmimetyperelation OK
akonadi.collectionpimitemrelation  OK
akonadi.collectiontableOK
akonadi.flagtable  OK
akonadi.mimetypetable  OK
akonadi.parttable  OK
akonadi.parttypetable  OK
akonadi.pimitemflagrelationOK
akonadi.pimitemtable   OK
akonadi.pimitemtagrelation OK
akonadi.resourcetable  OK
akonadi.schemaversiontable OK
akonadi.tagattributetable  OK
akonadi.tagremoteidresourcerelationtable   OK
akonadi.tagtable   OK
mysql.columns_priv OK
mysql.db   OK
mysql.eventOK
mysql.func OK
mysql.general_log  OK
mysql.help_categoryOK
mysql.help_keyword OK
mysql.help_relationOK
mysql.help_topic   OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin   OK
mysql.proc OK
mysql.procs_priv   OK
mysql.servers  OK
mysql.slow_log OK
mysql.tables_priv  OK
mysql.time_zoneOK
mysql.time_zone_leap_secondOK
mysql.time_zone_name   OK
mysql.time_zone_transition OK
mysql.time_zone_transition_typeOK
mysql.user OK
MySQL version OK (required 5.1 , available 5.5 ) 
Database akonadi opened using driver QMYSQL 
DbInitializer::run() 
checking table  SchemaVersionTable 
checking table  ResourceTable 
checking table  CollectionTable 
checking table  MimeTypeTable 
checking table  PimItemTable 
checking table  FlagTable 
checking table  PartTypeTable 
checking table  PartTable 
checking table  CollectionAttributeTable 
checking table  TagTable 
checking table  TagAttributeTable 
checking table  TagRemoteIdResourceRelationTable 
checking table  PimItemFlagRelation 
checking table  PimItemTagRelation 
checking table  CollectionMimeTypeRelation 
checking table  CollectionPimItemRelation 
DbInitializer::run() done 
skipping update 2 
skipping update 3 
skipping update 4 
skipping update 8 
skipping update 10 
skipping update 12 
skipping update 13 
skipping update 14 
skipping update 15 
skipping update 16 
skipping update 17 
skipping update 18 
skipping update 19 
skipping update 20 
skipping update 21 
skipping update 22 
skipping update 23 
skipping update 24 
skipping update 25 
skipping update 26 
Adding new foreign key constraints 
ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES
CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE 
Updating index failed:  
Sql error: Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`#sql-a49_1b`, CONSTRAINT `#sql-a49_1b_ibfk_1` FOREIGN KEY
(`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE
CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES
CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE 

Unable to initialize database.
[
0: akonadiserver() [0x805d455]
1: akonadiserver() [0x805d6e1]
2: [0xb76fc400]
3: [0xb76fc424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6d99aff]
5: 

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

2014-04-28 Thread Daniel Vrátil
https://bugs.kde.org/show_bug.cgi?id=331867

--- Comment #25 from Daniel Vrátil dvra...@redhat.com ---
jajaX, your problem is unrelated to this one, please open a new report.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-28 Thread Panard
https://bugs.kde.org/show_bug.cgi?id=331867

Panard pan...@inzenet.org changed:

   What|Removed |Added

 CC|pan...@inzenet.org  |

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-28 Thread jajaX
https://bugs.kde.org/show_bug.cgi?id=331867

--- Comment #26 from jajaX jaja...@gmail.com ---
ok, no problem. sorry ;)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-22 Thread Daniel Vrátil
https://bugs.kde.org/show_bug.cgi?id=331867

Daniel Vrátil dvra...@redhat.com changed:

   What|Removed |Added

 Status|CONFIRMED   |RESOLVED
   Version Fixed In||1.12.2
 Resolution|--- |FIXED
  Latest Commit||http://commits.kde.org/akon
   ||adi/4ca8b846baaad48ebbd723f
   ||6411f9571a3b0f5ad

--- Comment #23 from Daniel Vrátil dvra...@redhat.com ---
Git commit 4ca8b846baaad48ebbd723f6411f9571a3b0f5ad by Dan Vrátil.
Committed on 22/04/2014 at 09:28.
Pushed by dvratil into branch '1.12'.

Remove the invalid GID part from PartTable before starting PartTable migration

More people than we expected have invalid 'GID' part in their PartTable,
which breaks migration to schema 25, because it expects all part types
to have a valid name.

To work around this fact, we DELETE all parts with name 'GID' from PartTable
before starting the actual migration. This will not fix the migration for
people with other invalid parts, but I haven't heard of any such. To make
this completely bullet-proof, we would need to iterate through all entries,
which would be massively slower than current INSERT INTO ... SELECT FROM
approach.

Distributions, this is a good choice for backporting into 1.12.1 ;-)
FIXED-IN: 1.12.2

M  +9-0server/src/storage/dbupdater.cpp

http://commits.kde.org/akonadi/4ca8b846baaad48ebbd723f6411f9571a3b0f5ad

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-22 Thread Stephan Diestelhorst
https://bugs.kde.org/show_bug.cgi?id=331867

Stephan Diestelhorst stephan.diestelho...@gmail.com changed:

   What|Removed |Added

 CC||stephan.diestelhorst@gmail.
   ||com

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-21 Thread Till Schäfer
https://bugs.kde.org/show_bug.cgi?id=331867

Till Schäfer till2.schae...@uni-dortmund.de changed:

   What|Removed |Added

 CC||till2.schaefer@uni-dortmund
   ||.de

--- Comment #22 from Till Schäfer till2.schae...@uni-dortmund.de ---
same here on gentoo with 4.13.0 + akonadi server 12.1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-20 Thread happy
https://bugs.kde.org/show_bug.cgi?id=331867

happy hh.kde.cr...@gmail.com changed:

   What|Removed |Added

 CC||hh.kde.cr...@gmail.com

--- Comment #18 from happy hh.kde.cr...@gmail.com ---
(In reply to comment #16)
Ivan, you are a legend!

Experienced this issue upgrading from Kubuntu 13.10 to 14.04; Akonadi DB
probably goes back to Kubunnto 12 era :
mysql DELETE FROM PartTable WHERE name='GID';
Query OK, 48 rows affected (1.12 sec)

Can I add that having Akonadi as a single point of failure it's a real shame
that it took me a day of poking around to find this bug report; no other user
visible means of diagnosis etc.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-20 Thread Ivan Adzhubey
https://bugs.kde.org/show_bug.cgi?id=331867

--- Comment #19 from Ivan Adzhubey iadzhu...@verizon.net ---
I am glad my fix helped you.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-20 Thread Mark Anderson
https://bugs.kde.org/show_bug.cgi?id=331867

Mark Anderson ourm...@gmail.com changed:

   What|Removed |Added

 CC||ourm...@gmail.com

--- Comment #20 from Mark Anderson ourm...@gmail.com ---
Ivan @ Comment 16

Thanks again for the walk-through. This one was a real pain for me.

Mark

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-20 Thread Brendan Barry
https://bugs.kde.org/show_bug.cgi?id=331867

Brendan Barry mailingl...@endosquid.com changed:

   What|Removed |Added

 CC||mailingl...@endosquid.com

--- Comment #21 from Brendan Barry mailingl...@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
partTypeIdparttable.dataparttable.external   
parttable.partTypeId  parttable.version parttypetable.id 
parttypetable.ns  
parttable parttable.datasizeparttable.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.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-19 Thread jms.daley
https://bugs.kde.org/show_bug.cgi?id=331867

jms.da...@gmail.com changed:

   What|Removed |Added

 CC|jms.da...@gmail.com |

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-19 Thread Michael D
https://bugs.kde.org/show_bug.cgi?id=331867

Michael D nortex...@gmail.com changed:

   What|Removed |Added

 CC||nortex...@gmail.com

--- Comment #17 from Michael D nortex...@gmail.com ---
Ivan Adzhubey at comment 16, thank you very much!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-18 Thread jms.daley
https://bugs.kde.org/show_bug.cgi?id=331867

jms.da...@gmail.com changed:

   What|Removed |Added

 CC||jms.da...@gmail.com

--- Comment #14 from jms.da...@gmail.com ---
I have the same problem after upgrading to kubuntu 14.04 (akonadi-server
1.12.1). 
How do I get akonadi console to run when any attempt to start it causes the
conversion to run and it therefore fails?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-18 Thread Ivan Adzhubey
https://bugs.kde.org/show_bug.cgi?id=331867

Ivan Adzhubey iadzhu...@verizon.net changed:

   What|Removed |Added

 CC||iadzhu...@verizon.net

--- Comment #15 from Ivan Adzhubey iadzhu...@verizon.net ---
I am having the same problem as well and I do not know how to fix it since
akonadi console is also non-functional after the upgrade. Please, help!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-18 Thread Ivan Adzhubey
https://bugs.kde.org/show_bug.cgi?id=331867

--- Comment #16 from Ivan Adzhubey iadzhu...@verizon.net ---
OK, figured it out myself:

$ mysql --socket=/tmp/akonadi-${USER}.rp6WPG/mysql.socket
mysql use akonadi
mysql DELETE FROM PartTable WHERE name = 'GID';
mysql quit
Bye
$ akonadictl start

That helped and akonadi database migration was successfully completed. KMail is
now working again.

P.S. Nota, that exact name of your akonadi mysqld instance temporary socket
file will be different, use the following command to find it out:

$ ps aux | grep mysqld

Then look for the line in the output with the following parameter:
--datadir=/home/$USER/.local/share/akonadi/db_data/. Copy the --socket=
parameter from the same line to start mysql textmode client above.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-17 Thread Mathieu Jobin
https://bugs.kde.org/show_bug.cgi?id=331867

Mathieu Jobin somek...@somekool.net changed:

   What|Removed |Added

 CC||somek...@somekool.net

--- Comment #13 from Mathieu Jobin somek...@somekool.net ---
thanks, comment by Daniel Vrátil  2014-03-14 18:36:05 UTC

solved my issue

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-17 Thread Jakob Petsovits
https://bugs.kde.org/show_bug.cgi?id=331867

Jakob Petsovits j.acco...@petsovits.com changed:

   What|Removed |Added

 CC||j.acco...@petsovits.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-14 Thread rdnetto
https://bugs.kde.org/show_bug.cgi?id=331867

rdne...@gmail.com changed:

   What|Removed |Added

 CC||rdne...@gmail.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-12 Thread m.wege
https://bugs.kde.org/show_bug.cgi?id=331867

m.w...@web.de changed:

   What|Removed |Added

 CC||m.w...@web.de

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-07 Thread Michael
https://bugs.kde.org/show_bug.cgi?id=331867

Michael mich...@stopthemindspam.com changed:

   What|Removed |Added

 CC||mich...@stopthemindspam.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-07 Thread Michael
https://bugs.kde.org/show_bug.cgi?id=331867

--- Comment #12 from Michael mich...@stopthemindspam.com ---
Daniel's solution in Comment #9 solved the issue for me when I today upgraded
from Kubuntu 13.10 to 14.04. 

As of April 6th, the akonadi-server package 1.12.0-0ubuntu1 still triggered the
exact GID issue as was reported in comment #8.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-03 Thread Johannes Huber
https://bugs.kde.org/show_bug.cgi?id=331867

Johannes Huber j...@gentoo.org changed:

   What|Removed |Added

 CC||j...@gentoo.org

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-03 Thread Johannes Huber
https://bugs.kde.org/show_bug.cgi?id=331867

Johannes Huber j...@gentoo.org changed:

   What|Removed |Added

   See Also||https://bugs.gentoo.org/sho
   ||w_bug.cgi?id=506608

--- Comment #11 from Johannes Huber j...@gentoo.org ---
Bug seems present in the final release 1.12.0.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-04-03 Thread Michael Palimaka
https://bugs.kde.org/show_bug.cgi?id=331867

Michael Palimaka kensing...@gentoo.org changed:

   What|Removed |Added

 CC||kensing...@gentoo.org

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-31 Thread Panard
https://bugs.kde.org/show_bug.cgi?id=331867

Panard pan...@inzenet.org changed:

   What|Removed |Added

 CC||pan...@inzenet.org

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-17 Thread Achim Bohnet
https://bugs.kde.org/show_bug.cgi?id=331867

Achim Bohnet a...@mpe.mpg.de changed:

   What|Removed |Added

 CC||a...@mpe.mpg.de

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-14 Thread Daniel Vrátil
https://bugs.kde.org/show_bug.cgi?id=331867

--- Comment #7 from Daniel Vrátil dvra...@redhat.com ---
If you still run the stable database (from Akonadi 1.11) that you tried to
update to 1.12, could any of you please open Akonadi Console, go to DB Console
tab and run following query:

SELECT DISTINCT(name) FROM PartTable;


and post it's output here? The problem you ran into can only happen when some
of they part names don't have NAMESPACE:NAME format, which should not happen,
but it's possible that there are some legacy names I missed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-14 Thread tbohaning
https://bugs.kde.org/show_bug.cgi?id=331867

--- Comment #8 from tbohan...@gmail.com ---
Daniel - As you requested

ATR:AddressAttribute
ATR:DispatchModeAttribute
ATR:MDNStateAttribute
ATR:ScamAttribute
ATR:SentActionAttribute
ATR:SentBehaviourAttribute
ATR:TransportAttribute
ATR:contactmetadata
ATR:pop3resourceattribute
GID
PLD:ENVELOPE
PLD:HEAD
PLD:RFC822

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-14 Thread Daniel Vrátil
https://bugs.kde.org/show_bug.cgi?id=331867

Daniel Vrátil dvra...@redhat.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |CONFIRMED
 Ever confirmed|0   |1

--- Comment #9 from Daniel Vrátil dvra...@redhat.com ---
Ha! We found the culprit. GID is not supposed to be there, it's not a part. It
looks like after an update you started KMail, but did not restart Akonadi, so
KMail was sending the GID data, but Akonadi did not know it so it though it's
a part type.

You can run following query in DB Console to get rid of it:

DELETE FROM PartTable WHERE name = 'GID';

This will fix the migration to 1.12 for you. I'll add a check to Akonadi to
prevent this from happening to others.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-14 Thread tbohaning
https://bugs.kde.org/show_bug.cgi?id=331867

--- Comment #10 from tbohan...@gmail.com ---
That took care of the akonadi issue. Thanks Daniel !!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-11 Thread tbohaning
https://bugs.kde.org/show_bug.cgi?id=331867

--- Comment #6 from tbohan...@gmail.com ---
The updated packages on 3/10 allowed Akonadi to start doing a data scan that
never finished. 
The packages released on 3.11 are back to the original issue.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-10 Thread Daniel Vrátil
https://bugs.kde.org/show_bug.cgi?id=331867

Daniel Vrátil dvra...@redhat.com changed:

   What|Removed |Added

 CC||dvra...@redhat.com
  Component|Migration   |server
Summary|Column in embedded mysqld   |mysql: column 'name' can
   |can not be null |not be null when migrating
   ||PartTable

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-10 Thread Daniel Vrátil
https://bugs.kde.org/show_bug.cgi?id=331867

Daniel Vrátil dvra...@redhat.com changed:

   What|Removed |Added

Version|unspecified |1.11.80

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs


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

2014-03-10 Thread Kevin Funk
https://bugs.kde.org/show_bug.cgi?id=331867

Kevin Funk kf...@kde.org changed:

   What|Removed |Added

 CC||kf...@kde.org

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs