Thilanka, could you have a look at this bug? I can reproduce it.
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=3392824...
Hi Marc,
On Wed, Aug 17, 2011 at 10:32 PM, Marc Delisle marc@infomarc.info wrote:
Thilanka, could you have a look at this bug? I can reproduce it.
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=3392824...
I'll go through this.
Regards, Thilanka.
Hi Marc,
I went through this issue and I found this with non ajax enabled situation also. So this should be a bug which is not produced by ajax modifications. I'll g through it and update you soon as possible. Thank you.
Regards, Thilanka.
On Thu, Aug 18, 2011 at 6:42 AM, Thilanka Kaushalya lgtkaushalya@gmail.comwrote:
Hi Marc,
On Wed, Aug 17, 2011 at 10:32 PM, Marc Delisle marc@infomarc.info wrote:
Thilanka, could you have a look at this bug? I can reproduce it.
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=3392824...
I'll go through this.
Regards, Thilanka.
-- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka
Connect with me at, Gmail : lgtkaushalya@gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya@yahoo.com Blog : http://coders-view.blogspot.com/
Hi Marc,
I found the place where this issue generates. When we try click on Table->Structure->Column->Change link it goes to the tbl_alter.php file and within that the "append_fields_form" is process by using tbl_properties.inc.php file. At line number 325 in tbl_properties.inc.php "PMA_getSupportedDatatypes(true, $type_upper);" function is call to get the table type select options.
You can find at line 3118 in "PMA_getSupportedDatatypes(true, $type_upper);" the option selection is set as *if ($selected == $value) {* * $retval .= "<option selected='selected'>$value</option>";* * } else {* * $retval .= "<option>$value</option>";* * }* But if you use an echo you can see that *$selected contains *VARCHAR(45) as the value and *$value contains *VARCHAR as the value. So when we try to edit the tables which are having VARCHAR type columns it does not select the value at the options.
I can modify the logic by splitting the *$selected *by "(" and solve the issue. Is there any better solution you can suggest. If there any please let me know. Thank you.
Regards, Thilanka.
-
Marc Delisle -
Thilanka Kaushalya