oric.org software page down?

In this forum you can write about anything that does not fit in other forums.
This includes generic Oric talkings and things that are totaly unrelated but want to share with people here :)
User avatar
Chema
Game master
Posts: 3013
Joined: Tue Jan 17, 2006 10:55 am
Location: Gijón, SPAIN
Contact:

oric.org software page down?

Post 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 :)
User avatar
ibisum
Wing Commander
Posts: 1643
Joined: Fri Apr 03, 2009 8:56 am
Location: Vienna, Austria
Contact:

Re: oric.org software page down?

Post by ibisum »

Works for me, same .. good ol' .. site ..
User avatar
Symoon
Archivist
Posts: 2301
Joined: Sat Jan 14, 2006 12:44 am
Location: Paris, France

Re: oric.org software page down?

Post by Symoon »

Noticed the SQL error too and warned Jede yesterday - he fixed it this morning! ;)
User avatar
Chema
Game master
Posts: 3013
Joined: Tue Jan 17, 2006 10:55 am
Location: Gijón, SPAIN
Contact:

Re: oric.org software page down?

Post by Chema »

It works for me if I am not logged, but fails with the above error if I am.
Godzil
Squad Leader
Posts: 774
Joined: Sat May 21, 2011 7:21 pm
Location: Between UK and France
Contact:

Re: oric.org software page down?

Post 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=""
User avatar
iss
Wing Commander
Posts: 1637
Joined: Sat Apr 03, 2010 5:43 pm
Location: Bulgaria
Contact:

Re: oric.org software page down?

Post by iss »

As temporary workaround you can use:
http://www.oric.org/index.php?page=soft ... waresearch

This works when you are logged too. ;)
User avatar
Symoon
Archivist
Posts: 2301
Joined: Sat Jan 14, 2006 12:44 am
Location: Paris, France

Re: oric.org software page down?

Post by Symoon »

Ah, too bad. I just reported the bug to Jede.
User avatar
coco.oric
Squad Leader
Posts: 720
Joined: Tue Aug 11, 2009 9:50 am
Location: North of France
Contact:

Re: oric.org software page down?

Post by coco.oric »

Seems it's working even i'm logged.
I suppose that jede has fixed the bug
coco.oric as DidierV, CEO Member
Historic owner of Oric, Apple II, Atari ST, Amiga
User avatar
Chema
Game master
Posts: 3013
Joined: Tue Jan 17, 2006 10:55 am
Location: Gijón, SPAIN
Contact:

Re: oric.org software page down?

Post by Chema »

Yep, it also works for me now. Thanks Jede!!! :)
Post Reply