# SQL Error

**URL:** <https://help.egroupware.org/t/sql-error/40436>\
**Category:** eGW-users\
**Created:** [July 17, 2010, 9:05pm UTC](https://help.egroupware.org/t/sql-error/40436 "2010-07-17T21:05:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsteinmetz70112](https://help.egroupware.org/letter_avatar_proxy/v4/letter/r/71c47a/32.png) [@rsteinmetz70112](https://help.egroupware.org/u/rsteinmetz70112)\
**Post date:** [July 17, 2010, 9:05pm UTC](https://help.egroupware.org/t/sql-error/40436/1 "2010-07-17T21:05:04Z")

</div>

* * *

This [SF.net](http://SF.net) email is sponsored by Sprint  
What will you do first with EVO, the first 4G phone?  
Visit [sprint.com/first](http://sprint.com/first) – [http://p.sf.net/sfu/sprint-com-first](http://p.sf.net/sfu/sprint-com-first)

---

<div class="post-metadata">

**Author:** ![sbegw](https://help.egroupware.org/letter_avatar_proxy/v4/letter/s/c0e974/32.png) [@sbegw](https://help.egroupware.org/u/sbegw)\
**Post date:** [July 18, 2010, 9:52am UTC](https://help.egroupware.org/t/sql-error/40436/2 "2010-07-18T09:52:21Z")

</div>

for me that sounds, that you have to go to the setup

and check the aplications to update. The database fileds are not up to  
date to that version.

Maybe the error\_log is not activated by default.

Stefan

> _Invalid SQL: SELECT egw\_addressbook.n\_given AS account\_firstname,egw\_addressbook.n\_family AS account\_lastname,egw\_addressbook.contact\_email AS account\_email,egw\_addressbook.n\_fn AS account\_fullname,egw\_addressbook.contact\_id AS person\_id,egw\_addressbook.contact\_created AS account\_created,egw\_addressbook.contact\_modified AS account\_modified,egw\_accounts._ FROM egw\_accounts LEFT JOIN egw\_addressbook ON egw\_accounts.account\_id=egw\_addressbook.account\_id WHERE egw\_accounts.account\_id=5:  
> Unknown column ‘egw\_addressbook.contact\_email’ in ‘field list’\*

–  
Stylite GmbH  
Morschheimer Strasse 15 | D-67292 Kirchheimbolanden | Germany  
fon +49 (0)6352 70629-0 | fax +49 (0)6352 70629-30  
mail [info@stylite.de](mailto:info@stylite.de)  
[www.stylite.de](http://www.stylite.de)  
UST-ID: DE214280951

---

<div class="post-metadata">

**Author:** ![rsteinmetz70112](https://help.egroupware.org/letter_avatar_proxy/v4/letter/r/71c47a/32.png) [@rsteinmetz70112](https://help.egroupware.org/u/rsteinmetz70112)\
**Post date:** [July 18, 2010, 5:34pm UTC](https://help.egroupware.org/t/sql-error/40436/3 "2010-07-18T17:34:12Z")

</div>

Thanks. That makes sense, but I also can’t get to the setup. See my  
previous messages.

> for me that sounds, that you have to go to the setup
> 
> and check the aplications to update. The database fileds are not up to  
> date to that version.
> 
> Maybe the error\_log is not activated by default.
> 
> Stefan
> 
> > _Invalid SQL: SELECT egw\_addressbook.n\_given AS account\_firstname,egw\_addressbook.n\_family AS account\_lastname,egw\_addressbook.contact\_email AS account\_email,egw\_addressbook.n\_fn AS account\_fullname,egw\_addressbook.contact\_id AS person\_id,egw\_addressbook.contact\_created AS account\_created,egw\_addressbook.contact\_modified AS account\_modified,egw\_accounts._ FROM egw\_accounts LEFT JOIN egw\_addressbook ON egw\_accounts.account\_id=egw\_addressbook.account\_id WHERE egw\_accounts.account\_id=5:  
> > Unknown column ‘egw\_addressbook.contact\_email’ in ‘field list’\*
> 
> –  
> Stylite GmbH  
> Morschheimer Strasse 15 | D-67292 Kirchheimbolanden | Germany  
> fon +49 (0)6352 70629-0 | fax +49 (0)6352 70629-30  
> [mailinfo@stylite.de](mailto:mailinfo@stylite.de)  
> [www.stylite.de](http://www.stylite.de)  
> UST-ID: DE214280951
> 
> * * *
> 
> This [SF.net](http://SF.net) email is sponsored by Sprint  
> What will you do first with EVO, the first 4G phone?  
> Visit [sprint.com/first](http://sprint.com/first) – [http://p.sf.net/sfu/sprint-com-first](http://p.sf.net/sfu/sprint-com-first)
> 
> * * *
> 
> eGroupWare-users mailing list  
> [eGroupWare-users@lists.sourceforge.net](mailto:eGroupWare-users@lists.sourceforge.net)  
> [https://lists.sourceforge.net/lists/listinfo/egroupware-users](https://lists.sourceforge.net/lists/listinfo/egroupware-users)

–  
_Robert Steinmetz, AIA_  
Principal  
_Steinmetz & Associates_

---

<div class="post-metadata">

**Author:** ![rsteinmetz70112](https://help.egroupware.org/letter_avatar_proxy/v4/letter/r/71c47a/32.png) [@rsteinmetz70112](https://help.egroupware.org/u/rsteinmetz70112)\
**Post date:** [July 19, 2010, 3:29pm UTC](https://help.egroupware.org/t/sql-error/40436/4 "2010-07-19T15:29:14Z")

</div>

* * *

This [SF.net](http://SF.net) email is sponsored by Sprint  
What will you do first with EVO, the first 4G phone?  
Visit [sprint.com/first](http://sprint.com/first) – [http://p.sf.net/sfu/sprint-com-first](http://p.sf.net/sfu/sprint-com-first)