When I try to do a post via w.bloggar the soft throws me a "requested category does not exist" error.

¿ any idea ?

PostPosted: Sat Oct 07, 2006 14:40 Post subject: Error with w.bloggar and other tools
Hello All;

Using the lattes release of b2: 1.8.2 I get the following error message when trying to get my blog categories or post from offline writers (w.bloggar and Windows Live Writer):

Quote:
Server Error 809 Occurred
DB error: <p>Unknown system variable 'NAMES'(Errno=1193)</p>

TIA

I'm getting this same error using BlogJet 1.6.2

I get the error when: Connecting and when publishing.

¿Anybody knows why?

Hello All;

I tried loading the xmlrpc.php from the older 1.8.x versions and got the same error. So, it's not specific to 1.8.2

I'm hoping someone has a fix for this....

Thanks

- JohnT

Another tool not working with version 1.8.2 but that did work with version 0.9.12 is post2blog.

Blogjet tool didn't have problems with 0.9.12 but does now with 1.8.2, so something happenning between those versions is the culprit.

When I same culprit I don't mean any har to b2evo v 1.8.2; I like the new version very much, but I would liket to be able to post from a client such as BlgJet, postblog, wbloggar, etc. too.

Does anybody have a clue as to what can be done to fix this?

jtruchon wrote:

Hello All;

Using the lattes release of b2: 1.8.2 I get the following error message when trying to get my blog categories or post from offline writers (w.bloggar and Windows Live Writer):

Server Error 809 Occurred
DB error: <p>Unknown system variable 'NAMES'(Errno=1193)</p>

TIA

JohnT

This should fix it:

Index: blogs/inc/_misc/_db.class.php
===================================================================
RCS file: /cvsroot/evocms/b2evolution/blogs/inc/_misc/_db.class.php,v
retrieving revision 1.6.2.8
diff -u -r1.6.2.8 _db.class.php
--- blogs/inc/_misc/_db.class.php       10 Oct 2006 21:25:14 -0000      1.6.2.8
+++ blogs/inc/_misc/_db.class.php       14 Oct 2006 02:55:53 -0000
@@ -1324,6 +1324,7 @@
                        $save_halt_on_error = $this->halt_on_error;
                        $this->show_errors = false;
                        $this->halt_on_error = false;
+                       $last_error = $this->last_error;
                        if( $this->query( 'SET NAMES '.$charset ) === false )
                        {
                                $Debuglog->add( 'Could not "SET NAMES '.$charset.'"! (MySQL error: '.strip_tags($this->last_error).')', 'locale' );
@@ -1336,6 +1337,7 @@
                        }
                        $this->show_errors = $save_show_errors;
                        $this->halt_on_error = $save_halt_on_error;
+                       $this->last_error = $last_error;

                        $this->connection_charset = $charset;
                }

(add the two lines with "+" into _db.class.php at the mentioned places)

gbrusella wrote:

When I try to do a post via w.bloggar the soft throws me a "requested category does not exist" error.

¿ any idea ?

That's another error. Please start a new thread for it, but I'm quite sure it's already around somewhere.

Actually, the XMLRPC implementation in b2evo is in bad shape..

blueyed;

This should fix it:
Code:

That did it...w.bloggar is working.

Thank you for the fix.

Blueyed, that solved the problem with BlogJet.

Thank You

Looks like this solution was rolled into subsequent versions. I'm still getting this error on B2Evo v. 1.8.5 even with the added lines. (I love the commenting!)
I'm using MySQL 4.0.27, PHP is version 4.4.2
(w/ Zend Optimizer)

I'm also using w.bloggar v4.00

Any suggestions? TIA

I can confirm this with 1.9.1, lines added to the file but I'm still getting a DB error with w.bloggar and Windows Live Writer. However, the item was posted to my blog...just seems to return the error.

@cubano61 and jtruchon:
1. What error are you getting exactly?
2. When are you getting it?
3. Can you reproduce it at the demo site? (for v-1-9 and HEAD)

jtruchon, thanks for the heads up! Mine posted, too!! (ack!) Thanks for the assistance, blueyed. Not sure where the demo site is. Again, I'm on b2evo 1.8.5.

I tried another simple new post and it worked. I tried again with an extra category chosen, and this time, it failed to post. (I think it has to do with when you choose more than one category.) I get this [window title]: "w.bloggar: 805" [message]: "Your blog server returned the following error message: Requested category does not exist". So, not sure if it's something that can be tweaked on the b2evo side or on w.bloggar. I can always follow-up w/ extra categories later so this is at least better than nothing!

Thanks in advance, as always.

cubano61

blueyed;

Here is the error I get with Windows Live Writer:

Server Error 809 Occurred

DB error:

I just tried it again and same error, but the article did post and it even had the correct category.

Thanks

Yes.. bummer..

You need the following patch. The line numbers refer to v-1-9, but it works for 1.8.x also:

--- blogs/inc/_misc/_db.class.php       19 Nov 2006 23:26:19 -0000      1.21.2.12
+++ blogs/inc/_misc/_db.class.php       4 Dec 2006 17:41:38 -0000
@@ -1342,6 +1342,7 @@
                        $this->show_errors = false;
                        $this->halt_on_error = false;
                        $last_error = $this->last_error;
+                       $error = $this->error;
                        if( $this->query( 'SET NAMES '.$charset ) === false )
                        {
                                $Debuglog->add( 'Could not "SET NAMES '.$charset.'"! (MySQL error: '.strip_tags($this->last_error).')', 'locale' );
@@ -1356,6 +1357,7 @@
                        $this->halt_on_error = $save_halt_on_error;
                        // Blatantly ignore any error generated by SET NAMES...
                        $this->last_error = $last_error;
+                       $this->error = $error;

                        $this->connection_charset = $charset;
                }

blueyed;

Thanks for the quick reply/fix. Added the two lines and is working again...no errors.

Thanks again

blueyed,
Thanks, but no change for me on 1.8.5. I still get the same error as before. I even went and upgraded to v 1.9.1 and still not any better. :-( Same error message as before. Works fine for 1 category. Any more and I get the error.

cubano61

cubano61, the problem is that w.bloggar sends a list of categories where b2evo expexts a single one (which it then fails to parse).

I've fixed it for CVS HEAD. Probably the fix won't make it into 1.9.x, but the release afterwards only (1.10 or 2.0) - sorry.

You may want to fix it for yourself by hacking two files:
http://evocms.cvs.sourceforge.net/evocms/b2evolution/blogs/inc/_misc/_misc.funcs.php?r1=1.152&r2=1.153
http://evocms.cvs.sourceforge.net/evocms/b2evolution/blogs/xmlsrv/xmlrpc.php?r1=1.124&r2=1.125

Thanks. Yeah, that's what it seemed like to me.

I'm a bit over my head, but I actually think I follow your suggestion! I'll give it a try and let you know how it goes.

cubano61