ka2
Forum Replies Created
-
Forum: Plugins
In reply to: [Custom DataBase Tables] Export table to Excel or PDFWell, I was able to understand your needs.
The CDBT plugin has a way to fulfill your hopes. It is a way to use the WEB-API.
However, the process to download a file after having acquired the data that match a certain condition by using the WEB-API must be prepared separately.Unfortunately, there is no available easy functions as like shortcodes in the current plugin.
Your request will be happy to effective use as the idea of additional future functionality.
Thank you,Forum: Reviews
In reply to: [Custom DataBase Tables] Seems nice, doesn't workI’m so sorry.
I fixed a bug of “input data” to hotfix-version 1.1.15.
Forum: Plugins
In reply to: [Custom DataBase Tables] ERROR in new version 1.1.14Sorry for my late reply.
I released a hotfix-version 1.1.15 that fixed a fatal error.
I apologize for any inconvenience that may have caused you.
Forum: Plugins
In reply to: [Custom DataBase Tables] Export table to Excel or PDFHi there.
In the current plugin, it is possible to export the data of the table to the CSV file.
Please try to use from “Setting” -> “Enable tables list” -> “Data Export” on the Custom DataBase Tables Management console.
Thank you,
Forum: Plugins
In reply to: [Custom DataBase Tables] Display all data that equals "x" onlyThank you for your inquiry.
The shortcode of [cdbt-view] can not narrow down the data. Therefore, please use the shortcode of [cdbt-extract] if you want to retrieve the matched data in your specifying the conditions.
For example, I try to convert from your shortcode:
[cdbt-view table=”wp_wp_card_info_all” bootstrap_style=”true” display_title=”false” display_search=”true” display_list_num=”false” enable_sort=”true” exclude_cols=”ID,cust_no,cust_name,chrono,created” add_class=””]
from above, follow as:
[cdbt-extract table=”wp_wp_card_info_all” bootstrap_style=”true” display_index_row=”true” narrow_keyword=”reg_no:XYP321GP” display_cols=”reg_no,updated” limit_items=”10″ add_class=””]
note:
The shortcode of [cdbt-extract] do not have an attribute of exclude_cols. Therefore, you must convert to an attribute of display_cols.
Also, in the [cdbt-extract] can not use a search box and a sort function.Thank you,
Forum: Plugins
In reply to: [Custom DataBase Tables] submitThank you very much for reporting.
What do your browser do any behavior when you clicked the button that is output by a shortcode of [cdbt-submit]?
- You can not press the button
- After you press the button it is dialog displays “Could not update data.”.
- Other error message is displayed
In the above case, do you you match in any case?
- In this case, it is due to users who do not have access to the specified table. Users who can not edit that table is not able to run an UPDATE query from [cdbt-submit]. Therefore, you can improve it by appropriate changes to the permission settings of the table.
- This message is output If there is no need to update the row records by your update query, or that query was invalid. Therefore, please review your specifying query, or confirm the data of target record.
- Please tell me it if such an error message is output.
Thank you for taking care of it.
Forum: Plugins
In reply to: [Custom DataBase Tables] ERROR in new version 1.1.14Thank you for taking the time to this matter.
That’s certainly true.
I am going to prepare as soon hotfix.
Forum: Plugins
In reply to: [Custom DataBase Tables] Will be no new features?Sorry for my late reply.
I answer as follows to what you want.
- [cdbt-extract table=”{your table name}” narrow_keyword=”ID:1″]
- It does not support unfortunately on the current plugin. Because your ideas will be likely a lot of users have same needs, I’ll try to add it as a new feature in the next version.
Thank you for taking care of it.
Forum: Plugins
In reply to: [Custom DataBase Tables] Form will not post to databaseI’m sorry, my reply is slow.
Whether the problems occurred when you entered what data to what type of column? I might be able to help you, if you can tell me more details.
Thank you for taking care of it.
Forum: Plugins
In reply to: [Custom DataBase Tables] Error creating a table: Failed to create tableHi, Thank you for report.
I was able to confirm the problem that you have reported to me.
I remember that plugin was working normally when immediately after that fixes bug of bit type field. I think maybe became to not work with affected after that fix other bugs.
I investigate, and will do the fix again.
Sorry, please wait for fixing a bug.
Forum: Plugins
In reply to: [Custom DataBase Tables] Error creating a table: Failed to create tableHello,
I tried to check the specifications of MySQL again.
Default value of bit type field there was a need to be specified in the binary bit values.According to it, SQL statement to set the default value in the column of “bit (1)” is as follows.
column_name bit(1) NOT NULL DEFAULT b’1′
Or,
column_name bit(1) NOT NULL DEFAULT b’0′
Forum: Plugins
In reply to: [Custom DataBase Tables] Failed to create tableYes, I understood.
Thank you for reply!
Forum: Plugins
In reply to: [Custom DataBase Tables] Error creating a table: Failed to create tableSorry for having many troubles in the plugin.
The bit field of MySQL is a synonym for “tinyint (1)”. The “tinyint (1)” itself is the only numeric value of 0, 1, 2-127 can be stored, but “bit (1)” is 2-127 can not be stored. In other words, you can store 0 and 1 and NULL in bit field.
Therefore, input data of plugin to the bit field must be modified at 0 and 1 only.
I would like to fix asap and release a bug fix version.
Forum: Plugins
In reply to: [Custom DataBase Tables] Can't create table after plugin installationHmmm, Sorry to not have resolved.
Since Setting-tab itself can not click, still might have there is a browser-dependent bug in the JavaScript. I’ll try more search the invalid source.
Forum: Plugins
In reply to: [Custom DataBase Tables] Error creating a table: Failed to create tableHello, Thank you for inquiry.
On MySQL database, if you specify the “bit” to type format of the column, you can not specify the default value to “0”.
So that,
column_name bit (1) NOT NULL DEFAULT ”
Or,
column_name bit (1) DEFAULT NULL
You will be able to create new table when you will modify as described above.
However, for a column of type “bit”, there was an error in the data input from the “Input data” page. It was a bug, I should be fix in the next version.