php - 我如何在 Agiletookit 中调试与数据库相关的错误？攻击力4

Question

我知道 $m->debug();如前所述here

但我不确定应该如何开始调试以下问题。我的方法是在 dsql.php 中执行 var_dump 并比较字段，然后在 OOP 层中逐步向上。我想知道是否有一些简单的方法可以做同样的事情。

实际错误:

/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/DB/dsql.php  :1518   bozims_db_db_dsql_mysql DB_dsql_mysql-  >exception("Database Query Failed")

完整日志

/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/BaseException.php    :63     Exception_DB    Exception_DB->collectBasicData(Null)
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/AbstractObject.php   :545    Exception_DB    Exception_DB->__construct("Database Query Failed", Null)
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/DB/dsql.php  :1518   bozims_db_db_dsql_mysql DB_dsql_mysql->exception("Database Query Failed")
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/DB/dsql.php  :1545   bozims_db_db_dsql_mysql DB_dsql_mysql->execute()
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/SQL/Model.php    :635    bozims_db_db_dsql_mysql DB_dsql_mysql->insert()
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/SQL/Model.php    :610    bozims_fileadmin_form_Upload_test_filestore_model_file  filestore\Model_File->insert()
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/Form/Field/Upload.php    :143    bozims_fileadmin_form_Upload_test_filestore_model_file  filestore\Model_File->save()
/   :   bozims_fileadmin_form_Upload_test   Form_Field_Upload->loadPOST(Object(Form))
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/AbstractObject.php   :786        Loggercall_user_func_array(Array(2), Array(1))
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/Form/Basic.php   :348    bozims_fileadmin_form   Form->hook("loadPOST")
/   :   bozims_fileadmin_form   Form->submitted(Object(Frontend))
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/AbstractObject.php   :786        Loggercall_user_func_array(Array(2), Array(1))
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/atk4/lib/ApiWeb.php   :290    bozims  Frontend->hook("submitted")
/Users/Qambar/Work/VERYCOOLAWESOMEPROJECT/index.php :5  bozims  Frontend->main()

Answer 1

通常 - 执行一个 debug() ，它会给你一个查询本身。将查询复制粘贴到 SQL 控制台。如果您在那里遇到错误，请尝试了解原因。

您还可以使用 setActualFields 来缩小查询的字段列表，这将使您的查询更简单。

这应该可以帮助您缩小问题范围。