Skip Navigation

[Resolved] repeating datefield : query returns more than 1 row error.

This support ticket is created 5 years ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Our next available supporter will start replying to tickets in about 3.95 hours from now. Thank you for your understanding.

Sun Mon Tue Wed Thu Fri Sat
- - 14:00 – 20:00 14:00 – 20:00 14:00 – 20:00 14:00 – 20:00 14:00 – 20:00
- - - - - - -

Supporter timezone: Asia/Ho_Chi_Minh (GMT+07:00)

This topic contains 5 replies, has 2 voices.

Last updated by Beda 5 years ago.

Assisted by: Beda.

Author
Posts
#1384741

I am trying to:
have custom post with repeating datefield .
am trying to get custom post with repeating datefield : but query returns more than 1 row error if more than 1 date field is inserted
Link to a page where the issue can be seen:
hidden link
I expected to see:
date displayed
Instead, I got:

#1384855

I cannot see any error on the link you provided, or a View, or a date field or similar.

Can you elaborate on the issue as follows?

1. Where does the issue happen
2. What is the goal (what should happen)
3. What is instead happening and where can we see the errors
4. Possible steps to the issue, so we can replicate it eventually on a local site?

Thanks!

#1384893
Screen Shot 2019-11-16 at 21.15.36.png
fiv.png

Hi
1.- happens when logged in , admin login details
<removed>
on page load , hidden link when calendar displays

2. What is the goal , to display post of custom date fields on a calendar view, works if datefield only 1 row custom post .
screenshot green
3. What is instead happening and where can we see the errors, the calendar not show datefields
hidden link
error screenshot
4. create post form, of calendar post type, with repeating datepicker . submit post with two datepicker fields .

#1386737

I do not see that error.
What I see is a JS error in the console though, but that's not related to Toolset, it is from your-site.com/ajax/libs/jquery/3.4.1/jquery.min.js
I suggest to first update all software, then check if that JS error is still there, and if it persists, please start (maybe on a staging site) by disabling non-Toolset software and change the theme to a default WordPress theme like Twenty Nineteen to check if that solves the issue.
If so, please then re-enable the plugins and theme one by one to check which causes the issue, and report the error to their support - unless of course the issue is persisting with Toolset only, then we will check this and eventually provide a fix.

The mySQL query error on the popup you show in the Screenshot doesn't happen to me, and it seems not related to Toolset, because Toolset's Date Field doesn't query the database at a all, only once you save a Form for example or a Post with that field, it will save a simple timestamp in the database.

Does the precise issue as you see it happen with only Toolset?

#1391013

Hi ,
yes with Toolset , i made a rework on the script and replaced the mysql query the popup disappeared.

I have a related goal . Can I insert all dates that is between datepicker-field start date and datepicker field end date. Is there a Cred API can i use. Instead of the current method of that adds a repeating datepicker field for each date in a period. Thanks

#1392199

I am not sure I follow precisely what you did to fix it, however, that was not a Toolset issue as I saw it and as it is described.

For the new issue, you would have to open a new ticket, so we can handle it with adequate priority and attention.

Generally, you can only use "between" dates on Views that filter things, but not on Forms or when you add values to the actual date Field.
If that does not answer your question, please open a new ticket with it explaining what the goal is and what you tried or what looks different than you expected.
The Forms API is documented here, in case you need this:
https://toolset.com/documentation/programmer-reference/cred-api/