Oracle DB users out there?

[bwdutton]

Hi,

I'm looking for feedback from other Oracle users out there. We've
installed farcry 5.0.0 (and since 5.0.2) and we've seen some query
errors on some of the screens (ORA-01427: single-row subquery returns
more than one row) and one of the tables wasn't created during the
install process. We're wondering if these issues are isolated to us or
if other Oracle users are having problems as well.

Thanks for your time,
Brad

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-user" group.
To post to this group, send email to farcry-user@...
To unsubscribe from this group, send email to farcry-user+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-user?hl=en
-~----------~----~----~----~------~----~------~--~---

[modius]

On Oct 17, 5:12 am, bwdutton <bradd-goo...@...> wrote:
> I'm looking for feedback from other Oracle users out there. We've
> installed farcry 5.0.0 (and since 5.0.2) and we've seen some query
> errors on some of the screens (ORA-01427: single-row subquery returns
> more than one row) and one of the tables wasn't created during the
> install process. We're wondering if these issues are isolated to us or
> if other Oracle users are having problems as well.

There have been a variety of Oracle issues fixed recently for the
upcoming 5.1 release.  It may be your issues have already been
addressed.  If you can detail the error and template for your
individual errors we can certainly check.

The bug and enhancements list is available here:
http://bugs.farcrycms.org/browse/FC

The farcry-dev forum will generally give you a better response to
developer related issues.

Best regards,

-- geoff
http://www.daemon.com.au/

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-user" group.
To post to this group, send email to farcry-user@...
To unsubscribe from this group, send email to farcry-user+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-user?hl=en
-~----------~----~----~----~------~----~------~--~---

[Tomek Kott]

Hi Brad,

Yup! I'm an Oracle user (8i) and have a site up and running. What you
are noticing is exactly the kinds of things I have noticed. I bugged a
couple of them and sent in corrections that I believe are the ones
Geoff mentioned as being fixed in 5.1.

For the table that wasn't installed, I'm guessing that is the
reffriendlyurl table. Go into farcry\core\webtop\install\fu.cfm. Some
way down you'll see the table definition. Just install it by hand and
reload your application scope (?updateapp=1 via admin or the code that
was presented at the beginning).

For the subquery return, I remember that problem, but can't find where
I fixed it. It has something to do with needing a "unique" qualifier
in front of the statemment in question. You should be able to trace it
via the error message.

I'll be glad to help with any other oracle problems.

Best,

Tomek

On Oct 16, 2:12 pm, bwdutton <bradd-goo...@...> wrote:

> Hi,
>
> I'm looking for feedback from other Oracle users out there. We've
> installed farcry 5.0.0 (and since 5.0.2) and we've seen some query
> errors on some of the screens (ORA-01427: single-row subquery returns
> more than one row) and one of the tables wasn't created during the
> install process. We're wondering if these issues are isolated to us or
> if other Oracle users are having problems as well.
>
> Thanks for your time,
> Brad

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-user" group.
To post to this group, send email to farcry-user@...
To unsubscribe from this group, send email to farcry-user+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-user?hl=en
-~----------~----~----~----~------~----~------~--~---