 |
DefenceTalk.com
User
Oct 20, 2006, 11:55 AM
Post #1 of 10
(578 views)
Shortcut
|
|
error during upgrade..what to do?
|
Can't Post
|
|
Getting this error during upgrade from 1.41 to 2.0
Error: no year specified! at (eval 224) line 2.
thanks
|
|
| |
|
Dave
Staff
/ Moderator
Oct 20, 2006, 12:10 PM
Post #2 of 10
(573 views)
Shortcut
|
|
Re: [DefenceTalk.com] error during upgrade..what to do?
[In reply to]
|
Can't Post
|
|
Do you know what stage that's coming from?
Is it when it's importing users, categories, articles, archives?
My guess is one of the records doesn't have a year specified somehow and the upgrade script doesn't know what to do with it so it's stopping.
If you could find out which record it was, and add a year, that would probably fix it. Failing that we can get in there and have a look for you if you want to fill out the support form:
https://www.interactivetools.com/support/email_support.cgi
Dave Edis - Senior Developer
interactivetools.com
(This post was edited by Theo on Oct 20, 2006, 12:11 PM)
|
|
| |
|
DefenceTalk.com
User
Oct 20, 2006, 12:14 PM
Post #3 of 10
(569 views)
Shortcut
|
|
Re: [Dave] error during upgrade..what to do?
[In reply to]
|
Can't Post
|
|
I fixed that error... dummy articles with no category, etc. info. Deleted them and fixed the issue.
Now, getting this:
Error: invalid insert: manual sequencing - 1 of the insert records have sequence numbers that already exist in database! at (eval 157) line 43.
:(
|
|
| |
|
Dave
Staff
/ Moderator
Oct 20, 2006, 12:52 PM
Post #4 of 10
(561 views)
Shortcut
|
|
Re: [DefenceTalk.com] error during upgrade..what to do?
[In reply to]
|
Can't Post
|
|
Are you starting the upgrade process from the beginning or just reloading the last page?
The upgrade script should clear out all the articles in the 2.00 database and then import into a clean empty database.
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
DefenceTalk.com
User
Oct 20, 2006, 5:32 PM
Post #5 of 10
(548 views)
Shortcut
|
|
Re: [Dave] error during upgrade..what to do?
[In reply to]
|
Can't Post
|
|
Well... it stops when the page doesn't auto reload. And often times it times out while record is being imported and it gives error saying record is already in the system. I press "start over" and directory info is already in there so press next, next again and it starts where it left off but sometimes it starts from the last point where the error occured and that gives error saying it is already in there...
thanks
|
|
| |
|
DefenceTalk.com
User
Oct 20, 2006, 9:59 PM
Post #6 of 10
(528 views)
Shortcut
|
|
Re: [DefenceTalk.com] error during upgrade..what to do?
[In reply to]
|
Can't Post
|
|
Well, I fixed the issue by setting the timeout to 1 second...
Now, another problem.
I just edited a category and clicked "saved" and it went on to republish everything over again. I plan on editing few more categories... anyway to not publish everytime category is saved/edited? I can't sit through 8500+ records being republished each time a category is edited. 
I don't like the fact that publishing and republishing the articles(after they are re-edited) issue is still there... what is the use of mysql and more so if perl is still there?
(This post was edited by DefenceTalk.com on Oct 20, 2006, 10:07 PM)
|
|
| |
|
Dave
Staff
/ Moderator
Oct 20, 2006, 10:10 PM
Post #7 of 10
(524 views)
Shortcut
|
|
Re: [DefenceTalk.com] error during upgrade..what to do?
[In reply to]
|
Can't Post
|
|
The first time you save _anything_ after upgrading it will publish everything. Next time you save a category it should only publish files that need to be updated, that would be the category files and any articles in those categories (since they might use category placeholders).
You can skip all that, however, by just clicking back or stop or anything else once it starts publishing and editing another category. It will remember what needs to be published and publish it next time. It doesn't turn off the "needsPublish" flag until publishing is complete.
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
DefenceTalk.com
User
Oct 20, 2006, 10:19 PM
Post #8 of 10
(523 views)
Shortcut
|
|
Re: [Dave] error during upgrade..what to do?
[In reply to]
|
Can't Post
|
|
Well.. i just opened the same category that i edited earlier and without editing anything again clicked on save and it went through republishing everything plus the 8,500 articles.
|
|
| |
|
Dave
Staff
/ Moderator
Oct 23, 2006, 2:22 PM
Post #9 of 10
(489 views)
Shortcut
|
|
Re: [DefenceTalk.com] error during upgrade..what to do?
[In reply to]
|
Can't Post
|
|
DefenceTalk,
Just wanted to check in to see if you were still having the problem or the CPU usage issues. If so let me know any we can take a look at your server and get it resolved.
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
DefenceTalk.com
User
Oct 24, 2006, 2:18 PM
Post #10 of 10
(471 views)
Shortcut
|
|
Re: [Dave] error during upgrade..what to do?
[In reply to]
|
Can't Post
|
|
Hey Dave,
Thanks. I will give another try and see if upgrade goes through smoothly... which it did last time but I guess too much customization messed up the show.
|
|
| |
|
