CMS Card does not display the content of table in database

[ncveggm]

Hi

I try to add CMS card and connect it to mysql database, but the card does not display the content of table.

N.B I write the fields name in card items values

may you help me

[ncveggm]

I have the latest version 17.4.1

[Pablo]

To be able to help you, I need to know your exact settings.

[ncveggm]

1. I make mysql database in xampp using phpadmin
2. in connect the database by the setting of CMS in img1
3. the page extension is .php
4. the error message appear like in img2
5. the mysite in location https://drive.google.com/drive/folders/ ... sp=sharing
6. the database structure in img3

[ncveggm]

Test site with add card item value to field name in database
http://www.scoeg.com/Mysite1/

Test site without add card item value to field name in database
http://www.scoeg.com/mysite2/

This test site with the same database but use datatables tool
http://www.scoeg.com/mysite3/

[WWBman]

The table is named "customers.customers_data" not "customers.customers_datapages"?

[ncveggm]

this code default generated by the tool

[Pablo]

The table name is not correct.

The value in the properties is a PREFIX, not the complete name!

If the prefix is CMS_ then the tabel name is CMS_PAGES

Also, note that you cannot just create a random table structure. It needs to have the structure of the WWB CMS, as documented in the help.

[ncveggm]

I create the database and 3 tables with the sql code in help and follow the help instruction but when i add the cms card it do not display any data, although I connect it to the database and i fill the table "cms_pages" with data.

so, what is the problem

[Pablo]

Do you have a working CMS basis?
Do all the other CSM tools work?
Do you still have an error?

Your previous screenshot were not correct. Can you please share the updated settings?
Note that there is nothing I can do to help you if I do not know all the exact settings.

[ncveggm]

the card works when I place CMS placeholder and CMS label, but not work alone or when remove CMS label

but I want to use card in card container

[Pablo]

To be able to help you, I need to know all your settings.

[ncveggm]

settings like what I confused

[Pablo]

You previous included screenshots of your settings.
Those settings were wrong, so that is why it did not work.

I assume you have used my suggestions to fix the configuration?
So, what are your current settings?
Are there still (fatal) errors?