kclearylcmc

About

Username
kclearylcmc
Joined
Visits
152
Last Active
Roles
Member
Points
24
Surname
Cleary
Preferred Name
Kevin

Comments

  • That does help--thank you, Sandra! I will keep the database fix in mind and give it a try sometime. One other issue that just cropped up is the ISBN requirement for print publications. Is there a way to at least make that field optional? I appreci…
  • Thanks, Ross--that makes perfect sense. I will experiment with your suggestion and other ideas to see what will work.
  • I tried chmod 775 and 755 on the entire uploads directory (recursively), and no change to the error message. Everything seems to be working fine, though; I will continue to ignore the message unless you discover some other trick to try. Thanks, San…
  • That worked great, Sandra! I got the first part replaced with our own message using string replacement. Unfortunately, the Original String field seems to have a character limit, so I wasn't able to fit the final sentence (If you do not have an acco…
  • As I continued to work on fixing this, I discovered in my system check that Gibbon shows my entire Uploads folder not server writable. When I checked permissions on the server, though, it shows that the folder is properly managed.
  • That makes perfect sense, Sandra. I will keep messing with it and see what I can manage to assemble on this end. The new update is looking good so far, though, and upgrading keeps getting easier and more reliable each time. Thanks for all the work …
  • Your three steps got it working, Jack--thank you so much! That all makes sense now that I've got it in place, but I don't think I would have made it without guidance. I had step one all set, but turning off less secure apps for a single account was …
  • That did the trick, Sandra! Thank you as always--your contributions to our program are beyond measure. Kevin
  • I got it enabled on the G Suite side (at least according to the Google instructions), so I think it's something on the server side. I tried opening up the 587 port on ufw in case that was an obstacle, but no luck. I started some php digging and foun…
  • Thank you, Ross, and thank you to Jack too! I haven't had any luck quite yet--I get a variety of errors when I try to send the test email (depending on my settings), but this one seems to indicate I am close. An error (SMTP connect() failed. https:…
  • Thanks, Sandra. I have tried a few ways of putting the new code into my query and I'm not getting it to work. (I do like how simple that new syntax is, though!) Here is the original query. (Image) When I replace the Case When lines directly, I h…
  • I actually spoke out of turn. I can make the first string return a value for 0006 and 0002 if they are first on the list, but not for 0009 no matter the position.
  • I'm always struggling with the Query Builder it seems--I appreciate any help that can be offered once again! I am running Gibbon 23.0.01 right now (I didn't upgrade to .02 with version 24 on the way) and Query Builder 2.0.04. I can finally get the …
  • Perfection! Thank you, Sandra. Kevin
  • I changed the lines in the files and it works perfectly now. Thank you so much, Ross! Kevin
  • Hello everyone! I'm actually in the same position as Yirong--after upgrading to version 23, my United States country code has vanished from pull down menus. At this point, all my families with a 1 code are now listed as Puerto Rico. I have combed th…
  • That worked great! Thank you so much, Sandra. Kevin
  • The name issue was actually my first realization, Sandra. When I initially copied the Default folder I forgot to match the names and didn't even get an option to install my new theme. (It showed in the "Not Installed" list but was red and …
  • Changing the chown solved the problem, Sandra. Thanks again! Kevin
  • I will give it a go, Sandra--thank you as always for looking out for me!
  • Thank you so much for the reply to my challenges, Sandra--I have been away from Query Building during the school year but am gearing up to need it for our summer programs. I anticipate this well help a lot, but I will keep you posted after I upgrade…
  • My son helped me determine a possible explanation for the problem pulling from 006. My 003 and 005 entries in gibbonPerson.fields is long text. He thought that might be messing with the Substring @find1 + 6 instructions. Not knowing much about JSON…
  • I've been messing with this more and can query the first field (School2122) by putting it's number first in the request. When I do this, though, the second field still doesn't pull. I've tried several variations but cannot figure out what is causing…
  • The query runs again, Sandra, but it's still not returning the values entered in those custom fields. The boxes are empty, so there must be something that isn't lining up. I'll experiment a little too, and thank you for correcting my codes.
  • Thank you so much for posting this, Sandra! I figured it was just a matter of syntax or adjusted database entries, but I don't know enough about JSON data types to figure that out alone. I am still running into trouble running the query, though. I …
  • I did finally get it figured out, Sandra and Ross. I chose to run with a second timetable for staff only (that did take a little back end fussing, but I got it in place). Students will just have a daily schedule which helps them better understand wh…
  • I think I see what you're saying, Ross. I'm struggling to apply it to my situation, but I'm going to give it a I also struggle with using query builder to export manageable schedules when using these rotations. Again, though, I'll mess with it a…
  • I think I have things moving in the right direction now. In my timetable column I have a row called Class 1 that runs 1:00-1:30--this is for classes that meet daily. I then created another row called Rotation 1 that also runs 1:00-1:30 (with the …
  • It is not making sense I'm afraid, but I will experiment a little and see if I can't get at what you're talking about. I'll keep you posted if I need more guidance. Thanks! Kevin
  • My apologies, Ross; I didn't use the correct terminology here. I did what you have described here last summer--one timetable with separate days. The problem is that we run a six day camp with a six day rotation. I was trying to avoid creating the en…