Re: [PLUG] novell kit

[LeRoy Cressy <ldc@lrcressy.com>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Debian - http://enigmail.mozdev.org

iD8DBQFBMfvrP+/m2oUBr+oRAh5wAJ91woKpGytbdffY7fQQJRg4cia6OgCfaBJ1
1H6pEzq4h3JgwdtuGy67K28=
=T/3H
-----END PGP SIGNATURE-----
___________________________________________________________________________
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