1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411 |
- 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
|