SeoSuite and Sitemap on MODX 3

excavator · November 30, 2023, 8:11am

Has anyone deployed SeoSuite on MODX3 successfully?
Sitemap is throwing:

[2023-11-30 09:06:53] (ERROR @ /var/www/sites/xxx.tld/dev/core/vendor/xpdo/xpdo/src/xPDO/xPDO.php : 667) Could not load class: SeoSuiteResource from mysql.seosuiteresource

Are there any alternatives used to this extra, or am I missing something?

halftrainedharry · November 30, 2023, 8:44am

What version of SeoSuite have you installed?
Could it be, that it is an old version for MODX 2.x?
Does the file core/components/seosuite/bootstrap.php exist?

excavator · November 30, 2023, 8:45am

SeoSuite 3.1.4-pl installed (latest from Extras). bootstrap.php exists.

halftrainedharry · November 30, 2023, 8:56am

Try changing this line in the code

github.com

Sterc/seosuite/blob/9299ee1dc8c1c4d3c92449aa44267a6a619eb170/core/components/seosuite/src/Snippets/Sitemap.php#L346


      
          $query = $this->modx->newQuery(modResource::class);
          $query->innerJoin(SeoSuiteResource::class, 'SeoSuiteResource', 'SeoSuiteResource.resource_id = modResource.id');
          
          $query->select(
              [
                  'modResource.*',
                  $this->modx->getSelectColumns(
                      SeoSuiteResource::class,
                      'SeoSuiteResource',
                      'SeoSuiteResource.',
                      array_keys($this->modx->getFields('SeoSuiteResource'))
                  )
              ]
          );
          
          $query->where([
              [
                  'modResource.context_key:IN' => $contextKey,
                  'modResource.published'      => 1,
                  'modResource.deleted'        => 0
              ]

to this instead:

array_keys($this->modx->getFields(SeoSuiteResource::class))

excavator · November 30, 2023, 9:11am

That fixed it, thanks! Although I think my main issue was that I imported reosurces and installed seosuite afterwards. Need to figure out how to process all of them, so they will show up (don’t really want to save all of them manuall).

system · December 2, 2023, 9:12am

This topic was automatically closed 2 days after discussion ended and a solution was marked. New replies are no longer allowed. You can open a new topic by clicking the link icon below the original post or solution and selecting “+ New Topic”.