[Tickets #13414] Errors during Schema-Upgrade

[noreply at bugs.horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/13414
------------------------------------------------------------------------------
  Ticket           | 13414
  Erstellt Von     | nschmidt at df.eu
  Zusammenfassung  | Errors during Schema-Upgrade
  Warteschlange    | Turba
  Version          | 4.2.0
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 1. Low
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


nschmidt at df.eu (2014-08-04 14:07) hat geschrieben:

I want to upgrade Horde to latest version, during upgrade vom sql  
database schema for turba i see (via horde debug log) many many sql  
calls like this

[horde] SQL  (0.0006s)    SELECT * FROM turba_sharesng WHERE  
share_name =           'EMAIL at ADDRESS' [pid 26086 on line 208 of  
"/var/www/html/live/horde/pear/lib/php/Horde/Db/Adapter/Pdo/Base.php"]

but the problem is, i got errors because of duplicate entry. so i had  
to dig this down, and i found that this upgradequery seems to be false ?

table "turba_sharesng" looks like this

select share_id,share_name,share_owner from turba_sharesng;

+----------+-------------------------+------------------+
| share_id | share_name              | share_owner      |
+----------+-------------------------+------------------+
|     1 | u9OhbsL8999OCXSF3OHCC2A | email at adress |
|     2 | 8fYeNUlCcOxOCXmlswVXnfA | email2 at adresse |
+----------+-------------------------+------------------+

so the right query seems to be "SELECT * FROM turba_sharesng WHERE  
share_owner...", because ob share_name only has a hash stored and not  
emailaddresses ?