Home › Forums › Quform WordPress › UNIQUE
- This topic has 10 replies, 2 voices, and was last updated 1 month, 1 week ago by
Icemanmx.
- AuthorPosts
- July 18, 2024 at 11:49 pm #37084
Icemanmx
ParticipantHello
I need to have a unique column for my e-mail so i don´t get double entries of e-mails in the data base.
How can i do this?
I will send you the sql file what you can see the sql.
I also sending you the image of the form what i need the unique field.I also had before CHARSET=utf8mb4 but now it shows CHARSET=utf8mb3. Why i ask about this is that some times when they sending the order it does not send it complete. So is it better for me to convert it back to CHARSET=utf8mb4?
We just had a server change from CentosOS7 to Rocky8 what we have now. So we transfer with cpanel from old to new server.
Best Regards
Adelbert OttoAttachments:
You must be logged in to view attached files.July 19, 2024 at 1:34 am #37088Icemanmx
ParticipantHello
It was not utf8mb4, it was only utf8 like this before…
ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=’Listado de Orden’;Best Regards
Adelbert OttoJuly 23, 2024 at 8:57 am #37089Ally
Support StaffYou don't have permission to view this content. Please log in or register and then verify your purchases to gain access.
July 23, 2024 at 11:51 pm #37092Icemanmx
ParticipantHello Ally
Thanks for help, that helped me so i don´t get double e-mails in the database….Anyway i changed the database from ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; to ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
But i guess that was not the problem, but is better.So to the other funny stuff what is going on with the partidas was that if you put 0 or leave blank the price field it is jumping over the that partida and don´t send it with the e-mail.
So how can we adjust the javascript code i have so it can accept 0 or empty field? I will attache the javascript here….
Best Regards
Adelbert Otto- This reply was modified 1 month, 2 weeks ago by
Icemanmx.
Attachments:
You must be logged in to view attached files.July 24, 2024 at 9:19 am #37098Ally
Support StaffYou don't have permission to view this content. Please log in or register and then verify your purchases to gain access.
July 24, 2024 at 4:30 pm #37099Icemanmx
ParticipantHello Ally
I don´t know how they did before but all was good to now.
When you put a 0 or leave it blank in the precio field it send the result to the database and it is cero and and have all the partidas.
But that Partida what is 0 or blank does not show up on my e-mail template in outlook, it just jumping over that partida.I will send you both file, the js and the plugin for the e-mail template i am using.
I also sent you mail with a video link you can see what i really mean.Best Regards
Adelbert OttoAttachments:
You must be logged in to view attached files.July 25, 2024 at 6:11 am #37105Ally
Support StaffYou don't have permission to view this content. Please log in or register and then verify your purchases to gain access.
July 25, 2024 at 8:17 am #37106Icemanmx
ParticipantHello Ally
I did what you told me and for me that function perfect, now i can use 0 or a blank field.
Thanks again for a outstanding service and support.
I purchased a other copy of your qform for wordpress.Best Regards
Adelbert OttoAttachments:
You must be logged in to view attached files.July 25, 2024 at 6:38 pm #37108Icemanmx
ParticipantHi Ally
Want to ask if you have license for multisite wordpress installation?Best Regards
Adelbert OttoJuly 26, 2024 at 11:12 am #37109Ally
Support StaffYou don't have permission to view this content. Please log in or register and then verify your purchases to gain access.
July 26, 2024 at 4:39 pm #37110Icemanmx
ParticipantHi Ally
Yes i have subdomain for my multisite i just started on jffk.org like eso.jffk.org and so on…
Ok, then i know i can use same license key…
ThanksBest Regards
Adelbert Otto - This reply was modified 1 month, 2 weeks ago by
- AuthorPosts
- You must be logged in to reply to this topic.