Olly

Forum Replies Created

Viewing 20 posts - 3,061 through 3,080 (of 4,446 total)
  • Author
    Posts
  • Olly
    Admin & Mod

      good stuff

      (i’d still ask your host to update mysql though…!)

      Olly
      Admin & Mod

        if you do you could alter the table like so

        ALTER TABLE 'wp_wppizza_orders' ADD COLUMN 'user_data' TEXT NULL AFTER 'notes';

        where wp_wppizza_orders should of course be the table name for your install
        (i would make a backup first though)

        this will not of course add multibyte support (actually even WP itself uses utf8mb4 now as of April 2015), but it should at least allow you to add to that table again (i.e save orders)

        Olly
        Admin & Mod

          do you have something like phpmyadmin though (or any other means of editing mysql tables) ?

          Olly
          Admin & Mod

            assuming that the mysql version is the issue and you have updated it , the table/column does not magically create itself.

            to do that, do either of the following:
            if there is a newer version of wppiza avilable, just update and it should create that column

            if there is no newer wppizza version yet, do the following (for the purpose of this example i assume your current wppizza version is 2.15.0.10):

            – de-activate wppizza
            – open wppizza/wppizza.php
            – on approx line 8 you will find Version: 2.15.0.10 change this to Version: 2.15.0.10.1
            – on approx line 39 you will find define('WPPIZZA_VERSION', '2.15.0.10'); change this to define('WPPIZZA_VERSION', '2.15.0.10.1');
            – save the file
            – go to your plugins page and reactivate the plugin. as the version number is now higher than what there was, it will check the table structure again and update what needs updating

            that should be it (i assume here that you know how to safely edit php files)

            Olly
            Admin & Mod

              this has nothing to do with ports. this has something to do with mysql 5.5 supporting multibyte character sets and old versions of mysql do not (not even talking about security/usability/speed etc issues with old db versiosn)

              that said, i still do not know what mysql/maria version you are using.
              if it’s below 5.5 just update it

              your host should also be more than happy to have recent releases. even 5.5 is about 5 years old now !

              Olly
              Admin & Mod
                This reply has been marked as private.
                Olly
                Admin & Mod

                  what version of mysql are you running

                  Olly
                  Admin & Mod

                    actually , forget previous.
                    just a quick look tells me your db table is missing a column

                    Olly
                    Admin & Mod

                      please , don’t post this whole debug stuff here (especially without putting it in code tags.
                      just give me a link to the debug.log .
                      make it private if you want

                      Olly
                      Admin & Mod

                        link to site please.
                        the errors you are posting above have nothing at all to do with what you are writing about and i suspect there are a LOT more entries in your debug.log

                        (though you might want to fix your server setup which is clearly messed up with missing or outdated extensions)

                        in reply to: Error when trying to order #12289
                        Olly
                        Admin & Mod

                          first of all, please start your own topics (though no harm in referencing/ linking to other topics)

                          secondly though, this error/notice never comes on its own and there will be something additional after that (i.e the reason of that note)
                          (of course, never say never, so if that’s not the case, there is something seriously wrong )

                          on top of that, please also emable wppizza->tools ->debug and see if you you get more error info

                          in reply to: Multiples of the same ingredient? #12243
                          Olly
                          Admin & Mod

                            of course you can add multiple unless you restrict this
                            i don’t know what you tested / looked at.

                            have a look at the
                            https://support.wp-pizza.com/twentytwelve/ -> make your own pizza.

                            the first few groups have restrictions (as labelled) the “ingredients for £ 0.50” for example don’t and you can add the same thing as often as you like

                            in reply to: Order History – Order status resets on refresh #12241
                            Olly
                            Admin & Mod
                              This reply has been marked as private.
                              in reply to: Order History – Order status resets on refresh #12237
                              Olly
                              Admin & Mod

                                @kaybee
                                for some reason i only just got (another) notice of your private post .
                                just ignore the test order i just placed (tried to check things that dont need checking anymore i believe)

                                in reply to: Scrolling cart #12227
                                Olly
                                Admin & Mod

                                  not quite,
                                  you’d also have to write some js to take away a bunch of classes

                                  generally though please also read here
                                  https://support.wp-pizza.com/topic/order-pickup-checkbox-doesnt-scroll-with-sticky-cart/

                                  in reply to: Difference between total and "Minimum Total" ?? #12222
                                  Olly
                                  Admin & Mod

                                    >….in general settings i can set:“Deliver even…..
                                    >..You can not add the option for this extension?…

                                    you do not need to, it’s a global setting that applies

                                    >In the current situation must look for something in store for 2 to have the opportunity to order.
                                    because you set minimum order to 80….

                                    in reply to: Difference between total and "Minimum Total" ?? #12220
                                    Olly
                                    Admin & Mod

                                      in other words.
                                      if you set minimum order value to 80 and free delivery above 80, there will NEVER be any delivery charges as you will not be able to order anything anyway until your items have reached 80.00

                                      in reply to: Difference between total and "Minimum Total" ?? #12219
                                      Olly
                                      Admin & Mod

                                        your minimum order value is still set to 80.00

                                        if minimum set to 80.00 minimum *items* have to be 80 to buy
                                        if minimum set to 20.00 for example minimum *items* have to be 20 to buy
                                        if at the same time “delivery free above 80” , delivery charges will be 80-item value….

                                        regarding your note on the screenshot: “now i cant see any other area because I turned off extension” —- of course you can’t . you turned it off…

                                        in reply to: Fax gateway #12211
                                        Olly
                                        Admin & Mod

                                          some fax gateways also require some sort of image attachment (for some reason) and / or the from address being set to something specific and a few other hoops….all doable though with what there is in the wppizza plugin

                                          in reply to: Add support for rest api #12209
                                          Olly
                                          Admin & Mod

                                            not really, no
                                            for what purpose anyway ?

                                          Viewing 20 posts - 3,061 through 3,080 (of 4,446 total)