RE: Can't create an issue

[Rob Mazeffa]

Just a note that I confirmed George Herson's suggested fix that he suggested
earlier in this thread.  
 


  _____  

From: Rob Mazeffa [mailto:rob@stripped] 
Sent: Tuesday, January 11, 2005 12:58 PM
To: 'Rob Mazeffa'; 'eventum-users@stripped'
Cc: 'jpm@stripped'
Subject: RE: Can't create an issue


Guys, thanks for your feedback.    Joao, you had mentioned that you though I
had a problem with my custom backend, but I'm using the sample customer
class right out of box and run into the problem.  You may note that 2 other
users have confirmed the problem.  

I will try to incorporate the fix that was suggested by one of the users,
but perhaps you can comment on the problem and either confirm his fix, or
provide an official fix to us.  

Thanks!

Rob


  _____  

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


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