Upgrade from v2 to v3 errors

eMax · 02:05 PM

During the upgrade I received a few errors (the refresh moved to fast to see them) but then it just stopped with this error:

Quote:

Importing: Knowledgebase (Page 4 of 4)
Unable to Import Comment, Found a bogus KB Article: 135

Any idea? As far as it looks the upgrade did not finish properly.

edit: KB Article: 135 does not exist in my current eSupport v2.3.5

eMax · 28-07-2005, 02:04 PM

Another issue with the upgrade is all articles are marked as being added "28 Jul 2005". Can't the true dates be transfered also?

***Varun Shoor*** · 28-07-2005, 09:04 PM

Try the following query to lookup the KB article:

SELECT * FROM asFaqQuestions WHERE id = '135';

The date not being transferred seems like a bug, Can you submit a bug report for this at http://bugs.kayako.net ?

Regards,

Varun Shoor

eMax · 28-07-2005, 09:12 PM

Varun,

KB Article doesn't exist as I said in my edited section of the first post. So what this tells me is any KB articles that were removed will end up kill the upgrade script. That was only #135. I have over 500 in mine. I'll replace the article with something to fill the spot and do a full upgrade again.

Sending bug in now.

***Varun Shoor*** · 28-07-2005, 09:19 PM

Thanks for the update, Please mark the bug as Critical.

Regards,

Varun Shoor

eMax · 28-07-2005, 09:24 PM

http://bugs.kayako.net/index.php?do=details&id=516

nine · 09-08-2005, 06:01 PM

Not sure if you remedied this bogus kb upgrade issue. I had the same issue. Looks like if the id field is not in sequence this error occurs. I resolved by changing the id of the last record to the missing id and again running the import.

eMax · 09-08-2005, 06:14 PM

Problem is I have many missing so that will take some time.

Thanks for the headsup fix tho.

eMax · 09-08-2005, 07:07 PM

Well that didn't work for me...

http://emaxhosting.com/support1/index.php

Even after fixing missing ID on 5 articles and did the installation and upgrade 3 times the completed install still shows all articles to be started for todays date.

***Varun Shoor*** · 13-08-2005, 08:59 AM

You had set the Priority to Low when I asked you to mark it as Critical, I have changed the Priority now. It will be resolved in the next bug fix build.

Regards,

Varun Shoor

eMax · 13-08-2005, 12:41 PM

I had actually submitted the bug before you told me to mark it critical.

Regardless thank you.

**bear** · 11:15 PM

Just for the record, this bug (fails on bad cat id) still exists, in the .32 build. I just tried impex to bring in my KB and it failed with a similar error. Fixed with a hand edit to alter parentid 3 to a valid one.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Upgrade errors?	camers	Installation & Upgrading	3	15-07-2006 01:55 PM
Upgrading and Rolling back an upgrade	Darren	Installation & Upgrading	1	13-06-2006 05:02 PM

eMax Offline Member Posts: 63 Join Date: Nov 2003	28-07-2005, 02:04 PM Another issue with the upgrade is all articles are marked as being added "28 Jul 2005". Can't the true dates be transfered also?

eMax Offline Member Posts: 63 Join Date: Nov 2003	28-07-2005, 09:12 PM Varun, KB Article doesn't exist as I said in my edited section of the first post. So what this tells me is any KB articles that were removed will end up kill the upgrade script. That was only #135. I have over 500 in mine. I'll replace the article with something to fill the spot and do a full upgrade again. Sending bug in now.

eMax Offline Member Posts: 63 Join Date: Nov 2003	28-07-2005, 09:24 PM http://bugs.kayako.net/index.php?do=details&id=516

nine Offline New Member Posts: 16 Join Date: Jan 2004	09-08-2005, 06:01 PM Not sure if you remedied this bogus kb upgrade issue. I had the same issue. Looks like if the id field is not in sequence this error occurs. I resolved by changing the id of the last record to the missing id and again running the import.

eMax Offline Member Posts: 63 Join Date: Nov 2003	09-08-2005, 06:14 PM Problem is I have many missing so that will take some time. Thanks for the headsup fix tho.

eMax Offline Member Posts: 63 Join Date: Nov 2003	09-08-2005, 07:07 PM Well that didn't work for me... http://emaxhosting.com/support1/index.php Even after fixing missing ID on 5 articles and did the installation and upgrade 3 times the completed install still shows all articles to be started for todays date.

eMax Offline Member Posts: 63 Join Date: Nov 2003	13-08-2005, 12:41 PM I had actually submitted the bug before you told me to mark it critical. Regardless thank you.

bear Offline Community Moderator Posts: 677 Join Date: Jan 2005	20-03-2006, 10:10 PM Just for the record, this bug (fails on bad cat id) still exists, in the .32 build. I just tried impex to bring in my KB and it failed with a similar error. Fixed with a hand edit to alter parentid 3 to a valid one. Last edited by bear; 20-03-2006 at 11:15 PM.