CRM
CRM copied to clipboard
ChurchCRM
non-admin user can\'t add family
A user with privileges: Add Records: Edit Records: Manage Donations and Finance:
gets "Cannot execute query" when attempting to add a family.
| Collected Value Title | Data |
|---|---|
| Page Name | /FamilyEditor.php |
| Screen Size | 720x1280 |
| Window Size | 584x1280 |
| Page Size | 1812x1280 |
| Platform Information | Linux server.reeveshome.org 4.4.0-116-generic #140-Ubuntu SMP Mon Feb 12 21:23:04 UTC 2018 x86_64 |
| PHP Version | 7.0.28-0ubuntu0.16.04.1 |
| SQL Version | 5.7.21-0ubuntu0.16.04.1 |
| ChurchCRM Version | 3.0.0 |
| Reporting Browser | Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0 |
| Prerequisite Status | All Prerequisites met |
| Integrity check status | {"status":"success"} |
yes
On 4/9/2018 8:32 PM, George Dawoud wrote:
@sjreeves https://github.com/sjreeves is this you
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChurchCRM/CRM/issues/4227#issuecomment-379945188, or mute the thread https://github.com/notifications/unsubscribe-auth/AgX3t3sC5F_lDRtgHkMZYyvBGN5QQOM8ks5tnAu_gaJpZM4TLvgG.
Can't seem to replicate this on demo site.
Still an issue for you @sjreeves ?
I'm getting the same issue after upgrading to 3.0.4. The web page says:
Cannot execute query.
INSERT INTO family_fam ( fam_Name, fam_Address1, fam_Address2, fam_City, fam_State, fam_Zip, fam_Country, fam_HomePhone, fam_WorkPhone, fam_CellPhone, fam_Email, fam_WeddingDate, fam_DateEntered, fam_EnteredBy, fam_SendNewsLetter, fam_OkToCanvass, fam_Canvasser, fam_Latitude, fam_Longitude, fam_Envelope) VALUES ('Burdell','','','','','','United States','','','','',NULL,'20180418184851',108,'TRUE','FALSE','','0','0','0')
Log file says:
PHP Fatal error: Uncaught Error: Call to a member function setUser() on null in .../ChurchCRM/model/ChurchCRM/Base/User.php:3759 Stack trace: #0 .../UserList.php(72): ChurchCRM\Base\User->getPerson() #1 {main} thrown in .../ChurchCRM/model/ChurchCRM/Base/User.php on line 3759
Here is some further observation. If the non-admin user has Canvasser privileges, then it can create a new family.
Also, even if I use an admin account, after creating the family, the menu items at the top won't work anymore until I go to the Menu.php page by clicking ChurchCRM in the upper left corner. And it throws the same error as above.
running the same query above i got the following SQL error
Error Code: 1366. Incorrect integer value: '' for column 'fam_Canvasser' at row 1
i created a user (non-admin user has Canvasser privileges) but i can't repo this issue
@sjreeves can you try to code change in https://github.com/ChurchCRM/CRM/pull/4280/files#diff-6c3139e002a1b75b53e294c2cb8eb2c0
