Page 1 of 1

oric.org software page down?

Posted: Mon May 30, 2016 1:42 pm
by Chema
Hi all!

I just went to oric.org and, when trying to access the software area, I got this error:

Code: Select all

Error SELECT count(id_comment) as nb FROM comment WHERE id_software_comment= AND id_utilisateur_comment=611064: 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 'AND id_utilisateur_comment=61' at line 1
You can access the individual game pages and other sections, though.

Just posted here so whoever may be able to solve it knows :)

Re: oric.org software page down?

Posted: Mon May 30, 2016 2:41 pm
by ibisum
Works for me, same .. good ol' .. site ..

Re: oric.org software page down?

Posted: Mon May 30, 2016 3:20 pm
by Symoon
Noticed the SQL error too and warned Jede yesterday - he fixed it this morning! ;)

Re: oric.org software page down?

Posted: Mon May 30, 2016 4:21 pm
by Chema
It works for me if I am not logged, but fails with the above error if I am.

Re: oric.org software page down?

Posted: Mon May 30, 2016 4:37 pm
by Godzil
I confirm:


Error SELECT count(id_comment) as nb FROM comment WHERE id_software_comment= AND id_utilisateur_comment=60761064: 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 'AND id_utilisateur_comment=6076' at line 1

I suppose that the "id_software_comment" equality must not be empty as it is currently bla= at least it should be bla=""

Re: oric.org software page down?

Posted: Mon May 30, 2016 7:41 pm
by iss
As temporary workaround you can use:
http://www.oric.org/index.php?page=soft ... waresearch

This works when you are logged too. ;)

Re: oric.org software page down?

Posted: Tue May 31, 2016 7:31 am
by Symoon
Ah, too bad. I just reported the bug to Jede.

Re: oric.org software page down?

Posted: Wed Jun 01, 2016 4:43 am
by coco.oric
Seems it's working even i'm logged.
I suppose that jede has fixed the bug

Re: oric.org software page down?

Posted: Wed Jun 01, 2016 1:55 pm
by Chema
Yep, it also works for me now. Thanks Jede!!! :)