Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Article Manager 2:
SQL migration problem

 
 


dougthompson
User

Nov 6, 2006, 9:21 AM

Post #1 of 10 (1405 views)
Shortcut
SQL migration problem Can't Post
Started the conversion program to move one of our flatfile databases to MySQL. It hit a glitch right away with this error message:

Error: DBD::mysql::st execute failed: Out of range value adjusted for column 'createdByUserNum' at row 1 at (eval 156) line 18, <DATA> line 643.

Using MySQL 5.1.11 on a Windows 2003 Server. Also running a Movable Type installation on this MYSql server with no problem.

Is there a config I need to tweak when created a new database for AM?

Thanks.


dougthompson
User

Nov 6, 2006, 9:42 AM

Post #2 of 10 (1404 views)
Shortcut
Re: [dougthompson] SQL migration problem [In reply to] Can't Post
Managed to get by that error by removing an old user from the file. Then it hit this problem:

Error: DBD::mysql::st execute failed: Out of range value adjusted for column 'archiveNum' at row 1 at (eval 184) line 18, <DATA> line 719.

Suggestions?

Thanks.


Dave
Staff / Moderator


Nov 7, 2006, 3:52 PM

Post #3 of 10 (1387 views)
Shortcut
Re: [dougthompson] SQL migration problem [In reply to] Can't Post
That's an odd one. It sounds like it's something to do with some malformed archive data in that's being imported that doesn't fit in the mysql field. We could take a look at that if you like. Here's a link to the support form:

https://www.interactivetools.com/support/email_support.cgi

Dave Edis - Senior Developer
interactivetools.com
 


dougthompson
User

Nov 9, 2006, 7:21 AM

Post #4 of 10 (1374 views)
Shortcut
Re: [Dave] SQL migration problem [In reply to] Can't Post
Dave:

Thanks for the feedback. We had a number of archives in our old flat-file database under 1.41. When we upgraded to 2.0 it coverted the archives back to active database entries but the archive field and archive number remained part of the new flatfile database. After several failures and hangups on the archive data field, I eliminated that field from the flatfile and it started importing the articles.

Then we got the same error when it tried to import the catefory db table. We had 37 categories (including seven with no data in them) so I trimmed the fields down to 30 and tried again. Same result. When I get a chance, I'm going to go through each category listing and look for data problems. If that doesn't work, I'll fill out a support form. First I want to see if I can work it out here.

I'm hoping we can get it sorted out because we may have to abandon AM if it doesn't work. Our database is far too big to work as a flatfile. As I noted in another post, we also use Movable Type for our onsite blog and I've been using it for news stories as well since we ran into the conversion problem with AM. We have more than 10,000 articles and 50,000 comments running in the MT MySQL database without a hitch. We just updated to MT's Enterprise edition and it is both fast and stable. I still prefer the AM interface and its features but I need the speed of a database interface.

Doug


WebFusion
User

Nov 9, 2006, 8:20 AM

Post #5 of 10 (1371 views)
Shortcut
Re: [dougthompson] SQL migration problem [In reply to] Can't Post
Man....this has me "really" excited about upgrading now.....I hope they fix these bugs soon, as I have over a dozen AM installations.

...of course, since I paid for one upgrade 3 days ago, and am still waiting for it to get done (hint-hint), perhaps they are working on a fix, as opposed to installing the upgrades.


Dave
Staff / Moderator


Nov 9, 2006, 12:57 PM

Post #6 of 10 (1360 views)
Shortcut
Re: [dougthompson] SQL migration problem [In reply to] Can't Post
Doug, give it a try and if you're still having troubles fill out a support request form. One way or another we'll get it working for you.

Dave Edis - Senior Developer
interactivetools.com
 


Dave
Staff / Moderator


Nov 9, 2006, 1:04 PM

Post #7 of 10 (1358 views)
Shortcut
Re: [WebFusion] SQL migration problem [In reply to] Can't Post
WebFusion, Most upgrades are pretty seamless. I've only seen one or two with invalid data issues. I'll ask about your upgrade, see what the delay was and ask them to follow up with you.

Dave Edis - Senior Developer
interactivetools.com
 


WebFusion
User

Nov 9, 2006, 1:54 PM

Post #8 of 10 (1349 views)
Shortcut
Re: [Dave] SQL migration problem [In reply to] Can't Post
Thanks Dave. Ross was working on the upgrade (it's for a site that's still under construction...so there are only a handful of test articles in teh database - less than 10).

I had to resubmit my info yesterday, and also sent it to ross via email, but still nothing.


Dave
Staff / Moderator


Nov 9, 2006, 2:58 PM

Post #9 of 10 (1344 views)
Shortcut
Re: [WebFusion] SQL migration problem [In reply to] Can't Post
Thanks for letting us know. I think we've been having spam filter problems and it was getting caught in the spam filter. Sorry about that.

Dave Edis - Senior Developer
interactivetools.com
 


dougthompson
User

Nov 9, 2006, 4:14 PM

Post #10 of 10 (1340 views)
Shortcut
Re: [Dave] SQL migration problem [In reply to] Can't Post
Success! Finally tracked the last error down to the category db. For some reason, any update to the categories was leaving out a zero in the lock column in one of the entries (the category was not locked). I inserted the zero manually, replaced the db_category.dat.cgi file and tried the coversion again. Everything worked smoothly. Just uploaded an article and the publish time is much, much faster.

I think our system was prone to problems because of the age. We've been using AM since the first version and our database probably had a lot of extraneous material in it. Just took some careful pruning of the old flatfile db files to get it working.

Thanks for the feedback from Dave and others. We're back in business.

Now, if you folks would just add a comments feature so I didn't have to maintain a blog CMS system for that and a separate AM CMS for articles. Wink

Doug