thread up :) !! waiting for someone to answer :) @maureen, good luck ;)
On Thu, Feb 17, 2011 at 12:57 PM, Maureen Soriano <[email protected]>wrote: > hi guys, > > i have found this through my study. i followed the instructions from > this link > http://code.google.com/p/mc-goog-visualization/wiki/UserDocumentation > and downloaded its package but still, i encountered errors. i think > this code causes error > > ?php > > require_once 'MC/Google/Visualization.php'; > > $db=new PDO ('mysql:host=localhost;database=pelopsx', 'root', > 'admin'); > > $vis = new MC_Google_Visualization($db, 'mysql'); > > $vis->addEntity('dlogs', array( > > 'dlogs'=>array( > > 'col1'=>array('cal','number'), > > 'col2'=> array('met','number') > > ) > > )); > > $vis->handleRequest(); > > ?> > > its error is > > Notice (8): Undefined index: table [APP/MC/Google/Visualization.php, > line 785] > > Code | Context > > */ > > public function addEntity($name, $spec=array()) { > > $entity = array('table' => ($spec['table']) ? $spec['table'] : $name, > 'fields' => array(), 'joins' => array()); > > $name = "dlogs" > > $spec = array( > > "dlogs" => array( > > "col1" => array(), > > "col2" => array() > > ) > > ) > > MC_Google_Visualization::addEntity() - APP/MC/Google/ > Visualization.php, line 785 > > include - APP/views/pages/test1.ctp, line 49 > > View::_render() - CORE/cake/libs/view/view.php, line 718 > > View::render() - CORE/cake/libs/view/view.php, line 417 > > Controller::render() - CORE/cake/libs/controller/controller.php, line > 861 > > PagesController::display() - CORE/cake/libs/controller/ > pages_controller.php, line 88 > > Object::dispatchMethod() - CORE/cake/libs/object.php, line 125 > > Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 240 > > Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206 > > [main] - APP/webroot/index.php, line 83 > > Notice (8): Undefined index: tq [APP/MC/Google/Visualization.php, line > 136] > > Code > > */ > > public function handleRequest() { > > $query = $_GET['tq']; > > MC_Google_Visualization::handleRequest() - APP/MC/Google/ > Visualization.php, line 136 > > include - APP/views/pages/test1.ctp, line 51 > > View::_render() - CORE/cake/libs/view/view.php, line 718 > > View::render() - CORE/cake/libs/view/view.php, line 417 > > Controller::render() - CORE/cake/libs/controller/controller.php, line > 861 > > PagesController::display() - CORE/cake/libs/controller/ > pages_controller.php, line 88 > > Object::dispatchMethod() - CORE/cake/libs/object.php, line 125 > > Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 240 > > Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206 > > [main] - APP/webroot/index.php, line 83 > > Notice (8): Undefined index: tqx [APP/MC/Google/Visualization.php, > line 138] > > Code | Context > > $query = $_GET['tq']; > > $params = array('version' => $this->version, 'responseHandler' => > 'google.visualization.Query.setResponse'); > > $paramlist = explode(';', $_GET['tqx']); > > $query = null > > $params = array( > > "version" => 0.5, > > "responseHandler" => "google.visualization.Query.setResponse" > > ) > > MC_Google_Visualization::handleRequest() - APP/MC/Google/ > Visualization.php, line 138 > > include - APP/views/pages/test1.ctp, line 51 > > View::_render() - CORE/cake/libs/view/view.php, line 718 > > View::render() - CORE/cake/libs/view/view.php, line 417 > > Controller::render() - CORE/cake/libs/controller/controller.php, line > 861 > > PagesController::display() - CORE/cake/libs/controller/ > pages_controller.php, line 88 > > Object::dispatchMethod() - CORE/cake/libs/object.php, line 125 > > Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 240 > > Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206 > > [main] - APP/webroot/index.php, line 83 > > Notice (8): Undefined offset: 1 [APP/MC/Google/Visualization.php, line > 140] > > Code | Context > > $paramlist = explode(';', $_GET['tqx']); > > foreach($paramlist as $paramstr) { > > list($name, $val) = explode(':', $paramstr); > > $query = null > > $params = array( > > "version" => 0.5, > > "responseHandler" => "google.visualization.Query.setResponse" > > ) > > $paramlist = array( > > "" > > ) > > $paramstr = "" > > MC_Google_Visualization::handleRequest() - APP/MC/Google/ > Visualization.php, line 140 > > include - APP/views/pages/test1.ctp, line 51 > > View::_render() - CORE/cake/libs/view/view.php, line 718 > > View::render() - CORE/cake/libs/view/view.php, line 417 > > Controller::render() - CORE/cake/libs/controller/controller.php, line > 861 > > PagesController::display() - CORE/cake/libs/controller/ > pages_controller.php, line 88 > > Object::dispatchMethod() - CORE/cake/libs/object.php, line 125 > > Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 240 > > Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206 > > [main] - APP/webroot/index.php, line 83 > > Notice (8): Undefined index: reqId [APP/MC/Google/Visualization.php, > line 144] > > Code | Context > > } > > $params['reqId'] = (int) $params['reqId']; > > $query = null > > $params = array( > > "version" => 0.5, > > "responseHandler" => "google.visualization.Query.setResponse", > > "" => null > > ) > > $paramlist = array( > > "" > > ) > > $paramstr = "" > > $val = null > > $name = "" > > MC_Google_Visualization::handleRequest() - APP/MC/Google/ > Visualization.php, line 144 > > include - APP/views/pages/test1.ctp, line 51 > > View::_render() - CORE/cake/libs/view/view.php, line 718 > > View::render() - CORE/cake/libs/view/view.php, line 417 > > Controller::render() - CORE/cake/libs/controller/controller.php, line > 861 > > PagesController::display() - CORE/cake/libs/controller/ > pages_controller.php, line 88 > > Object::dispatchMethod() - CORE/cake/libs/object.php, line 125 > > Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 240 > > Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206 > > [main] - APP/webroot/index.php, line 83 > > Notice (8): Uninitialized string offset: 0 [APP/MC/Parser/Def.php, > line 58] > > Code | Context > > list($loc, $tok) = $this->_parse($str, $loc); > > $char = $str[$loc++]; > > $str = "" > > $loc = 1 > > $tok = null > > MC_Parser_Def::parsePart() - APP/MC/Parser/Def.php, line 58 > > MC_Parser_Def_OneOf::_parse() - APP/MC/Parser/Def/OneOf.php, line 40 > > MC_Parser_Def::parsePart() - APP/MC/Parser/Def.php, line 56 > > MC_Parser_Def_Set::_parse() - APP/MC/Parser/Def/Set.php, line 38 > > MC_Parser_Def::parsePart() - APP/MC/Parser/Def.php, line 56 > > MC_Parser_Def::parse() - APP/MC/Parser/Def.php, line 42 > > MC_Google_Visualization::parseQuery() - APP/MC/Google/ > Visualization.php, line 671 > > MC_Google_Visualization::handleQuery() - APP/MC/Google/ > Visualization.php, line 169 > > MC_Google_Visualization::handleRequest() - APP/MC/Google/ > Visualization.php, line 154 > > include - APP/views/pages/test1.ctp, line 51 > > View::_render() - CORE/cake/libs/view/view.php, line 718 > > View::render() - CORE/cake/libs/view/view.php, line 417 > > Controller::render() - CORE/cake/libs/controller/controller.php, line > 861 > > PagesController::display() - CORE/cake/libs/controller/ > pages_controller.php, line 88 > > Object::dispatchMethod() - CORE/cake/libs/object.php, line 125 > > Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 240 > > Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206 > > [main] - APP/webroot/index.php, line 83 > > > google.visualization.Query.setResponse({version:"0.5"reqId:"0",status:"error",errors: > [{reason:"server_error",message:"Server Error",detailed_message:"FROM > clauses are required if no default entity is defined"}]}); > > as you can see, it contains huge error. i tried to understand and edit > it but still, i obtain more errors. > > i will be using the database pelopsx with the table dlogs that has > fields of id, timestamp, cal, and met. > > can you please help me?.. > > any help is highly appreciated. thanks > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- Thanks, Romel :) -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
