Title: Dave's Replies | WordPress.org --- # Dave [ ](https://wordpress.org/support/users/dnuttall/) * [Profile](https://wordpress.org/support/users/dnuttall/) * [Topics Started](https://wordpress.org/support/users/dnuttall/topics/) * [Replies Created](https://wordpress.org/support/users/dnuttall/replies/) * [Reviews Written](https://wordpress.org/support/users/dnuttall/reviews/) * [Topics Replied To](https://wordpress.org/support/users/dnuttall/replied-to/) * [Engagements](https://wordpress.org/support/users/dnuttall/engagements/) * [Favorites](https://wordpress.org/support/users/dnuttall/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 56 total) 1 [2](https://wordpress.org/support/users/dnuttall/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/dnuttall/replies/page/3/?output_format=md) [4](https://wordpress.org/support/users/dnuttall/replies/page/4/?output_format=md) [→](https://wordpress.org/support/users/dnuttall/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] TablePress + relational tables?](https://wordpress.org/support/topic/tablepress-relational-tables/) * Thread Starter [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [3 years, 10 months ago](https://wordpress.org/support/topic/tablepress-relational-tables/#post-15970420) * Yes, the wpdb class is an option. I’ll probably end up using a PHP app generator and running the results on a sub-folder or sub-domain. * Thanks. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[TablePress - Tables in WordPress made easy] TablePress + relational tables?](https://wordpress.org/support/topic/tablepress-relational-tables/) * Thread Starter [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [3 years, 10 months ago](https://wordpress.org/support/topic/tablepress-relational-tables/#post-15968640) * Thanks, Tobias. You are correct. Join queries to avoid incredibly wide “flat” files. I can solve my problem….just not in WordPress. Regardless, TablePress is a very impressive plugin. Congrats Tobias. d. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form 7] Unable to edit contact forms since 5.5 update](https://wordpress.org/support/topic/unable-to-edit-contact-forms-since-5-5-update/) * [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [4 years, 9 months ago](https://wordpress.org/support/topic/unable-to-edit-contact-forms-since-5-5-update/#post-14957990) * I have the same problem upon updating to ver. 5.5 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[List category posts] Output tags](https://wordpress.org/support/topic/output-tags/) * [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [5 years, 8 months ago](https://wordpress.org/support/topic/output-tags/#post-13538240) * Does this feature still carry the “coming soon” label? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[List category posts] list post and pages](https://wordpress.org/support/topic/list-post-and-pages/) * [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [5 years, 8 months ago](https://wordpress.org/support/topic/list-post-and-pages/#post-13538191) * THAT PAGE SEEMS TO HAVE BEEN HI-JACKED. BE CAREFUL. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Ultimate Member – User Profile, Registration, Login, Member Directory, Content Restriction & Membership Plugin] account page is empty after installation?](https://wordpress.org/support/topic/account-page-is-empty-after-installation/) * [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [5 years, 10 months ago](https://wordpress.org/support/topic/account-page-is-empty-after-installation/#post-13297682) * Thank you! I saw something in another post where it suggested that account.php should be copied to the child theme but in a folder: ultimate-member/templates/ account.php * My guess is that if you put the page-account.php in the root of your child theme, that was POSSIBLY (don’t know for sure) a potential problem. * Thanks again. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Ultimate Member – User Profile, Registration, Login, Member Directory, Content Restriction & Membership Plugin] account page is empty after installation?](https://wordpress.org/support/topic/account-page-is-empty-after-installation/) * [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [5 years, 10 months ago](https://wordpress.org/support/topic/account-page-is-empty-after-installation/#post-13297041) * Dear [@nadiaam67](https://wordpress.org/support/users/nadiaam67/), It would be VERY helpful if you could post exactly what you did to solve the problem. * TIA! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Combine wp_users table with wp_usermeta](https://wordpress.org/support/topic/combine-wp_users-table-with-wp_usermeta/) * [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [6 years, 3 months ago](https://wordpress.org/support/topic/combine-wp_users-table-with-wp_usermeta/#post-12617852) * Please consider using the native WordPress capabilities and control mechanisms before inventing something. * What you should consider is ROLES within WordPress. If that isn’t sufficient, then think about doing what you’re asking about. * WordPress ROLES are very powerful and easily expanded. * HTH. Dave * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Difficulty with auto column and primary key errors in designer](https://wordpress.org/support/topic/difficulty-with-auto-column-and-primary-key-errors-in-designer/) * [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [6 years, 3 months ago](https://wordpress.org/support/topic/difficulty-with-auto-column-and-primary-key-errors-in-designer/#post-12590244) * Peter/John: With regard to the primary key (ID, name) and the assumption that you want “name” to be unique, why not simply declare a UNIQUE INDEX on name? * Just my $0.02! (USD) Dave * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] How to make data items clickable?](https://wordpress.org/support/topic/how-to-make-data-items-clickable/) * Thread Starter [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [6 years, 3 months ago](https://wordpress.org/support/topic/how-to-make-data-items-clickable/#post-12568953) * Peter, The explicit table.fieldname (c_songtitles.hymnary_org_url) does NOT work; HOWEVER, the ALIAS works PERFECTLY! * What a dream come true! I’ve been fooling with “custom fields” and FAILING. * I think the appropriate expression (perhaps outdated) is: YOU da bomb, Peter! * THANKS! d. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] How to make data items clickable?](https://wordpress.org/support/topic/how-to-make-data-items-clickable/) * Thread Starter [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [6 years, 3 months ago](https://wordpress.org/support/topic/how-to-make-data-items-clickable/#post-12568472) * OK! Hard-coded URL works but the concat() string MUST have a “comma” at the end of the line. * I’m guessing now that what you’re working on MIGHT provide the ability to replace the hard-coded URL with the actual data in a selected field? * I’m “all in” for something like that! And can wait until the “coronavirus” comes around and then I have to run because I’m 15 years past the youngest members of the high-risk group! * THANKS, Peter! d. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] How to make data items clickable?](https://wordpress.org/support/topic/how-to-make-data-items-clickable/) * Thread Starter [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [6 years, 3 months ago](https://wordpress.org/support/topic/how-to-make-data-items-clickable/#post-12568027) * I don’t recognize what should be substituted in that concat string, except that“ target” will likely be “_blank”. * Does label = the field name and url/your-url = the data? * Sorry to be so “dense between the ears”! d. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] How to make data items clickable?](https://wordpress.org/support/topic/how-to-make-data-items-clickable/) * Thread Starter [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [6 years, 3 months ago](https://wordpress.org/support/topic/how-to-make-data-items-clickable/#post-12567958) * It is becoming CLEARER, Peter! But WHERE does the JSON get added to the column? Thanks. Dave * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] How to make data items clickable?](https://wordpress.org/support/topic/how-to-make-data-items-clickable/) * Thread Starter [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [6 years, 3 months ago](https://wordpress.org/support/topic/how-to-make-data-items-clickable/#post-12567426) * Hi Peter, Here is the core of my view. Fields that I would like to have as active hyperlinks are: **c_songtitles.hymnary_org_url** and **c_mtracks.url** – – – select `c_songtitles`.`st_id` AS `st_id`, `c_songtitles`.`st_title` AS `st_title`,` c_songtitles`.`st_genre` AS `st_genre`, `c_songtitles`.`music_key` AS `music_key`,` c_songtitles`.`hymnary_org_url` AS `hymnary_org_url`, `c_song_genres`.`id` AS` id`, `c_song_genres`.`genre` AS `genre`, `midi_sequencers`.`ms_id` AS `ms_id`,` midi_sequencers`.`ms_name` AS `ms_name`, `c_mtracks`.`mst_id` AS `mst_id`, `c_mtracks`.` sequencer_id` AS `sequencer_id`, `c_mtracks`.`url` AS `url`, `midi_voicing`.` mv_id` AS `mv_id`, `midi_instrumentation`.`mi_id` AS `mi_id`, `midi_voicing`.` mv_desc` AS `mv_desc`, `midi_instrumentation`.`mi_desc` AS `mi_desc` from (((((` c_songtitles` join `c_song_genres`) join `midi_sequencers`) join `c_mtracks`) join `midi_voicing`) join `midi_instrumentation`) where ( (`c_mtracks`.`mst_id` = `c_songtitles`.`st_id`) and (`c_mtracks`.`sequencer_id` = `midi_sequencers`.` ms_id`) and (`c_song_genres`.`id` = `c_songtitles`.`st_genre`) and (`c_mtracks`.` voicing` = `midi_voicing`.`mv_id`) and (`c_mtracks`.`instrumentation` = `midi_instrumentation`.` mi_id`) ) order by `c_songtitles`.`st_title` – – – – – TIA. Dave - This reply was modified 6 years, 3 months ago by [Dave](https://wordpress.org/support/users/dnuttall/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] ERROR: Not authorized](https://wordpress.org/support/topic/error-not-authorized/) * [Dave](https://wordpress.org/support/users/dnuttall/) * (@dnuttall) * [6 years, 3 months ago](https://wordpress.org/support/topic/error-not-authorized/#post-12565109) * I’ve been following this thread with great interest! * Mike, Does BlueHost NOT allow you to create your unique database administration users and then allow you to assign one or more to each database? * I run on DreamHost and their cPanel gives me total control over which users have access to databases, whether the access is via WordPress, phpMyAdmin or any other PHP code. (i.e., I have some apps that were created with SQL Maestro’s “PHP Generator). * Just curious! Dave - This reply was modified 6 years, 3 months ago by [Dave](https://wordpress.org/support/users/dnuttall/). Viewing 15 replies - 1 through 15 (of 56 total) 1 [2](https://wordpress.org/support/users/dnuttall/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/dnuttall/replies/page/3/?output_format=md) [4](https://wordpress.org/support/users/dnuttall/replies/page/4/?output_format=md) [→](https://wordpress.org/support/users/dnuttall/replies/page/2/?output_format=md)