symfony - Symfony2 and Doctrine 2 result data incorrectly returns an array of nulls -


i have query run in doctrine; failing, in weird way. query has worked year, messed composer.json bit adding couple new libraries, , changing versions. updated linux box (maybe mysql or mariadb has been updated, not sure).

whatever has changed (doubtful it's bundle's doctrine model code, unless wasn't kosher in first place , core update reveals broken), query returning results, array of correct amount of keys, values getting nulled somehow. array looks this, direct copy , paste var_dump, e.g. 

var_dump($query->getsql()); var_dump($results); exit;  select goallabel opt_goals scale = 'mathematics'  array(17) { [0]=> null [1]=> null [2]=> null [3]=> null [4]=> null [5]=> null [6]=> null [7]=> null [8]=> null [9]=> null [10]=> null [11]=> null [12]=> null [13]=> null [14]=> null [15]=> null [16]=> null }

but when run same query in mysql command line, actual results, same amount of keys, values are there.

here's non default portion of composer.json require section:

    "components/jquery": "~1.11,<2.0",     "twbs/bootstrap": "3.3.*",     "braincrafted/bootstrap-bundle": "~2.1",     "knplabs/knp-menu": "~1.1",     "knplabs/knp-menu-bundle": "~1.1",     "knplabs/knp-paginator-bundle": "dev-master",     "symfony/icu": "1.1.*",     "mnot/hinclude": "dev-master",     "rhumsaa/array_column": "~1.1",     "webfactory/exceptions-bundle": "@stable",     "friendsofsymfony/jsrouting-bundle": "~1.5",     "hearsay/require-js-bundle": "~1.0",     "browserstate/history.js": "dev-master"

pay close attention version adjustments, because did mess this. don't know @ point doctrine went off deep end.

edit: per latest comments, , now seeing this, going on? this url more appropriate because not using doctrine/dbal, i'm using doctrine/orm.

this problem caused updating of doctrine/orm version 2.5 2.4.x. there lot of bc breaks.

downgrade doctrine/orm https://packagist.org/packages/doctrine/orm#v2.4.7 , problem go away. after knowing issue, need rewrite queries satisfy new requirements. did see note in there mariadb problem well.

in fact, since haven't tackled yet myself, might easy regenerating entities. i'm hesitant when that....


Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more