We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
  • I’ve installed and reinstalled getResources and I still can’t get it to work. Someone on another post of mine suggested I call just: [[getresources]] to see what I get.

    Here is the error:

    called [[getResources]] as you suggested and got this:

    [2010-09-13 16:34:02] (ERROR @ /index.php) Error 42000 executing statement: Array (
    => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,18,19,17) AND (`modResource`.`context_key’ at line 1 )

    Does anyone have any thoughts for this? I really need this to work for several parts of my site and it’s getting very frustrating.

    Thanks.
      Michael Smull
      http://www.bigpixelstudio.com
      twitter: @mdsdesign
      • 33636
      • 7 Posts
      I am having this same problem with no explanation. The only thing I did was install the getResources Package and then call it. One possiblity is that I’m developing the site on MAMP locally and I am not sure if that would effect it. But if anyone has any suggestions. It would be very helpful. Attached are the code I’m using.

      Here is my template Chunk
      <li>
      	<a href="[[++site_url]][[+image-full]]" class="fancybox">
      		<img src="[[++site_url]]/[[+image-thmb]]" />
      	</a>
      	
      </li>


      And this is my snippet call
      [[getResources? &parents=`[[*id]] &tpl=`imageTmpl`]] 
        • 28215
        • 4,149 Posts
        One, make your snippet call (you forgot an `):

        [[getResources? &parents=`[[*id]]` &tpl=`imageTmpl`]]


        Two, you don’t need the site_url prefix in your tpl, and your TVs should be prefixed with `tv.`:

        <li>
        <a href="[[+tv.image-full]]" class="fancybox">
           <img src="[[+tv.image-thmb]]" alt="" />
        </a>
        </li>
          shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com
          • 33636
          • 7 Posts
          Thanks so much! The first was an obvious mistake I should have seen, but your second one helped me a lot! Fixed the problems I was having. Thanks again!