Page 1 of 1
CMS Card does not display the content of table in database
Posted: Sun Sep 25, 2022 12:15 pm
by 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
Re: CMS Card does not display the content of table in database
Posted: Sun Sep 25, 2022 12:32 pm
by ncveggm
I have the latest version 17.4.1
Re: CMS Card does not display the content of table in database
Posted: Sun Sep 25, 2022 12:52 pm
by Pablo
To be able to help you, I need to know your exact settings.
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 12:11 pm
by 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
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 12:44 pm
by 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/
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 2:04 pm
by WWBman
The table is named "customers.customers_data" not "customers.customers_datapages"?
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 2:32 pm
by ncveggm
this code default generated by the tool
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 3:06 pm
by 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.
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 4:38 pm
by 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
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 5:06 pm
by 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.
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 6:12 pm
by 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
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 7:56 pm
by Pablo
To be able to help you, I need to know all your settings.
Re: CMS Card does not display the content of table in database
Posted: Mon Sep 26, 2022 8:02 pm
by ncveggm
settings like what I confused
Re: CMS Card does not display the content of table in database
Posted: Tue Sep 27, 2022 5:41 am
by 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?