Getting "OperationalError: 1366" from python script - MySQL 5.6 . MySQLdb 1.2.3 -

-

environment:

  • mysql-python-1.2.3.win-amd64-py2.7

  • python-2.7.amd64

  • mysql-installer-community-5.6.12.2

  • windows server 2008 r2 datacenter

i getting operational error 1366 when inserting data python script. need run epfimporter 2010

i think problem mysqldb can handle uft8 not utf8mb4_unicode_ci. data need import contains utf8mb4 charackters , may not remove them.

running script cmd comand line gives me following error message after succesfully inserted ~70.000 rows:

2013-07-31 15:14:53,460 [error]: fatal error encountered while ingesting 'c:\webserver\www\site1\assets\scripts traceback (most recent call last):   file "c:\webserver\www\site1\assets\scripts\epfimporter\epfingester.py", line 129, in ingestfull     self._populatetable(self.tmptablename, skipkeyviolators=skipkeyviolators)   file "c:\webserver\www\site1\assets\scripts\epfimporter\epfingester.py", line 379, in _populatetable     cur.execute(exstr)   file "c:\windows\python\lib\site-packages\mysqldb\cursors.py", line 174, in execute     self.errorhandler(self, exc, value)   file "c:\windows\python\lib\site-packages\mysqldb\connections.py", line 36, in defaulterrorhandler     raise errorclass, errorvalue operationalerror: (1366, "incorrect string value: '\\xf0\\x9f\\x98\\x8a a...' column 'description' @ row 1")

i allready made:

alter database databasexyz character set = utf8mb4 collate = utf8mb4_unicode_ci

and changed following innodb to:

default storage engine  myisam  documentation default tmp storage engine  myisam

before change not importing row @ all.

what else can do? should working since on shared host running on mysql server version: 5.5.28 , worked fine

edit1: testing installed latest xampp version , under xampp script running fine having xampp-mysql server running not apache. python , mysqldb versions remained same before , untouched. pretty sure did wrong in configuration of mysql-server. in xampp db running innodb engine.

here speccs of xampp mysql server:

server: 127.0.0.1 via tcp/ip server type: mysql server version: 5.6.11 - mysql community server (gpl) protocol version: 10 user: root@localhost server charset: utf-8 unicode (utf8)

does has idea trace down problem in original mysql setup? in variable setting, mysql error handling or python connector?

i solved problem comparing xampp-mysql , regular mysql values in phpmyadmin > localhost > variables

i changed few values in regular mysql variables not 100% sure change solved issue guess changing to:

sql mode    no_engine_substitution

i had few more other values strict_mode in there before deleted.


Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more