Version: 1.5.0 (using KDE 4.5.2)
I cannot add any tag. This action always ended with error - "Failed to add tag to database". I use MySQL database to store relevant data.
Steps to Reproduce:
add new tag
error has occured
new tag is added
Version of MySQL server is 5.0.51a-24+lenny4. "Tags" and "Tags Tree" tables are empty.
@bug_id = 257183
@bug_status = RESOLVED
@resolution = FIXED
Git commit ec7ceeea0d2587abb9f1bdd17109d4903998e943 by Francesco Riosa.
Committed on 09/05/2011 at 14:20.
Pushed by riosa into branch 'master'.
more resilient database upgrade and startup
All statements are made resilient to a partially upgraded database.
- CREATE TABLE are done with IF NOT EXISTS
- TRIGGERs are dropped and re-created
- a new stored procedure is added "create_index_if_not_exists"
the procedure check in information_schema if the index exists,
if not does create it
- all INDEXes are created using "create_index_if_not_exists"
M +90 -56 data/database/dbconfig.xml.cmake