|
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
On Sun, Aug 29, 2004 at 11:53:16AM -0400, LeRoy Cressy wrote:
> eric@lucii.org wrote:
> | On Fri, Aug 27, 2004 at 10:42:14AM -0400, Stewart Lone wrote:
> |
> |>This page seem to have a link(working at the moment- Friday 10:27 AM)
> |>that takes you to a Novell page with a questionair- signup form for
> |>their "kit".
> |>
> |>Here is the URL for the page.
> |>http://www.nwfusion.com/cgi-bin/forum/gforum.cgi?do=post_view_threaded;post=1871;sb=post_latest_reply;so=ASC;t=default
> |>
> |>Here is the actual URL----
> |>http://www.novell.com/community/linux/order_limited.php
> |
> |
> | Once *again*, I'm hosed by Novell's application. I fill out the form,
> | click the submit button and BAM!
> |
> | Couldn't execute query. (dbilib.inc:dbquery) insert into
> | SurveyAnswers (questionid, userid, questionanswer) values
> | (0,61516,'More than 10'),(1,61516,'10'),(2,61516,'Yes'),
> | (2,61516,'Philadelphia Linux User's Group'),
> | (3,61516,'No'),(4,61516,'None'),(4,61516,''),
>
> I think that the problem could be the Novell application is attempting
> to insert into the database questionid where questionid and userid are
> not unique. See questionid with the value '4' in two inserts in the
> above line? If there is an index that specifies uniqueness for userid
> and questionid the query will fail.
>
> create unique index index_name on table SurveyAnswers
> (
> questionid, userid
> );
>
> | (5,61516,'Computer - Network Consulting'),(6,61516,'Computer
> Support'),
> | (7,61516,'1-10'),(8,61516,'1-10'),(20,61516,'Application_Server'),
> | (20,61516,'Database_Server'), (20,61516,'Email_Server'),
> | (20,61516,'File_Server'), (20,61516,'Print_Server'),
> | (20,61516,'Proxy_Caching'), (20,61516,'Security'),
> | (20,61516,'Web_Server'),(21,61516,'None'), (22,61516,'None'),
> | (23,61516,'None'),(24,61516,'Test_Environment'),
> (24,61516,'Web_Server'),
> | (25,61516,'None'),(26,61516,'None'), (27,61516,'Linux'),
> | (27,61516,'Windows'),(28,61516,'LDAP'), (29,61516,'Other'),
> | (30,61516,'None'),(31,61516,'Open_Office_(all_variants)'),
> | (31,61516,'Microsoft'),(32,61516,'Yes')
> |
> | Curiously, I'm not sure if this means that I'm not entered to get
> | the kit or if I _am_ entered but they don't have the survey answers
> | in the database now :-D Guess I'll find out.
> |
> | Eric
>
> It appears that Novell's SurveyAnswer table is all messed up. On the
> otherhand, it seems that the customer table along with the shipping
> address portion of the application is working.
>
>
> --
> Rev. LeRoy D. Cressy mailto:leroy@lrcressy.com /\_/\
> ~ http://lrcressy.com ( o.o )
> ~ Phone: 215-535-4037 > ^ <
> ~ FAX: 215-535-4285
>
> gpg fingerprint: 62DE 6CAB CEE1 B1B3 359A 81D8 3FEF E6DA 8501 AFEA
>
> For info on enigmail: http://lrcressy.com/linux/mozilla.pdf
> For info on gpg: http://www.gnupg.org/
>
> Jesus saith unto him, I am the way, the truth, and the life:
> no man cometh unto the Father, but by me. (John 14:6)
Wow - nice detective work. I concur with the duplicate key theory - given
the code it makes perfect sense.
Actually, I tried several hours later and was successful! The email arrived
a short time later and delivery of the kit has been promised!
Thanks,
Eric
--
# Eric Lucas
# "Oh, I have slipped the surly bond of earth
# And danced the skies on laughter-silvered wings...
# -- John Gillespie Magee Jr.
___________________________________________________________________________
Philadelphia Linux Users Group -- http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion -- http://lists.phillylinux.org/mailman/listinfo/plug
|
|