INFO 2019-10-17 10:11:05,598 basehttp 124 "GET /areas/ HTTP/1.1" 200 10 INFO 2019-10-17 13:26:27,171 autoreload 597 Watching for file changes with StatReloader INFO 2019-10-17 13:27:09,435 autoreload 217 E:\12446\PycharmProjects\wangli\wanjia\awj\awj\setting\dev.py changed, reloading. INFO 2019-10-17 13:27:10,260 autoreload 597 Watching for file changes with StatReloader INFO 2019-10-17 13:27:35,090 autoreload 217 E:\12446\PycharmProjects\wangli\wanjia\awj\awj\setting\dev.py changed, reloading. INFO 2019-10-17 13:27:35,938 autoreload 597 Watching for file changes with StatReloader INFO 2019-10-17 13:28:06,660 autoreload 597 Watching for file changes with StatReloader INFO 2019-10-17 13:28:39,906 autoreload 597 Watching for file changes with StatReloader WARNING 2019-10-17 14:12:35,299 log 228 Not Found: /areas/ WARNING 2019-10-17 14:12:35,300 basehttp 154 "GET /areas/ HTTP/1.1" 404 1955 WARNING 2019-10-17 14:12:37,216 log 228 Not Found: /areas/ WARNING 2019-10-17 14:12:37,216 basehttp 154 "GET /areas/ HTTP/1.1" 404 1955 INFO 2019-10-17 14:15:22,231 basehttp 154 "GET /areas/ HTTP/1.1" 200 10 INFO 2019-10-17 14:15:45,505 basehttp 154 "GET /areas/ HTTP/1.1" 200 10 ERROR 2019-10-17 14:21:46,626 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 11, in get with connection.cursor() as cursor: File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:21:46,628 basehttp 154 "GET /areas/ HTTP/1.1" 500 99869 ERROR 2019-10-17 14:22:09,101 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 11, in get with connection.cursor() as cursor: File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:22:09,103 basehttp 154 "GET /areas/ HTTP/1.1" 500 99864 ERROR 2019-10-17 14:23:11,195 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 11, in get with connection.cursor() as cursor: File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:23:11,197 basehttp 154 "GET /areas/ HTTP/1.1" 500 99866 ERROR 2019-10-17 14:23:55,955 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 11, in get with connection.cursor() as cursor: File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:23:55,957 basehttp 154 "GET /areas/ HTTP/1.1" 500 99876 ERROR 2019-10-17 14:24:23,614 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 11, in get with connection.cursor() as cursor: File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:24:23,615 basehttp 154 "GET /areas/ HTTP/1.1" 500 99876 ERROR 2019-10-17 14:26:39,285 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 14, in get with connection.cursor() as cursor: File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:26:39,287 basehttp 154 "GET /areas/ HTTP/1.1" 500 100119 ERROR 2019-10-17 14:29:28,143 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 11, in get with connection.cursor() as cursor: File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:29:28,145 basehttp 154 "GET /areas/ HTTP/1.1" 500 99876 ERROR 2019-10-17 14:36:51,606 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 11, in get with connection.cursor() as cursor: File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:36:51,608 basehttp 154 "GET /areas/ HTTP/1.1" 500 99792 ERROR 2019-10-17 14:38:25,722 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 12, in get cursor = connection.cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:38:25,723 basehttp 154 "GET /areas/ HTTP/1.1" 500 99949 ERROR 2019-10-17 14:44:01,821 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 12, in get cursor = connection.cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:44:01,823 basehttp 154 "GET /areas/ HTTP/1.1" 500 99949 ERROR 2019-10-17 14:46:00,691 log 228 Internal Server Error: /areas/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 11, in get with connection.cursor() as cursor: File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\base\base.py", line 196, in connect self.init_connection_state() File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 365, in init_connection_state "The database driver doesn't support modern datatime types.") django.core.exceptions.ImproperlyConfigured: The database driver doesn't support modern datatime types. ERROR 2019-10-17 14:46:00,693 basehttp 154 "GET /areas/ HTTP/1.1" 500 100396 WARNING 2019-10-17 14:46:00,830 log 228 Not Found: /favicon.ico WARNING 2019-10-17 14:46:00,832 basehttp 154 "GET /favicon.ico HTTP/1.1" 404 2126 INFO 2019-10-17 14:48:52,834 basehttp 154 "GET /areas/ HTTP/1.1" 200 10 INFO 2019-10-17 14:52:36,899 basehttp 154 "GET /areas/ HTTP/1.1" 200 10 INFO 2019-10-17 16:21:08,859 basehttp 154 "GET /areas/ HTTP/1.1" 200 10 WARNING 2019-10-17 17:33:38,727 log 228 Forbidden (CSRF cookie not set.): /areas/ WARNING 2019-10-17 17:33:38,727 basehttp 154 "POST /areas/ HTTP/1.1" 403 2868 INFO 2019-10-17 17:33:42,872 basehttp 154 "GET /areas/ HTTP/1.1" 200 10 INFO 2019-10-17 17:34:25,001 basehttp 154 "GET /invoice/ HTTP/1.1" 200 10 WARNING 2019-10-17 17:40:06,205 log 228 Forbidden (CSRF cookie not set.): /invoice/ WARNING 2019-10-17 17:40:06,206 basehttp 154 "POST /invoice/ HTTP/1.1" 403 2868 ERROR 2019-10-17 17:40:59,373 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 137, in _get_response "returned None instead." % (callback.__module__, view_name) ValueError: The view stockinvoice.views.InvoiceView didn't return an HttpResponse object. It returned None instead. ERROR 2019-10-17 17:40:59,374 basehttp 154 "POST /invoice/ HTTP/1.1" 500 61366 INFO 2019-10-17 17:42:00,134 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 ERROR 2019-10-17 17:44:11,957 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 581, in fetchone row = self.cursor.fetchone() pyodbc.ProgrammingError: No results. Previous SQL was not a query. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 14, in get row = cursor.fetchone() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 581, in fetchone row = self.cursor.fetchone() django.db.utils.ProgrammingError: No results. Previous SQL was not a query. ERROR 2019-10-17 17:44:11,959 basehttp 154 "GET /invoice/ HTTP/1.1" 500 102978 ERROR 2019-10-17 17:45:20,027 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 581, in fetchone row = self.cursor.fetchone() pyodbc.ProgrammingError: No results. Previous SQL was not a query. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 14, in get row = cursor.fetchone() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 581, in fetchone row = self.cursor.fetchone() django.db.utils.ProgrammingError: No results. Previous SQL was not a query. ERROR 2019-10-17 17:45:20,028 basehttp 154 "GET /invoice/ HTTP/1.1" 500 103115 INFO 2019-10-17 17:45:40,818 basehttp 154 "GET /invoice/ HTTP/1.1" 200 10 ERROR 2019-10-17 17:47:14,790 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 581, in fetchone row = self.cursor.fetchone() pyodbc.ProgrammingError: No results. Previous SQL was not a query. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 14, in get row = cursor.fetchone() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 581, in fetchone row = self.cursor.fetchone() django.db.utils.ProgrammingError: No results. Previous SQL was not a query. ERROR 2019-10-17 17:47:14,792 basehttp 154 "GET /invoice/ HTTP/1.1" 500 103115 ERROR 2019-10-17 17:47:52,312 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 581, in fetchone row = self.cursor.fetchone() pyodbc.ProgrammingError: No results. Previous SQL was not a query. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 14, in get row = cursor.fetchone() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 581, in fetchone row = self.cursor.fetchone() django.db.utils.ProgrammingError: No results. Previous SQL was not a query. ERROR 2019-10-17 17:47:52,314 basehttp 154 "GET /invoice/ HTTP/1.1" 500 103117 ERROR 2019-10-17 17:52:52,408 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 594, in fetchall return self.format_rows(self.cursor.fetchall()) pyodbc.ProgrammingError: No results. Previous SQL was not a query. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 14, in get row = cursor.fetchall() File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 96, in inner return func(*args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 594, in fetchall return self.format_rows(self.cursor.fetchall()) django.db.utils.ProgrammingError: No results. Previous SQL was not a query. ERROR 2019-10-17 17:52:52,409 basehttp 154 "GET /invoice/ HTTP/1.1" 500 102677 INFO 2019-10-17 17:59:44,327 basehttp 154 "GET /invoice/ HTTP/1.1" 200 10 INFO 2019-10-17 18:00:03,991 basehttp 154 "GET /invoice/ HTTP/1.1" 200 10 INFO 2019-10-17 18:01:04,025 basehttp 154 "GET /invoice/ HTTP/1.1" 200 10 INFO 2019-10-17 18:01:52,909 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 ERROR 2019-10-17 18:03:36,505 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 83, in _execute return self.cursor.execute(sql) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42S22', "[42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]列名 'CUS_NO' 无效。 (207) (SQLExecDirectW)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 12, in get cursor.execute("INSERT INTO PRDT(CUS_NO,NAME)VALUES ('QQ12345','DSDADADA')") File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 83, in _execute return self.cursor.execute(sql) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42S22', "[42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]列名 'CUS_NO' 无效。 (207) (SQLExecDirectW)") ERROR 2019-10-17 18:03:36,507 basehttp 154 "GET /invoice/ HTTP/1.1" 500 119454 ERROR 2019-10-17 18:04:03,824 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 83, in _execute return self.cursor.execute(sql) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]'`' 附近有语法错误。 (102) (SQLExecDirectW)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 12, in get cursor.execute("INSERT INTO PRDT(CUS_NO,`NAME`)VALUES ('QQ12345','DSDADADA')") File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 83, in _execute return self.cursor.execute(sql) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]'`' 附近有语法错误。 (102) (SQLExecDirectW)") ERROR 2019-10-17 18:04:03,825 basehttp 154 "GET /invoice/ HTTP/1.1" 500 119498 ERROR 2019-10-17 18:05:23,538 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 83, in _execute return self.cursor.execute(sql) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42S22', "[42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]列名 'CUS_NO' 无效。 (207) (SQLExecDirectW)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 12, in get cursor.execute("INSERT INTO PRDT(CUS_NO,[NAME])VALUES ('QQ12345','DSDADADA')") File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 83, in _execute return self.cursor.execute(sql) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42S22', "[42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]列名 'CUS_NO' 无效。 (207) (SQLExecDirectW)") ERROR 2019-10-17 18:05:23,540 basehttp 154 "GET /invoice/ HTTP/1.1" 500 119474 ERROR 2019-10-17 18:06:14,326 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42S22', "[42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]列名 'CUS_NO' 无效。 (207) (SQLExecDirectW); [42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 12, in get cursor.execute("INSERT INTO PRDT(CUS_NO,[NAME])VALUES ('QQ12345',%s)",[a]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42S22', "[42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]列名 'CUS_NO' 无效。 (207) (SQLExecDirectW); [42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") ERROR 2019-10-17 18:06:14,328 basehttp 154 "GET /invoice/ HTTP/1.1" 500 120137 INFO 2019-10-17 18:06:36,521 basehttp 154 "GET /invoice/ HTTP/1.1" 200 10 INFO 2019-10-17 21:27:12,877 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:08:39,806 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:11:55,840 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:12:22,921 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:12:43,199 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:13:51,143 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 ERROR 2019-10-17 22:15:09,179 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]对象名 'SLAM' 无效。 (208) (SQLExecDirectW); [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 54, in post row_usr = cursor.execute("SELECT COUNT(*) FROM SLAM WHERE CUS_NO=%s",[USR]).fetchall()[0][0] File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42S02', "[42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]对象名 'SLAM' 无效。 (208) (SQLExecDirectW); [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") ERROR 2019-10-17 22:15:09,183 basehttp 154 "POST /invoice/ HTTP/1.1" 500 124347 ERROR 2019-10-17 22:15:33,723 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]对象名 'SLAM' 无效。 (208) (SQLExecDirectW); [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 54, in post row_usr = cursor.execute("SELECT COUNT(*) FROM SLAM WHERE SAL_NO=%s",[USR]).fetchall()[0][0] File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42S02', "[42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]对象名 'SLAM' 无效。 (208) (SQLExecDirectW); [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") ERROR 2019-10-17 22:15:33,727 basehttp 154 "POST /invoice/ HTTP/1.1" 500 124350 INFO 2019-10-17 22:16:30,085 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:19:35,485 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:19:41,014 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:22:30,127 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:22:32,199 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:31:58,427 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:32:25,280 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:32:37,349 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:32:56,619 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:34:21,074 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:56:34,519 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:57:58,780 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:58:01,718 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:58:30,375 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:58:46,584 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-17 22:59:12,091 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 WARNING 2019-10-17 23:07:47,139 log 228 Forbidden: /invoice/ WARNING 2019-10-17 23:07:47,140 basehttp 154 "POST /invoice/ HTTP/1.1" 403 12 ERROR 2019-10-17 23:14:23,137 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.IntegrityError: ('23000', "[23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]违反了 PRIMARY KEY 约束 'PK__MF_PSS'。不能在对象 'dbo.MF_PSS' 中插入重复键。 (2627) (SQLExecDirectW); [23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]语句已终止。 (3621)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 75, in post datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.IntegrityError: ('23000', "[23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]违反了 PRIMARY KEY 约束 'PK__MF_PSS'。不能在对象 'dbo.MF_PSS' 中插入重复键。 (2627) (SQLExecDirectW); [23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]语句已终止。 (3621)") ERROR 2019-10-17 23:14:23,139 basehttp 154 "POST /invoice/ HTTP/1.1" 500 129497 ERROR 2019-10-17 23:15:02,233 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 78, in post VALUES('PC',%s,%s,'0000','AQ001',,1,1,%f,%f,5,1,1,%f)""", ['PC'+ZL_NO[2::], datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT,AMT,AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 542, in execute sql = self.format_sql(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 510, in format_sql sql = sql % tuple('?' * len(params)) TypeError: must be real number, not str ERROR 2019-10-17 23:15:02,235 basehttp 154 "POST /invoice/ HTTP/1.1" 500 111057 ERROR 2019-10-17 23:17:43,751 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 78, in post VALUES('PC',%s,%s,'0000','AQ001',1,1,%f,%f,5,1,1,%f)""", ['PC'+ZL_NO[2::], datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT,AMT,AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 542, in execute sql = self.format_sql(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 510, in format_sql sql = sql % tuple('?' * len(params)) TypeError: must be real number, not str ERROR 2019-10-17 23:17:43,754 basehttp 154 "POST /invoice/ HTTP/1.1" 500 111047 ERROR 2019-10-17 23:24:18,477 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.IntegrityError: ('23000', "[23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]违反了 PRIMARY KEY 约束 'PK__MF_PSS'。不能在对象 'dbo.MF_PSS' 中插入重复键。 (2627) (SQLExecDirectW); [23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]语句已终止。 (3621)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 75, in post datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.IntegrityError: ('23000', "[23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]违反了 PRIMARY KEY 约束 'PK__MF_PSS'。不能在对象 'dbo.MF_PSS' 中插入重复键。 (2627) (SQLExecDirectW); [23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]语句已终止。 (3621)") ERROR 2019-10-17 23:24:18,480 basehttp 154 "POST /invoice/ HTTP/1.1" 500 129530 INFO 2019-10-17 23:24:39,910 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 ERROR 2019-10-18 14:08:39,860 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.IntegrityError: ('23000', "[23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]违反了 PRIMARY KEY 约束 'PK__MF_PSS'。不能在对象 'dbo.MF_PSS' 中插入重复键。 (2627) (SQLExecDirectW); [23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]语句已终止。 (3621)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 75, in post datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.IntegrityError: ('23000', "[23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]违反了 PRIMARY KEY 约束 'PK__MF_PSS'。不能在对象 'dbo.MF_PSS' 中插入重复键。 (2627) (SQLExecDirectW); [23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]语句已终止。 (3621)") ERROR 2019-10-18 14:08:39,897 basehttp 154 "POST /invoice/ HTTP/1.1" 500 129655 INFO 2019-10-18 14:10:22,226 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-18 14:12:42,840 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 ERROR 2019-10-18 14:24:23,829 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 87, in post datetime.datetime.strptime(LZ_DD,'%Y-%m-%d'),INV_NO,AMT,AMT,AMT,datetime.datetime.strptime(LZ_DD,'%Y-%m-%d')]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 542, in execute sql = self.format_sql(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 510, in format_sql sql = sql % tuple('?' * len(params)) TypeError: not all arguments converted during string formatting ERROR 2019-10-18 14:24:23,831 basehttp 154 "POST /invoice/ HTTP/1.1" 500 112068 ERROR 2019-10-18 14:26:22,690 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 87, in post datetime.datetime.strptime(LZ_DD,'%Y-%m-%d'),INV_NO,datetime.datetime.strptime(LZ_DD,'%Y-%m-%d')]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 542, in execute sql = self.format_sql(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 510, in format_sql sql = sql % tuple('?' * len(params)) TypeError: not all arguments converted during string formatting ERROR 2019-10-18 14:26:22,695 basehttp 154 "POST /invoice/ HTTP/1.1" 500 111683 ERROR 2019-10-18 14:27:31,739 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 87, in post datetime.datetime.strptime(LZ_DD,'%Y-%m-%d'),INV_NO,datetime.datetime.strptime(LZ_DD,'%Y-%m-%d')]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 542, in execute sql = self.format_sql(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 510, in format_sql sql = sql % tuple('?' * len(params)) TypeError: not all arguments converted during string formatting ERROR 2019-10-18 14:27:31,740 basehttp 154 "POST /invoice/ HTTP/1.1" 500 111600 INFO 2019-10-18 14:29:33,513 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-18 14:30:49,220 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-18 14:33:54,856 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-18 16:55:49,676 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 WARNING 2019-10-18 17:35:41,041 log 228 Forbidden: /invoice/ WARNING 2019-10-18 17:35:41,042 basehttp 154 "POST /invoice/ HTTP/1.1" 403 12 WARNING 2019-10-18 17:36:40,118 log 228 Forbidden: /invoice/ WARNING 2019-10-18 17:36:40,118 basehttp 154 "POST /invoice/ HTTP/1.1" 403 12 WARNING 2019-10-18 17:37:26,363 log 228 Forbidden: /invoice/ WARNING 2019-10-18 17:37:26,363 basehttp 154 "POST /invoice/ HTTP/1.1" 403 12 ERROR 2019-10-18 17:40:08,827 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]'，' 附近有语法错误。 (102) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 71, in post row_usr = cursor.execute("SELECT COUNT(*) FROM SALM WHERE SAL_NO=%s，NAME=%s",[USR,USR_NAME]).fetchall()[0][0] File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]'，' 附近有语法错误。 (102) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") ERROR 2019-10-18 17:40:08,829 basehttp 154 "POST /invoice/ HTTP/1.1" 500 126022 ERROR 2019-10-18 17:42:05,691 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 91, in post UNI_NO_PAY,SAL_ADR,SAL_TEL,SAL_KH_BANK,SAL_ID_CODE]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 542, in execute sql = self.format_sql(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 510, in format_sql sql = sql % tuple('?' * len(params)) TypeError: not enough arguments for format string ERROR 2019-10-18 17:42:05,693 basehttp 154 "POST /invoice/ HTTP/1.1" 500 114075 INFO 2019-10-18 18:14:39,620 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 ERROR 2019-10-18 18:19:40,492 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 108, in post (%,200001,'LP',21,%s,%s,%s,%s,1,1,1)""", [ZL_NO, CUS_NO,CUS_NO_NAME,CUS_NO_NAME,AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 542, in execute sql = self.format_sql(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 510, in format_sql sql = sql % tuple('?' * len(params)) ValueError: unsupported format character ',' (0x2c) at index 123 ERROR 2019-10-18 18:19:40,494 basehttp 154 "POST /invoice/ HTTP/1.1" 500 112036 INFO 2019-10-18 18:20:06,062 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-18 18:24:54,648 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-18 18:43:21,037 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 ERROR 2019-10-18 19:37:18,327 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'UP'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'UP' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 84, in post VALUES('PC',%s,%s,'0000','AQ001',1,1,%s,%s,5,1,1,%s,%s)""", ['PC'+ZL_NO[2::], datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT,AMT,AMT,AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'UP'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'UP' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") ERROR 2019-10-18 19:37:18,330 basehttp 154 "POST /invoice/ HTTP/1.1" 500 131455 ERROR 2019-10-18 19:39:04,222 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 84, in post VALUES('PC',%s,%s,'0000','AQ001',1,%s,%s,%s,5,1,1,%s,%s)""", ['PC'+ZL_NO[2::], datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT,AMT,AMT,AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 542, in execute sql = self.format_sql(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 510, in format_sql sql = sql % tuple('?' * len(params)) TypeError: not enough arguments for format string ERROR 2019-10-18 19:39:04,224 basehttp 154 "POST /invoice/ HTTP/1.1" 500 113069 ERROR 2019-10-18 19:41:17,426 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 84, in post VALUES('PC',%s,%s,'0000','AQ001',1,%s,%s,%s,5,1,1,%s,%s)""", ['PC'+ZL_NO[2::], datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT,AMT,AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 542, in execute sql = self.format_sql(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 510, in format_sql sql = sql % tuple('?' * len(params)) TypeError: not enough arguments for format string ERROR 2019-10-18 19:41:17,428 basehttp 154 "POST /invoice/ HTTP/1.1" 500 112945 ERROR 2019-10-18 19:41:50,353 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.IntegrityError: ('23000', "[23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]违反了 PRIMARY KEY 约束 'PK__MF_PSS'。不能在对象 'dbo.MF_PSS' 中插入重复键。 (2627) (SQLExecDirectW); [23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]语句已终止。 (3621)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 81, in post datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.IntegrityError: ('23000', "[23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]违反了 PRIMARY KEY 约束 'PK__MF_PSS'。不能在对象 'dbo.MF_PSS' 中插入重复键。 (2627) (SQLExecDirectW); [23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]语句已终止。 (3621)") ERROR 2019-10-18 19:41:50,355 basehttp 154 "POST /invoice/ HTTP/1.1" 500 130619 ERROR 2019-10-18 19:42:27,658 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'UP'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'UP' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 84, in post VALUES('PC',%s,%s,'0000','AQ001',1,1,%s,%s,5,1,1,%s,%s)""", ['PC'+ZL_NO[2::], datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT,AMT,AMT,AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'UP'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'UP' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") ERROR 2019-10-18 19:42:27,659 basehttp 154 "POST /invoice/ HTTP/1.1" 500 131458 ERROR 2019-10-18 19:43:44,138 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'UP'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'UP' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 84, in post VALUES('PC',%s,%s,'0000','AQ001',1,1,%s,%s,5,1,1,%s,%s)""", ['PC'+ZL_NO[2::], datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT,AMT,AMT,AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'UP'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'UP' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") ERROR 2019-10-18 19:43:44,139 basehttp 154 "POST /invoice/ HTTP/1.1" 500 131458 ERROR 2019-10-18 19:45:12,557 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'UP'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'UP' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 84, in post VALUES('PC',%s,%s,'0000','AQ001',1,1,%s,%s,5,1,1,%s,%s)""", ['PC'+ZL_NO[2::], datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),AMT,AMT,AMT,AMT]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'UP'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'UP' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") ERROR 2019-10-18 19:45:12,560 basehttp 154 "POST /invoice/ HTTP/1.1" 500 131458 ERROR 2019-10-18 19:47:07,834 log 228 Internal Server Error: /invoice/ Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'EST_ITM'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'EST_ITM' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\12446\Envs\awj\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 68, in view return self.dispatch(request, *args, **kwargs) File "C:\Users\12446\Envs\awj\lib\site-packages\django\views\generic\base.py", line 88, in dispatch return handler(request, *args, **kwargs) File "E:\12446\PycharmProjects\wangli\wanjia\awj\awj\apps\stockinvoice\views.py", line 108, in post ('LP',%s,1,%s,%s,%s,'AQ001',0,%s,5,1,1,'PC',1,'服務費用',%s,1,1,1)""", [ZL_NO,'PC'+ZL_NO[2::],AMT,AMT,datetime.datetime.strptime(LZ_DD, '%Y-%m-%d'),CUS_NO]) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\12446\Envs\awj\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Users\12446\Envs\awj\lib\site-packages\sql_server\pyodbc\base.py", line 546, in execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]在 SET 子句中多次指定了列名 'EST_ITM'。在同一 SET 子句中不得为一个列分配多个值。请修改 SET 子句，以确保一个列仅更新一次。如果 SET 子句更新了某视图的多列，那么列名 'EST_ITM' 可能会在该视图定义中出现两次。 (264) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。 (8180)") ERROR 2019-10-18 19:47:07,836 basehttp 154 "POST /invoice/ HTTP/1.1" 500 131500 INFO 2019-10-18 19:48:39,128 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-18 19:52:03,188 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25 INFO 2019-10-18 20:02:22,372 basehttp 154 "POST /invoice/ HTTP/1.1" 200 25