Tickets :: Comment on [#13414] Errors during Schema-Upgrade

* Your Email Address
* Spam protection	Enter the letters below: .__.. ,.__ . .. . \| \| \./ [ __\| \|\| \| \|__\| \| [_./\|__\|\|/\\|
Comment	> 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@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@adress \| > \| 2 \| 8fYeNUlCcOxOCXmlswVXnfA \| email2@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 ? > >
Attachment
Watch this ticket