default userpic

Bug in php/lib/mtdb_base.php line 229 - list() causes only first result in a array to be returned

Vote 0 Votes

227 function fetch_config() {
228 $sql = "select * from mt_config";
229 list($row) = $this->get_results($sql, ARRAY_A);
230 if (!$row) return null;
231 return $row;
232 }

the use of list here is problematic if the desire is to return multiple rows of config values from the mt_config table. In a multirow result list() will only grab the results in the first array it encounters.

its not clear to me the design of mt_config because MT is stuffing all config values into one row (seems to defeat the point of using a table). since its a table I would assume mutliple rows is the intent (no matter what the MT kernel is doing with the base config values), and thus this function seems broken.

the fix is obvious, iterate over the returned hash and merge the results (pretty nasty results, but its what the caller would expect at least).

Though I have not installed any of the 5beta branches it seems like those will have a similar problem as the code still doesnt look for multiple rows returned - tho that code doesnt seem to make sense to me at all since I dont see where Load learns to select from mt_config, the table is not passed in a class.mt_config.php Load function, which is what I would have expected looking at that code.

Reported on Movable Type 4.25

1 Reply

| Add a Reply

Add a Reply

If you need to share template code, replace all the "<" signs with "&lt;" or use this utility.

Forum Groups

1773 6162

Last Topic: Excluding categories from blog by kholechek on Feb 9, 2012

86 302

Last Topic: website entries by masoud on Oct 26, 2011

1429 5077

Last Topic: What apocalypse hit this community in the middle of 2011? by 75th on Feb 10, 2012

695 2910

Last Topic: Insert Image / File Fails by Russ Miller on Feb 10, 2012

84 291

Last Topic: How to have some other characters in entry basename automatically written by Afshin Haghighatnia on Dec 22, 2011

173 737

Last Topic: About the MT version stated in HTML source by Alex E. Schneider on Feb 7, 2012

190 567

Last Topic: Analytics Reporting by michael webster on Feb 5, 2012

48 210

Last Topic: An idea and also a request by Afshin Haghighatnia on Jun 29, 2011

64 246

Last Topic: jQuery in MT 5.1 still at 1.4 - why? by perlmonkey on May 25, 2011

code.sixapart.com

137 478

Last Topic: Getting a thumbnail with xpath by Peter on Mar 13, 2011

222 720

Last Topic: Custom Field for Asset Not Appearing by android on Feb 9, 2012