添加客户是出现Query Error

851718528

msguery Error:
sql:INSERT INTO `toa_crm_company` (`number`, `title`, `user`, `bid`, `uid`, `date`, `toa_crm_company3538_130707151232`, `toa_crm_company8701_130707151018`, `toa_crm_company9793_130707150911`, `toa_crm_company8860_130707150634`, `toa_crm_company4128_130707151505`, `toa_crm_company5608_130707151553`, `toa_crm_company3983_130707151936`, `toa_crm_company1407_130707151913`, `toa_crm_company0785_130707151846`, `toa_crm_company3337_130707151924`, `toa_crm_company3616_130707151643`, `toa_crm_company8222_130707152032`, `toa_crm_company0773_130707152050`, `toa_crm_company5031_130707152058`, `toa_crm_company9083_130707152329`) VALUES ('T20210828164629', 'allportinternational', '', '', '3', '2021-08-28 16:52:16', '', '一星', '', '企业客户', 'India', '', '', '', '', '333 Udyog Vihar Phase II，Gurgaon- 122016 Haryana,', 'allportinternational.com', '', '', '', '')
errno:1054
error:Unknown column 'toa_crm_company3538_130707151232' in 'field list'

851718528

安装环境为 php5.5+mysql5.5.62

admin

数据表没有生成，在CRM表单管理里，重置一下表单

851718528

msguery Error:
sql:INSERT INTO `toa_crm_contact` (`name`, `cid`, `type`, `type1`, `uid`, `date`, `toa_crm_contact4876_130707145252`, `toa_crm_contact8440_130707145325`, `toa_crm_contact8466_130707145412`, `toa_crm_contact9124_130707145346`, `toa_crm_contact1165_130707145357`, `toa_crm_contact4245_130707145421`, `toa_crm_contact3648_130707145439`, `toa_crm_contact8837_130707145451`, `toa_crm_contact9436_130707145500`, `toa_crm_contact6338_130707145511`, `toa_crm_contact9839_130707145550`) VALUES ('Backpacks', '1000', '1', '1', '1', '2021-08-28 18:54:00', '男', '2021-08-28', '', '', '', '', '', '', '', '', '')
errno:1054
error:Unknown column 'toa_crm_contact4876_130707145252' in 'field list'

851718528

谢谢管理员，但是重置后添加客户还是显示上面的问题

851718528

msguery Error:
sql:INSERT INTO `toa_crm_company` (`number`, `title`, `user`, `bid`, `uid`, `date`, `toa_crm_company3538_130707151232`, `toa_crm_company8701_130707151018`, `toa_crm_company9793_130707150911`, `toa_crm_company8860_130707150634`, `toa_crm_company4128_130707151505`, `toa_crm_company5608_130707151553`, `toa_crm_company3983_130707151936`, `toa_crm_company1407_130707151913`, `toa_crm_company0785_130707151846`, `toa_crm_company3337_130707151924`, `toa_crm_company3616_130707151643`, `toa_crm_company8222_130707152032`, `toa_crm_company0773_130707152050`, `toa_crm_company5031_130707152058`, `toa_crm_company9083_130707152329`) VALUES ('T20210828190037', 'LED Light', '管理员', '', '1', '2021-08-28 19:01:38', '意向客户', '一星', '独立开发', '企业客户', '', '', '', '', '', '', 'www.www.cc', '', '', '', '')
errno:1292
error:Incorrect date value: '' for column 'toa_crm_company0785_130707151846' at row 1

851718528

请问管理员，你安装的正常的php和mysql版本各是多少的？

admin

851718528 发表于 2021-8-28 19:02
msguery Error:
sql:INSERT INTO `toa_crm_company` (`number`, `title`, `user`, `bid`, `uid`, `date`, ...

数据表没有生成，在CRM表单管理里，重置一下表单!所有的都点一下重置，和MYSQL没有关系

851718528

已经修改显示正常，是一排的每个表格都需要重置

851718528

已经修改显示正常，是一排的每个表格都需要重置