[ php-blog-Bugs-1526398 ] Upgrade needs extra privileges f??r Indexes

Bugs item #1526398, was opened at 2006-07-21 10:51
Message generated for change (Comment added) made by garvinhicking
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1526398&group_id=75065

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Installer/Upgrader
Group: None
>Status: Closed
>Resolution: Invalid
>Priority: 1
Submitted By: Nobody/Anonymous (nobody)
>Assigned to: Garvin Hicking (garvinhicking)
Summary: Upgrade needs extra privileges für Indexes

Initial Comment:
I just upgraded s9y from 0.8.4 to 1.0, and had the
following problem:

A confixx-administered user had no privilege to use
CREATE INDEX on a mysql database. Rephrasing the failed
queries to ALTER TABLE ... ADD INDEX was possible and
worked fine.

While this may not be a bug, i think these set-ups are
common enough to alter the update scripts so that even
without the index privilege, the update works.

----------------------------------------------------------------------

>Comment By: Garvin Hicking (garvinhicking)
Date: 2006-07-24 07:15

Message:
Logged In: YES 
user_id=473563

Yes, Serendipity needs the "CREATE INDEX" privileges, this
is also mentioned in the Upgrade-FAQ on www.s9y.org.

We need this to be portable to other Databases.

If your provider does not give you the "INDEX" privilege,
this is considered a setup bug of your provider, and you
should kindly ask him to change that. Giving a user "CREATE"
but not "INDEX" privileges in MySQL is a very weird setup. ;-)

Thank you for reporting this though, maybe it is of help for
future users - but I really suggest to fix a buggy setup
instead to accomodate our installer to those buggy setups,
and rather keep our upgrade routines lean and clean :)

Best regards,
Garvin

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1526398&group_id=75065

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV