Install SQL error

[francoisjacquet]

DB Execute Failed. ERROR: column a.custom_200000017 does not exist LINE 89: a.custom_200000017, ^

The custom_200000017 column is a custom Student field which happens not be existing on a blank RosarioSIS installation.

[francoisjacquet]

All your questions should be answered in the README which includes what Custom Fields to add to the code.

Please answer each issue separately.

The README reads:

Also YOU MUST create a Student Custom Field of CLASS. We use this to track the graduation year of every student. This information is invaluable to many things we do. Example Class2025

Alright, but:

1. What is the type of this field?
2. The SQL error is, after adding a Student field: DB Execute Failed. ERROR: column a.custom_200000018 does not exist LINE 90: a.custom_200000018, ^

[DocStem]

The custom fields are a function of the system. You should look at the Rosario SIS documentation for creation of custom fields.

At a Database level you will find those fields present here.

Our number is 18 as that is the order in which we created our custom fields. Depending on the order in which you might create them, you would have a different number. We chose not to create a custom table, as that would make us too tied into the maintenance code and updates for the table relational linkage. If you convert this to a normal module, you can create a custom Table and then link through that since you’re the code maintainer.

From: François Jacquet @.> Sent: Monday, September 27, 2021 3:47 PM To: DocStem/LunchReport-master @.> Cc: Subscribed @.***> Subject: Re: [DocStem/LunchReport-master] Install SQL error (#3)

All your questions should be answered in the README which includes what Custom Fields to add to the code.

Please answer each issue separately.

The README reads:

Also YOU MUST create a Student Custom Field of CLASS. We use this to track the graduation year of every student. This information is invaluable to many things we do. Example Class2025

Alright, but:

1. What is the type of this field?
2. The SQL error is, after adding a Student field: DB Execute Failed. ERROR: column a.custom_200000018 does not exist LINE 90: a.custom_200000018, ^

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/DocStem/LunchReport-master/issues/3#issuecomment-928215548 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AQX6OKBBX3NRZOCGNJPSEV3UEDC35ANCNFSM5EZAABVA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub . https://github.com/notifications/beacon/AQX6OKGLIQZETMON4QXQ6FDUEDC35A5CNFSM5EZAABVKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOG5JXD7A.gif

-- CONFIDENTIALITY NOTICE:  This message is being sent by or on behalf of Immaculate Conception Academy.  It is intended exclusively for the individual or entity to which it is addressed.  This communication may contain information that is proprietary, privileged or confidential or otherwise legally protected.  The information herein may also be protected by the Electronic Communications Privacy Act, 18 U.S.C.A. Sections 2510-2521 or Children’s Online Privacy Protection Act (COPPA), 15 U.S.C. §§ 6501–6506.  If you are not the named addressee, you are not authorized to read, print, retain copy or disseminate this message or any part of it.  If you have received this message in error, please notify the sender immediately by e-mail and permanently delete all copies of the message.   INTERNET SECURITY NOTICE:  While all reasonable care has been taken to avoid the transmission of computer viruses, spyware, and other types of malware, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data.  No responsibility is accepted by the sender and the recipient should carry out such virus and other checks as it considers appropriate.

[DocStem]

We will be dropping a much more sophisticated meal module in the next 30 days that allows for on-line ordering and meal with ‘optional selections (which vegetable)’

Again for us everything is elementary and middle school, so the Parents will be the ordering and paying person (paypal and stripe).

From: François Jacquet @.> Sent: Monday, September 27, 2021 3:47 PM To: DocStem/LunchReport-master @.> Cc: Subscribed @.***> Subject: Re: [DocStem/LunchReport-master] Install SQL error (#3)

All your questions should be answered in the README which includes what Custom Fields to add to the code.

Please answer each issue separately.

The README reads:

Also YOU MUST create a Student Custom Field of CLASS. We use this to track the graduation year of every student. This information is invaluable to many things we do. Example Class2025

Alright, but:

1. What is the type of this field?
2. The SQL error is, after adding a Student field: DB Execute Failed. ERROR: column a.custom_200000018 does not exist LINE 90: a.custom_200000018, ^

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/DocStem/LunchReport-master/issues/3#issuecomment-928215548 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AQX6OKBBX3NRZOCGNJPSEV3UEDC35ANCNFSM5EZAABVA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub . https://github.com/notifications/beacon/AQX6OKGLIQZETMON4QXQ6FDUEDC35A5CNFSM5EZAABVKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOG5JXD7A.gif

-- CONFIDENTIALITY NOTICE:  This message is being sent by or on behalf of Immaculate Conception Academy.  It is intended exclusively for the individual or entity to which it is addressed.  This communication may contain information that is proprietary, privileged or confidential or otherwise legally protected.  The information herein may also be protected by the Electronic Communications Privacy Act, 18 U.S.C.A. Sections 2510-2521 or Children’s Online Privacy Protection Act (COPPA), 15 U.S.C. §§ 6501–6506.  If you are not the named addressee, you are not authorized to read, print, retain copy or disseminate this message or any part of it.  If you have received this message in error, please notify the sender immediately by e-mail and permanently delete all copies of the message.   INTERNET SECURITY NOTICE:  While all reasonable care has been taken to avoid the transmission of computer viruses, spyware, and other types of malware, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data.  No responsibility is accepted by the sender and the recipient should carry out such virus and other checks as it considers appropriate.