Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Article Manager 2:
Publishing issues

 
 


TitanJeff
User

Nov 2, 2009, 7:49 AM

Post #1 of 11 (3840 views)
Shortcut
Publishing issues Can't Post
I've been having some issues publishing lately.

"The server timed out and was unable to complete publishing.
The last status message was: Publishing: SiteMap (articleList)"

The server load at the time is around 2.0 which isn't great but I've usually been able to publish eventually. The summary works but the link to the article itself is blank.

I have around 3,000 articles currently.


Donna
Staff / Moderator


Nov 2, 2009, 11:34 AM

Post #2 of 11 (3832 views)
Shortcut
Re: [TitanJeff] Publishing issues [In reply to] Can't Post
Hi Jeff!

Are you using a MySQL database or the built in flatfile database?

If you're using flatfile, I'd recommend switching up to MySQL. Flatfile works great if you have under a thousand articles, but once you start climbing higher it's a good idea to switch to a proper database.

Donna

--
support@interactivetools.com


TitanJeff
User

Nov 2, 2009, 11:48 AM

Post #3 of 11 (3831 views)
Shortcut
Re: [Donna] Publishing issues [In reply to] Can't Post
Thanks for the reply, Donna.

Under "Database Manger" in the AM admin, I see db_article. Once in there, I see "Database Type: File". So I'm thinking it is flatfile.

I went to my Cpanel and in the MySQL folder and don't see anything there referring to AM.

What would you recommend me do now?


TitanJeff
User

Nov 2, 2009, 2:40 PM

Post #4 of 11 (3824 views)
Shortcut
Re: [TitanJeff] Publishing issues [In reply to] Can't Post
I ran a search and found some info but can't get it to work. Here's what I did:

Created a new MySQL database: <name>_amdb with a new user: <name>_am.

In Admin>Database Editor, I switched to the MySQL:

Hostname: localhost
Port: blank
DB Name: <name>_amdb
User: <name>_am
Password: <password>
Table Prefix: db_ (which was what it was as a flatfile)

When I hit the continued button, I got:

Program was unable to connect to the MySQL database '<name>_amdb' on 'localhost'.
The reason given was: Access denied for user '<name>_am'@'localhost' (using password: YES)


Donna
Staff / Moderator


Nov 2, 2009, 4:40 PM

Post #5 of 11 (3815 views)
Shortcut
Re: [TitanJeff] Publishing issues [In reply to] Can't Post
Yup, definitely time to switch!

Sometimes it can take 10-15 minutes for your database to be created, depending on your provider. Try again with the details you setup when you created your database.

If that doens't work, doublecheck with your hosting provider what the correct login credentials should be and they can let you know what to switch that to. :)

Donna

--
support@interactivetools.com


TitanJeff
User

Nov 2, 2009, 7:42 PM

Post #6 of 11 (3814 views)
Shortcut
Re: [Donna] Publishing issues [In reply to] Can't Post
Got it all set up and everything seemed to be in order.

I tried to save the article again and it hung up at:
"Publishing: SiteMap (articleList)"

Then it resulted in:
"The server timed out and was unable to complete publishing.
The last status message was: Publishing: SiteMap (articleList)"

The summary shows up but the link to the article goes to a 404 error page.

I tried the same with just an article with the word "test" as the title, summary and article itself and the same thing happened.


Donna
Staff / Moderator


Nov 3, 2009, 1:43 PM

Post #7 of 11 (3804 views)
Shortcut
Re: [TitanJeff] Publishing issues [In reply to] Can't Post
Hmm, definitely odd. Are you able to publish your sitemap publish rule independently (ie, through the Admin -> Publishing menu.)

I think regardless of the answer, we should probably move this to a support request so I can take a look at it directly. You can fill this out here:

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

Donna

--
support@interactivetools.com


TitanJeff
User

Nov 3, 2009, 1:54 PM

Post #8 of 11 (3802 views)
Shortcut
Re: [Donna] Publishing issues [In reply to] Can't Post
I just tried to publish again and it worked. It took a while but it happened.

I noticed my server load was light at the time which may have something to do with it or I needed to wait longer after transferring everything to MySQL.

Either way, I'm good and thanks again for your help.


TitanJeff
User

Nov 9, 2009, 5:03 AM

Post #9 of 11 (3747 views)
Shortcut
Re: [TitanJeff] Publishing issues [In reply to] Can't Post
To follow up, I'm having the same problems again.

"The server timed out and was unable to complete publishing.
The last status message was: Publishing: SiteMap (articleList)"

My server load was under .80 at the time.

Any suggestions?


Donna
Staff / Moderator


Nov 9, 2009, 3:41 PM

Post #10 of 11 (3744 views)
Shortcut
Re: [TitanJeff] Publishing issues [In reply to] Can't Post
Hi Jeff,

Would you be able to fill out a support request? You can do so here:

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

Donna

--
support@interactivetools.com


TitanJeff
User

Nov 10, 2009, 4:29 AM

Post #11 of 11 (3734 views)
Shortcut
Re: [Donna] Publishing issues [In reply to] Can't Post
Will do. Thanks.