close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Updating products is throwing error in Power Store

Thread began 3/19/2019 1:35 pm by Patrice | Last modified 3/27/2019 1:05 pm by Ray Borduin | 85 views | 17 replies |

Patrice

Updating products is throwing error in Power Store

A new error is being thrown when updating cart products.

Update ps4_products set ProductStartDate = '18-12-02', ProductEndDate = '19-06-01', ProductUpdateDate = '2019-03-19 13:29:49' WHERE ProductID in ( select Distinct ProductID from ps4_productoptions where ps4_productoptions.OptionID in ('') AND ProductID in (select ProductID from ps4_productoptions where OptionID = 464)) OR ProductID = 483
Truncated incorrect DOUBLE value: ''

I have two small testers and it is not doing it to those two but other products are getting this message.

I think this may be related to updating from mysql to MariaDB which happened about the same time they are reporting errors.

Sign in to reply to this post

Ray BorduinWebAssist

I'll need FTP access and a url and steps to reproduce. I can't be sure of the cause without more active debugging.

Sign in to reply to this post

Patrice

OK

Sign in to reply to this post

Patrice

The first private message contained the cart admin. The second is the ftp log in.
Let me know if you want access to the database. A repair maybe?

Sign in to reply to this post

Ray BorduinWebAssist

What product should I update to get the error? I just need steps to reproduce... do I need to change anything or just go to the page and click update for a particular product?

Sign in to reply to this post

Patrice

They are all throwing it, except for two that are called test for $1.00.
Just select a product and click update. Don't even need to change anything.

Sign in to reply to this post

Patrice

I logged into cpanel and checked the database and it reported back OK. I didn't try the repair button.

Checking on it and some are not throwing error now, but I'll post in PM one that I found that still is.

Sign in to reply to this post

Patrice

Let me know if I can do anything to help.I did observe that if you make an edit in descriptions, that even though the error gets thrown, the edit sticks. I tested this on the 210 product.

Sign in to reply to this post

Ray BorduinWebAssist

What coalition is defined in phpMyAdmin for the ps4_products table and the ProductName column?

Sign in to reply to this post

Patrice

utf8_general_ci

in non-cart db for pages, it is latin1_swedish_ci

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...