tpc at csua.berkeley.edu
tpc at csua.berkeley.edu
Tue Oct 21 11:12:46 EST 2003
hello all, I am trying to index and search mp3s in my Apache document root. Whenever executing a database select statement that retrieves the URL and title (the filename minus the .mp3 extension) of mp3s whose filenames contain the words I type into a web form, I get a "invalid literal for float" error message. The same script works fine on the command line and in IDLE. The error messages vary, and I sometimes see "invalid literal for int" or "invalid literal for long" though now it seems I just get "invalid literal for float." Also the error seems to come and go, and sometimes I get the results I want. I have gotten this type of message before when playing around with Python and trying to convert, say, a string to int, but this has me scratching my head: Mod_python error: "PythonHandler mod_python.publisher" Traceback (most recent call last): File "/usr/lib/python2.2/site-packages/mod_python/apache.py", line 335, in HandlerDispatch result = object(req) File "/usr/lib/python2.2/site-packages/mod_python/publisher.py", line 194, in handler result = apply(object, (), args) File "/var/www/html/python/temp-invalidtest.py", line 45, in search results = getMP3SearchResults(terms) File "/var/www/html/python/temp-invalidtest.py", line 14, in getMP3SearchResults results = getMatchingURLs(cursor) File "/var/www/html/python/temp-invalidtest.py", line 40, in getMatchingURLs cursor.execute(sql) File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line 95, in execute return self._execute(query, args) File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line 114, in _execute self.errorhandler(self, exc, value) File "/usr/lib/python2.2/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler raise errorclass, errorvalue ValueError: invalid literal for float(): <insert any mp3 title here>
|