Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Oct 23 07:32
    FrancescoGd commented #638
  • Oct 23 06:28
    pauljaks edited #639
  • Oct 23 06:24
    pauljaks opened #639
  • Oct 20 20:30
    dregad labeled #638
  • Oct 20 20:29
    dregad labeled #620
  • Oct 20 20:24
    dregad closed #638
  • Oct 20 20:24
    dregad commented #638
  • Oct 20 20:24
    dregad labeled #638
  • Oct 20 12:38
    FrancescoGd commented #638
  • Oct 20 12:37
    FrancescoGd commented #638
  • Oct 19 20:26
    dregad commented #638
  • Oct 19 09:46
    FrancescoGd commented #638
  • Oct 16 15:28
    dolphinotaku commented #491
  • Oct 16 13:33
    dolphinotaku commented #491
  • Oct 16 13:09
    dolphinotaku commented #491
  • Oct 16 10:11
    davidsneighbour commented #638
  • Oct 16 08:57
    dregad commented #638
  • Oct 16 08:14
    FrancescoGd commented #638
  • Oct 15 13:52
    dregad commented #638
  • Oct 15 11:05
    FrancescoGd opened #638
Mark Newnham
@mnewnham
Yes please. Could you include a code sample including things like fetchmode. This odd query behavior feels like something I've seen before, a long time ago.
Federico Martinez
@federicoemartinez
Wellington Pinto
@wellspinto_twitter

Hi everyone.
I use adodb to connect with an access database.
I have a field with the name MÉD.
I have tried several SELECT and nothing.
SELECT MÉD
SELECT MÉD
SELECT [MÉD]

How to proceed?

Damien Regad
@dregad
@wellspinto_twitter I would say that it's always a bad idea to use accented characters for field names to begin with...
Anyway I don't use Access myself so I'm afraid I won't be of much help here, but this could be a limitation of the underlying ODBC driver which ADOdb relies on. Try to execute your query directly using odbc_execute() or odbc_exec() - if that fails too, then it's not an ADOdb issue, and we won't be able to help.
Crystal Shaneyfelt
@crystalshaneyfelt
Hi, my team switched to using dev-master for PHP 7.2 compatibility. It looks like the update is planned to be included in 5.20.15. We'd like to switch back to using a tagged version if possible. Is there a planned release date for 5.20.15?
Thanks
Damien Regad
@dregad
Yes I was planning on releasing before summer but I got sidetracked sorry
hdale
@hdale

Hi! Would need some help with connecting PHP7.2 on Centos 7 with adoDB 5.20.14 to MSSQL server 2012. I have following settings: Into folder /usr/lib64/php/modules I have copied the files php_sqlsrv_72_nts.signature, php_sqlsrv_72_nts.so, php_sqlsrv_72_ts.signature, php_sqlsrv_72_ts.so. In php.ini I have the extension setup: [mssqlnative]
extension=/usr/lib64/php/modules/php_sqlsrv_72_ts.so. In my connection class I've following settings: <?php
require_once('ADOdb-5.20.14/adodb.inc.php');

$_SYS_DB_CONFIG = array(
'host' => ‘xx.xxx.xxx.xxx’,
'database' => 'test',/
'user' => 'dbuser',
'password' => ‘password’,
'type' => 'mssqlnative'
);
function getDBConnection() {
global $_SYS_DB_CONFIG;
$cnn = adoNewConnection($_SYS_DB_CONFIG['type']);

//$cnn->setConnectionParameter('CharacterSet','ISO-8859-15');

$ret = $cnn->Connect(
            $_SYS_DB_CONFIG['host'],
            $_SYS_DB_CONFIG['user'],
            $_SYS_DB_CONFIG['password'],
            $_SYS_DB_CONFIG['database']
) or die("Unable to connect to server");
if (!$ret) {
Sorry, pressed enter. Ok so I continue previous explanation: I get connection OK, but I have problems with character encoding. The collation of the MSSQL server is Finnish_Swedish_CA_AS. The pages I serve are in encoding 1251. Now I get scrambled all the scandinavian letters like äöå.
hdale
@hdale
I tried to set $cnn->setConnectionParameter('CharacterSet','ISO-8859-15'); but it won't accept it. It only accepts: cnn->setConnectionParameter('CharacterSet','UTF-8');
How to get the scandinavian characters displayed correctly?
hdale
@hdale
Is it so that adoDB 5.20.14 only supports UTF-8? or why is that I can't get ISO-8859-15 working?
KJones
@KJsRepo

So I'm trying to connect to an MSSQL server, and I'm getting a very ADODB error. Connecting with:

$msdb = NewADOConnection("pdo_sqlsrv");

I get:

PHP Fatal error: Uncaught Error: Class 'ADODB_pdo' not found in /srv/npsm/httpd/www/htdocs/ADOdb-5.20.14/drivers/adodb-pdo_sqlsrv.inc.php:6

So I looked for "ADODB_pdo" and found it in (surprise!) adodb-pdo.inc.php, so I manually included it in the test file, and I'm getting:
include("ADOdb-5.20.14/drivers/adodb-pdo.inc.php");

Oops :

PHP Fatal error: Uncaught Error: Call to a member function prepare() on bool in /srv/npsm/httpd/www/htdocs/ADOdb-5.20.14/drivers/adodb-pdo.inc.php:479

KJones
@KJsRepo
Well, that second bit is embarrassing, I just wasn't connecting properly. But I do still have to include the pdo driver file manually.
Damien Regad
@dregad
KJones
@KJsRepo
I see now... I am not a smart man. Thanks for everything!
Damien Regad
@dregad
No worries 😃
KJones
@KJsRepo
I don't think this is an ADOdb problem, but just in case you happen to have any insight on this.... Hitting a MSSQL server: On my Windows / ODBC connection, this query takes 0.01 seconds. On Linux / PDO, it takes 0.12 seconds, so 10x longer.
I'm using PConnect to make the connection, so it should be using pooling...
Damien Regad
@dregad
I don't use mssql sorry can't help
KJones
@KJsRepo
Thanks anyway!
Damien Regad
@dregad

ADOdb Version 5.20.15 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.20.15/docs/changelog.md
Mark Newnham
@mnewnham
Hey Damien, I'm having trouble resetting my login on mantisbt bug reporting, doesn't seem to want to send me a reset email. Anyway, I'm using 2.22.1 and in /api/soap/mc_api.php on line 364, its trying to call 2 methods , "getMessage" and "getFault", that don't exist in the class "RestFault". To test, use the rest api to update the status of an issue, without the privileges to do so. A "Slim Application error" is thrown. Thanks, Mark
Damien Regad
@dregad

Hey Damien, I'm having trouble resetting my login on mantisbt bug reporting, doesn't seem to want to send me a reset email.

I tried the reset on the server side, you should receive a notification to confirm the password change (maybe check your spam folder ?)

Mark Newnham
@mnewnham
wondering if you've got time to do a 5.21 release soon. I've got more fixes/updates to go towards 5.22.
Khastech123
@Khastech123
Helo I got an error during ojs installation process. The error is http 500 on localhost.
Damien Regad
@dregad
@Khastech123 not sure what ojs is, and what that has to do with ADOdb. In any case, you are not providing enough information to analyze the problem. You should start by looking at your webserver's logs for errors.
Khastech123
@Khastech123
@dregad i check the logs of webserver's but i could not resolve the issue ojs is an open source plateform to generate the rss feeds on website
Damien Regad
@dregad
Well in that case I'm not sure why you are posting here - this channel is about ADOdb library support. I suggest you look for help with ojs resources
Damien Regad
@dregad
I had a quick look and it would appear that while OJS is indeed relying on ADOdb, they are not using a standard version, so this is definitely not the right place for you to post. Try the PKP community forum at http://forum.pkp.sfu.ca/
Damien Regad
@dregad

ADOdb Version 5.20.16 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.20.16/docs/changelog.md
Mark Newnham
@mnewnham
Any idea on when you might be able to cut a 5.21 release?
Damien Regad
@dregad
I was planning to do this in January, but real life got in the way... I have not forgotten, will get to it as soon as I can
Mark Newnham
@mnewnham
Could we cut a new version of 5.20 for the couple of fixes I've just done please. Hope you are safe
Damien Regad
@dregad
Hello Mark ! Sure, I'll take care of it
Damien Regad
@dregad

ADOdb Version 5.20.17 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.20.17/docs/changelog.md
Rance Hall
@ranceh_gitlab
I need some sqlite3 documentation help. There is no sample connect string in the doc page that I could find, and my development is on sqlite3 with production planned for mysql or postgresql. Have sample connections for each db, but none for sqlite3. Can someone point me in the right direction please
Damien Regad
@dregad
@ranceh_gitlab I rarely use sqlite, but you should be able to connect to a local database like so
$db = ADONewConnection('sqlite3');
$db->connect($filename);
Rance Hall
@ranceh_gitlab
@dregad Thanks for answering, this was it. What was confusing was the pro_sqlite module requires a username of root (so it says)
Damien Regad
@dregad

ADOdb Version 5.20.18 released on June 28th

see changelog https://github.com/ADOdb/ADOdb/blob/v5.20.18/docs/changelog.md
Wutze
@Wutze

Hello,

I would like to switch one of my MySQL databases to Sqlite. This works so far. But I also store the login data with cryptsession2 ... and nothing works here. The error message is: "Missing extension for sqlite".

Do I make a mistake? If so, where?

geri777
@geri777
I have installed Adodb via composer. I am not sure which version was installed - most files are tagged with @version v5.20.0 28-Nov-2015 ... for example adodb.inc.php
On Github - if I check adodb.inc.php it is tagged with "@version v5.21.0-dev ??-???-2016"
So obviously the composer repo does not have the latest version. And obviously you have "-dev" code on your master on Github.
geri777
@geri777
Damien Regad
@dregad
@geri777 I responded in #628