Strange problem with 1.4.002 on class egw_db

[Jean-Charles_Passard]

Hello,

I have a piece of code that doesn’t make problem in eGw 1.4.001 but now
with 1.4.002 something strange happen.
I make a connection to another database (same server than egw db) this way

class somaintenance
{
function somaintenance()
{

    $this->dbotrs=& CreateObject('phpgwapi.egw_db');
    $this->dbotrs->connect('database','dbserver', 3306,'dbuser', 

‘dbpass’);
}

blah, blah, …

}
and this is what I get :

Database error: Invalid SQL: SELECT * FROM egw_etemplate WHERE
et_name=‘provectio.maintenance’ AND et_template=’’ AND et_lang=’’ ORDER
BY et_lang DESC,et_template DESC,et_version DESC
mysql Error: 1146 (Table ‘database.egw_etemplate’ doesn’t exist)

File:
/home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php
Line: 450
Function: egw_db::select / soetemplate::read / boetemplate::read /
boetemplate::boetemplate / etemplate::etemplate / eval() /
CreateObject(etemplate.etemplate) / uimaintenance::maintenance /
ExecMethod(provectio.uimaintenance.maintenance)

Session halted.

Database error: Invalid SQL: SELECT * FROM egw_async WHERE
async_id=’##last-check-run##'
mysql Error: 1146 (Table ‘database.egw_async’ doesn’t exist)

File:
/home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php
Line: 463
Function: egw_db::select / asyncservice::read /
asyncservice::last_check_run / asyncservice::check_run /
ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final

*Session halted.

This code was working with 1.4.001
This error shows up only when connect method is called. It’s libe my
other db connection modify the global egw connection. I have followed
the code throught egw_db and etemplate but I can"t see where I mess
things up.

Any clue ?

JC Passard
Provectio

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

[Jean-Charles_Passard]

Jean Charles Passard wrote:

Hello,

I have a piece of code that doesn’t make problem in eGw 1.4.001 but now
with 1.4.002 something strange happen.
I make a connection to another database (same server than egw db) this way

class somaintenance
{
function somaintenance()
{

    $this->dbotrs=& CreateObject('phpgwapi.egw_db');
    $this->dbotrs->connect('database','dbserver', 3306,'dbuser', 

‘dbpass’);
}

blah, blah, …

}
and this is what I get :

Database error: Invalid SQL: SELECT * FROM egw_etemplate WHERE
et_name=‘provectio.maintenance’ AND et_template=’’ AND et_lang=’’ ORDER
BY et_lang DESC,et_template DESC,et_version DESC
mysql Error: 1146 (Table ‘database.egw_etemplate’ doesn’t exist)

File:
/home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php
Line: 450
Function: egw_db::select / soetemplate::read / boetemplate::read /
boetemplate::boetemplate / etemplate::etemplate / eval() /
CreateObject(etemplate.etemplate) / uimaintenance::maintenance /
ExecMethod(provectio.uimaintenance.maintenance)

Session halted.

Database error: Invalid SQL: SELECT * FROM egw_async WHERE
async_id=’##last-check-run##'
mysql Error: 1146 (Table ‘database.egw_async’ doesn’t exist)

File:
/home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php
Line: 463
Function: egw_db::select / asyncservice::read /
asyncservice::last_check_run / asyncservice::check_run /
ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final

*Session halted.

This code was working with 1.4.001
This error shows up only when connect method is called. It’s libe my
other db connection modify the global egw connection. I have followed
the code throught egw_db and etemplate but I can"t see where I mess
things up.

Any clue ?

JC Passard
Provectio

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello,
I have test a lot of way to resolve this issue. No way.
Is it still possible to use egw api to connect another database ?
Does someone has an idea I could test ? or is it aventually a bug I have
to declare ?

I hope to read someone soon.

JC Passard

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

[Ralf_Becker_6]

Hi Jean,

I know Pim uses that feature to connect to different databases and I
also hava an installation where I connect to a second database.

The problem is the following:

$this->dbotrs=& CreateObject(‘phpgwapi.egw_db’);

try using

$this->dbotrs = new egw_db();

Ralf

Jean Charles Passard schrieb:

Jean Charles Passard wrote:

Hello,

I have a piece of code that doesn’t make problem in eGw 1.4.001 but now
with 1.4.002 something strange happen.
I make a connection to another database (same server than egw db) this way

class somaintenance
{
function somaintenance()
{

    $this->dbotrs=& CreateObject('phpgwapi.egw_db');
    $this->dbotrs->connect('database','dbserver', 3306,'dbuser', 

‘dbpass’);
}

blah, blah, …

}
and this is what I get :

Database error: Invalid SQL: SELECT * FROM egw_etemplate WHERE
et_name=‘provectio.maintenance’ AND et_template=’’ AND et_lang=’’ ORDER
BY et_lang DESC,et_template DESC,et_version DESC
mysql Error: 1146 (Table ‘database.egw_etemplate’ doesn’t exist)

File:
/home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php
Line: 450
Function: egw_db::select / soetemplate::read / boetemplate::read /
boetemplate::boetemplate / etemplate::etemplate / eval() /
CreateObject(etemplate.etemplate) / uimaintenance::maintenance /
ExecMethod(provectio.uimaintenance.maintenance)

Session halted.

Database error: Invalid SQL: SELECT * FROM egw_async WHERE
async_id=’##last-check-run##'
mysql Error: 1146 (Table ‘database.egw_async’ doesn’t exist)

File:
/home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php
Line: 463
Function: egw_db::select / asyncservice::read /
asyncservice::last_check_run / asyncservice::check_run /
ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final

*Session halted.

This code was working with 1.4.001
This error shows up only when connect method is called. It’s libe my
other db connection modify the global egw connection. I have followed
the code throught egw_db and etemplate but I can"t see where I mess
things up.

Any clue ?

JC Passard
Provectio

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello,
I have test a lot of way to resolve this issue. No way.
Is it still possible to use egw api to connect another database ?
Does someone has an idea I could test ? or is it aventually a bug I have
to declare ?

I hope to read someone soon.

JC Passard

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

[Jean-Charles_Passard]

Ralf Becker a écrit :

Hi Jean,

I know Pim uses that feature to connect to different databases and I
also hava an installation where I connect to a second database.

The problem is the following:

$this->dbotrs=& CreateObject(‘phpgwapi.egw_db’);

try using

$this->dbotrs = new egw_db();

Ralf

Jean Charles Passard schrieb:

Jean Charles Passard wrote:

Hello,

I have a piece of code that doesn’t make problem in eGw 1.4.001 but now
with 1.4.002 something strange happen.
I make a connection to another database (same server than egw db) this way

class somaintenance
{
function somaintenance()
{

    $this->dbotrs=& CreateObject('phpgwapi.egw_db');
    $this->dbotrs->connect('database','dbserver', 3306,'dbuser', 

‘dbpass’);
}

blah, blah, …

}
and this is what I get :

Database error: Invalid SQL: SELECT * FROM egw_etemplate WHERE
et_name=‘provectio.maintenance’ AND et_template=’’ AND et_lang=’’ ORDER
BY et_lang DESC,et_template DESC,et_version DESC
mysql Error: 1146 (Table ‘database.egw_etemplate’ doesn’t exist)

File:
/home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php
Line: 450
Function: egw_db::select / soetemplate::read / boetemplate::read /
boetemplate::boetemplate / etemplate::etemplate / eval() /
CreateObject(etemplate.etemplate) / uimaintenance::maintenance /
ExecMethod(provectio.uimaintenance.maintenance)

Session halted.

Database error: Invalid SQL: SELECT * FROM egw_async WHERE
async_id=’##last-check-run##'
mysql Error: 1146 (Table ‘database.egw_async’ doesn’t exist)

File:
/home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php
Line: 463
Function: egw_db::select / asyncservice::read /
asyncservice::last_check_run / asyncservice::check_run /
ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final

*Session halted.

This code was working with 1.4.001
This error shows up only when connect method is called. It’s libe my
other db connection modify the global egw connection. I have followed
the code throught egw_db and etemplate but I can"t see where I mess
things up.

Any clue ?

JC Passard
Provectio

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello,
I have test a lot of way to resolve this issue. No way.
Is it still possible to use egw api to connect another database ?
Does someone has an idea I could test ? or is it aventually a bug I have
to declare ?

I hope to read someone soon.

JC Passard

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello Ralf,

thanks for the hint, but unfortunately that does not work.
I have reduce the code to its simple expression :

<?php class uimaintenance { var $public_functions = array( 'maintenance'=>True ); var $dbotrs; function uimaintenance() { $this->dbotrs = new egw_db(); $this->dbotrs->connect('provectioOTRS','mysql.provectio.local', 3306,'root', 'rootsan'); } function maintenance($content=null) { $tpl=& CreateObject('etemplate.etemplate', 'provectio.maintenance'); $tpl->exec('provectio.uimaintenance.maintenance', $content, $sel_option); } } This is all the code I have, and this is the answer when invoking index.php?menuaction=provectio.uimaintenance.maintenance *Database error:* Invalid SQL: SELECT * FROM egw_etemplate WHERE et_name='.provectio' AND et_template='' AND et_lang='##' ORDER BY et_lang DESC,et_template DESC,et_version DESC *mysql Error*: 1146 (Table 'provectioOTRS.egw_etemplate' doesn't exist) *File:* /home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php *Line:* 449 *Function:* egw_db::select / soetemplate::read / soetemplate::soetemplate / soetemplate::test_import / soetemplate::read / boetemplate::read / boetemplate::boetemplate / etemplate::etemplate / eval() / CreateObject(etemplate.etemplate) / uimaintenance::maintenance / ExecMethod(provectio.uimaintenance.maintenance) *Session halted.* *Database error:* Invalid SQL: SELECT * FROM egw_async WHERE async_id='##last-check-run##' *mysql Error*: 1146 (Table 'provectioOTRS.egw_async' doesn't exist) *File:* /home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php *Line:* 463 *Function:* egw_db::select / asyncservice::read / asyncservice::last_check_run / asyncservice::check_run / ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final *Session halted.* I have test with the trunk version of 1.4.002 and it's the same. I have track all the things I could understand (then not so much), I have even activate $debug in egw_db but It shows the good egw database and never the provectioOTRS db in all _debug_array. Could this happen with a particular config of php or apache ? ( I am not convinced but I am desesperate ;-) JC Passard ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ eGroupWare-developers mailing list eGroupWare-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Ralf_Becker_6]

Hi Jean,

than you can only start debugging the code in
phpgwapi/inc/class.egw_db.inc.php around line 290 in trunk.

Ralf

Jean Charles Passard schrieb:

Ralf Becker a écrit :

Hi Jean,

I know Pim uses that feature to connect to different databases and I
also hava an installation where I connect to a second database.

The problem is the following:

$this->dbotrs=& CreateObject(‘phpgwapi.egw_db’);

try using

$this->dbotrs = new egw_db();

Ralf

Jean Charles Passard schrieb:

Jean Charles Passard wrote:

Hello,

I have a piece of code that doesn’t make problem in eGw 1.4.001 but now
with 1.4.002 something strange happen.
I make a connection to another database (same server than egw db) this way

class somaintenance
{
function somaintenance()
{

    $this->dbotrs=& CreateObject('phpgwapi.egw_db');
    $this->dbotrs->connect('database','dbserver', 3306,'dbuser', 

‘dbpass’);
}

blah, blah, …

}
and this is what I get :

Database error: Invalid SQL: SELECT * FROM egw_etemplate WHERE
et_name=‘provectio.maintenance’ AND et_template=’’ AND et_lang=’’ ORDER
BY et_lang DESC,et_template DESC,et_version DESC
mysql Error: 1146 (Table ‘database.egw_etemplate’ doesn’t exist)

File:
/home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php
Line: 450
Function: egw_db::select / soetemplate::read / boetemplate::read /
boetemplate::boetemplate / etemplate::etemplate / eval() /
CreateObject(etemplate.etemplate) / uimaintenance::maintenance /
ExecMethod(provectio.uimaintenance.maintenance)

Session halted.

Database error: Invalid SQL: SELECT * FROM egw_async WHERE
async_id=’##last-check-run##'
mysql Error: 1146 (Table ‘database.egw_async’ doesn’t exist)

File:
/home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php
Line: 463
Function: egw_db::select / asyncservice::read /
asyncservice::last_check_run / asyncservice::check_run /
ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final

*Session halted.

This code was working with 1.4.001
This error shows up only when connect method is called. It’s libe my
other db connection modify the global egw connection. I have followed
the code throught egw_db and etemplate but I can"t see where I mess
things up.

Any clue ?

JC Passard
Provectio

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello,
I have test a lot of way to resolve this issue. No way.
Is it still possible to use egw api to connect another database ?
Does someone has an idea I could test ? or is it aventually a bug I have
to declare ?

I hope to read someone soon.

JC Passard

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello Ralf,

thanks for the hint, but unfortunately that does not work.
I have reduce the code to its simple expression :

<?php class uimaintenance { var $public_functions = array( 'maintenance'=>True ); var $dbotrs; function uimaintenance() { $this->dbotrs = new egw_db(); $this->dbotrs->connect('provectioOTRS','mysql.provectio.local', 3306,'root', 'rootsan'); } function maintenance($content=null) { $tpl=& CreateObject('etemplate.etemplate', 'provectio.maintenance'); $tpl->exec('provectio.uimaintenance.maintenance', $content, $sel_option); } } This is all the code I have, and this is the answer when invoking index.php?menuaction=provectio.uimaintenance.maintenance *Database error:* Invalid SQL: SELECT * FROM egw_etemplate WHERE et_name='.provectio' AND et_template='' AND et_lang='##' ORDER BY et_lang DESC,et_template DESC,et_version DESC *mysql Error*: 1146 (Table 'provectioOTRS.egw_etemplate' doesn't exist) *File:* /home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php *Line:* 449 *Function:* egw_db::select / soetemplate::read / soetemplate::soetemplate / soetemplate::test_import / soetemplate::read / boetemplate::read / boetemplate::boetemplate / etemplate::etemplate / eval() / CreateObject(etemplate.etemplate) / uimaintenance::maintenance / ExecMethod(provectio.uimaintenance.maintenance) *Session halted.* *Database error:* Invalid SQL: SELECT * FROM egw_async WHERE async_id='##last-check-run##' *mysql Error*: 1146 (Table 'provectioOTRS.egw_async' doesn't exist) *File:* /home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php *Line:* 463 *Function:* egw_db::select / asyncservice::read / asyncservice::last_check_run / asyncservice::check_run / ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final *Session halted.* I have test with the trunk version of 1.4.002 and it's the same. I have track all the things I could understand (then not so much), I have even activate $debug in egw_db but It shows the good egw database and never the provectioOTRS db in all _debug_array. Could this happen with a particular config of php or apache ? ( I am not convinced but I am desesperate ;-) JC Passard ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ 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: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

[Jean-Charles_Passard]

Ralf Becker a écrit :

Hi Jean,

than you can only start debugging the code in
phpgwapi/inc/class.egw_db.inc.php around line 290 in trunk.

Ralf

Jean Charles Passard schrieb:

Ralf Becker a écrit :

Hi Jean,

I know Pim uses that feature to connect to different databases and I
also hava an installation where I connect to a second database.

The problem is the following:

$this->dbotrs=& CreateObject(‘phpgwapi.egw_db’);

try using

$this->dbotrs = new egw_db();

Ralf

Jean Charles Passard schrieb:

Jean Charles Passard wrote:

Hello,

I have a piece of code that doesn’t make problem in eGw 1.4.001 but now
with 1.4.002 something strange happen.
I make a connection to another database (same server than egw db) this way

class somaintenance
{
function somaintenance()
{

    $this->dbotrs=& CreateObject('phpgwapi.egw_db');
    $this->dbotrs->connect('database','dbserver', 3306,'dbuser', 

‘dbpass’);
}

blah, blah, …

}
and this is what I get :

Database error: Invalid SQL: SELECT * FROM egw_etemplate WHERE
et_name=‘provectio.maintenance’ AND et_template=’’ AND et_lang=’’ ORDER
BY et_lang DESC,et_template DESC,et_version DESC
mysql Error: 1146 (Table ‘database.egw_etemplate’ doesn’t exist)

File:
/home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php
Line: 450
Function: egw_db::select / soetemplate::read / boetemplate::read /
boetemplate::boetemplate / etemplate::etemplate / eval() /
CreateObject(etemplate.etemplate) / uimaintenance::maintenance /
ExecMethod(provectio.uimaintenance.maintenance)

Session halted.

Database error: Invalid SQL: SELECT * FROM egw_async WHERE
async_id=’##last-check-run##'
mysql Error: 1146 (Table ‘database.egw_async’ doesn’t exist)

File:
/home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php
Line: 463
Function: egw_db::select / asyncservice::read /
asyncservice::last_check_run / asyncservice::check_run /
ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final

*Session halted.

This code was working with 1.4.001
This error shows up only when connect method is called. It’s libe my
other db connection modify the global egw connection. I have followed
the code throught egw_db and etemplate but I can"t see where I mess
things up.

Any clue ?

JC Passard
Provectio

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello,
I have test a lot of way to resolve this issue. No way.
Is it still possible to use egw api to connect another database ?
Does someone has an idea I could test ? or is it aventually a bug I have
to declare ?

I hope to read someone soon.

JC Passard

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello Ralf,

thanks for the hint, but unfortunately that does not work.
I have reduce the code to its simple expression :

<?php class uimaintenance { var $public_functions = array( 'maintenance'=>True ); var $dbotrs; function uimaintenance() { $this->dbotrs = new egw_db(); $this->dbotrs->connect('provectioOTRS','mysql.provectio.local', 3306,'root', 'rootsan'); } function maintenance($content=null) { $tpl=& CreateObject('etemplate.etemplate', 'provectio.maintenance'); $tpl->exec('provectio.uimaintenance.maintenance', $content, $sel_option); } } This is all the code I have, and this is the answer when invoking index.php?menuaction=provectio.uimaintenance.maintenance *Database error:* Invalid SQL: SELECT * FROM egw_etemplate WHERE et_name='.provectio' AND et_template='' AND et_lang='##' ORDER BY et_lang DESC,et_template DESC,et_version DESC *mysql Error*: 1146 (Table 'provectioOTRS.egw_etemplate' doesn't exist) *File:* /home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php *Line:* 449 *Function:* egw_db::select / soetemplate::read / soetemplate::soetemplate / soetemplate::test_import / soetemplate::read / boetemplate::read / boetemplate::boetemplate / etemplate::etemplate / eval() / CreateObject(etemplate.etemplate) / uimaintenance::maintenance / ExecMethod(provectio.uimaintenance.maintenance) *Session halted.* *Database error:* Invalid SQL: SELECT * FROM egw_async WHERE async_id='##last-check-run##' *mysql Error*: 1146 (Table 'provectioOTRS.egw_async' doesn't exist) *File:* /home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php *Line:* 463 *Function:* egw_db::select / asyncservice::read / asyncservice::last_check_run / asyncservice::check_run / ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final *Session halted.* I have test with the trunk version of 1.4.002 and it's the same. I have track all the things I could understand (then not so much), I have even activate $debug in egw_db but It shows the good egw database and never the provectioOTRS db in all _debug_array. Could this happen with a particular config of php or apache ? ( I am not convinced but I am desesperate ;-) JC Passard ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ eGroupWare-developers mailing list eGroupWare-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Hello again :
I think that I got it :
extract from http://phplens.com/adodb/code.initialization.html#init

Connection Gotcha: If you create two connections, but both use the
same userid and password, PHP will share the same connection. This can
cause problems if the connections are meant to different databases. The
solution is to always use different userid’s for different databases, or
use NConnect().

I have tryied with $connect = ‘NConnect’; after line 282 in egw_db, it’s
seems to work well with mysql but I do not know the implications.
If think that if it’s work for you and Pim it’s because you don’t have
the same user for other databases.

It’s all in your hand know

Thanks very much for your help, this one was a bit too much for me alone.

JC Passard

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

[Ralf_Becker_6]

Hi Jean,

good to know, I try to remember for the next one asking.

So your solution is simple, create a 2. user and use that to connect the
2. database.

According to the documentation in ADOdb the NConnect is not implemented
for all Databases, so it does not make sense to use it for us …

Ralf

Jean Charles Passard schrieb:

Ralf Becker a écrit :

Hi Jean,

than you can only start debugging the code in
phpgwapi/inc/class.egw_db.inc.php around line 290 in trunk.

Ralf

Jean Charles Passard schrieb:

Ralf Becker a écrit :

Hi Jean,

I know Pim uses that feature to connect to different databases and I
also hava an installation where I connect to a second database.

The problem is the following:

$this->dbotrs=& CreateObject(‘phpgwapi.egw_db’);

try using

$this->dbotrs = new egw_db();

Ralf

Jean Charles Passard schrieb:

Jean Charles Passard wrote:

Hello,

I have a piece of code that doesn’t make problem in eGw 1.4.001 but now
with 1.4.002 something strange happen.
I make a connection to another database (same server than egw db) this way

class somaintenance
{
function somaintenance()
{

    $this->dbotrs=& CreateObject('phpgwapi.egw_db');
    $this->dbotrs->connect('database','dbserver', 3306,'dbuser', 

‘dbpass’);
}

blah, blah, …

}
and this is what I get :

Database error: Invalid SQL: SELECT * FROM egw_etemplate WHERE
et_name=‘provectio.maintenance’ AND et_template=’’ AND et_lang=’’ ORDER
BY et_lang DESC,et_template DESC,et_version DESC
mysql Error: 1146 (Table ‘database.egw_etemplate’ doesn’t exist)

File:
/home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php
Line: 450
Function: egw_db::select / soetemplate::read / boetemplate::read /
boetemplate::boetemplate / etemplate::etemplate / eval() /
CreateObject(etemplate.etemplate) / uimaintenance::maintenance /
ExecMethod(provectio.uimaintenance.maintenance)

Session halted.

Database error: Invalid SQL: SELECT * FROM egw_async WHERE
async_id=’##last-check-run##'
mysql Error: 1146 (Table ‘database.egw_async’ doesn’t exist)

File:
/home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php
Line: 463
Function: egw_db::select / asyncservice::read /
asyncservice::last_check_run / asyncservice::check_run /
ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final

*Session halted.

This code was working with 1.4.001
This error shows up only when connect method is called. It’s libe my
other db connection modify the global egw connection. I have followed
the code throught egw_db and etemplate but I can"t see where I mess
things up.

Any clue ?

JC Passard
Provectio

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello,
I have test a lot of way to resolve this issue. No way.
Is it still possible to use egw api to connect another database ?
Does someone has an idea I could test ? or is it aventually a bug I have
to declare ?

I hope to read someone soon.

JC Passard

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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

Hello Ralf,

thanks for the hint, but unfortunately that does not work.
I have reduce the code to its simple expression :

<?php class uimaintenance { var $public_functions = array( 'maintenance'=>True ); var $dbotrs; function uimaintenance() { $this->dbotrs = new egw_db(); $this->dbotrs->connect('provectioOTRS','mysql.provectio.local', 3306,'root', 'rootsan'); } function maintenance($content=null) { $tpl=& CreateObject('etemplate.etemplate', 'provectio.maintenance'); $tpl->exec('provectio.uimaintenance.maintenance', $content, $sel_option); } } This is all the code I have, and this is the answer when invoking index.php?menuaction=provectio.uimaintenance.maintenance *Database error:* Invalid SQL: SELECT * FROM egw_etemplate WHERE et_name='.provectio' AND et_template='' AND et_lang='##' ORDER BY et_lang DESC,et_template DESC,et_version DESC *mysql Error*: 1146 (Table 'provectioOTRS.egw_etemplate' doesn't exist) *File:* /home/system/apache/egwtest/html/etemplate/inc/class.soetemplate.inc.php *Line:* 449 *Function:* egw_db::select / soetemplate::read / soetemplate::soetemplate / soetemplate::test_import / soetemplate::read / boetemplate::read / boetemplate::boetemplate / etemplate::etemplate / eval() / CreateObject(etemplate.etemplate) / uimaintenance::maintenance / ExecMethod(provectio.uimaintenance.maintenance) *Session halted.* *Database error:* Invalid SQL: SELECT * FROM egw_async WHERE async_id='##last-check-run##' *mysql Error*: 1146 (Table 'provectioOTRS.egw_async' doesn't exist) *File:* /home/system/apache/egwtest/html/phpgwapi/inc/class.asyncservice.inc.php *Line:* 463 *Function:* egw_db::select / asyncservice::read / asyncservice::last_check_run / asyncservice::check_run / ExecMethod(phpgwapi.asyncservice.check_run) / common::egw_final *Session halted.* I have test with the trunk version of 1.4.002 and it's the same. I have track all the things I could understand (then not so much), I have even activate $debug in egw_db but It shows the good egw database and never the provectioOTRS db in all _debug_array. Could this happen with a particular config of php or apache ? ( I am not convinced but I am desesperate ;-) JC Passard ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ eGroupWare-developers mailing list eGroupWare-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Hello again :
I think that I got it :
extract from http://phplens.com/adodb/code.initialization.html#init

Connection Gotcha: If you create two connections, but both use the
same userid and password, PHP will share the same connection. This can
cause problems if the connections are meant to different databases. The
solution is to always use different userid’s for different databases, or
use NConnect().

I have tryied with $connect = ‘NConnect’; after line 282 in egw_db, it’s
seems to work well with mysql but I do not know the implications.
If think that if it’s work for you and Pim it’s because you don’t have
the same user for other databases.

It’s all in your hand know

Thanks very much for your help, this one was a bit too much for me alone.

JC Passard

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

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