Data not displayed

Thank you for your inquiry.

Where do you happen that trouble?
Which does the WordPress management screen or the front-end page using shortcode?
Isn’t occur an error of javascript at the time of trouble?

Please tell me in detail the situation at the time of trouble.

Thank you for taking care of it.

i discovered that is happening when the table containing more than one columns with a “SET” type. can you help me solving this?

Hmm, I was not able to reproduce the problem.

Could you tell me the create SQL statements of the table that trouble occurs?

Thank you for taking care of it.

CREATE TABLE Used_Cars (
ID int(11) NOT NULL AUTO_INCREMENT,
??????? enum(‘?? ??’,’????’,’????’,’???? ?????’,’??????’,’????????’,’????’,’?? ?? ?????’,’????’,’??????’,’??????’,’???? ???’,’???’,’????’,’????????’,’????’,’????’,’???? ????’,’???????’,’?????’,’??????’,’??????’,’????’,’?????’,’????’,’????????’,’????’,’?????’,’????? ????’,’????’,’???????’,’???’,’????’,’???? ????’,’?????’,’?????????’,’??????’,’????’,’?????’,’?????’,’???????’) NOT NULL,
??????? varchar(255) NOT NULL,
(??? ?????? (?? ?? int(255) NOT NULL,
??? ????? year(4) NOT NULL,
???? ??????? int(11) NOT NULL,
????? text,
?????? varchar(255) NOT NULL,
???????? varchar(255) NOT NULL,
??????? ???? set(‘?????’,’???? ???????’,’???? ???’,’???? ????? ABS’,’???? ???’,’?????’,’???? ????’,’????? ???????? ??????? EBD’,’????’,’????? ??????’,’????? ?????’),
??????? text,
PRIMARY KEY(ID) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

Here is my create SQL, when i insert any number of rows when I try to view the data it keeps telling me “No data in this table” but in the “Operate Table” screen it shows the real number of rows inserted.

Thank you for help ??

I could see of the problems in your favor.

In this plugin, it does not work when is using the characters other than alphanumeric and allowed symbols at the table name. Because the JavaScript that is rendered via the shortcode of “cdbt-view” and “cdbt-edit” cannot handle operating normally.

You should change to alphanumeric characters from the table name of Arabic.
Their shortcodes works normally after I change the names of all tables using the SQL below.

alter table used_cars change ??????? model varchar(255) NOT NULL comment '???????';
alter table used_cars change (??? ?????? (?? ?? engine_capacity int(255) NOT NULL comment '(??? ?????? (?? ??';
alter table used_cars change ??????? brand enum('?? ??','????','????','???? ?????','??????','????????','????','?? ?? ?????','????','??????','??????','???? ???','???','????','????????','????','????','???? ????','???????','?????','??????','??????','????','?????','????','????????','????','?????','????? ????','????','???????','???','????','???? ????','?????','?????????','??????','????','?????','?????','???????') NOT NULL comment '???????';
alter table used_cars change ??? ????? manufacturing_year year(4) NOT NULL comment '??? ?????';
alter table used_cars change ???? ??????? odometer int(11) NOT NULL comment '???? ???????';
alter table used_cars change  ????? description text comment '?????';
alter table used_cars change ?????? telephone varchar(255) NOT NULL comment '??????';
alter table used_cars change ???????? province varchar(255) NOT NULL comment '????????';
alter table used_cars change ??????? ???? other_specifications set('?????','???? ???????','???? ???','???? ????? ABS','???? ???','?????','???? ????','????? ???????? ??????? EBD','????','????? ??????','????? ?????') DEFAULT NULL comment '??????? ????';
alter table used_cars change ??????? notes text comment '???????';

Or, it may re-create the table in the following SQL.

CREATE TABLE used_cars (
  ID int(11) NOT NULL AUTO_INCREMENT,
  brand enum('?? ??','????','????','???? ?????','??????','????????','????','?? ?? ?????','????','??????','??????','???? ???','???','????','????????','????','????','???? ????','???????','?????','??????','??????','????','?????','????','????????','????','?????','????? ????','????','???????','???','????','???? ????','?????','?????????','??????','????','?????','?????','???????') NOT NULL COMMENT '???????',
  model varchar(255) NOT NULL COMMENT '???????',
  engine_capacity int(255) NOT NULL COMMENT '(??? ?????? (?? ??',
  manufacturing_year year(4) NOT NULL COMMENT '??? ?????',
  odometer int(11) NOT NULL COMMENT '???? ???????',
  description text COMMENT '?????',
  telephone varchar(255) NOT NULL COMMENT '??????',
  province varchar(255) NOT NULL COMMENT '????????',
  other_specifications set('?????','???? ???????','???? ???','???? ????? ABS','???? ???','?????','???? ????','????? ???????? ??????? EBD','????','????? ??????','????? ?????') DEFAULT NULL COMMENT '??????? ????',
  notes text COMMENT '???????',
  PRIMARY KEY (ID)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8

Thank you,

Thank you very much it this worked for me, just another question isn’t there anyway to translate the Columns names into Arabic?

Ummm, unfortunately there may be currently no workaround.

I’ll try a little more thought.

Hi,
I’m very sorry, this trouble didn’t in by Arabic column name.

Because there had contained a single-byte space in the column name of “set” type.

“??????? ????” is wrong.

“???????_????” is OK.

Please try to modify the column name of the “set” type without single-byte spaces.

Thank you,

Hi,

I’m going to be corresponding to the column name that contains a space at the next version.
Please wait a while until this plugin is released the next version.

Thank you,

Thank You Very Much!