We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Get started

New SQL state error - Fresh install! [BUG] | Forum

Topic location: Forum home » Support » Bug reports and troubleshooting

Steven Jan 20 '15

Hi,

I did a fresh install because all of the sudden Oxwall was throwing me a ton of error which started with this one. Then with my fresh install it was there again:

Message:SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'

I think it comes from ow_base_user_online.. I have no idea why it starts with a zero:

http://screencast.com/t/VtpQJYgq

The error:

http://screencast.com/t/X0CdcBxWQMYo

Server:

Nginx on debian

MariaDB 10.1.2-MariaDB-1~wheezy-wsrep-log

MySQL-client versie: mysqlnd 5.0.10 - 20111026

Team

ross Jan 20 '15

Provide the whole error, please

Steven Jan 22 '15

Hi Ross,

No offense but try reading the message again.. full error is there:

http://screencast.com/t/X0CdcBxWQMYo

Team

ross Jan 22 '15

Sorry, did not noticed the screenshot in the first post.

Can you please provide me the screenshot of your ow_base_user_online table in your database? If it's empty please confirm.

By the way, when did you get this error? What exactly you did, before that started to occur?

Steven Jan 24 '15

Hi Ross,

That was this screenshot http://screencast.com/t/VtpQJYgq

When I´m on the site (browser open) I cant even delete the row probably because it gets generated instantly again so it seems. When Im not on the site I can delete the row and when I then open the site again it gave the same error and that same entry was back.

I think it has something to do with mysql config possibly with ´only full group by´ directive from mysql.

I´ve remove a few sql strict settings and now it does seem to be working ok

Team

ross Jan 25 '15

What settings are you referring to?

Steven Jan 26 '15

SQL_MODE='ONLY_FULL_GROUP_BY'

in your mysql config file.

Oxwall Software

Please sign in

We build. You grow.

Start a social network, a fan-site, an education project with oxwall - free opensource community software

New SQL state error - Fresh install! [BUG] | Forum