Community Forums

KBPublisher Forums » KBPublisher General discussion

1. pcsystemd
   Member

   Hello,

   I wish to make an update to version 2.1 to version 3.2, but I receive an error and I do not know what to do. I attach the picture that shows the error.

   http://pcsystemd.free.fr/images/forums/kb.PNG

   Thank you

   Posted 3 years ago #

2. onesign
   Key Master

   Looks like you do not have "user" index.
   Try to add this index to user table or update sql file at kb/setup/db/ directory.
   You need to have clean database (not affected by previous upgrade process) to start over.

   Posted 3 years ago #

3. pcsystemd
   Member

   Sorry but I do not understand what you ask me. In my table s_user I recordings.

   Thank you

   Posted 3 years ago #

4. onesign
   Key Master

   In table s_priv add index with name "user" or update sql file kb/setup/db/upgrade_20_to_30.sql
   from:
   ALTER TABLE kbp_priv DROP INDEX user,
   DROP id,
   o ADD PRIMARY KEY (user_id , priv_name_id);

   to:
   ALTER TABLE kbp_priv DROP id, ADD PRIMARY KEY (user_id , priv_name_id);

   Posted 3 years ago #

5. pcsystemd
   Member

   When update sql file kb/setup/db/upgrade_20_to_30.sql, I have this error message :

   http://pcsystemd.free.fr/images/forums/error.PNG

   Here is my current database:

   knowledgebase

   s_data_to_user_rule
   s_data_to_user_value
   s_feedback
   s_file_category
   s_file_entry
   s_file_entry_to_category
   s_kb_attachment_to_entry
   s_kb_category
   s_kb_comment
   s_kb_entry
   s_kb_entry_to_category
   s_kb_glossary
   s_kb_rating
   s_kb_related_to_entry
   s_letter_template
   s_member
   s_priv
   s_priv_module
   s_priv_name
   s_priv_rule
   s_role
   s_setting
   s_setting_input
   s_setting_to_value
   s_user

   Have you got an idea?

   Thank you for your help

   Posted 3 years ago #

6. onesign
   Key Master

   If you do it manually you have to replace kbp_ prefix to s_

   Posted 3 years ago #

RSS feed for this topic

Reply

You must log in to post.