[error] [client 178.59.111.223] (2)No such file or directory: exec of

ishish ishish at domhain.de
Wed Aug 28 06:11:05 EDT 2013


Am 28.08.2013 10:48, schrieb Ferrous Cranus:
>> >> I quote from a Python 3 Guide
>>
>> >> [http://python.about.com/od/python30/ss/30_strings_3.htm]:
>>
>> >>
>>
>> >> The two data types, str and bytes, are mutually exclusive. One
>>
>> >> cannot
>>
>> >> legally combine them into one call. With the distinction between
>>
>> >> text
>>
>> >> and data, therefore, comes the need to convert between them.
>>
>> >>
>>
>> >>
>>
>> >
>>
>> > So, in this line:
>>
>> >
>>
>> > cur.execute('''SELECT ID FROM counters WHERE url = %s''', page )
>>
>> >
>>
>> > the variable 'page' needs conversion to what?
>>
>> >
>>
>> > all that is stores is the location of a file
>>
>> >
>>
>> > path = '/home/nikos/public_html/'
>>
>> >
>>
>> > page = form.getvalue('page')
>>
>> >
>>
>> > if not page and os.path.exists( file ):
>>
>> > # it is an html template
>>
>> > page = file.replace( path, '' )
>>
>> >
>>
>> > So chnage it to what?
>>
>> > --
>>
>> > What is now proved was at first only imagined!
>>
>>
>>
>>
>>
>> The error occurs in file
>>
>> 
>> "/usr/local/bin/python/lib/python3.3/site-packages/pymysql/cursors.py",
>>
>> line 108, in execute
>>
>> query = query % escaped_args
>>
>>
>>
>> You can check the actual values and data types using:
>>
>>
>>
>> print repr(query)
>>
>> print type(query)
>>
>>
>>
>> print repr(escaped_args)
>>
>> print type(escaped_args)
>>
>>
>>
>> Always useful is a proper exception handling using try:/except:
>
>
> hOW YOU MEAN PLEASE I TRY TO IMPLMENT WHAT YOU PROPOSE BUT I CANT.
>
> 	try:
> 		#find the needed counter for the page URL
> 		if os.path.exists( path + page ) or os.path.exists( cgi_path + page 
> ):
> 			cur.execute('''SELECT ID FROM counters WHERE url = %s''', page )
> 			data = cur.fetchone()		#URL is unique, so should only be one
>
>
> print repr('''SELECT ID FROM counters WHERE url = %s''')
> print type('''SELECT ID FROM counters WHERE url = %s''')
>
> print repr(escaped_args)
> print type(escaped_args)
>
> I MEAN IF FAILS BEFORE IT TRIES TO GO INTO MY PRINT STAEMNT.
> HOW AM I GONNA CPATURE THE QUERY?


http://i.stack.imgur.com/jiFfM.jpg

http://wiki.python.org/moin/HandlingExceptions



More information about the Python-list mailing list