Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Aug 23 14:57

    dregad on master

    duh Merge branch 'hotfix/5.20' (compare)

  • Aug 23 14:56

    dregad on 5.20

    duh (compare)

  • Aug 23 14:29
    dregad closed #547
  • Aug 23 14:29

    dregad on master

    PHP 7.4: fix deprecated usage o… Merge branch 'hotfix/5.20' # C… (compare)

  • Aug 23 14:27

    dregad on 5.20

    PHP 7.4: fix deprecated usage o… (compare)

  • Aug 23 14:20
    dregad milestoned #547
  • Aug 23 14:20
    dregad labeled #547
  • Aug 23 14:20
    dregad labeled #547
  • Aug 23 14:20
    dregad opened #547
  • Aug 20 07:33
    Javaid commented #546
  • Aug 20 07:08
    dregad commented #546
  • Aug 20 07:08
    dregad labeled #546
  • Aug 20 07:08
    dregad labeled #546
  • Aug 20 06:19
    Javaid edited #546
  • Aug 20 06:19
    Javaid opened #546
  • Aug 14 16:14
    dirtyren opened #545
  • Aug 13 10:51
    dregad commented #544
  • Aug 13 10:50
    dregad labeled #544
  • Aug 13 10:50
    dregad labeled #544
  • Aug 10 17:18
    dirtyren closed #542
AGanguli
@AGanguli
Hi folks. We encountered an odd issue today that I was hoping to get some feedback on. It seems that SerializableRS closes the database connection while it serializes a record. We ended up having to write our own implementation that doesn't close the connection. Does anybody know why SerializableRS does this? Seems like very odd behaviour, and I figure there must be some good reason for it that I'm not understanding.
Mark Newnham
@mnewnham
ADOdb version please, driver, platform etc
Didier GM
@didiergm
Hi guys/gals; I need to upgrade an app which has been happily running with adodb on php 5.X for several years to php 7 but cannot find a definitive answer to the status of PHP 7 support for adodb : which version of php 7 (7.0, 7.1 7.2) is supported in the latest production versions of adodb ?
Damien Regad
@dregad
@didiergm barring any undiscovered bugs, PHP up to 7.2 is supported in ADOdb 5.20.12.
Damien Regad
@dregad

Oh and by the way

cannot find a definitive answer to the status of PHP 7 support for adodb

Not sure where you looked, but this is clearly stated in bold characters right on the project's home page: ADOdb runs on all active versions of PHP including PHP 7.

Anyway I just reworded the introduction on the PHP 7 support page to hopefully make things a bit more clear.

Didier GM
@didiergm
@dregad thanks for your detailed answer; my comment re "definitive answer" was more regarding the bottom of the page "php7_status" where the package testing status reads 'Not Yet Tested' for several modules including Session management; (which seems to me like a core feature of adodb ) hence my initial doubt
Roberto Protasio
@robertoprotasio
Today i'm trying update adodb from php 5.2 to php7.1, before was used php5_mssql extension. What extension now is being used that use mssql sintax ?
Mark Newnham
@mnewnham
For windows, use the php5_mssqlnative, available from microsost
Chathula Sampath
@Chathula
hi
i am getting an error like this.. i am new to ADOdb.. what should i do?
ADOConnection._Execute(Select packages.*, shops.shop_name sel_shop_id, group_concat(distinct shop_items.brand, ", ", shop_items.name, ", ", str_transla..., false) % line 1015, file: adodb.inc.php
                              ADOConnection.Execute(Select packages.*, shops.shop_name sel_shop_id, group_concat(distinct shop_items.brand, ", ", shop_items.name, ", ", str_transla..., false) % line  631, file: adodb-mysqli.inc.php
                           ADODB_mysqli.SelectLimit(Select packages.*, shops.shop_name sel_shop_id, group_concat(distinct shop_items.brand, ", ", shop_items.name, ", ", str_transla..., 20, 20, false) % line    0, file: 
                        call_user_func_array(Array[2], Array[4]) % line  877, file: DB.class.php
                     DB.__call(SelectLimit, Array[4]) % line  160, file: OutTable.class.php
Mark Newnham
@mnewnham
You need to provide a little more information, I suggest opening up an issue on GitHub. Provide a code snippet, the error and the version of adodb and php that you are using
Damien Regad
@dregad

ADOdb Version 5.20.13 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.20.13/docs/changelog.md
Javed Iqbal
@Javaid
Hi, I am facing a problem, while using ADODB with MSSQL.
ADODB did not print the record set of some queries having MAX data type.
any clue ?
Mark Newnham
@mnewnham
If you still need support on this please open an issue on github, we may need to get you to supply a lot of information to identify the problem
Didier GM
@didiergm
Ever heard of PHP Recoverable fatal error: session_module_name(): Cannot set 'user' save handler by ini_set() or session_module_name() in inc/classes/adodb5/session/adodb-session2.php on line 467 with Version 5.20.13 , php 7.2
I must say that I had the same error when using an older version of adodb, but no issues with php 7.1
Damien Regad
@dregad
#449 ?
Didier GM
@didiergm
Looks like it
OK, I'll remove the line as suggested and see what happens; thanks @dregad
Damien Regad
@dregad
Thank you @didiergm. And since @UrvishSSPL has not yet provided any feedback, it would be great if you could let me know by posting a note in the issue, if the problem is indeed fixed and also if you notice any side-effects or regressions.
Didier GM
@didiergm
Of course will do, although it may take a wee while before I am confident there's no issues
Damien Regad
@dregad
No worries. Cheers !
Brice Favre
@brice
Hello, i use the last version of ADODB with the PDO-MySQL driver. I wonder why GenID is not supported? We need it for compatibility with one of our library. What should i do? Is it a good candidate for an issue and a PR?
Damien Regad
@dregad
@brice by all means do submit a pull request.
pikeshawn
@pikeshawn
I am not sure if anyone knows but is there a reason why I could connect with MYSQLi but not with PConnect? I keep getting connection refused with the same params as I use for Mysqli.
this works
$user='user';
$dbname='db';
$password='pass';
$port='1234';
echo "<br>$server<br>$user<br>$password<br>$port<br>$dbname<br>";
if (mysqli_connect($server, $user, $password, $dbname, $port)) {
   echo 'I connected';
} else {
        echo 'not connected';
}
this does not
$database->PConnect($host, $login, $pass, $dbase);
the values for the variables are the same
Mark Newnham
@mnewnham
You're not really comparing like-for-like, firstly, adodb uses mysqli_real_connect to connect, not mysqli_connect. More importantly, when you use pConnect(), you are establishing a persistent connection to the mysql database, which you are not doing with your own example. Try first using ->connect(), then move on from there
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