search

dreamfactorysoftware / dreamfactory

DreamFactory API Management Platform
https://www.dreamfactory.com
Apache License 2.0
1.55k stars 314 forks source link

Unable to execute mysql _func/functions after upgrading to DF 2.9 it was working in 2.6 #165

Closed hbsuhas closed 6 years ago

hbsuhas commented 6 years ago

Pleas see the below error log.

[2017-10-23 13:03:10] local.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Type error: Argument 1 passed to DreamFactory\Core\Database\Components\Schema::loadProcedure() must be an instance of DreamFactory\Core\Database\Schema\ProcedureSchema, instance of DreamFactory\Core\Database\Schema\FunctionSchema given, called in /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-database/src/Components/Schema.php on line 377 in /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-database/src/Components/Schema.php:716 Stack trace:

0 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-database/src/Components/Schema.php(377): DreamFactory\Core\Database\Components\Schema->loadProcedure(Object(DreamFactory\Core\Database\Schema\FunctionSchema))

1 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-sqldb/src/Resources/StoredFunction.php(348): DreamFactory\Core\Database\Components\Schema->getResource('procedure', Object(DreamFactory\Core\Database\Schema\FunctionSchema))

2 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-sqldb/src/Resources/StoredFunction.php(241): DreamFactory\Core\SqlDb\Resources\StoredFunction->callFunction()

3 [internal function]: DreamFactory\Core\SqlDb\Resources\StoredFunction->handleGET()

4 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(340): call_user_func(Array)

5 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(201): DreamFactory\Core\Components\RestHandler->processRequest()

6 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(259): DreamFactory\Core\Components\RestHandler->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), 'test')

7 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(176): DreamFactory\Core\Components\RestHandler->handleResource(Array)

8 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseRestService.php(129): DreamFactory\Core\Components\RestHandler->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), '_func/test')

9 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Controllers/RestController.php(262): DreamFactory\Core\Services\BaseRestService->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), '_func/test')

10 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Controllers/RestController.php(163): DreamFactory\Core\Http\Controllers\RestController->handleService('v2', 'dev', '_func/test')

11 [internal function]: DreamFactory\Core\Http\Controllers\RestController->handleGET('v2', 'dev', '_func/test')

12 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)

13 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('handleGET', Array)

14 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(DreamFactory\Core\Http\Controllers\RestController), 'handleGET')

15 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()

16 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(572): Illuminate\Routing\Route->run()

17 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

18 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Middleware/AccessCheck.php(135): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

19 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): DreamFactory\Core\Http\Middleware\AccessCheck->handle(Object(Illuminate\Http\Request), Object(Closure))

20 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

21 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Middleware/AuthCheck.php(232): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

22 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): DreamFactory\Core\Http\Middleware\AuthCheck->handle(Object(Illuminate\Http\Request), Object(Closure))

23 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

24 /opt/bitnami/apps/dreamfactory/htdocs/vendor/barryvdh/laravel-cors/src/HandleCors.php(34): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

25 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Barryvdh\Cors\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure))

26 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

27 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

28 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

29 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))

30 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

31 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))

32 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))

33 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

34 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))

35 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

36 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

37 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))

38 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

39 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

40 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))

41 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

42 /opt/bitnami/apps/dreamfactory/htdocs/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

43 {main}

MSchaer1985 commented 6 years ago

@hbsuhas I've been testing this and unable to replicate.

I created a simple function in MySQL (below):

CREATE FUNCTION hello_world(addressee TEXT)

RETURNS TEXT

BEGIN

RETURN CONCAT('Hello ', addressee);

And called it with POST http://localhost:8080/api/v2/mysqlocal/_func/hello_world?returns=string

Body:

{ "params": [{ "name": "addressee", "value": "Earthling" }] }

As expected in my response body I see the following:

"Hello Earthling"

Am I missing something?

hbsuhas commented 6 years ago

@MSchaer1985

Thank you for your response.

i used bitnami df stack 2.9 in aws. i connected to mysql server 10..1.19 MariaDB. But its still giving me the same error. Even i created the same function with param but still getting the same error

ERROR ----

[2017-10-24 12:05:34] local.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Type error: Argument 1 passed to DreamFactory\Core\Database\Components\Schema::loadProcedure() must be an instance of DreamFactory\Core\Database\Schema\ProcedureSchema, instance of DreamFactory\Core\Database\Schema\FunctionSchema given, called in /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-database/src/Components/Schema.php on line 377 in /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-database/src/Components/Schema.php:716 Stack trace:

0 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-database/src/Components/Schema.php(377): DreamFactory\Core\Database\Components\Schema->loadProcedure(Object(DreamFactory\Core\Database\Schema\FunctionSchema))

1 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-sqldb/src/Resources/StoredFunction.php(348): DreamFactory\Core\Database\Components\Schema->getResource('procedure', Object(DreamFactory\Core\Database\Schema\FunctionSchema))

2 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-sqldb/src/Resources/StoredFunction.php(251): DreamFactory\Core\SqlDb\Resources\StoredFunction->callFunction()

3 [internal function]: DreamFactory\Core\SqlDb\Resources\StoredFunction->handlePOST()

4 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(340): call_user_func(Array)

5 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(201): DreamFactory\Core\Components\RestHandler->processRequest()

6 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(259): DreamFactory\Core\Components\RestHandler->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), 'hello_world')

7 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(176): DreamFactory\Core\Components\RestHandler->handleResource(Array)

8 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseRestService.php(129): DreamFactory\Core\Components\RestHandler->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), '_func/hello_wor...')

9 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Controllers/RestController.php(262): DreamFactory\Core\Services\BaseRestService->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), '_func/hello_wor...')

10 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Controllers/RestController.php(177): DreamFactory\Core\Http\Controllers\RestController->handleService('v2', 'dev', '_func/hello_wor...')

11 [internal function]: DreamFactory\Core\Http\Controllers\RestController->handlePOST('v2', 'dev', '_func/hello_wor...')

12 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)

13 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('handlePOST', Array)

14 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(DreamFactory\Core\Http\Controllers\RestController), 'handlePOST')

15 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()

16 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(572): Illuminate\Routing\Route->run()

17 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

18 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Middleware/AccessCheck.php(135): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

19 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): DreamFactory\Core\Http\Middleware\AccessCheck->handle(Object(Illuminate\Http\Request), Object(Closure))

20 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

21 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Middleware/AuthCheck.php(232): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

22 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): DreamFactory\Core\Http\Middleware\AuthCheck->handle(Object(Illuminate\Http\Request), Object(Closure))

23 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

24 /opt/bitnami/apps/dreamfactory/htdocs/vendor/barryvdh/laravel-cors/src/HandleCors.php(34): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

25 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Barryvdh\Cors\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure))

26 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

27 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

28 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

29 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))

30 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

31 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))

32 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))

33 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

34 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))

35 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

36 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

37 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))

38 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

39 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

40 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))

41 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

42 /opt/bitnami/apps/dreamfactory/htdocs/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

43 {main}

=================================================

Package List

==============================

aws/aws-sdk-php|3.36.13| barryvdh/laravel-cors|v0.8.6| clue/stream-filter|v1.4.0| doctrine/annotations|v1.4.0| doctrine/cache|v1.6.2 doctrine/collections|v1.4.0 doctrine/common|v2.7.3 doctrine/dbal|v2.5.13 doctrine/inflector|v1.2.0 doctrine/lexer|v1.0.1 dready92/php-on-couch|1.0.1-p2 dreamfactory/azure-documentdb-php-sdk|0.2.1 dreamfactory/df-admin-app|2.11.0 dreamfactory/df-api-docs-ui|1.0.1 dreamfactory/df-apidoc|0.4.0 dreamfactory/df-aws|0.13.0 dreamfactory/df-azure|0.13.0 dreamfactory/df-cache|0.9.0 dreamfactory/df-cassandra|0.10.0 dreamfactory/df-core|0.12.3 dreamfactory/df-couchbase|0.8.0 dreamfactory/df-couchdb|0.13.0 dreamfactory/df-database|0.7.0 dreamfactory/df-email|0.6.0 dreamfactory/df-file|0.4.1 dreamfactory/df-filemanager-app|0.2.0 dreamfactory/df-firebird|0.5.0 dreamfactory/df-git|0.1.0 dreamfactory/df-mongodb|0.13.0 dreamfactory/df-oauth|0.12.0 dreamfactory/df-rackspace|0.12.0 dreamfactory/df-rws|0.12.0 dreamfactory/df-script|0.6.1 dreamfactory/df-sqldb|0.13.0 dreamfactory/df-user|0.12.0 dreamfactory/installer|1.0.1 erusev/parsedown|1.6.3 graham-campbell/github|v5.1.0 graham-campbell/manager|v2.5.0 guzzlehttp/guzzle|6.3.0 guzzlehttp/promises|v1.3.1 guzzlehttp/psr7|1.4.2 jacquestvanzuydam/laravel-firebird|dev-5.4-support jenssegers/mongodb|v3.2.3 knplabs/github-api|2.5.0 kriswallsmith/buzz|v0.15.1 laravel/framework|v5.4.36 laravel/socialite|v2.0.21 league/flysystem|1.0.41 league/flysystem-sftp|1.0.14 league/flysystem-webdav|1.0.5 league/oauth1-client|1.7.0 m4tthumphrey/php-gitlab-api|7.15.0 microsoft/azure-storage|v0.13.0 mongodb/mongodb|1.1.2 monolog/monolog|1.23.0 mtdowling/cron-expression|v1.2.0 mtdowling/jmespath.php|2.4.0 namshi/jose|7.2.3 nesbot/carbon|1.22.1 paragonie/random_compat|v2.0.10 php-http/cache-plugin|v1.4.0 php-http/client-common|1.5.0 php-http/discovery|1.3.0 php-http/guzzle6-adapter|v1.1.1 php-http/httplug|v1.1.0 php-http/message|1.6.0 php-http/message-factory|v1.0.2 php-http/promise|v1.0.0 phpseclib/phpseclib|2.0.6 predis/predis|v1.1.1 psr/cache|1.0.1 psr/http-message|1.0.1 psr/log|1.0.2 rackspace/php-opencloud|V1.5.10 ramsey/uuid|3.7.0 sabre/dav|3.2.2 sabre/event|3.0.0 sabre/http|4.2.3 sabre/uri|1.2.1 sabre/vobject|4.1.2 sabre/xml|1.5.0 socialiteproviders/manager|v2.2.1 socialiteproviders/microsoft-live|v2.1.0 socialiteproviders/twitter|v2.0.2 swiftmailer/swiftmailer|v5.4.8 symfony/console|v3.3.9 symfony/css-selector|v3.3.9 symfony/debug|v3.3.9 symfony/event-dispatcher|v3.3.9 symfony/finder|v3.3.9 symfony/http-foundation|v3.3.9 symfony/http-kernel|v3.3.9 symfony/options-resolver|v3.3.9 symfony/polyfill-mbstring|v1.5.0 symfony/polyfill-php56|v1.5.0 symfony/polyfill-util|v1.5.0 symfony/process|v3.3.9 symfony/routing|v3.3.9 symfony/translation|v3.3.9 symfony/var-dumper|v3.3.9 symfony/yaml|v3.3.9 tijsverkoyen/css-to-inline-styles|2.2.0 tymon/jwt-auth|1.0.0-rc.1 vinkla/gitlab|2.6.0 vlucas/phpdotenv|v2.4.0

MSchaer1985 commented 6 years ago

@hbsuhas I tested with mysql Ver 14.14 Distrib 5.7.20, for Linux (x86_64). I can test with MariaDB today and let you know.

MSchaer1985 commented 6 years ago

@hbsuhas also just to clarify, your upgrade path was from 2.6 to 2.9? You didn't do a fresh 2.9 install?

DF-User commented 6 years ago

I am having the same issue. I have attempted two approaches. I upgraded my server from 2.7 to 2.9. I created a clean instance of 2.9. Both have the same issue. The response message is in html rather than JSON. I have been using various versions of DF from pre V2.0 This is the first time I have an issue with the API not working with my code. I calling stored procs on a postgres DB. The response I get: <!DOCTYPE html>

Whoops, looks like something went wrong.

Response Code 500 Response Headers

DF-User commented 6 years ago

I have reverted back to 2.7 for now. It is still working correctly

hbsuhas commented 6 years ago

@MSchaer1985

First i upgraded due to some issue at MYSQL procedure.

Issue occurred when we changed mysql procedure parameters from 3 params to 2 parameter then DF starts throwing error, error is "procedure expects 3 param but got 2 only". Then i Did php clean , df cache clean but issue was not resolved then i thought upgrading the df. after upgrading from df 2.6 to 2.9 started facing the same problem. then we created new procedure and with 2 params then we resumed our work but Mysql functions start giving above problems.

But i installed fresh bitnami 2.9 df image in cloud and connected the same mysql database and same scheme but the error is same. even i tried 2.8x df in that also error is same.

so i came here for help!!!!! :)

DF-User commented 6 years ago

I have some time to do more testing against the stored procedures/functions api. Dreamfactory version 2.6 - Works correctly Dreamfactory version 2.7 - Works correctly Dreamfactory version 2.8 - Works correctly Dreamfactory version 2.8.1 - Broken Dreamfactory version 2.9 - Broken

All the above tests were done against the same database instance. The only variation was the DF version.

I hope this helps you guys find the issue

chas688 commented 6 years ago

@DF-User , You are saying that all the instances you tested are running against the same DB, but when you upgraded each time, did you run php artisan migrate --seed?

MSchaer1985 commented 6 years ago

This is fixed in df-sqldb 0.13.1

Run: composer update dreamfactory/df-sqldb --no-dev

DF-User commented 6 years ago

The php artisan migrate --seed is run during every upgrade. It is part of our script and checklist.

I have applied the df-sqldb 0.13.1 patch to my DF 2.9 instance and tested it with a range of stored procs and functions. I can confirm that DF version 2.9 is now working correctly with our functions.

Note: I had to use the command composer.phar update dreamfactory/df-sqldb --no-dev instead of of composer update dreamfactory/df-sqldb --no-dev

Thanks for the good work!! P.S I can see how the typo could be causing my issues!!