SQL Error in Frontend on trying to use nawork-uri in TYPO3

[kanow]

Hi,
today I tried to use nawork-uri in TYPO3. I create a new domain record to use default configuration. I create my own configuration in an extension and register this configuration. I can choose the dfeault configuration and my own configuration in the domain record. But whatever I try in frontend everytime I see an error:

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
      gated column 'mytestdomain.loc.sys_domain.uid' which is not functionally dependen
      t on columns in GROUP BY clause; this is incompatible with sql_mode=only_ful
      l_group_by' (238 chars)
   lastBuiltQuery => 'SELECT uid,tx_naworkuri_masterDomain FROM sys_domain WHERE domainName LIKE '
      mytestdomain.loc' GROUP BY hidden=0'

and the urls doesn't working. "Page not Found!" on every page.
Furthermore my "config.absRefPrefix=auto" prefixes me all url's with "auto".
Any idea?

[thommyhh]

I was actually not ware of the auto option. I will take a look at it. And the sql error, well, the GROUP BY hidden doesn't make sense.

I will work on this an provide an updated version.

[thommyhh]

@kanow Can you test the current master/nawork_uri_3.1/nawork_uri_3.0 branch? This should fix the SQL error.

[kanow]

Hi,
Thx for your response. I'm tested the current master (3.2.0-dev) and with this I don't have an error in FE. I'm afraid but there are no url rewriting. I created a domain and use the default configuration for those. What should I do to get nawork_uri working?

[thommyhh]

@kanow I fixed the config.absRefPrefix = auto in all 3.x branches (including master). Please try, if it works correctly for you now.

About your problem to get the urls working in general: It seems to me, that you did not configure your server to rewrite the urls to index.php. What kind of setup are you using (Apache/Nginx, PHP module/FPM)?