contao/test — Issue #2721: Error in mysql
Author: importer
Created: 2011-11-29 10:11:45+00:00
State: open
Labels: backend, Defect, Invalid

Hi,

I updated my local contao from 2.9.1 to 2.9.2, But when I duplicate a website root it returens this error mesage:

```
Fatal error: Uncaught exception Exception with message Query error: 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 ')' at line 1 (SELECT c.* FROM tl_content c LEFT OUTER JOIN tl_article a ON c.pid=a.id LEFT OUTER JOIN tl_page p ON a.pid=p.id WHERE (((c.type='download' OR c.type='downloads') AND c.addToSitemap='1') OR c.type='downloadarchiv') AND p.id IN ()) thrown in /var/www/html/nasertextures/system/libraries/Database.php on line 642

#0 /var/www/html/nasertextures/system/libraries/Database.php(589): Database_Statement->query()
#1 /var/www/html/nasertextures/system/libraries/Database.php(164): Database_Statement->execute()
#2 /var/www/html/nasertextures/system/modules/googlesitemap/GoogleSitemap.php(451): Database->execute('SELECT c.* FROM...')
#3 /var/www/html/nasertextures/system/modules/googlesitemap/GoogleSitemap.php(115): GoogleSitemap->getDownloadFiles('28', '')
#4 /var/www/html/nasertextures/system/modules/googlesitemap/dca/tl_page.php(88): GoogleSitemap->generateSitemap('28')
#5 /var/www/html/nasertextures/system/drivers/DC_Table.php(1765): tl_page_googlesitemap->updateSitemap(Object(DC_Table))
#6 /var/www/html/nasertextures/system/modules/backend/Backend.php(234): DC_Table->edit()
#7 /var/www/html/nasertextures/contao/main.php(101): Backend->getBackendModule('page')
#8 /var/www/html/nasertextures/contao/main.php(304): Main->run()
#9 {main}
```

I have Redhat EL6 64Bit that have php 5.3.2 and Mysql 5.1.47.

I had the same problem in installing Contao 2.9.2, so, first I installed Contao 2.9.1 and updated it.

--- _Originally created by hamidabp on December 5th, 2010, at 04:56pm (ID 2721)_