CMS Card does not display the content of table in database

Issues related to the CMS tools of WYSIWYG Web Builder.
Forum rules
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901

MUST READ:
http://www.wysiwygwebbuilder.com/cms_tools.html
A lot of information about the Content Manager System can be found in the help/manual. Please read this first before posting any questions! Also check out the demo template that is include with the software.

CMS trouble shooting / FAQ:
viewtopic.php?f=10&t=43245
Post Reply
ncveggm
 
 
Posts: 31
Joined: Mon Nov 06, 2017 12:14 am

CMS Card does not display the content of table in database

Post 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
ncveggm
 
 
Posts: 31
Joined: Mon Nov 06, 2017 12:14 am

Re: CMS Card does not display the content of table in database

Post by ncveggm »

I have the latest version 17.4.1
User avatar
Pablo
 
Posts: 21572
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: CMS Card does not display the content of table in database

Post by Pablo »

To be able to help you, I need to know your exact settings.
ncveggm
 
 
Posts: 31
Joined: Mon Nov 06, 2017 12:14 am

Re: CMS Card does not display the content of table in database

Post by ncveggm »

1. I make mysql database in xampp using phpadmin
2. in connect the database by the setting of CMS in img1 Image
3. the page extension is .php
4. the error message appear like in img2 Image
5. the mysite in location https://drive.google.com/drive/folders/ ... sp=sharing
6. the database structure in img3 Image
ncveggm
 
 
Posts: 31
Joined: Mon Nov 06, 2017 12:14 am

Re: CMS Card does not display the content of table in database

Post 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/
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: CMS Card does not display the content of table in database

Post by WWBman »

The table is named "customers.customers_data" not "customers.customers_datapages"?
ncveggm
 
 
Posts: 31
Joined: Mon Nov 06, 2017 12:14 am

Re: CMS Card does not display the content of table in database

Post by ncveggm »

this code default generated by the tool
User avatar
Pablo
 
Posts: 21572
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: CMS Card does not display the content of table in database

Post 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.
ncveggm
 
 
Posts: 31
Joined: Mon Nov 06, 2017 12:14 am

Re: CMS Card does not display the content of table in database

Post 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
User avatar
Pablo
 
Posts: 21572
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: CMS Card does not display the content of table in database

Post 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.
ncveggm
 
 
Posts: 31
Joined: Mon Nov 06, 2017 12:14 am

Re: CMS Card does not display the content of table in database

Post 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
User avatar
Pablo
 
Posts: 21572
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: CMS Card does not display the content of table in database

Post by Pablo »

To be able to help you, I need to know all your settings.
ncveggm
 
 
Posts: 31
Joined: Mon Nov 06, 2017 12:14 am

Re: CMS Card does not display the content of table in database

Post by ncveggm »

settings like what I confused
User avatar
Pablo
 
Posts: 21572
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: CMS Card does not display the content of table in database

Post 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?
Post Reply