by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jun 01 02:53
    stccorp closed #616
  • Jun 01 02:53
    stccorp commented #616
  • May 31 23:57

    mnewnham on 5.20

    Retrieve error messages early b… (compare)

  • May 31 23:49
    mnewnham closed #614
  • May 31 23:49

    mnewnham on master

    Retrieve error messages early b… (compare)

  • May 31 21:14
    mnewnham commented #616
  • May 31 18:59
    mnewnham commented #614
  • May 31 18:56
    mnewnham edited #614
  • May 31 05:09
    stccorp commented #616
  • May 31 05:06
    stccorp commented #616
  • May 31 05:06
    stccorp commented #616
  • May 31 05:03
    stccorp commented #616
  • May 31 04:17
    stccorp commented #616
  • May 31 04:16
    stccorp commented #616
  • May 31 02:10
    mnewnham commented #616
  • May 30 22:10
    mnewnham closed #615
  • May 30 22:10
    mnewnham commented #615
  • May 30 22:09
    mnewnham commented #616
  • May 30 01:08
    jasonmm closed #136
  • May 30 01:08
    jasonmm commented #136
Damien Regad
@dregad

ADOdb Version 5.20.14 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.20.14/docs/changelog.md
Federico Martinez
@federicoemartinez
Hi! I need to connect to a MSSQL
Using tls, is that possible with adodb?
Mark Newnham
@mnewnham
Which driver. mssql or mssqlnative?
Federico Martinez
@federicoemartinez
We have this legacy app that needs to run using php 7.2 and support tls to connecto to sqlserver. It uses ADODB_odbc_mssql2012 to access sqlserver but it doesn't seem to work, we get an SSL error. We changed to native and it seems to work, however, the same app uses doctrine1 for migrations and it uses pdo to access sqlserver. Thing is that when we configure adodb to use the nativeclient, the application crashes (i think php segfaults) when we try to access the page where the migrations (and hence doctrine1) is loaded. We tried adodb with PDO_SQLSRV but it lacks the meta* functions. At the moment, we are trying to figure how why it crashes and see if we can update to doctrine2 or something. Sorry for the long story, do you know if it is possible using odbc_mssql2012 ? Thanks!
Federico Martinez
@federicoemartinez
we have configured xdebug to get a trace of the cash and it seems it's crashing in adodb code, specifically in ADORecordset_mssqlnative->_close() Any thoughts on what can we do?
Federico Martinez
@federicoemartinez
we found the query that made it crash: SELECT confvalue "0" from customconf where id = 3
we removed the "0" and it worked. Odd query but I guess it shouldn't crash
Damien Regad
@dregad
Good to hear you found the root cause of the problem. As to why it crashed, if @mnewnham can spare the time and is able to reproduce (I can't as I don't use MSSQL), maybe we'll be able to get to the bottom of the issue. Thanks for the feedback anyway.
Federico Martinez
@federicoemartinez
Thank you! Would you like me to create an issue in github?
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