Hello,

Sorry for my lack of python knowledge. As far as I know all of the
dependencies are met and the files I'm working with are good. Here's the
output I'm getting when trying to import the IMDB.

[CODE]

joh...@ears:/750/Code/Projects/MySQL/IMDB$ sudo imdbpy2sql.py -o sqlobject
-d /750/Code/Projects/MySQL/IMDB/ -u mysql://root:passw...@localhost/imdb -c
.

NOTICE: IF you're using InnoDB tables, data insertion can
be very slow; you can switch to MyISAM tables - forcing it
with the --mysql-force-myisam option - OR use the
--mysql-innodb command line option, but DON'T USE these if
you're already working on MyISAM tables, because it will
force MySQL to use InnoDB, and performances will be poor.

/usr/lib/python2.6/dist-packages/sqlobject/converters.py:165:
DeprecationWarning: the sets module is deprecated
from sets import Set, ImmutableSet
/usr/lib/python2.6/dist-packages/sqlobject/mysql/mysqlconnection.py:51:
DeprecationWarning: sqlobject_encoding is deprecated and no longer used.
deprecated("sqlobject_encoding is deprecated and no longer used.")
IMPORTING psyco... FAILED (not a big deal, everything is alright...)

RUNNING imdbpy2sql.py
SAVING imdbID values for movies... SKIPPING: no data.
SAVING imdbID values for people... SKIPPING: no data.
SAVING imdbID values for characters... SKIPPING: no data.
SAVING imdbID values for companies... SKIPPING: no data.
DROPPING current database...
Traceback (most recent call last):
File "/usr/local/bin/imdbpy2sql.py", line 5, in <module>
pkg_resources.run_script('IMDbPY==4.3', 'imdbpy2sql.py')
File "/usr/lib/python2.6/dist-packages/pkg_resources.py", line 448, in
run_script
self.require(requires)[0].run_script(script_name, ns)
File "/usr/lib/python2.6/dist-packages/pkg_resources.py", line 1166, in
run_script
execfile(script_filename, namespace, namespace)
File
"/usr/local/lib/python2.6/dist-packages/IMDbPY-4.3-py2.6-linux-i686.egg/EGG-INFO/scripts/imdbpy2sql.py",
line 2788, in <module>
run()
File
"/usr/local/lib/python2.6/dist-packages/IMDbPY-4.3-py2.6-linux-i686.egg/EGG-INFO/scripts/imdbpy2sql.py",
line 2616, in run
dropTables(DB_TABLES)
File
"/usr/local/lib/python2.6/dist-packages/IMDbPY-4.3-py2.6-linux-i686.egg/imdb/parser/sql/dbschema.py",
line 417, in dropTables
table.dropTable(ifExists)
File "/usr/lib/python2.6/dist-packages/sqlobject/main.py", line 1370, in
dropTable
if ifExists and not cls.tableExists(connection=conn):
File "/usr/lib/python2.6/dist-packages/sqlobject/main.py", line 1363, in
tableExists
return conn.tableExists(cls.sqlmeta.table)
File "/usr/lib/python2.6/dist-packages/sqlobject/mysql/mysqlconnection.py",
line 193, in tableExists
self.query('DESCRIBE %s' % (tableName))
File "/usr/lib/python2.6/dist-packages/sqlobject/dbconnection.py", line 337,
in query
return self._runWithConnection(self._query, s)
File "/usr/lib/python2.6/dist-packages/sqlobject/dbconnection.py", line 250,
in _runWithConnection
val = meth(conn, *args)
File "/usr/lib/python2.6/dist-packages/sqlobject/dbconnection.py", line 334,
in _query
self._executeRetry(conn, conn.cursor(), s)
File "/usr/lib/python2.6/dist-packages/sqlobject/mysql/mysqlconnection.py",
line 127, in _executeRetry
raise InternalError(ErrorMessage(e))
sqlobject.dberrors.InternalError: Can't create/write to file
'/750/tmp/mysql/#sql_46a1_0.MYI' (Errcode: 17)
joh...@ears:/750/Code/Projects/MySQL/IMDB$

[/CODE]


I've also tried without specifying the -o option and changing sqlobject to
sqlalchemy
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help

Reply via email to