Community Forums

Forum » KBPublisher General discussion

1. markg
   Member

   During upgrade install of current data from version 2.0.1 to 3.0 beta 2, I receive the following error and I am not able to proceed forward:

   SQL ERROR: 1091
   CODE: Can't DROP 'user'; check that column/key exists
   SQL:

   ALTER TABLE s_priv DROP INDEX user,
   DROP id,
   ADD PRIMARY KEY (user_id , priv_name_id);

   Posted 9 months ago #

2. onesign
   Key Master

   Strange.
   What is MySQL version?

   Check table s_priv for index "user", create it if there is no such index.
   Or you can try to edit sql file at kb/setup/db/upgrade_20_to_30.sql

   Do not forget to backup 2.0.1 database.

   Posted 9 months ago #

3. markg
   Member

   I am using MySQL version 5.0.45. I will try as you suggested. Thanks!

   Posted 9 months ago #

RSS feed for this topic

Reply

You must log in to post.