SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-2022-2023' for key 'exams_term_year_unique' #57
Comments
|
There is definitely a unique key |
|
From what I can see you can only add one exam with same term and year |
|
Hello thanks for your reply
I try to install application and seed db, and i go to exam , i create first
exam is ok and i create second and third, but when i want to create another
first exam i see this erreur
…On Fri, Nov 25, 2022, 1:18 PM Ebuka Ifezue ***@***.***> wrote:
From what I can see you can only add one exam with same term and year
—
Reply to this email directly, view it on GitHub
<#57 (comment)>, or
unsubscribe
<https://github.com/notifications/unsubscribe-auth/AH45KULPZK7N4VI4IHQB66LWKCVA3ANCNFSM6AAAAAASLFVVII>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
So you can explain me how it work sir , thank you for your time
…On Fri, Nov 25, 2022, 1:22 PM Karim Saber ***@***.***> wrote:
Hello thanks for your reply
I try to install application and seed db, and i go to exam , i create
first exam is ok and i create second and third, but when i want to create
another first exam i see this erreur
On Fri, Nov 25, 2022, 1:18 PM Ebuka Ifezue ***@***.***>
wrote:
> From what I can see you can only add one exam with same term and year
>
> —
> Reply to this email directly, view it on GitHub
> <#57 (comment)>, or
> unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AH45KULPZK7N4VI4IHQB66LWKCVA3ANCNFSM6AAAAAASLFVVII>
> .
> You are receiving this because you authored the thread.Message ID:
> ***@***.***>
>
|
|
I think this means that 2 exams cannot have the same name. I'm not sure as I'm not running the project anywhere and judging based on what you told me The code itself says that somehow you cannot have more than 1 exam in the same term and year @4jean should be able to clear this |
|
I see but i want to create many exams it possible or this part accepte only
3
For example i want to create exam english maths phylo and frensh, or this
is not the place i think to add this
…On Fri, Nov 25, 2022, 1:31 PM Ebuka Ifezue ***@***.***> wrote:
I think this means that 2 exams cannot have the same name. I'm not sure as
I'm not running the project anywhere and judging based on what you told me
The code itself says that somehow you cannot have more than 1 exam in the
same term and year
@4jean <https://github.com/4jean> should be able to clear this
—
Reply to this email directly, view it on GitHub
<#57 (comment)>, or
unsubscribe
<https://github.com/notifications/unsubscribe-auth/AH45KUKOJDIMHK6QIA2VGMLWKCWTVANCNFSM6AAAAAASLFVVII>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
I don't think Exams work that way You should create an exam like first semester final exams etc then you can add grades for each subjects in the system |
|
Aaaah i see hhh sorry bro, because here in Morocco not the same concept , i
understand now, thank you so much
…On Fri, Nov 25, 2022, 2:05 PM Ebuka Ifezue ***@***.***> wrote:
I don't think Exams work that way
You should create an exam like first semester final exams etc then you can
add grades for each subjects in the system
—
Reply to this email directly, view it on GitHub
<#57 (comment)>, or
unsubscribe
<https://github.com/notifications/unsubscribe-auth/AH45KUOIPVSCEH4TEXRO4JLWKC2THANCNFSM6AAAAAASLFVVII>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
Also i find an error in graduat student when you find a promotion student
and you make him graduate you go to graduate section and you find it, but
the error when you want to edit the graduate student from graduation
section there is and erreur also when you want to see the profile from
graduat section.
…On Fri, Nov 25, 2022, 2:17 PM Karim Saber ***@***.***> wrote:
Aaaah i see hhh sorry bro, because here in Morocco not the same concept ,
i understand now, thank you so much
On Fri, Nov 25, 2022, 2:05 PM Ebuka Ifezue ***@***.***>
wrote:
> I don't think Exams work that way
>
> You should create an exam like first semester final exams etc then you
> can add grades for each subjects in the system
>
> —
> Reply to this email directly, view it on GitHub
> <#57 (comment)>, or
> unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AH45KUOIPVSCEH4TEXRO4JLWKC2THANCNFSM6AAAAAASLFVVII>
> .
> You are receiving this because you authored the thread.Message ID:
> ***@***.***>
>
|
|
I think you should create a different issue for that wirh screenshots |
|
ok alright brother
…On Fri, Nov 25, 2022 at 3:52 PM Ebuka Ifezue ***@***.***> wrote:
I think you should create a different issue for that wirh screenshots
—
Reply to this email directly, view it on GitHub
<#57 (comment)>, or
unsubscribe
<https://github.com/notifications/unsubscribe-auth/AH45KUJG63HKDUQPWQXRTW3WKDHEPANCNFSM6AAAAAASLFVVII>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
SABER Karim
- Engineer Full Stack Developer
- Phone : 06 44 97 93 79
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hello sir, can sameone help me please .
i need to create exam i add exam with name and term, first try accepte the exam and when i want to add another exam they show me this issue
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-2022-2023' for key 'exams_term_year_unique' (SQL: insert into
exams(name,term,year,updated_at,created_at) values (sport, 1, 2022-2023, 2022-11-25 10:22:52, 2022-11-25 10:22:52))how can i solve this ? im going to migration and i see nothing is unique on table , i think i should increment the id
Thank you sir
The text was updated successfully, but these errors were encountered: