Announcement

Collapse
No announcement yet.

error "Data Type Mismatch In Criteria Expression"

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    error "Data Type Mismatch In Criteria Expression"

    Hi all

    finally got moving putting this site together

    Now I got another problem ! !

    Moving items around in my on-line shop in V14, I'm sometimes seeing the
    error

    If, for example, I want to cut and paste an item or section, when I right
    click and cut, I get

    "Data Type Mismatch In Criteria Expression"

    It's in a box with a yellow exclamation mark in a triangle, with an 'ok'
    button

    If I click 'ok', the box goes, then when I go to paste the item, I get the
    box again, I click 'ok' and the paste appears to have worked

    If I pick up 4 items, the I have to click the 'ok' box 4 times, when I paste

    I've tried compacting the database, completely un-installing V14 and
    re-installing it, and importing a snapshot back

    Any ideas anyone ??

    #2
    I have the same problem too. Tried compacting database etc. Its quite annoying! Have you found a fix?

    Comment


      #3
      Compacting is unlikely to help for this one. The error usually refers to the syntax being used to access a certain field of data being incorrect for that data type (i.e. date, number, text etc). Either you have managed to create illegal content in one of the fields, or it's a bug whereby Sellerdeck is using the wrong syntax for a field under certain conditions.

      Does it happen in all cases? If not, can you establish a pattern (e.g. only when the product has certain fields populated?)

      Also, try copying a product known to produce this error and then pasting it as a new product (not a duplicate). Check all the fields for discrepancies between the two products which might help identify the field which is causing the problem.

      (Obviously report to Sellerdeck also in case it is a known bug)
      Andy Barrow
      http://www.codepath.biz
      T: 0161 870 6355

      Accredited Sellerdeck development partners since 2004.
      Data import / export and catalog management plug-ins.

      Comment


        #4
        I found no patten to it got it any time I moved or deleted anything

        I got little help from support so I did this

        Export the site as a csv file

        Inported a snapshop taken before the error first showed

        Inported the csv file

        after doing that never saw the error again

        got to say not what a expect from software costing over £500 to upgrade to and £1000 as a new user

        Comment


          #5
          Tried that Andy but no joy. Have raised a support ticket.

          Comment


            #6
            This was the response I got from support about this problem


            (SellerDeck Support)

            Apr 17, 10:09

            Hello,

            I looked into error you were having when moving an item in the content tree and have found out that this is actually a bug, so it will continue to happen.

            However, Development have explained there is a work around for this to get it to stop occurring. If you go to the Home on the content tree, and select the fragment Home Page Carousel | Marketing | Untick Enabled and select Apply.

            Now try dragging and dropping an item. That error should not occur again. When you are finished moving items, just go back to Home Page Carousel | Marketing | Tick Enabled and Apply.

            This should work and make it easier for you to drag and drop sections.


            By the time I got that info I had done the fix above

            Comment


              #7
              Thanks for that David.. I ended up doing the same as you, importing a snapshot.

              Comment


                #8
                Not a bug they've fixed as I've now got it in a 2016 site!
                Elysium:Online - Official Accredited SellerDeck Partner
                SellerDeck Design, Build, Hosting & Promotion
                Based in rural Northants

                Comment


                  #9
                  Still occurs

                  If you change the image on any product or section hat is included on the carousel without updating the carousel entry you will still get the mismatch error. I was confused to start with but this thread pointed me in the right direction.

                  Comment


                    #10
                    Welcome to the Community, David. Thanks for posting as it will let people know the issue is still current.
                    Norman - www.drillpine.biz
                    Edinburgh, U K / Bitez, Turkey

                    Comment


                      #11
                      Originally posted by David Laine View Post

                      However, Development have explained there is a work around for this to get it to stop occurring. If you go to the Home on the content tree, and select the fragment Home Page Carousel | Marketing | Untick Enabled and select Apply.
                      OK am I having a dumb blonde moment here? I am having the same problem as above, just started today. I do not understand the instructions above "and select the fragment Home Page Carousel" - where is this fragment?

                      Kind Regards
                      Karen

                      Charmed Cards & Crafts

                      Comment


                        #12
                        Originally posted by Goz View Post
                        Not a bug they've fixed as I've now got it in a 2016 site!
                        How did you fix it Goz? I can't see anything amiss in the database.
                        Kind Regards
                        Karen

                        Charmed Cards & Crafts

                        Comment


                          #13
                          OK am I having a dumb blonde moment here? I am having the same problem as above, just started today. I do not understand the instructions above "and select the fragment Home Page Carousel" - where is this fragment?
                          You should find it by going to the top of the content to find the home page, then click on the + to see the fragments that are there. One of them should be called 'Carousel'.
                          -----------------------------------------

                          First Tackle - Fly Fishing and Game Angling

                          -----------------------------------------

                          Comment


                            #14
                            Click image for larger version

Name:	home-fragments.JPG
Views:	144
Size:	34.2 KB
ID:	552825
                            Originally posted by Mike Hughes View Post

                            You should find it by going to the top of the content to find the home page, then click on the + to see the fragments that are there. One of them should be called 'Carousel'.
                            No I don't have that.
                            Kind Regards
                            Karen

                            Charmed Cards & Crafts

                            Comment


                              #15
                              I guess the 'known' bug is due to a type mismatch in that carousel fragment and if you don't have that fragment then I'd say the chances are you probably have a type mismatch happening somewhere else.

                              All I can suggest is that you try compacting the database or maybe doing the fix referred to above. i.e. export site CSV > Import an earlier snapshot before the problem occured > Import site CSV.

                              As always, make sure you have a backup before trying anything that might cause more problems.
                              -----------------------------------------

                              First Tackle - Fly Fishing and Game Angling

                              -----------------------------------------

                              Comment

                              Working...
                              X