Database error Invalid SQL at Login eGroupware 1.5.011 revision 25934

Old eGW-developers
1

Hello,

I get the following Error Message after pressing “Login” when I’ve entered a correct name and password:

Database error

Invalid SQL: SELECT message_id,content FROM egw_lang WHERE lang=’’ AND app_name=’’

#0 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_db.inc.php(674): egw_db->halt(‘Invalid SQL: SE…’, 220, ‘/usr/local/http…’)
#1 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_db.inc.php(1892): egw_db->query(‘SELECT message_…’, 220, ‘/usr/local/http…’, false, -1, false, 2)
#2 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.translation.inc.php(220): egw_db->select(‘egw_lang’, ‘message_id,cont…’, Array, 220, ‘/usr/local/http…’)
#3 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw.inc.php(193): translation->add_app(‘calendar’)
#4 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/functions.inc.php(88): egw->wakeup2()
#5 /usr/local/httpsd/htdocs/laikakopie/header.inc.php(127): include(’/usr/local/http…’)
#6 /usr/local/httpsd/htdocs/laikakopie/index.php(55): include(’/usr/local/http…’)
#7 {main}

I have eGroupware 1.5.011 at revision 25394 on Linux with MySQL 5.0.67, PHP 5.2.6 (compiled with support for MySQL, Mysqli and PDO-MySQL) and OpenLDAP

Thanks in Advance for your help!

2

No languages installed??? Setup Installed Languages …

3

I’ve installed German and English.
When I go to setup and say “delete and reinstall languages” and activate the additional Messages, then I get the following output:

Zurückgewiesende Zeilen:
Anwendung: , Datei: , Zeile: “exports entries from your timesheet into a csv file. csv means ‘comma seperated values’. however in the options tab you\tcan also choose other seperators.\ttimesheet\ten\tExports entries from your Timesheet into a CSV File. CSV means ‘Comma Seperated Values’. However in the options Tab you\tcan also choose other seperators.\n”

(The “\t” and “\n” are red.)

Can that cause the Problem?

[quote=“Leithoff, Klaus”]
No languages installed??? Setup Installed Languages …

4

Yep, translation phrases can NOT contain tabs (\t), as that’s the
delimiter of the csv file.

I fixed it in svn.

Ralf

Ageless schrieb:

I’ve installed German and English.
When I go to setup and say “delete and reinstall languages” and activate the
additional Messages, then I get the following output:

Zurückgewiesende Zeilen:
Anwendung: , Datei: , Zeile: “exports entries from your timesheet into a csv
file. csv means ‘comma seperated values’. however in the options tab
you\tcan also choose other seperators.\ttimesheet\ten\tExports entries from
your Timesheet into a CSV File. CSV means ‘Comma Seperated Values’. However
in the options Tab you\tcan also choose other seperators.\n”

(The “\t” and “\n” are red.)

Can that cause the Problem?

No languages installed??? Setup Installed Languages …

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

5

Thank you for your fast response.

I just found the same and removed that tab out of the egw_en.lang and reinstalled my languages without errors.

But I still get the same error Messages when I log in.

6

When I log in to setup and after that log out from setup and click on “Back to User Login” then i am logged in to the Groupware (without telling name or password) and see the following error messages:

Database error

Invalid SQL: SELECT * FROM egw_config WHERE config_app=’’

#0 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_db.inc.php(674): egw_db->halt(‘Invalid SQL: SE…’, 215, ‘/usr/local/http…’)
#1 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_db.inc.php(1892): egw_db->query(‘SELECT * FROM e…’, 215, ‘/usr/local/http…’, false, -1, false, 2)
#2 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.config.inc.php(215): egw_db->select(‘egw_config’, ‘*’, Array, 215, ‘/usr/local/http…’)
#3 /usr/local/httpsd/htdocs/laikakopie/infolog/inc/class.boinfolog.inc.php(172): config::read(‘infolog’)
#4 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/common_functions.inc.php(688): boinfolog->boinfolog()
#5 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/common_functions.inc.php(792): CreateObject(‘infolog.boinfol…’)
#6 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.hooks.inc.php(152): ExecMethod(‘infolog.boinfol…’, ‘search_link’)
#7 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.hooks.inc.php(110): hooks->single(‘search_link’, ‘infolog’, false)
#8 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_link.inc.php(114): hooks->process(‘search_link’)
#9 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_link.inc.php(949): egw_link::init_static()
#10 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/common_functions.inc.php(1350): include_once(’/usr/local/http…’)
#11 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_framework.inc.php(360): __autoload(‘egw_link’)
#12 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_framework.inc.php(284): egw_framework::_get_quick_add()
#13 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/templates/idots/class.idots_framework.inc.php(438): egw_framework->_get_navbar(Array)
#14 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/templates/idots/class.idots_framework.inc.php(134): idots_framework->_get_navbar(Array)
#15 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.common.inc.php(1012): idots_framework->navbar()
#16 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw.inc.php(214): common->egw_header()
#17 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw.inc.php(199): egw->load_optional_classes()
#18 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/functions.inc.php(88): egw->wakeup2()
#19 /usr/local/httpsd/htdocs/laikakopie/header.inc.php(127): include(’/usr/local/http…’)
#20 /usr/local/httpsd/htdocs/laikakopie/home/index.php(32): include(’/usr/local/http…’)
#21 {main}

I can see the the menues, but when I click on one of the Items I get the error Messages I reported on the start of this Thread.

7

Hi,

I can see were the error happens, thought I dont understand why.

Infolog tries to read it’s configuration (#3) which should lead to an
SQL query: SELECT * FROM egw_config WHERE config_app='infolog’
Not an empty string, but anyway the empty string is still valid SQL.

Looks like there’s something seriously wrong on your system :wink:

I can’t help without looking on the system …

Ralf

PS.: If you want one of Stylite to look on your system you need to
contract us via the website mentioned in my signature.

Ageless schrieb:

When I log in to setup and after that log out from setup and click on “Back
to User Login” then i am logged in to the Groupware (without telling name or
password) and see the following error messages:

Database error

Invalid SQL: SELECT * FROM egw_config WHERE config_app=’’

#0
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_db.inc.php(674):
egw_db->halt(‘Invalid SQL: SE…’, 215, ‘/usr/local/http…’)
#1
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_db.inc.php(1892):
egw_db->query(‘SELECT * FROM e…’, 215, ‘/usr/local/http…’, false, -1,
false, 2)
#2
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.config.inc.php(215):
egw_db->select(‘egw_config’, ‘*’, Array, 215, ‘/usr/local/http…’)
#3
/usr/local/httpsd/htdocs/laikakopie/infolog/inc/class.boinfolog.inc.php(172):
config::read(‘infolog’)
#4
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/common_functions.inc.php(688):
boinfolog->boinfolog()
#5
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/common_functions.inc.php(792):
CreateObject(‘infolog.boinfol…’)
#6
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.hooks.inc.php(152):
ExecMethod(‘infolog.boinfol…’, ‘search_link’)
#7
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.hooks.inc.php(110):
hooks->single(‘search_link’, ‘infolog’, false)
#8
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_link.inc.php(114):
hooks->process(‘search_link’)
#9
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_link.inc.php(949):
egw_link::init_static()
#10
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/common_functions.inc.php(1350):
include_once(’/usr/local/http…’)
#11
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_framework.inc.php(360):
__autoload(‘egw_link’)
#12
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_framework.inc.php(284):
egw_framework::_get_quick_add()
#13
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/templates/idots/class.idots_framework.inc.php(438):
egw_framework->_get_navbar(Array)
#14
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/templates/idots/class.idots_framework.inc.php(134):
idots_framework->_get_navbar(Array)
#15
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.common.inc.php(1012):
idots_framework->navbar()
#16 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw.inc.php(214):
common->egw_header()
#17 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw.inc.php(199):
egw->load_optional_classes()
#18 /usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/functions.inc.php(88):
egw->wakeup2()
#19 /usr/local/httpsd/htdocs/laikakopie/header.inc.php(127):
include(’/usr/local/http…’)
#20 /usr/local/httpsd/htdocs/laikakopie/home/index.php(32):
include(’/usr/local/http…’)
#21 {main}

I can see the the menues, but when I click on one of the Items I get the
error Messages I reported on the start of this Thread.

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

8

Hi,

I think I found what was seriously wrong on my system.

The db_type in header.inc.php was mysqli, I changed it to mysql and everything is fine now.

Is the db_type mysql the one that you would suggest or should I change to another one like PDO?

9

Ok, interesting, I had expected ‘mysqli’ to work - thought I never used
it, only the ‘mysql’ one.

eGW is currently not ready to use only PDO, but it requires PDO for the
new VFS in 1.6.

Ralf

Ageless schrieb:

Hi,

I think I found what was seriously wrong on my system.

The db_type in header.inc.php was mysqli, I changed it to mysql and
everything is fine now.

Is the db_type mysql the one that you would suggest or should I change to
another one like PDO?

ralfbecker wrote:

Hi,

I can see were the error happens, thought I dont understand why.

Infolog tries to read it’s configuration (#3) which should lead to an
SQL query: SELECT * FROM egw_config WHERE config_app='infolog’
Not an empty string, but anyway the empty string is still valid SQL.

Looks like there’s something seriously wrong on your system :wink:

I can’t help without looking on the system …

Ralf

PS.: If you want one of Stylite to look on your system you need to
contract us via the website mentioned in my signature.

Ageless schrieb:

When I log in to setup and after that log out from setup and click on
"Back
to User Login" then i am logged in to the Groupware (without telling name
or
password) and see the following error messages:

Database error

Invalid SQL: SELECT * FROM egw_config WHERE config_app=’’

#0
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_db.inc.php(674):
egw_db->halt(‘Invalid SQL: SE…’, 215, ‘/usr/local/http…’)
#1
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_db.inc.php(1892):
egw_db->query(‘SELECT * FROM e…’, 215, ‘/usr/local/http…’, false, -1,
false, 2)
#2
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.config.inc.php(215):
egw_db->select(‘egw_config’, ‘*’, Array, 215, ‘/usr/local/http…’)
#3
/usr/local/httpsd/htdocs/laikakopie/infolog/inc/class.boinfolog.inc.php(172):
config::read(‘infolog’)
#4
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/common_functions.inc.php(688):
boinfolog->boinfolog()
#5
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/common_functions.inc.php(792):
CreateObject(‘infolog.boinfol…’)
#6
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.hooks.inc.php(152):
ExecMethod(‘infolog.boinfol…’, ‘search_link’)
#7
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.hooks.inc.php(110):
hooks->single(‘search_link’, ‘infolog’, false)
#8
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_link.inc.php(114):
hooks->process(‘search_link’)
#9
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_link.inc.php(949):
egw_link::init_static()
#10
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/common_functions.inc.php(1350):
include_once(’/usr/local/http…’)
#11
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_framework.inc.php(360):
__autoload(‘egw_link’)
#12
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw_framework.inc.php(284):
egw_framework::_get_quick_add()
#13
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/templates/idots/class.idots_framework.inc.php(438):
egw_framework->_get_navbar(Array)
#14
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/templates/idots/class.idots_framework.inc.php(134):
idots_framework->_get_navbar(Array)
#15
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.common.inc.php(1012):
idots_framework->navbar()
#16
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw.inc.php(214):
common->egw_header()
#17
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/class.egw.inc.php(199):
egw->load_optional_classes()
#18
/usr/local/httpsd/htdocs/laikakopie/phpgwapi/inc/functions.inc.php(88):
egw->wakeup2()
#19 /usr/local/httpsd/htdocs/laikakopie/header.inc.php(127):
include(’/usr/local/http…’)
#20 /usr/local/httpsd/htdocs/laikakopie/home/index.php(32):
include(’/usr/local/http…’)
#21 {main}

I can see the the menues, but when I click on one of the Items I get the
error Messages I reported on the start of this Thread.

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

This SF.Net email is sponsored by the Moblin Your Move Developer’s
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

10

Ralf Becker escribió:

Ok, interesting, I had expected ‘mysqli’ to work - thought I never used
it, only the ‘mysql’ one.

I think I already reported that on tracker #1215

Can you, Ageless, confirm that?

Regards.

eGW is currently not ready to use only PDO, but it requires PDO for the
new VFS in 1.6.

Ralf

Ageless schrieb:

Hi,

I think I found what was seriously wrong on my system.

The db_type in header.inc.php was mysqli, I changed it to mysql and
everything is fine now.

Is the db_type mysql the one that you would suggest or should I change to
another one like PDO?

–

----------------------------------------------------------------------|
http://counter.li.org info: Linux user: 92390 - Linux machine: 39301 |
Oscar Manuel Gómez Senovilla - omgsATescomposlinux.org |
GPG Key at http://pgp.escomposlinux.org |
----------------------------------------------------------------------|

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

11

Hi,

on the same System were I have the eGroupware 1.5.011 for testing purpose, which is not working with mysqli, I have a 1.4.004 as a production system with about 30 Users where I am using mysqli and it is working fine. So, I can not confirm Tracker #1215.

Regards

[quote=“Oscar Manuel Gómez Senovilla”]
Ralf Becker escribió:

Ok, interesting, I had expected ‘mysqli’ to work - thought I never used
it, only the ‘mysql’ one.

I think I already reported that on tracker #1215

Can you, Ageless, confirm that?

Regards.

12

Ageless escribió:

Hi,

on the same System were I have the eGroupware 1.5.011 for testing purpose,
which is not working with mysqli, I have a 1.4.004 as a production system
with about 30 Users where I am using mysqli and it is working fine. So, I
can not confirm Tracker #1215.

Can you detail what OS is on every installation, to collect more data?
To me, it seems the same, but the implementation of the packages
mysql/mysqli changes from one distro to another. Besides, as time goes
by, the feature is getting outdated with newer releases. It could also
be a bug in adodb, and maybe pdo solves it.

Regards.

Ralf Becker escribió:

Ok, interesting, I had expected ‘mysqli’ to work - thought I never used
it, only the ‘mysql’ one.

I think I already reported that on tracker #1215

Can you, Ageless, confirm that?

Regards.

–

----------------------------------------------------------------------|
http://counter.li.org info: Linux user: 92390 - Linux machine: 39301 |
Oscar Manuel Gómez Senovilla - omgsATescomposlinux.org |
GPG Key at http://pgp.escomposlinux.org |
----------------------------------------------------------------------|

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

13

Hi,

The System is a OpenSuSE 10.1, but I didn’t use the PHP, Mysql or Apache from Suse.
I am using a binary MySQL 5.0.67, a Apache 2.2.2 and PHP 5.2.6 compiled with the following options:
’./configure’ ‘–with-apxs2=/usr/local/httpsd/bin/apxs’ ‘–with-mysqli=/usr/local/mysql/bin/mysql_config’ ‘–with-openssl’ ‘–with-zlib’ ‘–enable-trans-sid’ ‘–with-mcrypt’ ‘–enable-mbstring’ ‘–with-gd’ ‘–with-imap=/usr/local/imap-2007a/’ ‘–with-imap-ssl’ ‘–with-freetype-dir’ ‘–enable-bcmath’ ‘–with-ldap’ ‘–with-gettext’ ‘–with-mysql=/usr/local/mysql/’ ‘–with-pdo-mysql=/usr/local/mysql/’

One Apache vhost runs the production system (1.4.004) and the other is for testing (1.5.011).

Anything else you want to know?

14

I think I know what the problem is: mysqli never worked with the session
restore in 1.4, it only worked if that was switched off.

In trunk the session restore is now mandatory (you cat switch it off
anymore).

I’m sure mysqli needs only some code to restore the connection.

Ralf

Oscar Manuel Gómez Senovilla schrieb:

15

Ralf Becker escribió:

I think I know what the problem is: mysqli never worked with the session
restore in 1.4, it only worked if that was switched off.

In trunk the session restore is now mandatory (you cat switch it off
anymore).

I guess you mean “can’t” instead of “cat”, which is ambiguous (it could
be “can” or something else I’m forgetting right now).

I’m sure mysqli needs only some code to restore the connection.

Do you mean this is an adodb bug? Should it be solved with pdo?

Regards.

Ralf

Oscar Manuel Gómez Senovilla schrieb:

Ralf Becker escribió:

Ok, interesting, I had expected ‘mysqli’ to work - thought I never
used it, only the ‘mysql’ one.

I think I already reported that on tracker #1215

Can you, Ageless, confirm that?

Regards.

eGW is currently not ready to use only PDO, but it requires PDO for
the new VFS in 1.6.

Ralf

Ageless schrieb:

Hi,

I think I found what was seriously wrong on my system.

The db_type in header.inc.php was mysqli, I changed it to mysql and
everything is fine now.

Is the db_type mysql the one that you would suggest or should I
change to
another one like PDO?

–

----------------------------------------------------------------------|
http://counter.li.org info: Linux user: 92390 - Linux machine: 39301 |
Oscar Manuel Gómez Senovilla - omgsATescomposlinux.org |
GPG Key at http://pgp.escomposlinux.org |
----------------------------------------------------------------------|

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

16

Hi Oscar,

PDO is currently only used by the VFS’ SQLfs backend.

The rest of eGW still uses ADOdb.

There’s a __wakeup() method in the egw_db class with reconnects with the
database, when the session get’s restored. That should in principle work
with all ADOdb supported DBMS …

Ralf

Oscar Manuel Gómez Senovilla schrieb:

Ralf Becker escribió:

I think I know what the problem is: mysqli never worked with the session
restore in 1.4, it only worked if that was switched off.

In trunk the session restore is now mandatory (you cat switch it off
anymore).

I guess you mean “can’t” instead of “cat”, which is ambiguous (it could
be “can” or something else I’m forgetting right now).

I’m sure mysqli needs only some code to restore the connection.

Do you mean this is an adodb bug? Should it be solved with pdo?

Regards.

Ralf

Oscar Manuel Gómez Senovilla schrieb:

Ralf Becker escribió:

Ok, interesting, I had expected ‘mysqli’ to work - thought I never
used it, only the ‘mysql’ one.

I think I already reported that on tracker #1215

Can you, Ageless, confirm that?

Regards.

eGW is currently not ready to use only PDO, but it requires PDO for
the new VFS in 1.6.

Ralf

Ageless schrieb:

Hi,

I think I found what was seriously wrong on my system.

The db_type in header.inc.php was mysqli, I changed it to mysql and
everything is fine now.

Is the db_type mysql the one that you would suggest or should I
change to
another one like PDO?

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers