[Revolution] creating custom DB table

• • 
  • 41 Posts
  MaZZie Reply #1, 15 years, 11 months ago

  I have created a build script.
  When I install the package, the custom table is not created.
  
  I have this as schema in the package: http://github.com/MaZZie/VisualTeams/blob/master/_build/schema/visualteams.mysql.schema.xml
  
  Does it need anything else?
  GH: http://github.com/MaZZie
  TW: http://twitter.com/Datz_MaZZie
• • 
  • 4,149 Posts
  splittingred Reply #2, 15 years, 11 months ago

  Did you run the build schema script? (IOW, did it generate the maps and class files?)
  
  Also, you’ll need to create the table at some point (I usually do it in a resolver during install):
  
  

  $manager = $modx->getManager();
  $manager->createObjectContainer('myClassName');
  
  shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com
• • 
  • 41 Posts
  MaZZie Reply #3, 15 years, 11 months ago

  I did run the build script and the package is created (with all maps and files)
  
  I have found this page: http://rtfm.modx.com/display/revolution20/Using+Custom+Database+Tables+in+your+3rd+Party+Components
  need to add some code in order to make this work.
  GH: http://github.com/MaZZie
  TW: http://twitter.com/Datz_MaZZie
• • 
  • 41 Posts
  MaZZie Reply #4, 15 years, 11 months ago

  Finally I understand how the build script is working
  There was nothing that runs the build.schema.php
  
  Now I receive the next error when I try to run a snippet:
  
  Fatal error: Call to a member function fromArray() on a non-object in D:\webserver\xampp\htdocs\Script\Visualize-Studio.com\vsc\TvL\core\cache\elements\modsnippet\1.include.cache.php on line 12
  
  http://github.com/MaZZie/VisualTeams/blob/master/core/components/visualteams/elements/snippets/snippet.visualteams.php
  There seems to be a problem with the fromArray.. can not find the solution after some google work.
  GH: http://github.com/MaZZie
  TW: http://twitter.com/Datz_MaZZie
• • 
  • 275 Posts
  skndn60 Reply #5, 15 years, 11 months ago

  If I’m not mistaken, fromArray() is a convenience method for xPDOSimpleObject and their subclasses to set instance variables from values stored in an array. So you’re probably using that method on something that is not an object and/or subclass of xPDOSimpleObject:
  
  

  someInstance->fromArray
  

  
  
  In your specific code, what kind of object is "someInstance"?
  MODx Revolution / MAMP / OS X
• • 
  • 4,149 Posts
  splittingred Reply #6, 15 years, 11 months ago

  Quote from: MaZZie at Oct 19, 2010, 03:52 PM

  
  Fatal error: Call to a member function fromArray() on a non-object in D:\webserver\xampp\htdocs\Script\Visualize-Studio.com\vsc\TvL\core\cache\elements\modsnippet\1.include.cache.php on line 12
  http://github.com/MaZZie/VisualTeams/blob/master/core/components/visualteams/elements/snippets/snippet.visualteams.php
  There seems to be a problem with the fromArray.. can not find the solution after some google work.
  

  
  I can tell you right now that line 24:
  
  

  $teams->Array(array(
  

  
  
  is wrong; should be fromArray. Also, you should check your core/cache/logs/error.log - that might provide you with more information.
  shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com
• • 
  • 24,544 Posts
  BobRay Reply #7, 15 years, 11 months ago

  MAZZIE, Sorry to butt in. I’ve just finished writing a much more modest tutorial here: http://bobsguides.com/custom-db-tables.html. Some of the explanations might help you.
  Did I help you? Buy me a beer
  Get my Book: MODX:The Official Guide
  MODX info for everyone: http://bobsguides.com/modx.html
  My MODX Extras
  Bob's Guides is now hosted at A2 MODX Hosting
  
• • 
  • 41 Posts
  MaZZie Reply #8, 15 years, 11 months ago

  Quote from: splittingred at Oct 19, 2010, 10:40 PM

  
  Quote from: MaZZie at Oct 19, 2010, 03:52 PM

  
  Fatal error: Call to a member function fromArray() on a non-object in D:\webserver\xampp\htdocs\Script\Visualize-Studio.com\vsc\TvL\core\cache\elements\modsnippet\1.include.cache.php on line 12
  http://github.com/MaZZie/VisualTeams/blob/master/core/components/visualteams/elements/snippets/snippet.visualteams.php
  There seems to be a problem with the fromArray.. can not find the solution after some google work.
  

  
  I can tell you right now that line 24:
  
  

  $teams->Array(array(
  

  
  
  is wrong; should be fromArray. Also, you should check your core/cache/logs/error.log - that might provide you with more information.
  

  
  I fixed the fromArray. But it was not the problem that brings the error
  
  The error log told me that the vsteams.class was nog fount.
  
  fixed
  

  
  $base_path = !empty($base_path) ? $base_path : $modx->getOption(’core_path’).’components/visualteams/’;
  $modx->addPackage(’visualteams’,$base_path.’model/’);
  

  
  added the / on the end and now it’s working!
  
  Bobray: I read your tutorial. I think the tutorial is good when you are more into modx. I’m still in the learning phase and try to understand modx (what is going really fast with all the help around here).
  
  
  
  
  
  
  GH: http://github.com/MaZZie
  TW: http://twitter.com/Datz_MaZZie

This discussion is closed to further replies. Keep calm and carry on.