Recent Topics

1 Aug 18, 2006 23:29    

Your b2evolution version: 1.8
Your level of knowledge of Internet technologies: Beginner
Link to your b2evolution blog: http://sergioflima.pro.br/blog/blogs

PHP Version: 4.4.2
MySQL Version: 4.1.21

What actions led up to your current issue?
After upgrade 0.92 to 1.8 I don't see my blog...a receive the message:

cted error has occured!

If this error persits, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lima)) GROUP BY myday ORDER BY post_datestart DESC' at line 8(Errno=1064)

Your query:

SELECT COUNT(DISTINCT post_ID) AS item_count,
YEAR(post_datestart), MONTH(post_datestart),
DAYOFMONTH(post_datestart) AS myday

FROM (evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID)
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID

WHERE YEAR(post_datestart) = "2006"

AND MONTH(post_datestart) = "08"

AND ( ( ( post_status = "private"
AND post_creator_user_ID = 1 )
OR post_status IN ('published','protected') ) )
AND (post_creator_user_ID IN (Sérgio Lima))

GROUP BY myday

ORDER BY post_datestart DESC

What have you tried to solve the issue?
I don't know :-(

2 Aug 19, 2006 06:38

I can see your blog..? Fixed?

Anyway, it looks like you set $author somewhere to "Sérgio Lima" (in a stub file or the like) which then gets used as the user ID(s) to restrict posts to.

Could that be?

btw: very nice bug/problem report! :)

3 Aug 19, 2006 09:43

My blog yet is with problem

I received this message

Bad Request!

The parameters of your request are invalid.

If you have obtained this error by clicking on a link INSIDE of this site, please report the bad link to the administrator.

Go back to home page
Additional information about this error:
Illegal value received for parameter «author»!

4 Aug 19, 2006 10:19

What's the link that causes this error message?

And on which URL does the first (similar) error appear?

5 Aug 19, 2006 13:47

Hi,

Thanks for your atention :-)

The error is dead :-) but in epyphany (only in this) I received this nessage in any url:

Bad Request!

The parameters of your request are invalid.

If you have obtained this error by clicking on a link INSIDE of this site, please report the bad link to the administrator.

Go back to home page
Additional information about this error:
Illegal value received for parameter «author»!

In IE, fiefox e galeon itś all ok

Very strange!

PS: Excuse my poor english, I Brazilian :-)

6 Aug 20, 2006 02:10

It appears than that Epyphany sends either an "author" cookie or something else, that gets recognized by b2evo.

I could not reproduce it here, but it may depend on which domain b2evo is running and what cookies you have set there.

Can you put the following script in your blogs folder, where also admin.php is and execute it through Epyphany? (save the code below as foobar.php for example)


<?php
phpinfo();
?>


Search for "author" therein. Can you find something?

If it's possible, I'd like to have an URL to that file to take a look at it, too.

8 Aug 20, 2006 17:58

I turn-off the cookies in Epiphany...anda now the blog is work :-)

Thanks :-)

blueyed wrote:

It appears than that Epyphany sends either an "author" cookie or something else, that gets recognized by b2evo.
I turn off the coookies in epiphany... and the blog is ok now :)

I could not reproduce it here, but it may depend on which domain b2evo is running and what cookies you have set there.

Can you put the following script in your blogs folder, where also admin.php is and execute it through Epyphany? (save the code below as foobar.php for example)


<?php
phpinfo();
?>


Search for "author" therein. Can you find something?

If it's possible, I'd like to have an URL to that file to take a look at it, too.

9 Aug 20, 2006 22:33

So, have you deleted a specific cookie?

Because turning them all off would not allow you to login (as you've said).

10 Aug 21, 2006 01:24

No, I don't deleted any cooky. I only turn-off the cookies.

I think that is a bug in Epiphany.

Thanks

blueyed wrote:

So, have you deleted a specific cookie?

Because turning them all off would not allow you to login (as you've said).

11 Dec 11, 2006 21:03

Hi.

i ran into the same Problem using firefox:
firefox -v
Mozilla Firefox 1.5.0.7, Copyright (c) 1998 - 2006 mozilla.org
i denied using cookies for my own blog page and now it works.

this is kind of a nasty bug, because if anyone visiting the site will see the error, he/she will ignore it since he will not recognize what that means.

josh

--edit
works means: i am able to view the site, but indeed, i am not able to login anymore.

12 Jan 22, 2007 16:20

I just experienced this same error. I upgraded to 1.8.6, it worked on Friday. I came back to work on Monday and was getting the "Illegal value received for parameter «author»!" error.

Turning off cookies is just not an option for me....but I ended up going into Firefox and deleting the "author" cookie for my site and that fixed the issue. I'm not sure if there will be any other consequences because of deleting that cookie, but I imagine it will just get re-written when needed.

13 Jan 22, 2007 20:59

The error came back for me, but I think I figured out what was happening. I had installed pmwiki on my site and apparently that creates an author cookie which is somehow conflicting with b2e. I'm not sure what the long-term solution is, though.

14 Jan 22, 2007 21:04

$cookie_domain / $cookie_path would be a solution. Both apps are probably installed in different paths, so use this path in the cookie setting(s).

15 Jan 22, 2007 23:42

Thanks blueyed,

There was a file in pmwiki called author.php which included the variable $AuthorCookieDir. That was originally set to / so I changed it to another path and that seems to have cleared this problem.

Thanks so much for sharing your wisdom!


Form is loading...