It's a question.
Permalink Browser Info Environment
Hello.
I'm Japanese.
When I try to add it to the block.
mysqlt error: [-9999: Numeric field type "N" requires numeric value.] in DOQUOTE(, )
I'm Japanese.
When I try to add it to the block.
mysqlt error: [-9999: Numeric field type "N" requires numeric value.] in DOQUOTE(, )
| Type: | Pre-Sale |
|---|---|
| Status: | In Progress |
Odd, which version of Concrete5 are you using?
I'm having this exact same problem with my site.
I'm using v5.6.3.3
Any ideas on what I can do to fix it?
I'm using v5.6.3.3
Any ideas on what I can do to fix it?
Looks like it's looking for a default numeric value for one of the fields.
The insert script should already check for this, but it appears to be
missing a field for some reason.
The insert script should already check for this, but it appears to be
missing a field for some reason.
Attached is a screenshot of the database when I had Simple JW Player working on a previous version of Concrete5 when it worked. Two fields that immediately draw my eye are the fs_thumbs and advertising field because they have N values.
Any ideas on how to get a more detailed error message so we can pinpoint which DB field is not being filled in correctly?
Any ideas on how to get a more detailed error message so we can pinpoint which DB field is not being filled in correctly?
Which version of C5 are you running?
Currently: v5.6.3.3
When the SS of the database was taken: v5.6.3.2
I have no issue implementing a fix to the file if you can help me pinpoint the error. I'm currently looking through Simple JWPlayer's form_setup_html.php for clues.
When the SS of the database was taken: v5.6.3.2
I have no issue implementing a fix to the file if you can help me pinpoint the error. I'm currently looking through Simple JWPlayer's form_setup_html.php for clues.
Both fields are serialized array text values rather than numeric values as the error states. Not sure what is causing it at the moment. Looking at the code to see if anything stands out.
The RTMP value did not enforce a default zero value on submission. Updated the code to correct this. Hope that solved it. I also updated the included JWPlayer library as well.
Right on.
What's the easiest way to get a copy of your updated code? I just checked C5 and it isn't notifying me that the add-on needs an update.
What's the easiest way to get a copy of your updated code? I just checked C5 and it isn't notifying me that the add-on needs an update.
If you have a license assigned to the website it should automatically list
the update within the update page.
the update within the update page.
I simply released and reassigned the add-on to my project and it popped up in the update panel.
I tested the new version and it fixed the error.
Thanks!
I tested the new version and it fixed the error.
Thanks!
Just applied a minor update that adds four new features.
autoplay, mute, loop playback, and disable controls options added
autoplay, mute, loop playback, and disable controls options added
I have the same error when adding a "Simple Testimonial".
Are we even talking about the same add-on?
No. But i had exactly the same problem with another addon. So i thaught it is a general C5 problem. But for now, i think i am wrong.