Undefined index: aggregate about laravel-db2 HOT 4 CLOSED

Hi.

What OS is hosting your code right now?

First this package is made for Laravel Framework. I don't know OctoberCMS. Even if it is based on Laravel I don't know again how to extend database module of this CMS.

Plus you have to know that for now pdo_ibm doesn't work well on IBMi so you can't make it work natively on IBMi. I'm working on it with Zend and IBM.
So my package work only with ODBC. Here I have a webapp running under Windows Server very well. I didn't test with unixODBC but it should.

Now the thing is that in your error stack message I don't see anything from my package. What did you do exactly?

from laravel-db2.

Sorry, here are more details:

As far as an OS goes, it's just the AS400 running with AIX. It's an iSeries, which is separate from their LUW products.

I realize that it is for Laravel. I just assumed since OctoberCMS was built on vanilla Laravel, using Illuminate, that this plugin would be compatible. I'll try testing the plugin with just Laravel today and see how it goes.

Also, we are using Zend Server as you mentioned. We have been able to successfully use Doctrine as a DBAL with just DB2 calls and not ODBC, so Symfony is a viable option, but I was really stoked when I heard about a Laravel solution, so I wanted to give it a shot. I can try out the ODBC maybe, but I'm not sure how to get an ODBC driver running on an iSeries. I could look into that also.

I am calling php artisan october:up, which just seeds the database like db:seed does, but with OctoberCMS data. I realize you're not here to debug October, and I'm not asking you to, but any help would be awesome. I'll try just Laravel today and give you an update on how that goes.

from laravel-db2.

Actually my package should work as it with Laravel (Really don't know for OctoberCMS but why not) running with Zend Server for IBMi. The thing is that it relies on PDO database access. That's why it works only with PDO_ODBC or PDO_IBM. In fact most of PHP frameworks use PDO.

As I said PDO_IBM is broken on IBMi (Zend Server). I'm waiting from them a fix.
A fix exists => http://youngiprofessionals.com/wiki/index.php/XMLService/PHPPDOChangeLog
The major issue I'm faced to is "- odd problem in column names" and they, he, she fixed it.

So I have a case opened at Zend. I'm waiting a new PDO_IBM.so library compiled for Zend Server for IBMi. Then I test it.

Doctrine uses ibm_db2 driver. This latter is not broken on IBMi. That's why you could make it work.

This issue made us host our website on Windows/Apache but I have good hope that we can migrate it on Zend Server for IBMi as soon as they fix PDO_IBM driver.

About OctoberCMS i'll try to have a look on it as soon as I have time ;-) Could you ask them in the same time how we can extend database access with their CMS. For instance there are also other packages for Laravel which add MongoDB support.

from laravel-db2.

Oh, that's great! Thanks for that link. I will talk to some developers in the OctoberCMS IRC and relay the information.

from laravel-db2.