Remove all tables from a MySQL schema

by GarciaPL on Thursday, 6 March 2014

A few days ago I found very useful solution (thanks for Biomathematicus!) for deleting tables from a MySQL schema. I know that it could be quite difficult for some developers (also for me) to manually remove every table from schema without removing this schema itself. So, there is a two-step solution which is going to help you removing a lot of tables from SQL database.

1) List all tables in the MySQL schema :

SELECT CONCAT('drop table ',table_name,'; ')
FROM information_schema.tables
WHERE table_schema = 'yourDatabaseName';

2) Copy result and paste it to query window and execute.
drop table table1; 
drop table table2;

Reference : [1] Biomathematicus.blogspot.com Remove all tables from mysql schema

Confitura 2013 - my participation

by GarciaPL on Sunday, 9 February 2014

I really really would like to share with a video of my participation on conference called "Confitura" in the year 2013.

Confitura is the largest free conference for Java developers in Europe and even the largest event of its kind in Poland. 6 July this year on the campus of the University of Warsaw will be the next edition of our conference. From year to year we develop and we host a growing number of enthusiasts programming, a year ago there were more than 800. This year we expect nearly 1,000 people, for whom we have prepared five parallel tracks of almost 30 lectures.

More information you can find on : http://2013.confitura.pl/

Video : http://www.youtube.com/watch?v=HAuVAgeBqyQ



You can see when I am talking a lot of about many interesting and clever things starting from 0:34 second of this video ;) Enjoy.

Django - 'charmap' codec can't encode characters in position

by GarciaPL on Wednesday, 1 January 2014

I used to have a problem while I was developing some application using Django (Python Web Framework). This problem occurs when I received some data from some kind of source using for example JSON notation. When this data contains some custom characters which should be saved in Unicode notation, I received and error like this one :

'charmap' codec can't encode characters in position
The solution of this issue is quite easy - everything applies to encoding of your file with source code. In this case I used to editor called PyDev (Eclipse based) in which you should go to :
Windows -> Preferences -> General -> Workspace
after that change option 'Text File Encoding' to UTF-8

References : [1] Django Python Web Framework [2] Stackoverflow.com Newcomer error in parsing tweet json unicodeencodeerror charmap codec cant encode characters in position 13-63: character maps to <undefined>

phpPgAdmin - Login disallowed

by GarciaPL on Saturday, 21 December 2013

Few days ago I had pleasure to install on my web server called XAMPP delivered by Apache Friends one of the management tool for PostgreSQL called PhpPgAdmin. I must to say that installation is very easy, all you have to do is to put extracted files of this tool to htdocs folder, edit config located on phpPgAdmin/conf/config.inc.php and just run index.php through your web browser.

Unfortunately in my case there was some issue with connecting to PostgreSQL database. I had message something like "Login disallowed". I spent a lot of time to figure out the right solution, which I am going to share with you.

Just go to file on this path - phpPgAdmin/conf/config.inc.php and just change

$conf['extra_login_security'] = true


on


$conf['extra_login_security'] = false



Reference : [1] PhpPgAdmin Home Page [2] XAMPP Home Page

jQuery 1.6+ Change attr to prop

by GarciaPL on Saturday, 7 December 2013

In the last days I was working on project which used one of the most powerful Javascript library jQuery in version 1.4.4. Yes, I know this version of jQuery is quite outdated. So, we decided to change it into jQuery 1.6.1. We expected some problems with change of library version, but what we discovered during looking for application errors was the change of handling of attributes and DOM object properties. I mean change function .attr to .prop

Before when we used jQuery 1.4.4 it was :


        jQuery 1.4 attr
        
        
    
    
        
        
    

Starting from jQuery 1.6+ it is :

        jQuery 1.6 prop
        
        
    
    
        
        
    



Reference : [1] Bugs.jquery.com Ticket 9088 [2] Ejohn.org - jQuery 1.6 and attr

Python PyXML gcc problem

by GarciaPL on Sunday, 10 November 2013

I would like to give you some advice how to solve the problem which brought you here. So, I had a problem with installing on Ubuntu 12.04.3 LTS one of Python module called PyXML which can be used for XML Processing. I would like to give below a very very long description of error which I was faced with during the installation of PyXML.


python2.5 setup.py build
running build
running build_py
running build_ext
building '_xmlplus.parsers.pyexpat' extension
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall 
-Wstrict-prototypes -fPIC -DXML_NS=1 -DXML_DTD=1 -DBYTEORDER=1234 
-DXML_CONTEXT_BYTES=1024 -DHAVE_MEMMOVE=1 -Iextensions/expat/lib 
-I/usr/include/python2.5 -c extensions/pyexpat.c -o 
build/temp.linux-i686-2.5/extensions/pyexpat.o
extensions/pyexpat.c:5:20: error: Python.h: No such file or directory
extensions/pyexpat.c:8:21: error: compile.h: No such file or directory
extensions/pyexpat.c:9:25: error: frameobject.h: No such file or directory
extensions/pyexpat.c:63: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:70: error: expected specifier-qualifier-list before 
‘PyObject_HEAD’
extensions/pyexpat.c:89: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘Xmlparsetype’
extensions/pyexpat.c:98: error: expected specifier-qualifier-list before 
‘PyCodeObject’
extensions/pyexpat.c:108: error: expected ‘)’ before ‘*’ token
extensions/pyexpat.c:123: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c: In function ‘have_handler’:
extensions/pyexpat.c:150: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:150: error: (Each undeclared identifier is reported 
only once
extensions/pyexpat.c:150: error: for each function it appears in.)
extensions/pyexpat.c:150: error: ‘handler’ undeclared (first use in this 
function)
extensions/pyexpat.c:150: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c: At top level:
extensions/pyexpat.c:154: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:201: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:214: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c: In function ‘flag_error’:
extensions/pyexpat.c:248: error: ‘xmlparseobject’ has no member named 
‘itself’
extensions/pyexpat.c: At top level:
extensions/pyexpat.c:252: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:305: error: expected ‘)’ before ‘*’ token
extensions/pyexpat.c:332: error: expected ‘)’ before ‘*’ token
extensions/pyexpat.c:367: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:419: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c: In function ‘call_character_handler’:
extensions/pyexpat.c:444: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:444: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:445: error: ‘temp’ undeclared (first use in this 
function)
extensions/pyexpat.c:447: warning: implicit declaration of function 
‘PyTuple_New’
extensions/pyexpat.c:455: warning: implicit declaration of function 
‘conv_string_len_to_utf8’
extensions/pyexpat.c:458: warning: implicit declaration of function 
‘Py_DECREF’
extensions/pyexpat.c:462: warning: implicit declaration of function 
‘PyTuple_SET_ITEM’
extensions/pyexpat.c:464: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:465: warning: implicit declaration of function 
‘call_with_frame’
extensions/pyexpat.c:465: warning: implicit declaration of function 
‘getcode’
extensions/pyexpat.c:466: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:468: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘flush_character_buffer’:
extensions/pyexpat.c:482: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:482: error: ‘xmlparseobject’ has no member named 
‘buffer_used’
extensions/pyexpat.c:484: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:484: error: ‘xmlparseobject’ has no member named 
‘buffer_used’
extensions/pyexpat.c:485: error: ‘xmlparseobject’ has no member named 
‘buffer_used’
extensions/pyexpat.c: In function ‘my_CharacterDataHandler’:
extensions/pyexpat.c:493: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:496: error: ‘xmlparseobject’ has no member named 
‘buffer_used’
extensions/pyexpat.c:496: error: ‘xmlparseobject’ has no member named 
‘buffer_size’
extensions/pyexpat.c:505: error: ‘xmlparseobject’ has no member named 
‘buffer_size’
extensions/pyexpat.c:507: error: ‘xmlparseobject’ has no member named 
‘buffer_used’
extensions/pyexpat.c:510: warning: implicit declaration of function ‘memcpy’
extensions/pyexpat.c:510: warning: incompatible implicit declaration of 
built-in function ‘memcpy’
extensions/pyexpat.c:510: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:510: error: ‘xmlparseobject’ has no member named 
‘buffer_used’
extensions/pyexpat.c:512: error: ‘xmlparseobject’ has no member named 
‘buffer_used’
extensions/pyexpat.c: In function ‘my_StartElementHandler’:
extensions/pyexpat.c:524: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:524: error: ‘container’ undeclared (first use in 
this function)
extensions/pyexpat.c:524: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:524: warning: left-hand operand of comma expression 
has no effect
extensions/pyexpat.c:524: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:524: warning: left-hand operand of comma expression 
has no effect
extensions/pyexpat.c:532: error: ‘xmlparseobject’ has no member named 
‘specified_attributes’
extensions/pyexpat.c:533: error: ‘xmlparseobject’ has no member named 
‘itself’
extensions/pyexpat.c:541: error: ‘xmlparseobject’ has no member named 
‘ordered_attributes’
extensions/pyexpat.c:542: warning: implicit declaration of function 
‘PyList_New’
extensions/pyexpat.c:544: warning: implicit declaration of function 
‘PyDict_New’
extensions/pyexpat.c:550: error: ‘n’ undeclared (first use in this function)
extensions/pyexpat.c:550: warning: implicit declaration of function 
‘string_intern’
extensions/pyexpat.c:551: error: ‘v’ undeclared (first use in this function)
extensions/pyexpat.c:557: warning: implicit declaration of function 
‘conv_string_to_utf8’
extensions/pyexpat.c:564: error: ‘xmlparseobject’ has no member named 
‘ordered_attributes’
extensions/pyexpat.c:565: warning: implicit declaration of function 
‘PyList_SET_ITEM’
extensions/pyexpat.c:568: warning: implicit declaration of function 
‘PyDict_SetItem’
extensions/pyexpat.c:579: warning: implicit declaration of function 
‘Py_BuildValue’
extensions/pyexpat.c:585: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:587: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:588: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_EndElementHandler’:
extensions/pyexpat.c:636: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:636: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:636: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:636: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:636: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:636: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_ProcessingInstructionHandler’:
extensions/pyexpat.c:640: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:640: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:640: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:640: error: ‘conv_string_to_utf8’ undeclared (first 
use in this function)
extensions/pyexpat.c:640: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:640: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:640: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_UnparsedEntityDeclHandler’:
extensions/pyexpat.c:646: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:646: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:646: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:646: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:646: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:646: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_EntityDeclHandler’:
extensions/pyexpat.c:659: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:659: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:659: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:659: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:659: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:659: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_XmlDeclHandler’:
extensions/pyexpat.c:696: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:696: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:696: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:696: error: ‘conv_string_to_utf8’ undeclared (first 
use in this function)
extensions/pyexpat.c:696: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:696: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:696: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: At top level:
extensions/pyexpat.c:705: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c: In function ‘my_ElementDeclHandler’:
extensions/pyexpat.c:737: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:737: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:740: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:741: error: ‘modelobj’ undeclared (first use in 
this function)
extensions/pyexpat.c:741: error: ‘nameobj’ undeclared (first use in this 
function)
extensions/pyexpat.c:741: warning: left-hand operand of comma expression 
has no effect
extensions/pyexpat.c:751: warning: implicit declaration of function 
‘conv_content_model’
extensions/pyexpat.c:751: error: ‘conv_string_to_utf8’ undeclared (first 
use in this function)
extensions/pyexpat.c:769: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:771: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:772: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:780: warning: implicit declaration of function 
‘Py_XDECREF’
extensions/pyexpat.c:781: error: ‘xmlparseobject’ has no member named 
‘itself’
extensions/pyexpat.c: In function ‘my_AttlistDeclHandler’:
extensions/pyexpat.c:785: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:785: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:785: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:785: error: ‘conv_string_to_utf8’ undeclared (first 
use in this function)
extensions/pyexpat.c:785: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:785: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:785: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_SkippedEntityHandler’:
extensions/pyexpat.c:798: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:798: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:798: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:798: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:798: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:798: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_NotationDeclHandler’:
extensions/pyexpat.c:806: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:806: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:806: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:806: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:806: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:806: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_StartNamespaceDeclHandler’:
extensions/pyexpat.c:816: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:816: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:816: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:816: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:816: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:816: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_EndNamespaceDeclHandler’:
extensions/pyexpat.c:823: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:823: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:823: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:823: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:823: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:823: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_CommentHandler’:
extensions/pyexpat.c:828: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:828: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:828: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:828: error: ‘conv_string_to_utf8’ undeclared (first 
use in this function)
extensions/pyexpat.c:828: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:828: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:828: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_StartCdataSectionHandler’:
extensions/pyexpat.c:832: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:832: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:832: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:832: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:832: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:832: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_EndCdataSectionHandler’:
extensions/pyexpat.c:836: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:836: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:836: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:836: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:836: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:836: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_DefaultHandler’:
extensions/pyexpat.c:841: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:841: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:841: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:841: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:841: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:841: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_DefaultHandlerExpandHandler’:
extensions/pyexpat.c:845: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:845: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:845: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:845: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:845: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:845: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_NotStandaloneHandler’:
extensions/pyexpat.c:862: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:862: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:862: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:862: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:862: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:862: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:862: warning: implicit declaration of function 
‘PyInt_AsLong’
extensions/pyexpat.c: In function ‘my_ExternalEntityRefHandler’:
extensions/pyexpat.c:866: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:866: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:866: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:866: error: ‘conv_string_to_utf8’ undeclared (first 
use in this function)
extensions/pyexpat.c:866: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:866: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:866: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_StartDoctypeDeclHandler’:
extensions/pyexpat.c:881: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:881: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:881: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:881: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:881: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:881: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: In function ‘my_EndDoctypeDeclHandler’:
extensions/pyexpat.c:889: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:889: error: ‘args’ undeclared (first use in this 
function)
extensions/pyexpat.c:889: error: ‘rv’ undeclared (first use in this 
function)
extensions/pyexpat.c:889: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c:889: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:889: error: ‘xmlparseobject’ has no member named 
‘in_callback’
extensions/pyexpat.c: At top level:
extensions/pyexpat.c:893: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:912: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:930: error: expected declaration specifiers or 
‘...’ before ‘PyObject’
extensions/pyexpat.c: In function ‘readinst’:
extensions/pyexpat.c:932: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:932: error: ‘arg’ undeclared (first use in this 
function)
extensions/pyexpat.c:933: error: ‘bytes’ undeclared (first use in this 
function)
extensions/pyexpat.c:934: error: ‘str’ undeclared (first use in this 
function)
extensions/pyexpat.c:937: warning: implicit declaration of function 
‘PyInt_FromLong’
extensions/pyexpat.c:948: warning: implicit declaration of function 
‘PyObject_CallObject’
extensions/pyexpat.c:948: error: ‘meth’ undeclared (first use in this 
function)
extensions/pyexpat.c:956: warning: implicit declaration of function 
‘PyString_Check’
extensions/pyexpat.c:957: warning: implicit declaration of function 
‘PyErr_Format’
extensions/pyexpat.c:957: error: ‘PyExc_TypeError’ undeclared (first use 
in this function)
extensions/pyexpat.c:962: warning: implicit declaration of function 
‘PyString_GET_SIZE’
extensions/pyexpat.c:964: error: ‘PyExc_ValueError’ undeclared (first 
use in this function)
extensions/pyexpat.c:970: warning: incompatible implicit declaration of 
built-in function ‘memcpy’
extensions/pyexpat.c:970: warning: implicit declaration of function 
‘PyString_AsString’
extensions/pyexpat.c:970: warning: passing argument 2 of ‘memcpy’ makes 
pointer from integer without a cast
extensions/pyexpat.c:970: note: expected ‘const void *’ but argument is 
of type ‘int’
extensions/pyexpat.c: At top level:
extensions/pyexpat.c:981: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1044: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1062: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1077: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1108: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1203: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1223: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1242: error: array type has incomplete element type
extensions/pyexpat.c:1243: error: ‘PyCFunction’ undeclared here (not in 
a function)
extensions/pyexpat.c:1243: error: expected ‘}’ before ‘xmlparse_Parse’
extensions/pyexpat.c:1245: error: expected ‘}’ before ‘xmlparse_ParseFile’
extensions/pyexpat.c:1247: error: expected ‘}’ before ‘xmlparse_SetBase’
extensions/pyexpat.c:1249: error: expected ‘}’ before ‘xmlparse_GetBase’
extensions/pyexpat.c:1251: error: expected ‘}’ before 
‘xmlparse_ExternalEntityParserCreate’
extensions/pyexpat.c:1253: error: expected ‘}’ before 
‘xmlparse_SetParamEntityParsing’
extensions/pyexpat.c:1255: error: expected ‘}’ before 
‘xmlparse_GetInputContext’
extensions/pyexpat.c:1258: error: expected ‘}’ before 
‘xmlparse_UseForeignDTD’
extensions/pyexpat.c:1320: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c: In function ‘xmlparse_dealloc’:
extensions/pyexpat.c:1395: warning: implicit declaration of function 
‘PyObject_GC_Fini’
extensions/pyexpat.c:1397: error: ‘xmlparseobject’ has no member named 
‘itself’
extensions/pyexpat.c:1398: error: ‘xmlparseobject’ has no member named 
‘itself’
extensions/pyexpat.c:1399: error: ‘xmlparseobject’ has no member named 
‘itself’
extensions/pyexpat.c:1401: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:1402: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:1402: error: ‘temp’ undeclared (first use in this 
function)
extensions/pyexpat.c:1404: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:1405: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:1408: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:1409: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:1411: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:1412: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:1413: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:1415: error: ‘xmlparseobject’ has no member named 
‘intern’
extensions/pyexpat.c:1418: warning: implicit declaration of function 
‘PyObject_Del’
extensions/pyexpat.c: In function ‘handlername2int’:
extensions/pyexpat.c:1430: warning: implicit declaration of function 
‘strcmp’
extensions/pyexpat.c: At top level:
extensions/pyexpat.c:1437: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1445: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1549: error: expected declaration specifiers or 
‘...’ before ‘PyObject’
extensions/pyexpat.c: In function ‘sethandler’:
extensions/pyexpat.c:1554: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:1554: error: ‘temp’ undeclared (first use in this 
function)
extensions/pyexpat.c:1554: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:1556: error: ‘v’ undeclared (first use in this 
function)
extensions/pyexpat.c:1556: error: ‘Py_None’ undeclared (first use in 
this function)
extensions/pyexpat.c:1559: warning: implicit declaration of function 
‘Py_INCREF’
extensions/pyexpat.c:1562: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:1564: error: ‘xmlparseobject’ has no member named 
‘itself’
extensions/pyexpat.c: At top level:
extensions/pyexpat.c:1571: error: expected declaration specifiers or 
‘...’ before ‘PyObject’
extensions/pyexpat.c: In function ‘xmlparse_setattr’:
extensions/pyexpat.c:1574: error: ‘v’ undeclared (first use in this 
function)
extensions/pyexpat.c:1575: warning: implicit declaration of function 
‘PyErr_SetString’
extensions/pyexpat.c:1575: error: ‘PyExc_RuntimeError’ undeclared (first 
use in this function)
extensions/pyexpat.c:1579: warning: implicit declaration of function 
‘PyObject_IsTrue’
extensions/pyexpat.c:1580: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:1581: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:1581: error: ‘xmlparseobject’ has no member named 
‘buffer_size’
extensions/pyexpat.c:1582: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:1583: warning: implicit declaration of function 
‘PyErr_NoMemory’
extensions/pyexpat.c:1586: error: ‘xmlparseobject’ has no member named 
‘buffer_used’
extensions/pyexpat.c:1589: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:1592: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:1593: error: ‘xmlparseobject’ has no member named 
‘buffer’
extensions/pyexpat.c:1599: error: ‘xmlparseobject’ has no member named 
‘ns_prefixes’
extensions/pyexpat.c:1601: error: ‘xmlparseobject’ has no member named 
‘ns_prefixes’
extensions/pyexpat.c:1602: error: ‘xmlparseobject’ has no member named 
‘itself’
extensions/pyexpat.c:1602: error: ‘xmlparseobject’ has no member named 
‘ns_prefixes’
extensions/pyexpat.c:1607: error: ‘xmlparseobject’ has no member named 
‘ordered_attributes’
extensions/pyexpat.c:1609: error: ‘xmlparseobject’ has no member named 
‘ordered_attributes’
extensions/pyexpat.c:1615: error: ‘PyExc_ValueError’ undeclared (first 
use in this function)
extensions/pyexpat.c:1623: error: ‘xmlparseobject’ has no member named 
‘returns_unicode’
extensions/pyexpat.c:1628: error: ‘xmlparseobject’ has no member named 
‘specified_attributes’
extensions/pyexpat.c:1630: error: ‘xmlparseobject’ has no member named 
‘specified_attributes’
extensions/pyexpat.c:1642: error: too many arguments to function 
‘sethandler’
extensions/pyexpat.c:1645: error: ‘PyExc_AttributeError’ undeclared 
(first use in this function)
extensions/pyexpat.c: At top level:
extensions/pyexpat.c:1676: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘Xmlparsetype’
extensions/pyexpat.c:1719: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1766: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c:1778: error: array type has incomplete element type
extensions/pyexpat.c:1779: error: expected ‘}’ before ‘pyexpat_ParserCreate’
extensions/pyexpat.c:1781: error: expected ‘}’ before ‘pyexpat_ErrorString’
extensions/pyexpat.c:1797: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or 
‘__attribute__’ before ‘*’ token
extensions/pyexpat.c: In function ‘initpyexpat’:
extensions/pyexpat.c:1835: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:1835: error: ‘m’ undeclared (first use in this 
function)
extensions/pyexpat.c:1835: error: ‘d’ undeclared (first use in this 
function)
extensions/pyexpat.c:1835: warning: left-hand operand of comma 
expression has no effect
extensions/pyexpat.c:1836: error: ‘errmod_name’ undeclared (first use in 
this function)
extensions/pyexpat.c:1836: warning: implicit declaration of function 
‘PyString_FromString’
extensions/pyexpat.c:1837: error: ‘errors_module’ undeclared (first use 
in this function)
extensions/pyexpat.c:1838: error: ‘modelmod_name’ undeclared (first use 
in this function)
extensions/pyexpat.c:1839: error: ‘model_module’ undeclared (first use 
in this function)
extensions/pyexpat.c:1840: error: ‘sys_modules’ undeclared (first use in 
this function)
extensions/pyexpat.c:1848: error: ‘Xmlparsetype’ undeclared (first use 
in this function)
extensions/pyexpat.c:1848: error: ‘PyType_Type’ undeclared (first use in 
this function)
extensions/pyexpat.c:1851: warning: implicit declaration of function 
‘Py_InitModule3’
extensions/pyexpat.c:1855: error: ‘ErrorObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:1856: warning: implicit declaration of function 
‘PyErr_NewException’
extensions/pyexpat.c:1862: warning: implicit declaration of function 
‘PyModule_AddObject’
extensions/pyexpat.c:1866: error: expected expression before ‘)’ token
extensions/pyexpat.c:1868: warning: implicit declaration of function 
‘get_version_string’
extensions/pyexpat.c:1869: warning: implicit declaration of function 
‘PyModule_AddStringConstant’
extensions/pyexpat.c:1889: warning: implicit declaration of function 
‘PySys_GetObject’
extensions/pyexpat.c:1890: warning: implicit declaration of function 
‘PyModule_GetDict’
extensions/pyexpat.c:1891: warning: implicit declaration of function 
‘PyDict_GetItem’
extensions/pyexpat.c:1893: warning: implicit declaration of function 
‘PyModule_New’
extensions/pyexpat.c:1918: error: ‘list’ undeclared (first use in this 
function)
extensions/pyexpat.c:1921: warning: implicit declaration of function 
‘PyErr_Clear’
extensions/pyexpat.c:1926: error: ‘item’ undeclared (first use in this 
function)
extensions/pyexpat.c:1933: warning: implicit declaration of function 
‘PyList_Append’
extensions/pyexpat.c:1996: warning: implicit declaration of function 
‘PyModule_AddIntConstant’
extensions/pyexpat.c: In function ‘clear_handlers’:
extensions/pyexpat.c:2023: error: ‘PyObject’ undeclared (first use in 
this function)
extensions/pyexpat.c:2023: error: ‘temp’ undeclared (first use in this 
function)
extensions/pyexpat.c:2027: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:2029: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:2030: error: ‘xmlparseobject’ has no member named 
‘handlers’
extensions/pyexpat.c:2032: error: ‘xmlparseobject’ has no member named 
‘itself’
error: command 'gcc' failed with exit status 1


Quite enormous, isn't it ? :) So, fix of this problem is very easy - just install python-dev package in Ubuntu. You can use this command in your terminal :

sudo apt-get install python-dev


Reference : [1] Gmane.org XML Processing [2] PyXML Home Page Project