http://kbpublisher.com/forums/ KBPublisher Forums » Topic: Error upgrade 2.1 to 3.2. en Thu, 09 Feb 2012 16:37:28 +0000 http://kbpublisher.com/forums/topic.php?id=9#post-43 Sat, 22 Mar 2008 16:51:40 +0000 onesign 43@http://kbpublisher.com/forums/ <p>If you do it manually you have to replace kbp_ prefix to s_ </p> http://kbpublisher.com/forums/topic.php?id=9#post-38 Fri, 21 Mar 2008 14:37:46 +0000 pcsystemd 38@http://kbpublisher.com/forums/ <p>When update sql file kb/setup/db/upgrade_20_to_30.sql, I have this error message :</p> <p><a href="http://pcsystemd.free.fr/images/forums/error.PNG" rel="nofollow">http://pcsystemd.free.fr/images/forums/error.PNG</a> </p> <p>Here is my current database:</p> <p>knowledgebase </p> <p> s_data_to_user_rule<br /> s_data_to_user_value<br /> s_feedback<br /> s_file_category<br /> s_file_entry<br /> s_file_entry_to_category<br /> s_kb_attachment_to_entry<br /> s_kb_category<br /> s_kb_comment<br /> s_kb_entry<br /> s_kb_entry_to_category<br /> s_kb_glossary<br /> s_kb_rating<br /> s_kb_related_to_entry<br /> s_letter_template<br /> s_member<br /> s_priv<br /> s_priv_module<br /> s_priv_name<br /> s_priv_rule<br /> s_role<br /> s_setting<br /> s_setting_input<br /> s_setting_to_value<br /> s_user</p> <p>Have you got an idea? </p> <p>Thank you for your help </p> http://kbpublisher.com/forums/topic.php?id=9#post-35 Fri, 21 Mar 2008 12:56:05 +0000 onesign 35@http://kbpublisher.com/forums/ <p>In table s_priv add index with name "user" or update sql file kb/setup/db/upgrade_20_to_30.sql<br /> from:<br /> ALTER TABLE <code>kbp_priv</code> DROP INDEX <code>user</code>,<br /> DROP <code>id</code>,<br /> o ADD PRIMARY KEY (<code>user_id</code> , <code>priv_name_id</code>);</p> <p>to:<br /> ALTER TABLE <code>kbp_priv</code> DROP <code>id</code>, ADD PRIMARY KEY (<code>user_id</code> , <code>priv_name_id</code>); </p> http://kbpublisher.com/forums/topic.php?id=9#post-32 Fri, 21 Mar 2008 12:25:29 +0000 pcsystemd 32@http://kbpublisher.com/forums/ <p>Sorry but I do not understand what you ask me. In my table s_user I recordings. </p> <p>Thank you </p> http://kbpublisher.com/forums/topic.php?id=9#post-31 Fri, 21 Mar 2008 11:23:26 +0000 onesign 31@http://kbpublisher.com/forums/ <p>Looks like you do not have "user" index.<br /> Try to add this index to user table or update sql file at kb/setup/db/ directory.<br /> You need to have clean database (not affected by previous upgrade process) to start over. </p> http://kbpublisher.com/forums/topic.php?id=9#post-30 Fri, 21 Mar 2008 09:31:15 +0000 pcsystemd 30@http://kbpublisher.com/forums/ <p>Hello, </p> <p>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. </p> <p><a href="http://pcsystemd.free.fr/images/forums/kb.PNG" rel="nofollow">http://pcsystemd.free.fr/images/forums/kb.PNG</a> </p> <p>Thank you </p>