adodb and odbc support in 1.3
I want to connect to an Access db on a a Vista pc (I have to, it is a legacy app.) I installed cakephp 1.3 and a datasource file found on the Bakery, only to discover that the file depends on dbo_adodb and dbo_adodb is missing in 1.3. Odbc is missing too form 1.3. Should I stay with a 1.2 version of cake? Or can I copy the files from 1.2 to 1.3? thank you maxx OT: I installed xampp and easyphp on the aforementioned Vista pc and I'm not satisfied. What wamp solution do you install on windows (vista)? I don't want to waste hours managing permissions, paths and other unknown parameters preventing apache from working properly. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: adodb and odbc support in 1.3
What happens when you give it a go? Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 25 Sep 2010, at 09:33, emmexx wrote: I want to connect to an Access db on a a Vista pc (I have to, it is a legacy app.) I installed cakephp 1.3 and a datasource file found on the Bakery, only to discover that the file depends on dbo_adodb and dbo_adodb is missing in 1.3. Odbc is missing too form 1.3. Should I stay with a 1.2 version of cake? Or can I copy the files from 1.2 to 1.3? thank you maxx OT: I installed xampp and easyphp on the aforementioned Vista pc and I'm not satisfied. What wamp solution do you install on windows (vista)? I don't want to waste hours managing permissions, paths and other unknown parameters preventing apache from working properly. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: adodb and odbc support in 1.3
On 25 Set, 11:04, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: What happens when you give it a go? I did a very simple scaffold. I copied dbo_adodb and dbo_adodb to model/datasources/... The index page of a table works but if I try to load one of the following (paginated) pages I get the following warning: Warning (512): SQL Error: [Microsoft][Driver ODBC Microsoft Access] Syntax error (missing operator) in the query 'OFFSET 20 [T1]. [id_persona]'. [CORE\cake\libs\model\datasources\dbo_source.php, line 681] I never used OFFSET in a ms access query, it's not a reserved word. OFFSET is used as an alternative to mysql LIMIT in dbo_adodb_access.php. I can live off without pagination in this particular application but my question was: can I use reliably this driver or it is unsupported/ wrong/obsolete and query results are unpredictable? And does association between models work properly? Thank you maxx Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: adodb and odbc support in 1.3
On 25 Set, 17:09, emmexx emmeics...@gmail.com wrote: Warning (512): SQL Error: [Microsoft][Driver ODBC Microsoft Access] Syntax error (missing operator) in the query 'OFFSET 20 [T1]. [id_persona]'. [CORE\cake\libs\model\datasources\dbo_source.php, line 681] Sorry I forgot to copy the query: Query: SELECT TOP 20 OFFSET 20 T1.id_persona ... maxx Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
1.2 RC3 and Adodb
Hi, I was trying to use Adodb in Cake 1.2 RC3 and for testing it I tried to connect to a mysql database like this: var $default = array( 'driver' = 'adodb', 'connect'= 'mysql', 'persistent' = true, 'host' = 'host', 'login' = 'root', 'password' = '', 'database' = 'test', ); but every time I do a query with that returns more than one result it enters in a infinite cycle. Can anyone confirm this behavior or do you have your connections using ado working? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: 1.2 RC3 and Adodb
You should not use the AdoDB driver for any database that does not require it. It is by far the slowest database driver. From the code you posted you are using MySQL. You should be using the native mysql dbo object. The last time I tested it, I did so against mysql and it was working. -Mark On Oct 21, 8:24 am, lightglitch [EMAIL PROTECTED] wrote: Hi, I was trying to use Adodb in Cake 1.2 RC3 and for testing it I tried to connect to a mysql database like this: var $default = array( 'driver' = 'adodb', 'connect'= 'mysql', 'persistent' = true, 'host' = 'host', 'login' = 'root', 'password' = '', 'database' = 'test', ); but every time I do a query with that returns more than one result it enters in a infinite cycle. Can anyone confirm this behavior or do you have your connections using ado working? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: adodb vendor using odbc for SQL Server 2005
For future reference to someone with the same problem. while using the driver adodb, you should use connect odbc_mssql for SQL Server On 4 Feb, 10:33, hellfish [EMAIL PROTECTED] wrote: Hi, I'm having a bit of a problem using SQL Server Database as data storage. My setup: Cakephp 1.1 SQL Server 2005 ADOdb library in the vendors folder my current connection: driver = adodb connect = odbc The connection is made (I spend a few days figuring the right way to do this) but the queries are not made correctly. The app worked fine using an identical structure in MySQL but with SQL Server I get an invalid argument supplied for foreach() in line 223 of the cake\libs \model\dbo\dbo_adodb.php This results in having a query like SELECT 0 FROM table... Has anyone experienced this problem? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
adodb vendor using odbc for SQL Server 2005
Hi, I'm having a bit of a problem using SQL Server Database as data storage. My setup: Cakephp 1.1 SQL Server 2005 ADOdb library in the vendors folder my current connection: driver = adodb connect = odbc The connection is made (I spend a few days figuring the right way to do this) but the queries are not made correctly. The app worked fine using an identical structure in MySQL but with SQL Server I get an invalid argument supplied for foreach() in line 223 of the cake\libs \model\dbo\dbo_adodb.php This results in having a query like SELECT 0 FROM table... Has anyone experienced this problem? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Adodb Library in Cake
The following worked:
vendor ('adodb' . DS . 'adodb.inc');
if ( !$Dbo = NewADOConnection('odbc') ) throw new
Exception('NewADOConnection failed');
$Dbo-Connect($my_dsn, $dbuser, $dbpass);
Are there better/safer/cleaner ways?
Tom
On Jan 28, 8:22 am, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
I see from the Cake API that there is a DboAdodb class:
http://api.cakephp.org/class_dbo_adodb.html
How can I create an object using this class within say a controller?
I need to connect to an iSeries database. I have been able to
successfully connect using the Adodb library outside of Cake. When I
try to configure Cake to connect however, the autoconfig stuff always
causes it to choke.
I notice that Cake includes the Adodb library. If I could just figure
out a way to create my own Adodb object, my problem would be solved.
Thanks,
Tom
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Adodb
This makes me wonder if anyone has done it. My project needs to connect to Oracle and it looks like the Adodb lib is the only one we can use to do that. I will post back later if we get it working. On Oct 23, 6:17 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Has anyone successfully used adodb with Cake. If so ver 1.17. Or does anyone know if there's a tutorial for this. Reason being I have this app that uses adodb and in needs to be integrated into Cake. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Adodb
var $default = array(
'driver' = 'adodb',
'connect' = 'oci8',
'host' = '',
'login'= 'username',
'password' = 'password',
'database' = 'dbname',
'prefix' = ''
);
I found that the major issue that I had was placing a host name in the
array. You should leave it blank.
Use this script to test if your Oracle/PHP configuration is working:
?php
$conn = oci_connect('username', 'password', 'dbname');
oci_connect(
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}
$query = SELECT 'hello' FROM DUAL;
$stid = oci_parse($conn, $query);
if (!$stid) {
$e = oci_error($conn);
print htmlentities($e['message']);
exit;
}
$r = oci_execute($stid, OCI_DEFAULT);
if (!$r) {
$e = oci_error($stid);
echo htmlentities($e['message']);
exit;
}
print 'table border=1';
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
print 'tr';
foreach ($row as $item) {
print 'td'.($item?htmlentities($item):'nbsp;').'/td';
}
print '/tr';
}
print '/table';
oci_close($conn);
?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Adodb
Has anyone successfully used adodb with Cake. If so ver 1.17. Or does anyone know if there's a tutorial for this. Reason being I have this app that uses adodb and in needs to be integrated into Cake. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: using adodb?
Claudia wrote: The sourcecode of dbo_adodb.php seems to imply that you specify only 'adodb' as driver and 'mysql' in the parameter 'connect' - maybe you should try this. I get the same result. From the lack of replies it seems that nobody uses adodb with cakephp. --Brent --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: using adodb?
Hi there
The sourcecode of dbo_adodb.php seems to imply that you specify only
'adodb' as driver
and 'mysql' in the parameter 'connect' - maybe you should try this.
Claudia
On Sep 20, 8:39 am, Brent Rieck [EMAIL PROTECTED] wrote:
Hello,
I'm new to Cake and have a question about how to use adodb rather
than the default database drivers as I keep getting the following error:
Fatal error: Unable to load DataSource file dbo/dbo_adodb-mysql.php in
/web/websites/asdf/cake/libs/model/connection_manager.php on line 163
I haven't been able to find any working examples of a cake app that
uses adodb yet, and after searching the google groups archive for hints
it seems nobody else has had this problem (or if they have they haven't
posted about it), the manual is a little thin on adodb, and the search
feature on the cakephp.org website and bakery is broken right now it
seems too.
Here's my details:
I've got a copy of adodb stuffed in vendors/adodb
Here's the relevant snippet from my app/config/database.php file:
var $default = array('driver' = 'adodb-mysql',
'connect' = 'mysql_connect',
'host' = 'localhost',
'login'= 'asdf',
'password' = 'asdf',
'database' = 'asdf',
'prefix' = '');
I'm using cake version 1.1.17.5612
Any ideas? Am I doing something boneheaded?
Thanks,
Brent
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
using adodb?
Hello,
I'm new to Cake and have a question about how to use adodb rather
than the default database drivers as I keep getting the following error:
Fatal error: Unable to load DataSource file dbo/dbo_adodb-mysql.php in
/web/websites/asdf/cake/libs/model/connection_manager.php on line 163
I haven't been able to find any working examples of a cake app that
uses adodb yet, and after searching the google groups archive for hints
it seems nobody else has had this problem (or if they have they haven't
posted about it), the manual is a little thin on adodb, and the search
feature on the cakephp.org website and bakery is broken right now it
seems too.
Here's my details:
I've got a copy of adodb stuffed in vendors/adodb
Here's the relevant snippet from my app/config/database.php file:
var $default = array('driver' = 'adodb-mysql',
'connect' = 'mysql_connect',
'host' = 'localhost',
'login'= 'asdf',
'password' = 'asdf',
'database' = 'asdf',
'prefix' = '');
I'm using cake version 1.1.17.5612
Any ideas? Am I doing something boneheaded?
Thanks,
Brent
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
cake con informix - tengo conexión con la bd a travé de ADOdb pero no puedo acceder a ninguna tabla
Hola !
Estoy probando cakePHP con una base de datos informix a través del
driver ADOdb pero no tengo acceso a ninguna tabla. Si me creo un
modelo llamado 'articulo' y su respectivo controlador 'articulos'
cuando cake intenta acceder al modelo me dice:
'No Database table for model Articulo (expected articulos), create
it first.' La tabla articulos ya está creada en la base de datos !!!
Mi modelo y mi controlador son:
-- articulo.php
?php
class Articulo extends AppModel
{var $name='Syscolumn';
}
?
Si hago una consulta a la base de datos con un script php fuera del
framework, tengo acceso a todas las tablas y no tengo ningún error.
Ejem:
?php
include('adodb5/adodb.inc.php');
$server=hp9000d_shm;
$user=informix;
$pwd=**;
$db=mibd;
$conn = ADONewConnection(informix72);
$conn-PConnect($server, $user, $pwd, $db);
$qry = select * from artic where Codart=041005;;
$row = $conn-Execute($qry);
echo $row;
?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
cake con informix - tengo conexión con la bd a travé de ADOdb pero no puedo acceder a ninguna tabla
Hola !
Estoy probando cakePHP con una base de datos informix a través del
driver ADOdb pero no tengo acceso a ninguna tabla. Cuando ejecuto
http://localhost/cake me dice:
'Your database configuration file is present.'
'Cake is able to connect to the database.'
Hasta aquí todo bien. Todo está correcto.
Si me creo un modelo llamado 'articulo' y su respectivo controlador
'articulos' cuando cake intenta acceder al modelo me dice:
'No Database table for model Articulo (expected articulos), create
it first.' La tabla articulos ya está creada en la base de datos !!!
Mi modelo y mi controlador son:
-- articulo.php
?php
class Articulo extends AppModel
{ var $name='Articulo'; }
?
- articulos_controller.php -
?php
class ArticulosController extends AppController
{ var $name='Articulos'; var $scaffold; }
?
He probado también a poner en el archivo database.php la variable
'prefix' el esquema de la base de datos: 'prefix' = 'informix.';
pero obtengo el mismo error.
Si hago una consulta a la base de datos con un script php fuera del
framework, tengo acceso a todas las tablas y no tengo ningún error.
Ejem:
informix.php -
?php
include('adodb5/adodb.inc.php');
$server=hp9000d_shm;
$user=informix;
$pwd=**;
$db=mibd;
$conn = ADONewConnection(informix72);
$conn-PConnect($server, $user, $pwd, $db);
$qry = select * from artic where Codart=041005;;
$row = $conn-Execute($qry);
echo $row;
?
Las pruebas las estoy haciendo en una maquina Linux con centos 4 y
apache+php+csdk informix funcionando correctamente.
Alguién ha tenido un problema similar ? Alguna pista ???
MUCHAS GRACIAS A TODOS POR ADELANTADO !!
UN SALUDO !!
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: cake con informix - tengo conexión con la bd a travé de ADOdb pero no puedo acceder a ninguna tabla
On Sep 6, 10:49 am, superbully [EMAIL PROTECTED] wrote: Hola ! snip I see you already found the spanish group ;) AD --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
dbo adodb driver problem
where was a bug in dbo adodb driver (dbo_adodb.php)
problem was in :
function fields($model, $alias, $fields) { ... }
to fix you need to add arguments types in function:
function fields($model, $alias = null, $fields = array()) { ... }
and in the start of functio add these lines:
if (empty($alias)) {
$alias = $model-name;
}
$fields = parent::fields($model, $alias, $fields, false);
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
ADODB
Hi
I'm using adodb to connect to my DB (MSSQL2000) and when I write:
function returnSomething
{
$this-set('data',$this-MyModel-findAll());
}
I get the following message from the browser:
Warning: Missing argument 2 for DboAdodb::fields(), called in mySite
\cake\libs\model\datasources\dbo_source.php on line 580 and defined in
mySite\cake\libs\model\dbo\dbo_adodb.php on line 331
Warning: Missing argument 3 for DboAdodb::fields(), called in mySite
\cake\libs\model\datasources\dbo_source.php on line 580 and defined in
mySite\cake\libs\model\dbo\dbo_adodb.php on line 331
Notice: Undefined variable: fields in misSite\cake\libs\model\dbo
\dbo_adodb.php on line 332
Notice: Undefined variable: fields in misSite\cake\libs\model\dbo
\dbo_adodb.php on line 335
Notice: Undefined variable: alias in misSite\cake\libs\model\dbo
\dbo_adodb.php on line 362
Where I can spicified the fields and alias?
Thanx
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
adodb-access execute() error: SQL Error: Too few parameters
Hello, I am trying to use the adodb-access driver, and I have no trouble with querying, but running execute() with an UPDATE or INSERT yields an SQL error. It dumps the SQL statement to the screen, and when I run the same statement within the database, it goes without a problem. Looking at posts within the group and trac, I realise that adodb is not as well supported as the other drivers, but I feel that there would be many more posts along these lines if INSERT/UPDATE didn't work at all. Is there some kind of trick that I am missing? Thank you, phrygius --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
[WTA] detail connection setting to informix using adodb driver
Hi, Does anybody want to tell me about detail database setting for connecting to informix database server in CakePHP Thanks, --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Notice: Only variable references .. in adodb-mysql.inc.php on line 75
Probelm fixed! Some how extra characters were at the end of the file that was causing problem --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Notice: Only variable references .. in adodb-mysql.inc.php on line 75
I have CakePHP in production and having some problem
1. It is shared hosting and no access to httpd.conf
Access to only
/home/myusername
/home/myusername/public_html
2. Setup
/home/myusername/app
/home/myusername/cake
/home/myusername/vendors (- has adodb)
/home/myusername/public_ html(- has the content of webroot)
Error: It is not connecting to Mysql
=
Notice: Only variable references should be returned by reference in
/home/myusername/vendors/adodb/drivers/adodb-mysql.inc.php on line 75
database.php
=
class DATABASE_CONFIG
{
var $default = array('driver' = 'adodb',
'connect' =
'mysql',
'host' =
'localhost',
'login' =
'fhawk',
'password' =
'KRcy599',
'database' =
'pr_phpfeedhawk');
}
index.php
===
if (!defined('ROOT')) {
define('ROOT', DS.'home'.DS.'myusername');
}
if (!defined('APP_DIR')) {
define('APP_DIR', 'app');
}
if (!defined('CAKE_CORE_INCLUDE_PATH')) {
define('CAKE_CORE_INCLUDE_PATH', ROOT);
}
Have also tried putting the following lines at the top in index.php
define('BASE_DIR', '/home/deepakpr/');
define('ROOT', BASE_DIR.'cake');
define ('APP_DIR', 'app');
define ('WEBROOT_DIR', 'public_html');
My problem could be else where, I am not able to google for the notice
of adodb.
If anyone ran into this problem, will you please share.
Thanks
Notice: Only variable references .. in adodb-mysql.inc.php on line 75
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~--~~~~--~~--~--~---
How to/where to set ADODB config instructions + utilise adodb methods.
Does anybody know where in cake you set adodb instructions such as $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC. Also, how do you utilise adodb methods such as execute to retrieve database records and how do these methods interact with the cake standard model methods such as findAll etc. Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Gettign a Adodb Session to work in cake
Are you saying a fix is required? Do tell. You can post bug and feature requests at https://trac.cakephp.org/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Gettign a Adodb Session to work in cake
No one who can help me in this case?
[EMAIL PROTECTED] wrote:
I need my session in cake work with the adodb sessio lib. I get it to
work in an older cake version, but with the latest cake cake_1.0.1.2708
it dont work any more.
my bootstrap looks like this:
###
$ADODB_SESSION_DRIVER = 'mysql';
$ADODB_SESSION_CONNECT = 'localhost';
$ADODB_SESSION_USER = 'user';
$ADODB_SESSION_PWD = 'pass';
$ADODB_SESSION_DB = 'test';
vendor('adodb/adodb.inc');
vendor('adodb/adodb-session');
###
The Site alwas tells my that it cannot connect to the datase, the
credentials are 100 percent correct
hope anybody hears me crying
thanks
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~--~~~~--~~--~--~---
Re: Gettign a Adodb Session to work in cake
I don't know about ADODB myself but if you change your debug level to 2 and post the error messages someone might be able to better help find a solution for you.On 6/6/06,
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
No one who can help me in this case?[EMAIL PROTECTED] wrote: I need my session in cake work with the adodb sessio lib. I get it to work in an older cake version, but with the latest cake cake_1.0.1.2708
it dont work any more. my bootstrap looks like this: ### $ADODB_SESSION_DRIVER = 'mysql'; $ADODB_SESSION_CONNECT = 'localhost'; $ADODB_SESSION_USER = 'user';
$ADODB_SESSION_PWD = 'pass'; $ADODB_SESSION_DB = 'test'; vendor('adodb/adodb.inc'); vendor('adodb/adodb-session'); ### The Site alwas tells my that it cannot connect to the datase, the
credentials are 100 percent correct hope anybody hears me crying thanks
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Gettign a Adodb Session to work in cake
You might want to jump on the irc channel and see if someone there can give you some help, try looking for nate or phpnut, they mioght be able to help. You might try adding some debugging calls to the adodb libraries you are trying to use and see if you can gain some insight that way. It is possible that there is some namespace problem or connections that are getting grabed somewhere.
Sam DOn 6/6/06, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
No one who can help me in this case?[EMAIL PROTECTED] wrote: I need my session in cake work with the adodb sessio lib. I get it to
work in an older cake version, but with the latest cake cake_1.0.1.2708
it dont work any more. my bootstrap looks like this: ### $ADODB_SESSION_DRIVER = 'mysql'; $ADODB_SESSION_CONNECT = 'localhost'; $ADODB_SESSION_USER = 'user';
$ADODB_SESSION_PWD = 'pass'; $ADODB_SESSION_DB = 'test'; vendor('adodb/adodb.inc'); vendor('adodb/adodb-session'); ### The Site alwas tells my that it cannot connect to the datase, the
credentials are 100 percent correct hope anybody hears me crying thanks
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Gettign a Adodb Session to work in cake
Sorry dude, I don't know crap about ADO. Are you not able to use the MySQL native driver? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Adodb with Sybase it not work on CakePHP
Thanks so much. I'm waiting for your Cake-native Sybase and I'll very happy to baking with Sybase-Driver. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Adodb with Sybase it not work on CakePHP
I'm using cakePHP and adodb (cake_1.0.1.2708.tar.gz , adodb481.tgz.gz)
and I query this sql in my.php as following:
my.php
-
class MyModel extends AppModel {
var $name = 'My';
var $useTable = false;
var $useDbConfig = 'sybase';
function view() {
$sql = SELECT name FROM sysobjects;
$ret = $this-findBySql($sql);
return $ret;
}
}
-
When I run web browser
Then i've got an alert message box
CGI / FastCGI has encountered a problem and needs to close. We are
sorry for the inconvenience.
and close message box
web browser have display:
CGI Error
The specified CGI application misbehaved by not returning a complete
set of HTTP headers. The headers it did return are:
Please tell me the right way to use adodb-sybase
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~--~~~~--~~--~--~---
Re: Adodb with Sybase it not work on CakePHP
first, findBySql is deprecated, use query() instead. Anyways, you have an error with CGI ? You haven't PHP as a module in Apache? If you comment findBySql, the CGI error is not shown? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Adodb with Sybase it not work on CakePHP
I'm try to use native adodb with sybase its ok. But when I use adodb with sybase via cakePHP the CGI error is shown ! Please try solve for me. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
