I installed viart shop v3.4.2 and all the patches,
but when I logged in as a user and clicked
My Support Requests --New Request, after I clicked
submit request, I got the following message:
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:
http://www.XXXX.com/support.php
Referrer URL:
http://www.XXXX.com/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 (2,'','XX','XXXXX@yahoo.co.uk','','sdf','sdfs',1,1,5,'sdefs','adsfdsa',1,2,0,0,NULL,0,'2008-03-20 22:33:43','2008-03-20 22:33:43')
MySQL Error: Column 'admin_id_added_by' cannot be null
can anyone help? I really appreciate this. Thanks in advance.
