Rss Bloggers: Anyone ever see this database error using AutoBloggerPro? - GoFuckYourself.com

Nismo · 12-27-2006, 01:09 PM

I just installed ABP on some blogs that were dead and when I went to the Feeds tab in ABP, I see this error, and obviously ABP doesnt work now.

Quote:

WordPress database error: [Unknown column 'link_activehidden' in 'where clause']
SELECT * FROM wp_links WHERE link_visible = 'Y' AND link_activehidden = 'n' AND is_RSS = 'Y'

uno · 12-27-2006, 01:51 PM

I haven't seen that one, but did you submit a support ticket?

Also, did you reinstall the program to update the database?

Nismo · 12-27-2006, 02:33 PM

Yes, I submitted a ticket and talked with someone from ABP. They didn't seem to care much to help me since Im using the older version of ABP.

And no, I didn't re-install anything. It was a fresh install.

Nismo · 12-27-2006, 05:23 PM

bump for help.

edgeprod · 12-27-2006, 05:28 PM

Looks like the WordPress update changes the way tables are handled.

I don't see a ticket in there right now, but thanks for the "they didn't seem to care much to help me" comment.

edgeprod · 12-27-2006, 05:32 PM

Quote:

Originally Posted by uno

I haven't seen that one, but did you submit a support ticket?

Also, did you reinstall the program to update the database?

You probably didn't try to update WordPress independently of Autoblogger Pro. I wouldn't recommend doing that in any event, because A) Autoblogger Pro is NOT designed to be updated without an official release, B) The latest STABLE version WordPress is the version that the old Autoblogger ships with. We don't sell it any longer, and it can only be downloaded by users who own the old Autoblogger.

Hope this helps you to not run into DB issues.

Nismo · 12-27-2006, 05:33 PM

Quote:

Originally Posted by edgeprod

Looks like the WordPress update changes the way tables are handled.

I don't see a ticket in there right now, but thanks for the "they didn't seem to care much to help me" comment.

YOU were helpful (actually very helpful), however, i haven't seen you on IRC in weeks

I sent a ticket a couple of weeks ago and wasn't offered much help since im not using the new stand alone version.

OzMan · 12-27-2006, 05:33 PM

Quote:

Originally Posted by edgeprod

...thanks for the "they didn't seem to care much to help me" comment.

That really makes you want to go the extra mile to help him doesn't it.

Nismo · 12-27-2006, 05:33 PM

Quote:

Originally Posted by edgeprod

Looks like the WordPress update changes the way tables are handled.

Is there any thing I can do to correct this or am I SOL?

Nismo · 12-27-2006, 05:38 PM

Quote:

Originally Posted by edgeprod

You probably didn't try to update WordPress independently of Autoblogger Pro. I wouldn't recommend doing that in any event, because A) Autoblogger Pro is NOT designed to be updated without an official release, B) The latest STABLE version WordPress is the version that the old Autoblogger ships with. We don't sell it any longer, and it can only be downloaded by users who own the old Autoblogger.

Hope this helps you to not run into DB issues.

I had to update WordPress in order to login. That's where things get fuzzy and the issue started.

edgeprod · 12-27-2006, 05:39 PM

Quote:

Originally Posted by OzMan

That really makes you want to go the extra mile to help him doesn't it.

If you saw HALF the abuse I take from people who have broken their own installation, posted on GFY instead of making a ticket, contacted my personal ICQ (or called) to demand that their ticket is answered within 2 minutes of submitting it, etc ... you'd fall over.

I just had a guy -- literally -- pick up his database, move it to another server, and forget to update his paths, etc. He yelled at me in a ticket, said the software was shit, etc, etc .. then, when I noticed it was user error in migrating it to a new server/directory without updating it .. he just went AWAY and never responded.

So, believe me when I say I've got a thick skin, and will help Nismo with his problem, no matter what -- our customers are VERY important to us, and we'll be abused a bit from time to time to make sure everyone is happy.

edgeprod · 12-27-2006, 05:40 PM

Quote:

Originally Posted by Nismo

Is there any thing I can do to correct this or am I SOL?

The old Autoblogger Pro *cannot* be used with the new WordPress. What version did you upgrade to, and what method did you use? We *might* be able to reverse it. If not, we can perhaps re-install ABP, not run any upgrades, and migrate the post database to "salvage" it.

Alternatively, I can pull your feed with my new version of ABP, and re-post it to your blog (the new one posts OUT, not pulls IN).

mattz · 12-27-2006, 05:41 PM

whenever i get errors i just reinstall

if its wordpress your talking about just deleate all wordpress file except wp-config.php and reupload all the files and everything will be back to normal

just dont overwrite the wp-config.php file

Nismo · 12-27-2006, 05:43 PM

I apologize if I came off as an asshole, but im just frustrated as you can imagine. I've been working on this issue for about 2-3 weeks now to no avail.

I've worked customer service before and I know, firsthand, it sucks. HEH

edgeprod · 12-27-2006, 05:43 PM

Quote:

Originally Posted by Nismo

YOU were helpful (actually very helpful), however, i haven't seen you on IRC in weeks

Well, thanks, I try.

I don't know if you saw Chio's thread, but I had a complete PC failure. I am using a "backup" PC until my main one is salvaged or replaced. My backup PC didn't even have an IRC client until yesterday, so ... you are unlikely to see me there much. I withdrew our SlashNET application in the meantime, as well.

Nismo · 12-27-2006, 05:44 PM

Quote:

Originally Posted by edgeprod

The old Autoblogger Pro *cannot* be used with the new WordPress. What version did you upgrade to, and what method did you use? We *might* be able to reverse it. If not, we can perhaps re-install ABP, not run any upgrades, and migrate the post database to "salvage" it.

Alternatively, I can pull your feed with my new version of ABP, and re-post it to your blog (the new one posts OUT, not pulls IN).

Can I just hit you up on ICQ?

edgeprod · 12-27-2006, 05:46 PM

Quote:

Originally Posted by Nismo

I apologize if I came off as an asshole

You didn't, but you have to understand: when someone sees a thread like this (instead of someone ICQ'ing me or Chio to get it straightened out), it looks like shit for us. We bend of backwards for our users, and there have been multiple threads applauding our service -- I think it's some of the best in the industry for a small company, personally, since I spend HOURS on even user-created problems, which is MUCH more than most companies would feel $299 entitles you to. Heck, we still support the OLD Autoblogger, even though the technology has moved WELL beyond it.

Quote:

Originally Posted by Nismo

, but im just frustrated as you can imagine. I've been working on this issue for about 2-3 weeks now to no avail.

I've worked customer service before and I know, firsthand, it sucks. HEH

We'll get it solved one way or another, then. WP asks you to upgrade, but it's not usually a good idea with the old Autoblogger. Because ABPSA (the new one) is unattached from WP, it would fine with the new one.

The guy who developed the old one is no longer with the company, and it puts a dampner on future development in that line of the product.

edgeprod · 12-27-2006, 05:47 PM

Quote:

Originally Posted by Nismo

Can I just hit you up on ICQ?

Of course. Most people end up using my personal ICQ as a support interface anyway ...

But I'm here, feel free.

Young · 12-27-2006, 06:16 PM

rss blogger = oxy moron

edgeprod · 12-27-2006, 06:33 PM

Quote:

Originally Posted by Young

rss blogger = oxy moron

And yet ..

traffic++;

So, as usual: *yawn*

Cory W · 12-27-2006, 06:41 PM

Edgepro is one of the most helpful people in the business.

edgeprod · 12-27-2006, 06:44 PM

Quote:

Originally Posted by WEG Cory

Edgepro is one of the most helpful people in the business.

Between him and his brother Edgeprod, they rock!

Haha, thanks Cory.

More Booze · 12-28-2006, 04:08 AM

No, but I have another problem with ABP. I got 3 blogs on the same server as ABP. ABP can post to one of them. But it says "Connect error: No route to host (113)" for the other two.

Anyone know what to do?

tenderobject · 12-28-2006, 04:14 AM

Quote:

Originally Posted by edgeprod

If you saw HALF the abuse I take from people who have broken their own installation, posted on GFY instead of making a ticket, contacted my personal ICQ (or called) to demand that their ticket is answered within 2 minutes of submitting it, etc ... you'd fall over.

I just had a guy -- literally -- pick up his database, move it to another server, and forget to update his paths, etc. He yelled at me in a ticket, said the software was shit, etc, etc .. then, when I noticed it was user error in migrating it to a new server/directory without updating it .. he just went AWAY and never responded.

So, believe me when I say I've got a thick skin, and will help Nismo with his problem, no matter what -- our customers are VERY important to us, and we'll be abused a bit from time to time to make sure everyone is happy.

lol that guy is harsh he can throw me his copy of your script man.. when will you have a promo for ABP stand alone?

Mike Semen · 12-28-2006, 04:53 AM

Quote:

Originally Posted by edgeprod

If you saw HALF the abuse I take from people who have broken their own installation, posted on GFY instead of making a ticket, contacted my personal ICQ (or called) to demand that their ticket is answered within 2 minutes of submitting it, etc ... you'd fall over.

So, believe me when I say I've got a thick skin, and will help Nismo with his problem, no matter what -- our customers are VERY important to us, and we'll be abused a bit from time to time to make sure everyone is happy.

That's pretty much the nature of software support right there bro.

edgeprod · 12-28-2006, 07:30 AM

Quote:

Originally Posted by More Booze

No, but I have another problem with ABP. I got 3 blogs on the same server as ABP. ABP can post to one of them. But it says "Connect error: No route to host (113)" for the other two.

Anyone know what to do?

That sounds very odd, like a network routing problem. Autoblogger *itself* has no such error, so I'm guessing network connectivity, or the configuration of the network itself. Who's the host? What's the environment like, generally?

Where does it SPECIFICALLY give you the error? During step 3 (posting)? Can you submit a ticket with a screenshot? It'd be interesting to take a peek.

Also, we should try posting to those blogs from *my* copy of ABPSA, so that we know Autoblogger works fine, and we can narrow it down to a problem with one of the blogs (this is usually the case).

You should *never* get a bad route to the *same* box, but I'm sure you know that.

Quote:

Originally Posted by tenderobject

lol that guy is harsh he can throw me his copy of your script man.. when will you have a promo for ABP stand alone?

Yeah, well. To each his own. ABPSA is $249 right now for the holidays.

Quote:

Originally Posted by Mike Semen

That's pretty much the nature of software support right there bro.

Agreed, but I want our users to be taken care of, so I'm willing to be a punching bag from time to time. We give a LOT of support for a $299 purchase, which usually extends to helping people fix server misconfiguration by their hosts. You'd be amazed how many "problems" go away when a server is set up correctly .. or maybe you wouldn't be.

edgeprod · 12-28-2006, 07:31 AM

Also, as a follow-up, do you get *any* error message for the blog is has no problems with? And they're all WordPress, same version, right?

More Booze · 12-28-2006, 11:52 AM

Quote:

Originally Posted by edgeprod

Also, as a follow-up, do you get *any* error message for the blog is has no problems with? And they're all WordPress, same version, right?

Hi, I just did open a support ticket. You'll find screenshots from "Step 3" and login-info to one of the blogs so you can try to post to it.

They're all Wordpress Blogs. One of the blogs did still run WP 2.0.4. I did upgrade to 2.0.5 but I still get the same error.

Nismo · 12-28-2006, 12:23 PM

Edge, are you going to be on ICQ today?

edgeprod · 12-28-2006, 04:22 PM

Quote:

Originally Posted by More Booze

Hi, I just did open a support ticket. You'll find screenshots from "Step 3" and login-info to one of the blogs so you can try to post to it.

They're all Wordpress Blogs. One of the blogs did still run WP 2.0.4. I did upgrade to 2.0.5 but I still get the same error.

Ok, thanks. I'll take a look at the screenshot, then we'll try posting from my ABP. If that fails, "Houston, we have a problem," and we'll smack your host around to find out what's wrong with the networking.

Quote:

Originally Posted by Nismo

Edge, are you going to be on ICQ today?

Yep. I just woke up (got up in the middle of the night to answer tickets, though, then went back to sleep). I'm going to pop on ICQ to check for "emergencies," go take a shower, then I'll be back. Feel free.

edgeprod · 12-28-2006, 04:38 PM

Quote:

Originally Posted by More Booze

Hi, I just did open a support ticket. You'll find screenshots from "Step 3" and login-info to one of the blogs so you can try to post to it.

Ok, I posted 20 posts successfully.

It would seem to me, then, to be a routing problem with the host. I can't imagine what specific type of misconfiguration would cause you not to be able to reach an IP on the same machine, but stranger things have happened. Because we can reach it fine from the "outside world," it would seem the host isn't doing something odd like blocking XML-RPC (because my posts went through).

It seems to be a networking problem unrelated to Autoblogger Pro, but that doesn't mean we won't continue to help you, of course. If the host fails to solve the problem in the long run, please bump the ticket or give them my contact information. Barring that, I can suggest a number of hosts that have been verified to A) know what they're doing, B) have good support, and C) have experience with Autoblogger Pro.

chronosafe · 12-28-2006, 07:01 PM

Edge & Co. rock. There product is solid and support is outstanding.

Now all they need is to be able to post to Joomla as well as Wordpress and they'd be godlike.

edgeprod · 12-28-2006, 07:12 PM

Quote:

Originally Posted by chronosafe

Edge & Co. rock. There product is solid and support is outstanding.

Now all they need is to be able to post to Joomla as well as Wordpress and they'd be godlike.

Haha, thanks. What's the Joomla API like?

12-27-2006, 01:51 PM	#2
uno RIP Dodger. BEST.CAT.EVER Industry Role: Join Date: Dec 2002 Location: NYC Area Posts: 18,450	I haven't seen that one, but did you submit a support ticket? Also, did you reinstall the program to update the database? __________________ -uno icq: 111-914 CrazyBabe.com - porn art MojoHost - For all your hosting needs, present and future. Tell them I sent ya!

12-27-2006, 02:33 PM	#3
Nismo Confirmed User Join Date: May 2002 Location: FLORIDA Posts: 4,977	Yes, I submitted a ticket and talked with someone from ABP. They didn't seem to care much to help me since Im using the older version of ABP. And no, I didn't re-install anything. It was a fresh install. __________________ i buy massive xxx dating traffic.

12-27-2006, 05:23 PM	#4
Nismo Confirmed User Join Date: May 2002 Location: FLORIDA Posts: 4,977	bump for help. __________________ i buy massive xxx dating traffic.

12-27-2006, 05:43 PM	#14
Nismo Confirmed User Join Date: May 2002 Location: FLORIDA Posts: 4,977	I apologize if I came off as an asshole, but im just frustrated as you can imagine. I've been working on this issue for about 2-3 weeks now to no avail. I've worked customer service before and I know, firsthand, it sucks. HEH __________________ i buy massive xxx dating traffic.

12-27-2006, 06:16 PM	#19
Young Bland for life Industry Role: Join Date: Nov 2004 Posts: 10,468	rss blogger = oxy moron __________________ ★★★

12-27-2006, 05:28 PM	#5
edgeprod Permanently Gone Industry Role: Join Date: Mar 2004 Posts: 10,019	Looks like the WordPress update changes the way tables are handled. I don't see a ticket in there right now, but thanks for the "they didn't seem to care much to help me" comment.

12-27-2006, 05:41 PM	#13
mattz Confirmed User Industry Role: Join Date: Dec 2001 Location: AZ Posts: 7,697	whenever i get errors i just reinstall if its wordpress your talking about just deleate all wordpress file except wp-config.php and reupload all the files and everything will be back to normal just dont overwrite the wp-config.php file

12-27-2006, 06:41 PM	#21
Cory W Deeply shallow Join Date: Jan 2004 Location: Hollywood, Ca. Posts: 9,133	Edgepro is one of the most helpful people in the business. __________________ ICQ: 292310358 Offering writing and content services (mainstream). Marketing for L3 Payments

12-28-2006, 04:08 AM	#23
More Booze Confirmed User Join Date: Mar 2004 Posts: 5,116	No, but I have another problem with ABP. I got 3 blogs on the same server as ABP. ABP can post to one of them. But it says "Connect error: No route to host (113)" for the other two. Anyone know what to do?

12-28-2006, 07:31 AM	#27
edgeprod Permanently Gone Industry Role: Join Date: Mar 2004 Posts: 10,019	Also, as a follow-up, do you get any error message for the blog is has no problems with? And they're all WordPress, same version, right?

12-28-2006, 12:23 PM	#29
Nismo Confirmed User Join Date: May 2002 Location: FLORIDA Posts: 4,977	Edge, are you going to be on ICQ today? __________________ i buy massive xxx dating traffic.

12-28-2006, 07:01 PM	#32
chronosafe Registered User Join Date: Nov 2006 Posts: 5	Edge & Co. rock. There product is solid and support is outstanding. Now all they need is to be able to post to Joomla as well as Wordpress and they'd be godlike. __________________ Replica Watch Report \| Classic Car VIN Decoder