DataProject with non-default “Options Set Name” second “Tabpage” not responding

Resolved Natuma
(@dmnauta)

5 years, 5 months ago

Hello Peter,

I have created a DataProject Parent/child Page with two child relations (i.e. Student with Classes and Grades) and parent and children with the same non-default OptionSetName (i.e: admin).
When I go to this page and select a record (i.e. Student) both tabpages headers (i.e. Classes and Grades) are shown but the second doesn’t respond to the mouse click (and no data is shown).
When I delete the table/OptionSetName (i.e. Classes/admin) in DP-table options and only the default OptionSetname is left, it than functions correctly.

Best regards,
Martin

Viewing 10 replies - 1 through 10 (of 10 total)

Plugin Author

(@peterschulznl)

Hi Martin,

Is the “problem tab” related to a one to many or a many to many relationship? Can you give me some info about the datamodel? Just tables and relationships would be sufficient.

Best regards,
Peter

Thread Starter

Natuma

(@dmnauta)

5 years, 5 months ago

Hi Peter,
the problem is related to a 1:n relationship.
The problem also occurs with the wpda_sas example:
Project:
parent/child
wpda_sas_student – OSN: admin
Manage tableoptions:
wpda_sas_student – OSN: admin
1:n wpda_sas_grade (not in Manage tableoptions)
1:n wpda_sas_student_courses (not in Manage tableoptions)
-> everything works fine

Adding wpda_sas_student_courses – OSN: admin in Manage tableoptions
-> the second tabpage (wpda_sas_student_courses – OSN: admin) is not responding anymore

Hope this clarifies it!

Martin

Plugin Author

Passionate Programmer Peter

(@peterschulznl)

5 years, 5 months ago

Hi Martin,

I tried but could not reproduce this error. When I delete the OSN of the second tab (which is the Grade tab on my page) the tab label is set to the view name but the tab interaction works fine. Just to be sure, are you on version 2.7.1? There have been a number of bug fixes in the area.

If you are on version 2.7.1, can you send me an export of your project and table options?

Best regards,
Peter

Thread Starter

Natuma

(@dmnauta)

5 years, 5 months ago

Hi Peter,

I’m on version 2.7.1. (Deactivated all other plugins, updated chrome, tested on another browser (firefox) but still the error occurs).
1) Just to be sure: one remark to your testing: the tabpage doesnot respond when the OSN definition is there (and everything works fine when you delete it): so just the other way!
2) I just saw an errormessage in chrome devtools which might relevant:

Uncaught Error: Syntax error, unrecognized expression: #form_tab_courses (admin)
    at Function.ea.error (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,moxiejs,plupload&ver=5.2.4:formatted:563)

Best regards,
Martin


<strong>export wpda_project_6.txt</strong>
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Export table <code>wp_wpda_project</code>
--
INSERT INTO <code>{wp_prefix}wpda_project</code> (<code>project_name</code>, <code>project_description</code>, <code>add_to_menu</code>, <code>menu_name</code>, <code>project_sequence</code>) VALUES 
('Student-test','Student-test','Yes','Student-test',0);
SET @PROJECT_ID = LAST_INSERT_ID();

--
-- Export table <code>wp_wpda_project_page</code>
--
INSERT INTO <code>{wp_prefix}wpda_project_page</code> (<code>project_id</code>, <code>page_name</code>, <code>add_to_menu</code>, <code>page_type</code>, <code>page_table_name</code>, <code>page_setname</code>, <code>page_mode</code>, <code>page_allow_insert</code>, <code>page_allow_delete</code>, <code>page_content</code>, <code>page_title</code>, <code>page_subtitle</code>, <code>page_role</code>, <code>page_where</code>, <code>page_sequence</code>) VALUES 
(@PROJECT_ID,'Student-test','Yes','parent/child','wpda_sas_student','admin','edit','yes','yes',0,'','','administrator,editor,author,contributor,subscriber,trainingscoordinator,Lid,Coordinator,beheerder','',0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
<strong>export wp_wpda_project_table.csv</strong>
Wpda Table Name, Wpda Table Setname, Wpda Table Design
"wpda_sas_student", "admin", "{""design_mode"":""advanced"",""engine"":""InnoDB"",""collation"":""latin1_swedish_ci"",""table"":[{""column_name"":""student_id"",""data_type"":""int"",""type_attribute"":"""",""key"":""Yes"",""mandatory"":""Yes"",""max_length"":""10"",""extra"":""auto_increment"",""default"":"""",""list"":""""},{""column_name"":""student_gender"",""data_type"":""enum"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""'female','male'""},{""column_name"":""student_date_of_birth"",""data_type"":""date"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_firstname"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_lastname"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_address"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_zipcode"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""10"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_city"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_county"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_country"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_email"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""254"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_phone_no"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""10"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_registration_date"",""data_type"":""date"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_wp_username"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""60"",""extra"":"""",""default"":"""",""list"":""""}],""indexes"":[{""index_name"":""student_email"",""unique"":""Yes"",""column_names"":""student_email""},{""index_name"":""student_wp_username"",""unique"":""Yes"",""column_names"":""student_wp_username""}],""table_type"":""TABLE"",""listtable_column_options"":[{""column_name"":""student_id"",""label"":""Student Id"",""show"":""on""},{""column_name"":""student_gender"",""label"":""Student Gender"",""show"":""on""},{""column_name"":""student_date_of_birth"",""label"":""Student Date Of Birth"",""show"":""on""},{""column_name"":""student_firstname"",""label"":""Student Firstname"",""show"":""on""},{""column_name"":""student_lastname"",""label"":""Student Lastname"",""show"":""on""},{""column_name"":""student_address"",""label"":""Student Address"",""show"":""on""},{""column_name"":""student_zipcode"",""label"":""Student Zipcode"",""show"":""on""},{""column_name"":""student_city"",""label"":""Student City"",""show"":""on""},{""column_name"":""student_county"",""label"":""Student County"",""show"":""on""},{""column_name"":""student_country"",""label"":""Student Country"",""show"":""on""},{""column_name"":""student_email"",""label"":""Student Email"",""show"":""on""},{""column_name"":""student_phone_no"",""label"":""Student Phone No"",""show"":""on""},{""column_name"":""student_registration_date"",""label"":""Student Registration Date"",""show"":""on""},{""column_name"":""student_wp_username"",""label"":""Student Wp Username"",""show"":""on""}],""tableform_column_options"":[{""column_name"":""student_id"",""label"":""Student Id (sleutel)"",""show"":""on""},{""column_name"":""student_gender"",""label"":""Student Gender"",""show"":""on""},{""column_name"":""student_date_of_birth"",""label"":""Student Date Of Birth"",""show"":""on""},{""column_name"":""student_firstname"",""label"":""Student Firstname"",""show"":""on""},{""column_name"":""student_lastname"",""label"":""Student Lastname"",""show"":""on""},{""column_name"":""student_address"",""label"":""Student Address"",""show"":""on""},{""column_name"":""student_zipcode"",""label"":""Student Zipcode"",""show"":""on""},{""column_name"":""student_city"",""label"":""Student City"",""show"":""on""},{""column_name"":""student_county"",""label"":""Student County"",""show"":""on""},{""column_name"":""student_country"",""label"":""Student Country"",""show"":""on""},{""column_name"":""student_email"",""label"":""Student Email"",""show"":""on""},{""column_name"":""student_phone_no"",""label"":""Student Phone No"",""show"":""on""},{""column_name"":""student_registration_date"",""label"":""Student Registration Date"",""show"":""on""},{""column_name"":""student_wp_username"",""label"":""Student Wp Username"",""show"":""on""}],""tableinfo"":{""tab_label"":""Student (admin)""},""relationships"":[{""relation_type"":""1n"",""source_column_name"":[""student_id""],""target_table_name"":""wpda_sas_grade"",""target_column_name"":[""student_id""]},{""relation_type"":""1n"",""source_column_name"":[""student_id""],""target_table_name"":""wpda_sas_student_courses"",""target_column_name"":[""student_id""]}]}"
"wpda_sas_student_courses", "admin", "{""design_mode"":""advanced"",""engine"":null,""collation"":null,""table"":[{""column_name"":""student_id"",""data_type"":""int"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""10"",""extra"":"""",""default"":""0"",""list"":""""},{""column_name"":""student_gender"",""data_type"":""enum"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""'female','male'""},{""column_name"":""student_date_of_birth"",""data_type"":""date"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_firstname"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_lastname"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_address"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_zipcode"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""10"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_city"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_county"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_country"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_email"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""Yes"",""max_length"":""254"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_phone_no"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""10"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_registration_date"",""data_type"":""date"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""student_wp_username"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""60"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""module_id"",""data_type"":""int"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""10"",""extra"":"""",""default"":""0"",""list"":""""},{""column_name"":""module_name"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""50"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""module_description"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""4000"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""course_id"",""data_type"":""int"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""10"",""extra"":"""",""default"":""0"",""list"":""""},{""column_name"":""course_start_date"",""data_type"":""date"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_id"",""data_type"":""int"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""10"",""extra"":"""",""default"":""0"",""list"":""""},{""column_name"":""teacher_gender"",""data_type"":""enum"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""'female','male'""},{""column_name"":""teacher_date_of_birth"",""data_type"":""date"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_firstname"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_lastname"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_address"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_zipcode"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""10"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_city"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_county"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_country"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""100"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_email"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""254"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_phone_no"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""10"",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_hire_date"",""data_type"":""date"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":"""",""extra"":"""",""default"":"""",""list"":""""},{""column_name"":""teacher_wp_username"",""data_type"":""varchar"",""type_attribute"":"""",""key"":""No"",""mandatory"":""No"",""max_length"":""60"",""extra"":"""",""default"":"""",""list"":""""}],""indexes"":[],""table_type"":""VIEW"",""listtable_column_options"":[{""column_name"":""student_id"",""label"":""Student Id"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_gender"",""label"":""Student Gender"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_date_of_birth"",""label"":""Student Date Of Birth"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_firstname"",""label"":""Student Firstname"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_lastname"",""label"":""Student Lastname"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_address"",""label"":""Student Address"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_zipcode"",""label"":""Student Zipcode"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_city"",""label"":""Student City"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_county"",""label"":""Student County"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_country"",""label"":""Student Country"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_email"",""label"":""Student Email"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_phone_no"",""label"":""Student Phone No"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_registration_date"",""label"":""Student Registration Date"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""student_wp_username"",""label"":""Student Wp Username"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""module_id"",""label"":""Module Id"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""module_name"",""label"":""Module Name"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""module_description"",""label"":""Module Description"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""course_id"",""label"":""Course Id"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""course_start_date"",""label"":""Course Start Date"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_id"",""label"":""Teacher Id"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_gender"",""label"":""Teacher Gender"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_date_of_birth"",""label"":""Teacher Date Of Birth"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_firstname"",""label"":""Teacher Firstname"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_lastname"",""label"":""Teacher Lastname"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_address"",""label"":""Teacher Address"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_zipcode"",""label"":""Teacher Zipcode"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_city"",""label"":""Teacher City"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_county"",""label"":""Teacher County"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_country"",""label"":""Teacher Country"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_email"",""label"":""Teacher Email"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_phone_no"",""label"":""Teacher Phone No"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_hire_date"",""label"":""Teacher Hire Date"",""less"":""off"",""show"":""on"",""lookup"":false},{""column_name"":""teacher_wp_username"",""label"":""Teacher Wp Username"",""less"":""off"",""show"":""on"",""lookup"":false}],""tableform_column_options"":[{""column_name"":""student_id"",""label"":""Student Id"",""show"":""on""},{""column_name"":""student_gender"",""label"":""Student Gender"",""show"":""on""},{""column_name"":""student_date_of_birth"",""label"":""Student Date Of Birth"",""show"":""on""},{""column_name"":""student_firstname"",""label"":""Student Firstname"",""show"":""on""},{""column_name"":""student_lastname"",""label"":""Student Lastname"",""show"":""on""},{""column_name"":""student_address"",""label"":""Student Address"",""show"":""on""},{""column_name"":""student_zipcode"",""label"":""Student Zipcode"",""show"":""on""},{""column_name"":""student_city"",""label"":""Student City"",""show"":""on""},{""column_name"":""student_county"",""label"":""Student County"",""show"":""on""},{""column_name"":""student_country"",""label"":""Student Country"",""show"":""on""},{""column_name"":""student_email"",""label"":""Student Email"",""show"":""on""},{""column_name"":""student_phone_no"",""label"":""Student Phone No"",""show"":""on""},{""column_name"":""student_registration_date"",""label"":""Student Registration Date"",""show"":""on""},{""column_name"":""student_wp_username"",""label"":""Student Wp Username"",""show"":""on""},{""column_name"":""module_id"",""label"":""Module Id"",""show"":""on""},{""column_name"":""module_name"",""label"":""Module Name"",""show"":""on""},{""column_name"":""module_description"",""label"":""Module Description"",""show"":""on""},{""column_name"":""course_id"",""label"":""Course Id"",""show"":""on""},{""column_name"":""course_start_date"",""label"":""Course Start Date"",""show"":""on""},{""column_name"":""teacher_id"",""label"":""Teacher Id"",""show"":""on""},{""column_name"":""teacher_gender"",""label"":""Teacher Gender"",""show"":""on""},{""column_name"":""teacher_date_of_birth"",""label"":""Teacher Date Of Birth"",""show"":""on""},{""column_name"":""teacher_firstname"",""label"":""Teacher Firstname"",""show"":""on""},{""column_name"":""teacher_lastname"",""label"":""Teacher Lastname"",""show"":""on""},{""column_name"":""teacher_address"",""label"":""Teacher Address"",""show"":""on""},{""column_name"":""teacher_zipcode"",""label"":""Teacher Zipcode"",""show"":""on""},{""column_name"":""teacher_city"",""label"":""Teacher City"",""show"":""on""},{""column_name"":""teacher_county"",""label"":""Teacher County"",""show"":""on""},{""column_name"":""teacher_country"",""label"":""Teacher Country"",""show"":""on""},{""column_name"":""teacher_email"",""label"":""Teacher Email"",""show"":""on""},{""column_name"":""teacher_phone_no"",""label"":""Teacher Phone No"",""show"":""on""},{""column_name"":""teacher_hire_date"",""label"":""Teacher Hire Date"",""show"":""on""},{""column_name"":""teacher_wp_username"",""label"":""Teacher Wp Username"",""show"":""on""}],""tableinfo"":{""tab_label"":""courses (admin)""}}"

This reply was modified 5 years, 5 months ago by Marius L. J.. Reason: Fix formatting

Moderator

Jan Dembowski

(@jdembowski)

Forum Moderator and Brute Squad

5 years, 5 months ago

@dmnauta The forums mangle most code like that especially anything that has the backtick character in it like many mysql commands do.

If you need share that data please use https://pastebin.com/ instead and post the link to that paste. That should preserve your commands there.

Thread Starter

Natuma

(@dmnauta)

5 years, 5 months ago

The project export: wpda_project.txt
The project table export: wp_wpda_project_table.csv

Plugin Author

Passionate Programmer Peter

(@peterschulznl)

5 years, 5 months ago

Thanks Martin! Can you send me an SQL export of your table wp_wpda_project_table? Simplest way is to export it from the Data Explorer.

@jdembowski Thanks Jan! I didn’t know about that feature.

Best regards,
Peter

Thread Starter

Natuma

(@dmnauta)

5 years, 5 months ago

Hi Peter,

The wp_wpda_project_table in sql format: wpda_wp_wpda_project_table.txt

Good luck,
Martin

Plugin Author

Passionate Programmer Peter

(@peterschulznl)

5 years, 5 months ago

Hi Martin,

Thank you for this export. I could finally reproduce the problem. You are using brackets and spaces in your labels and the plugin doesn’t like that. If you remove the brackets and spaces the tabs work fine.

The label name is used to create an object id to make the tab clickable. Special characters are not allowed in ids so it looks like I never tested this with special characters. I fixed this issue but it won’t be available before the version release. If you don’t want to wait you can use the actual development version which can be downloaded from Bitbucket. If you don’t mind you could remove the brackets and spaces from your labels and add them ones the next version is release.

Thank you for bringing up this issue and being so patient! 😉

Best regards,
Peter

Thread Starter

Natuma

(@dmnauta)

5 years, 5 months ago

Thanks,Peter!

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘DataProject with non-default “Options Set Name” second “Tabpage” not responding’ is closed to new replies.