Recent Topics

1 Aug 26, 2006 20:43    

Recently my hosting provider moved my site to another server (Linux). Since then, at the bottom of the page a MySQL error appears after visiting the site for the second time.

MySQL error!

Duplicate entry '0' for key 1(Errno=1062)

Your query:

INSERT INTO evo_hitlog( visitTime, visitURL, hit_ignore, referingURL, baseDomain,
hit_blog_ID, hit_remote_addr, hit_user_agent )
VALUES( FROM_UNIXTIME(1156618607), '/index.php', 'invalid',
'', '', 2,
'[ip adress]', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6')

I emptied the evo hitlog table and even dropped it.

2 Aug 26, 2006 22:06

Which b2evo version are you using?

3 Aug 27, 2006 11:59

i've got the same problem with Version 1.81.

on the local webserver everthing was allright

see here
http://mikelbower.de/blog/

when i deleted in phpmadmin all entries in evo_sessions i'm able to see the login screen, after login the same thing happens

???????

4 Aug 27, 2006 12:58

nearly fixed. seams a problem of the mysql dump and versions of mysql.

Crazy thing. the url is now running on every browser, without firefox :(((

5 Aug 27, 2006 15:57

blueyed wrote:

Which b2evo version are you using?

version 0.9.2

(upgrade to 1.8 fails miserably, so I decided to solve this one first... 8| )

6 Aug 27, 2006 16:00

mikel wrote:

nearly fixed. seams a problem of the mysql dump and versions of mysql.

Crazy thing. the url is now running on every browser, without firefox :(((

Can you be a little bit more specific on how you nearly fixed this?
Tnx!

7 Aug 27, 2006 18:08

It seems like the hit_ID field in evo_hitlog is not AUTO_INCREMENT or something similar on your setup(s).

8 Aug 27, 2006 19:55

You hit it right on the head Blueyed!
I set the visit_ID on auto increment and the darn thing went counting again. I had to do the same with antispam table btw...
Don't know what happened with sql importfile the host provided, but I guess there might have been a version difference in the MySQL service...
Thanks for the effective and swift replies you all!

9 Aug 29, 2006 08:41

thats it an I fixed my firefox problem too: It's a cookie problem. I changed the $b2evo_name and deleted the cookies and then everthing was fine.
@blueeyed
maybe a random-genarated cookie-name 8during installation-rotines) would help with many installations of b2evo on the same server with the same domain?

10 Aug 29, 2006 21:16

mikel wrote:

@blueeyed
maybe a random-genarated cookie-name 8during installation-rotines) would help with many installations of b2evo on the same server with the same domain?

Yes, there's already a "todo" about that in the code.. since some time already..


Form is loading...