[Phpmyadmin-devel] GSOC Interesting

[Marc Delisle]

Le 2011-03-19 16:56, Andreas Lundquist a écrit :
> 2011/3/19 Marc Delisle <marc at infomarc.info>
> 
>>
>> Please give a test case of what you are trying to inline edit. Server
>> error 500 is at the server level (a level below phpMyAdmin) and not
>> related to it.
>>
>> Anyway if there were an error in the generated Javascript, it would be
>> seen at the browser's js console level, not at the server level.
>>
>>
> Say we have a table with any columns.
> 1. Then I go to Browse tab.
> 2. Click on Inline edit on a row.
> 3. Edit something or not, no difference.
> 4. Click on Save.
> 5. Nothing happen instantly as it should. I get an 500 Internal Server Error
> on the POST request to tbl_replace.php if I look in the console of firebug.
> 6. If I refresh the page the data has been saved to db.
> 
> This is the information of the POST request.
> 
> Response Headers:
> Date Sat, 19 Mar 2011 20:45:16 GMT
> Server Apache/2.2.15 (Linux/SUSE)
> X-Powered-By PHP/5.3.3
> Expires Thu, 19 Nov 1981 08:52:00 GMT
> Cache-Control no-cache
> Last-Modified Sat, 19 Mar 2011 13:56:38 GMT
> Set-Cookie pma_collation_connection=deleted; expires=Fri, 19-Mar-2010
> 20:45:15 GMT; path=/dev/phpmyadmin/; httponly
> Content-Length 0
> Connection close
> Content-Type application/json
> Request Headersview source
> Host localhost
> User-Agent Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.13)
> Gecko/20101203 SUSE/3.6.13-0.2.1 Firefox/3.6.13
> Accept */*
> Accept-Language en-us,en;q=0.5
> Accept-Encoding gzip,deflate
> Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
> Keep-Alive 115
> Connection keep-alive
> Content-Type application/x-www-form-urlencoded; charset=UTF-8
> X-Requested-With XMLHttpRequest
> Referer
> http://localhost/dev/phpmyadmin/sql.php?target=sql.php&token=64bf55643b883a9f0d50ac20c98cce7f&db=test&table=editing
> Content-Length 385
> Cookie pma_lang=en; pma_mcrypt_iv=vAABnpGDcJE%3D; pmaUser-1=kAtkNtgOL2Y%3D;
> pma_navi_width=200; phpMyAdmin=5g1ro8fuo6ndm2jj4ra1n0b8l33400hv;
> pmaPass-1=57Nm6BuuBU8%3D
> 
> Parameters:
> ajax_request true
> clause_is_unique 1
> db test
> disp_direction horizontal
> do_transformations false
> goto sql.php
> rel_fields_list
> sql_query UPDATE `editing` SET `id`='1' , `name`='hej' WHERE `editing`.`id`
> = 1
> submit_type save
> table editing
> token 64bf55643b883a9f0d50ac20c98cce7f
> transform_fields_list
> where_clause %60editing%60.%60id%60+%3D+1

Are you using phpMyAdmin 3.4.0-beta4 or the git master version?

Is your PHP compiled with JSON support? (it's possible to disable JSON
at compile time).


-- 
Marc Delisle
http://infomarc.info