RE: Can't create an issue

[Rob Mazeffa]

I am getting an error log, as it turns out.  It would appear that the
problem is due to the iss_usr_id field being empty, but I am selecting a
user in the pulldown list  (BTW, I did toggle the General Options setting
called 'Allow Un-assigned Issues'.  I wonder if there could be something
wrong with that logic...)
 
 
on line '1649' of script
'/var/www/developer/support/include/class.issue.php' on page
'/support/new.php'.
[Mon Jan 10 17:35:04 2005] Found error 'DB Error: syntax error/INSERT INTO
                    techsoft.eventum_issue
                 (
                    iss_prj_id,
iss_prc_id,
iss_pre_id,
iss_pri_id,
                    iss_usr_id,iss_sta_id,
                    iss_customer_id,
                    iss_customer_contact_id,
                    iss_contact_person_lname,
                    iss_contact_person_fname,
                    iss_contact_email,
                    iss_contact_phone,
                    iss_contact_timezone,
                    iss_created_date,
                    iss_last_public_action_date,
                    iss_last_public_action_type,
                    iss_summary,
                    iss_description,
                    iss_dev_time
                 ) VALUES (
                    1,
1,
1,
4,,1,
                    1,
                    93,
                    'Smith',
                    'Bob',
                    'bob@stripped',
                    '[phone]',
                    'UTC',
                    '2005-01-11 01:35:04',
                    '2005-01-11 01:35:04',
                    'created',
                    'test',
                    'test',
                    4
                 ) [nativecode=1064 ** 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 '1,
                    1,
                    93,
           ]' on line '1649' of script
'/var/www/developer/support/include/class.issue.php' on page
'/support/new.php'.

 
 

  _____  

From: Rob Mazeffa [mailto:rob@stripped] 
Sent: Monday, January 10, 2005 4:39 PM
To: 'eventum-users@stripped'
Subject: Can't create an issue


I've installed and begun configuring eventum (customizing it) and did some
testing which has result in me being unable to create an issue.  The error I
get is simply 'There was an error creating your issue' at the top of the
'create issue' form.   No error gets sent to the error log file.
 
I suspect this is related to some testing I had done, which is as follows:
I want to import our existing issues into the 'eventum_issue' table, and did
a test where I changed the 'id' of my one and only test issue (the value was
1 and I changed it to 4000), and then tried to create a new issue but to no
avail.  I now realize that since iss_id is a primary key and other records
were going off of it, this was probably a no-no.  Anyway, I blew away my
single 'eventum_issue' record along with all associated records that I could
find, and tried to create a new issue, but am getting the aforementioned
error.
 
Is there something else I need to do to 'reset' eventum (short of
reinstalling it?)    Anyway, when importing our existing issues, I presume
that I can just import them directly into the eventum_issue table (mapping
our current issue id to iss_id, provided that the value for iss_id is unique
and non-negative.)
 
Thanks for any advice y'all,
 
Rob