Hi,

a just buy the DMXzone Database Connector 2 and try to display the results on the page. The page is restrict to users onley and not to admim user. I just have a filter on databe for that.
I just have to uninstall the Database Connector 2 because when i try to build with that it simple doesn't show anything. When i use the previous versions of datababase connector everything works fine ...

Please check for any errors as described here: www.dmxzone.com/go/32354/debugging-problems-in-dmxzone-server-connect/

Can i sent you an email with a screenshot of the error? What's your email?

I've got this error:

--------init----------- localhost/cp_ivdp2/_userarea/perfil/untitled1.php
/cp_ivdp2/dmxConnect/api/base_dados/bd_users_admin.php?:1 Failed to load resource: the server responded with a status of 500 (Internal Server Error)

This error is not enough.
Please check the tutorial I sent you, it's described there how to see the detailed error message.

I floow the tutorial and this is the error:
--------init----------- localhost/cp_ivdp2/_userarea/perfil/untitled1.php
fetch.js:247 GET localhost/cp_ivdp2/dmxConnect/api/base_dados/bd_users_admin.php? 500 (Internal Server Error)
fetch @ fetch.js:247
(anonymous) @ appConnect.js:252
setTimeout (async)
(anonymous) @ appConnect.js:251
update @ fetch.js:153
render @ fetch.js:145
constructor @ BaseComponent.js:20
n @ appConnect.js:412
constructor @ fetch.js:5
n @ appConnect.js:412
e.hasOwnProperty.e.constructor @ appConnect.js:445
n @ appConnect.js:412
$addChild @ BaseComponent.js:201
(anonymous) @ BaseComponent.js:272
walk @ dom.js:180
(anonymous) @ dom.js:185
walk @ dom.js:184
$parse @ BaseComponent.js:242
render @ app.js:23
constructor @ BaseComponent.js:20
n @ appConnect.js:412
constructor @ app.js:5
n @ appConnect.js:412
dmx.appConnect @ appConnect.js:64
(anonymous) @ appConnect.js:74
[Violation] 'setTimeout' handler took 187ms

and also this:

{code: 0, file: "C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\db\SqlBuilder.php", line: 185,…}
code: 0
file: "C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\db\SqlBuilder.php"
line: 185
message: "preg_match() expects parameter 2 to be string, object given"
trace: "#0 [internal function]: exception_error_handler(2, 'preg_match() ex...', 'C:\\xampp\\htdocs...', 185, Array)↵#1 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\db\SqlBuilder.php(185): preg_match('/\\s+AS\\s+/i', Object(stdClass))↵#2 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\db\SqlBuilder.php(275): lib\db\SqlBuilder->quoteIdentifier(Object(stdClass))↵#3 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\db\SqlBuilder.php(241): lib\db\SqlBuilder->compileFrom(Object(stdClass))↵#4 [internal function]: lib\db\SqlBuilder->compileComponent('from')↵#5 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\db\SqlBuilder.php(224): array_map(Array, Array)↵#6 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\db\SqlBuilder.php(208): lib\db\SqlBuilder->compileCount()↵#7 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\modules\dbconnector.php(174): lib\db\SqlBuilder->compile()↵#8 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\App.php(163): modules\dbconnector->paged(Object(stdClass), 'query1')↵#9 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\App.php(128): lib\App->execSteps(Object(stdClass))↵#10 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\App.php(98): lib\App->execSteps(Array)↵#11 C:\xampp\htdocs\cp_ivdp2\dmxConnectLib\lib\App.php(71): lib\App->exec(Object(stdClass))↵#12 C:\xampp\htdocs\cp_ivdp2\dmxConnect\api\base_dados\bd_users_admin.php(8): lib\App->define(Object(stdClass))↵#13 {main}"

Ok, the last message shows the real error.
Is this some old server action, which you are editing in version 2?

not exactly. When i try to build a new fresh server database the error remains. I don't have this problem the previou version of database connector

Please send us some screenshots of how are your server action steps configured.

what's the email to send you the photos?

teodor at dmxzone.com

Ok. Just sent to you

Manuel, are you sure there are no old files left on your server?
Please do the following:
1. Remove the dmxConnectLib locally and on the remote server.
2. Save your server action, it will regenerate the dmxConnectLib folder
3. Upload it to your server and try again.

Hi Teodor,

Done! Now it's OK. Thanks for your excellent support.