Sql Error

👨‍💻 Development Help
1

I have created one custom module, so module table is there . and i created custom also from studio so cstm table also there.

table a and table a_cstm.

Thing is that on save button data’s are storing in respective tables Most of the time. But problem is here sometimes while saving its showing error.
sugar generating insert query

insert into table a (including all the filedds of table a anf table a_cstm also ) and values (also same case)

can anybody tell me why this thing is happening ???

2

Hi jaydeep ,

i hope this might help

error on insert call

suite crm post

Try to share sugar logs !

Thanks for Your time and support !

3

Hi,

No it is not that kind of error. its working fine most of the time. but sometimes it is occurring.

4

Hi jaydeep ,

i hope u can share the log’s and did you check with the permission ?

recommended permission settings are


'default_permissions' =>
array (
'dir_mode' => 1517,
'file_mode' => 420,
'user' => 'youruser', // you must replace <youruser> with the actual value
'group' => 'yourgroup', // you must replace <yourgroup> with the actual value
),

Then running the following commmands inside your SuiteCRM directory:

sudo chown -R youruser:yourgroup .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload config_override.php

Thanks for your time and support

5

Hi Adr,

I have no idea on this what actually it is. in many files many places are there this thing. How this thing make any changes…

can you explain on this…

In my files most of them are this thing , which to change and where to change.

'default_permissions' => 
  array (
    'dir_mode' => 1528,
    'file_mode' => 432,
    'user' => '',
    'group' => '',
  ),
6

what is the exact error it is giving in the log?

7

INSERT INTO ca_payment (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,credit,status,proforma,filename[color=#4400ff],tds_requir_c,[/color]deposit_city_c,deposit_date_c,check_number_c,deposit_bank_c,payment_date_c,amount_paid_c,tds_c,bank_city_c,dd_number_c,transaction_number_c,payment_mode_c,bank_name_c,deposit_branch_c,payment_type_c,bank_branch_c)
VALUES (‘31fa4529-abcd-8118-18de-54dae639bc06’,‘Payment-[Cheque : 258730]’,‘2015-02-11 05:20:04’,‘2015-02-11 05:20:04’,‘b79a0f21-597a-425d-f776-549d4fba39b3’,‘b79a0f21-597a-425d-f776-549d4fba39b3’,‘Received Part Payment against Ultimate Package.’,0,‘36a16107-138c-caaf-ffb6-537dc456d6d8’,7000,‘pending’,’^74df73e3-efd8-e2ac-e76e-54bf7871bce0^’,’’,’[color=#884400]Not_Applicable[/color]’,‘Bangalore’,‘10-02-2015’,‘258730’,‘axis’,‘10-02-2015’,’^70000^’,’’,‘Virudhanagar’,’’,’’,‘cd’,‘Axis Bank’,‘Jayanagar’,‘proforma’,‘Virudhanagar’)

1054: Unknown column ‘tds_requir_c’ in ‘field list’ …

8

Anyone ???

9

I assume you have tried doing a quick repair and rebuild and executing any changes required for the db?
Have you deleted any custom fields from this module?

10

No mate , thing is that, this query sometimes occurring. But most of the time it is perfectly working fine.

My question is that only , why sometimes it is happening. and about the field it is fine everything. Then also … no idea :wink: