All Activity
This stream auto-updates
- Today
-
NOTE is not just not included in the screen shot. a new upload of the files addnewacct.php and admin_adduser.php solved the problem Thank you all Jean-Louis
-
Yes - if it truly is missing, and not just not included in the screen shot But there's still a mismatch between the number of fields given by name in the error message (34) and the number of ? entries (33) and the number of fields to be inserted as separated by the | character (35). The file admin_adduser from a fresh TNG install has 34, 34, 35 respectively. Roger
-
Control User Access in both TNG & Wordpress - with single user DB
KevyNC replied to KevyNC's topic in WordPress
Thanks Roger -- I will share any relevant info here that I find. Kevin -
Except that that the phpMyAdmin list of fields shows Notes which is field 37 as missing. It will need to be manually added back in. Too bad there is not the capability to drop a single table and rebuild it in TNG. Looks like notes is defined as simply text in the tabledefs notes TEXT NULL, so it should be easy enough to add it back in using phpMyAdmin
-
The field called "Site Owner" is what goes into the dbowner field in the database. First I would suggest updating to TNG 12.0.3 and see if that alone fixes this problem - it works fine on my TNG 12.0.3 site, so maybe that's something that got fixed between TNG 12.0 and TNG 12.0.3 Roger
-
Ken, Great advice as always, thanks
-
Try uploading a fresh copy of the files addnewacct.php admin_adduser.php and see if that fixes the problems. Roger
-
Control User Access in both TNG & Wordpress - with single user DB
theKiwi replied to KevyNC's topic in WordPress
@HeatherFeuer had a WordPress plugin that lets you have a single sign on I believe. But it perhaps seems to be no more - the bookmark I saved to her Github page no longer works. https://uniquelyyourshosting.net/how-to-integrate-wordpress-with-tng/ still exists - maybe contact her through that site. Roger -
If that is the complete list of fields in the tng_users table, you are missing the Notes field which is the last field in the TNG table.
-
I remove changes to database of Private Media Mod and uninstall / or re-install this. creating user always impossible. Requête: INSERT IGNORE INTO tng_users (description,username,password,password_type,realname,phone,email,website,address,city,state,zip,country,languageID,notes,gedcom,mygedcom,personID,role,allow_edit,allow_add,tentative_edit,allow_delete,allow_lds,allow_living,allow_private,allow_ged,allow_pdf,allow_profile,branch,dt_activated,dt_consented,no_email,disabled) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)sssssssssssssssssssssssssssssssss | aaa | aaa | 47bce5c74f589f4867dbd57e9ca9f808 | md5 | aaa | | | http:// | | | | | | 0 | | tree1 | | | guest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 2019-02-19 10:36:02 | | 0 | 0 Column count doesn't match value count at row 1
-
My site is located here: http://jeffcdo.com/genealogy/ The issue I'm having is when I print a fan chart, the footer reads "Castel de Oro & Karlsten Family Tree - Maintained by" with no value after that. I understand the variable is dbowner but I'm not finding that in the settings. I do have "Site Owner" defined under Setup/Configuration/General Settings/Site Design & Definition
-
Control User Access in both TNG & Wordpress - with single user DB
mahesh replied to KevyNC's topic in WordPress
You do not say whetherTNG and WP are integrated. This is what I have done, for many years. TNG and WP integrated using Mark Barnes method. Although I am seriously considering moving to KLOOSTERSMAN method. I keep the 2 databases separate, keeping the users list identical. I use wp plugin, Restrict Content by Role, to control access. This allows you to customize each page with conditional access. My method is to grant subscriber privilages to new members and guests. Registered users are granted contributor role. Each page is customized to give access to a perticular role. I also use a plugin, Menu Items Visibility Control, to control who can see each individual menu item ( again subsciber, contributor, admin etc.) Hope this gives you some ideas. -
Larry, I would implement the TNG captcha and also Deny this user access using the .htaccess file
-
To both Jim and Ken - I DO like the idea of having people being able to suggest changes, logged in or not. And I use Ken's method of registered users submitting changes as well but, someone is out there typing in data with urls for various sites. Of course I'm the only one getting it so it's not a tremendous issue. If they are taking the time to type these things then I believe they'd take the time to enter a captcha code as well. Then again, maybe bots are smart enough these days to fill in a name, two emails and a comment and press send... Maybe I'll just go ahead and put captcha on the suggest change dialog and see what happens. It would be nice to be able to block specific IP addresses from the site in general. Or maybe I'll just find the address and block it at the server level. Anyway, thanks for the thoughts, much appreciated. Larry
-
Control User Access in both TNG & Wordpress - with single user DB
KevyNC posted a topic in WordPress
Hello, I want to be able control access on TNG and Wordpress -- I want to have only ONE user DB. The reason for this is mainly because I want to have forums and maybe a few other items that I wanted to restrict access to in the Wordpress pages. The majority of Wordpress items will be public (other than forum). The Majority of TNG items will be private/restricted to registered users. I want to one sign-on for both TNG and Wordpress. Wordpress is in my /root/ and TNG is in subfolder. Which I want to prevent access to TNG Php's by manipulating the URL's etc. I did use Forum 10.x? on my older site, but I really would prefer a Wordpress Forum. One option if there was a way to Wordpress to recognize the TNG users and access level and control access from the TNG users/ DB. Second option and might word better in the long run for both, is to use a Wordpress plugin to control access to both TNG and Wordpress. My question is if anyone has tried and implemented either method -- what did you do, and why. What were the challenges, pros, and cons? Other thoughts, suggestions? Thanks, Kevin -
I agree with Jim. I chose to allow visitors to surf my site without a user name and over the years got value corrections and additions from others. My Roy ancestor only had one son who got married 3 times and had 19 children, 18 of which have descendants to today, since we are talking of the late 1600s and early 1700s there is no way that I know all current branches Logged in users who are granted the submitter role can enter corrections on the site which need to be approved before they are posted. I use that approach since my master database is on my laptop, so it needs to be updated with the changes made by submitters.
- Yesterday
-
Larry, Just my personal opinion and it is your site but if you prevent suggestions from the general public, and allow only suggestions from logged in users, then you might loose valuable clues... I say this because i make suggestions correcting entries in peoples trees and pointing them to the appropriate documentation all the time and while we might have common relations, they are usually not close enough for me to want to register on the respective site as it is just another password i have to remember and i usually stumble on these pages while searching for clues... Jim
-
Ken, thanks for the detail on captcha which I could install. I think if would be far better if suggestions were only allowed for registered and logged in users. Is this a possibility? There's really no need for the general public to suggest changes to anything because if they've gone that far, they must be related and might as well become a registered user??? Or, would there be a way to restrict/prohibit the use of url's in the comments area? Thoughts? Larry
-
Captcha has been available in TNG since TNG v6, but until TNG v12 you needed to install one of the captcha mods. With TNG v12 you need to either use the provided Google reCaptcha by saving the keys in the correct Admin > Setup > General Settings area or install one of the other mods. Captcha in TNG is available for New User requests and for Suggestions and Contact Us. I personally use the Image Captcha mod
-
Replying here because I'm not sure where else (other than start a new topic) would work. Same question - block IP address - but different problem. For the public area of my site, someone is going through individuals and clicking on "Suggest" and then submitting fictitious names and email addresses then using the "description of proposed changes" to list various websites. Any ideas on how to prevent someone (or some THING) from doing this is appreciated. There is no "captcha" associated with making proposed changes. I know I could limit access by requiring everyone to get a user name and password but I really don't want to do that. Thanks in advance
-
Sounds like you did not re-install the mod that added that new column to the tng_users record after the upgrade. Possibly the Private Media Mod
-
Photo's can't be seen and backup not possible
mk0111 replied to mk0111's topic in Questions and Answers
And the website is working again! WITH pictures and the possibility to backup. I replaced the config.php file. Since it was old, the website didnt work as planned. No template and so. I asked Darrin for help. He told me to run the updates again, because some tables were missing. I did. Ofcourse the old rootpad was still in, but since i knew how to fix things, i redid the deleting of the rootpad. I saved it again and voila. Now the right link was there. My website host changed a few folders on their site, so it wasn't working anymore.. THANX a lot for all your help! -
They are 38 fields = 19 allow privatemedia !!!
-
When I look at the database on my sites running TNG 12.0.3 there are 37 fields in the tng_users table. How many does yours have? Which one is missing? Roger
-
dabase upgrade OK, but creating user always impossible Requête: INSERT IGNORE INTO tng_users (description,username,password,password_type,realname,phone,email,website,address,city,state,zip,country,languageID,notes,gedcom,mygedcom,personID,role,allow_edit,allow_add,tentative_edit,allow_delete,allow_lds,allow_living,allow_private,allow_privatemedia,allow_ged,allow_pdf,allow_profile,branch,dt_activated,dt_consented,no_email,disabled) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)ssssssssssssssssssssssssssssssssss | test | xxx | b8114d4b98350e8bd7ad910bc6674e4b | md5 | Jean-Louis Valoryxxx | | test@gmail.com | http:// | rue d'Urfé | Saint-Just-en-Chevalet | Rhône-Alpes | 42430 | France | 0 | | tree1 | tree1 | | guest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 2019-02-18 15:48:01 | | 0 | 0 Column count doesn't match value count at row 1
