I am having a really hard time viewing data from a source through app connect. I have followed the letter to a T. The servers connect states it is connecting to the server, but when I try to add a repeat rgn, it does not reflect to data in my database. PLEASE Help

Hi Leon,
Could you please explain a little more detailed what exactly are you trying to do? A link to your page would also be helpful.

Teodor,

I have uploaded the file temp to the website and you can view it via this link temp-page. I was try to build a projects page using a connection to my phpyadmin via server connect and app connect. I thought that I entered the data and followed the steps in the videos to set up a repeat region, but it does not work. It connects to the db and I can follow the steps all they way to entering the data to bind. At this point I cannot bind the data to the page. I have enter the data binding manually, but it does not seem to work. Note: the testimonials page is linked to the same database, but not same table and the data is able to be seen on the www.mitoinsulation.testimonials.php

Hi Leon,
All of your server actions return errors. Please enable the debug option in server connect settings so we can see the exact error.

Ok I have set the option to allow debug mode? Is this something that should always be on? How do I attach images here?

It seems that in your first action file, you are using an non-existant table or view, which probably breaks the rest of the page:
www.mitoinsulation.online/dmxConnect/api/testing/New%20File.php?

I have deleted the file and app and server setting, and reuploaded the page and have the same issue. Please see new page.

Please start again for the repeat regions - on blank new page, delete this one and create a new one.
Make sure you are selecting the right expression for the repeat - and bind the data using the insert binding button.

Teodor,

I wrote the php code to connect with the database and it connects and reflects the data from the code that I wrote see test2.php. So it seems the issue is with DMX Server connect or app connect.

I do not get the insert bindings button appear. It is really odd and I have to input that part manually. How do I correct this? I could record a short video and allow you access to it so you can see for yourself mate.

What do you mean by - "I do not get the insert bindings button appear"? Please send us this video or some screenshots of what you see to

I was not able to send the video as too big. I have given you access to server for you to view.
Please see email to support titled: Requested video from Leon to Teodor Kuduschiev. Look forward to sorting this out soon mate Thank you.

Hi Leon,
The issue you are having not seeing the insert binding button is caused because your are not keeping the app connect panel open and docked on the side of the screen, and every time you open it ... DW loses the focus on the screen. Please make sure to keep both app and server connect panels expanded and docked to the screen, and not minimized, as they are now...
Also i see some issue in the generated query. What type of database field is the "image" field? IT generates a really strange code for two of the records (id 302 and id 303):

..."image": }
instead of
"image": ""}
as it is for the rest of the records. Please check the value stored there(or not stored) for these two records.

I have made the changes to the setup and will keep the apps expanded going forward. I have used the BLOB type for the images. id 302 and 303 are the only ones with images stored in them. Hopefully this should work or should I use a different type for images? I will try again to connect now.

Unfortunately server connect does not support BLOB (binary) data fields. That's the issue.

Ok I will make the changes and confirm that is the issue mate. If it is the issue, how can I store images in the database Or if I store the path in the database, how do I direct app connect to show the image? Or can I store this image as a different file type that will work with app connect?

Teodor,

Thank you soooooooooo much it worked! It was driving me nuts :-)

Ok so how can I store the image of the project in the database or path and link the database to the image so it can be viewed with the project data?

Hi Leon,

Usually you just store the path / image name in your database, then you just bind a dynamic img-src, to your image tags, using the dynamic attributes > image > src option in app connect panel.