Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Article Manager 2:
2.02 MySQL database error

 
 


stag
User

Nov 18, 2006, 1:56 PM

Post #1 of 7 (1438 views)
Shortcut
2.02 MySQL database error Can't Post
I tested artman 2 on my website a few days ago and successfully upgraded everything from the previous version and moved the data to mysql database as well. Now when I am trying to do the same with version 2.02 I am getting the following error (while moving the data from flat file to mysql database)

==================
Error: Database writes are currently disabled while the database is being updated. Please wait a few minutes and try again. (107 seconds remaining on current lock) at (eval 118) line 6, <DATA> line 71.
==================

I am at my wits end in solving this bug. Can someone help?


mgdamore
User

Nov 18, 2006, 2:15 PM

Post #2 of 7 (1437 views)
Shortcut
Re: [stag] 2.02 MySQL database error [In reply to] Can't Post
Stag;

My apologies for such a simplistic question - but did you delete your previous database after 2.01 was installed?

- Mike


stag
User

Nov 18, 2006, 2:35 PM

Post #3 of 7 (1435 views)
Shortcut
Re: [mgdamore] 2.02 MySQL database error [In reply to] Can't Post
Thanks for a prompt reply Mike. I didnt delete the mysql database for version 2.0 but chose to assign a totally new mysql database for version 2.02. Also I updated to 2.02 directly from 2.0. Could that be a reason?


mgdamore
User

Nov 18, 2006, 2:49 PM

Post #4 of 7 (1431 views)
Shortcut
Re: [stag] 2.02 MySQL database error [In reply to] Can't Post
Stag;

Don't think so, unless the upgrade wasn't successful. But if your far enough along that your converting your 1.41 database - that couldn't be it. Ummm...Are you converting the flat file from 2.0 or upgrading the file directly 1.41 using the upgrade utility?

- Mike


ChetW
Staff


Nov 18, 2006, 5:52 PM

Post #5 of 7 (1424 views)
Shortcut
Re: [stag] 2.02 MySQL database error [In reply to] Can't Post
Hi,

Thanks for the post!

Mike thank you for the help we always appreciated it when the community jumps in to help out! Stag, if you would like to send us a support request with your ftp details we will be more than happy to take a closer look at this for you. :)

You can fill out a support request here:

https://www.interactivetools.com/support/email_support.cgi
Cheers,
Chet Woodside - Product Specialist
support@interactivetools.com

[hr][i][url "http://www.interactivetools.com/consulting/"][b]Hire me![/b][/url]
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with [url "http://www.interactivetools.com/consulting/"][b]Priority Consulting[/b][/url].[/i]


Dave
Staff / Moderator


Nov 18, 2006, 6:10 PM

Post #6 of 7 (1423 views)
Shortcut
Re: [stag] 2.02 MySQL database error [In reply to] Can't Post
You might also want to moving the data again and see if it works smoothly the second time.

What happens is we lock the database while moving data from one place to another to prevent anyone from updating the data. You shouldn't get that error, though, unless you're using multiple browsers or reloading the page before it's done or something like that.

If it keeps happening send in a support request and we can take a look and sort it out for you.

Dave Edis - Senior Developer
interactivetools.com
 


stag
User

Nov 19, 2006, 8:17 AM

Post #7 of 7 (1409 views)
Shortcut
Re: [Dave] 2.02 MySQL database error [In reply to] Can't Post
Thanks Dave,

I tried everything but the problem is still there. I have submitted a support ticket few moments ago. I am sure you guys will find the hitherto elusive bug!