We are the proud owners of the Enterprise version (Just purchased 2 days ago).. Everything works fine but we are having serious issues with the user support system...
I have posted this directly to ViArt support (Which their system works just fine) but am posting this here as this is criticle to our business and am hoping someone might have a fast answer so we can get this fixed. (I am using the latest version 3.4.5
Anytime a user tries to enter a support ticket the following error comes up: (Note;: My domain replaced for this public post)
DB ERROR 1048
We are very sorry, but an error has occurred while processing your request. Please try the operation again by either pressing the Refresh button on your browser, or by going back one page using the Back button. If the error persists, please contact our web development team.
The details of the error are shown below. Please quote this in any correspondance regarding this problem.
Page URL:
https://MYDOMAIN.org/support/support.php
Referrer URL:
https://MYDOMAIN.org/support/support.php
Database error: Invalid SQL: INSERT INTO va_support (user_id,affiliate_code,user_name,user_email,remote_address,identifier,environment,dep_id,support_product_id,support_type_id, summary,description,support_status_id,support_priority_id,admin_id_assign_to,admin_id_assign_by,admin_id_added_by,admin_id_ modified_by,date_added,date_modified) VALUES (5,'','Dave Nosker','dnosker@MYDOMAIN.org','71.218.89.202',NULL,NULL,2,0,10,'test','test123 test',1,2,0,0,NULL,0,'2008-03-13 12:12:58','2008-03-13 12:12:58')
MySQL Error: Column 'admin_id_added_by' cannot be null
