Home | Products | Consulting | Forums | Support | Order | 1-800-752-0455
  Main
Index
Search
Posts
Who's
Online
Log
In

Home: Products: Article Manager 2:
2.02 MySQL database error

 

 


stag
User

Nov 18, 2006, 1:56 PM

Post #1 of 7 (574 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 (573 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 (571 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 (567 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 (560 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


Hire me!
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 Priority Consulting.



Dave
Staff / Moderator


Nov 18, 2006, 6:10 PM

Post #6 of 7 (559 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 (545 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!

 
 
 


Search for (options)
Products
CMS Builder
Article Manager
Realty Manager
Listings Manager
Order Now
Services
Priority Consulting
Support
Online Documentation
Support Forums
Support Homepage
Company Info
12 reasons to choose us!
Meet the team
Monthly newsletter
Contact Us
Toll Free: 1-800-752-0455
Phone: (604) 689-3347
Sales | Support
Conditions of Use | Privacy Policy | Copyright © interactivetools.com 2008
#201 - 2730 Commercial Drive, Vancouver BC Canada V5N 5P4