[Owncloud] Core db schema broken and unfixable without new installation

Bernhard Posselt nukeawhale at gmail.com
Mon Mar 18 16:15:14 UTC 2013


In response to this issue: https://github.com/owncloud/core/issues/2142


There are currently no primary keys in the schema. A typical primary key 
field would look like this:

             <field>
                 <name>id</name>
                 <type>integer</type>
                 <default>0</default>
                 <notnull>true</notnull>
                 <primary>true</primary>
                 <unsigned>true</unsigned>
                 <autoincrement>true</autoincrement>
             </field>

Unfortunately there is not a single field like this which makes database 
replication (important business customer feature!) virtually impossible.

I've tried adding those fields and removing the primary key values from 
the indices fields (why the fuck are they even in there!?) with the 
result that owncloud broke and im now in maintenance mode and cant get 
out of it (503 responses from server) and i cant get out by removing the 
maintenance mode.


Ideas on how to fix this?



More information about the Owncloud mailing list