Vtiger:我无法添加待办事项事件
如果我进入日历,单击“待办事项”,然后尝试添加一个事件,会弹出表单,我填写它,按“保存”,但没有添加任何事件。 在 SQL 错误日志中,我看到这样的错误:
2011-09-29 14:57:07 EDT ERROR: null value in column "visibility" violates not-null constraint
2011-09-29 14:57:07 EDT STATEMENT: insert into
vtiger_activity(activityid,subject,date_start,time_start,time_end,due_date,status,eventstatus,priority,sendnotification,activitytype,visibility,duration_hours,duration_minutes,location,recurringtype,notime)
values('235','Testing','2011-09-29','19:50',NULL,'2011-09-29','Not Started',NULL,'High','0','Task',NULL,NULL,NULL,NULL,NULL,'0')
因此,由于某种原因,它试图在插入空值时添加待办事项。我最大的问题是我无法找到查询的来源。因此,基本上,我要问的最重要的事情是哪个文件获取输入到 todosave 表单中的数据并将其转换为查询。
我不知道这里是否有很多人使用 Vtiger,但我无法弄清楚这一点,所以我还是继续发布了。我认为官方文档没有太大帮助。
感谢所做的一切,祝你有美好的一天。
If I got to calendar, click on To Do, then try to add an event, the form pops up, I fill it out, press save, but no Event gets added.
In the SQL error log's I see an error like this:
2011-09-29 14:57:07 EDT ERROR: null value in column "visibility" violates not-null constraint
2011-09-29 14:57:07 EDT STATEMENT: insert into
vtiger_activity(activityid,subject,date_start,time_start,time_end,due_date,status,eventstatus,priority,sendnotification,activitytype,visibility,duration_hours,duration_minutes,location,recurringtype,notime)
values('235','Testing','2011-09-29','19:50',NULL,'2011-09-29','Not Started',NULL,'High','0','Task',NULL,NULL,NULL,NULL,NULL,'0')
So, for some reason, it is trying to add a To-Do while inserting null values. My biggest problem is that I cannot locate the origin of the query. So, basically, the most important thing I am asking is what file takes the data that was input into the todosave form and turns it into a query.
I don't know if many people on here use Vtiger, but I couldn't figure this out so I went ahead and posted anyway. The official documentation is not very helpful in my opinion.
Thanks for everything, have a good day.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这可能是一个孤立的案例,但最近是否修改了任何模块?在这种情况下,我假设它是日历模块。我已经在演示网站和我的 vTiger 安装上对此进行了测试,它工作正常。
也许您可以下载 vTiger 的新副本并替换模块/日历的所有内容。
顺便说一句,如果您有任何问题,另一个可以询问的地方是 vTiger 论坛。
http://forums.vtiger.com/index.php
通常你可以在帮助中询问- 5.2.1 节。希望这有帮助!
This might be an isolated case, but was any of the modules modified recently? In this case, I would assume that it would be the Calendar module. I've tested this on the demo website and on my vTiger installation and it works fine..
Perhaps you can download a fresh copy of vTiger and replace the modules/Calendar all its content.
By the way, another place to ask if you have any questions, is the vTiger forums.
http://forums.vtiger.com/index.php
Usually you can ask it in the Help - 5.2.1 section. Hope this helps!