Order history no longer works

Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • #48334
    Dominique Gagné
    Participant

      I added Gateway pizza and preorder to wp-pizza, everything works for the extensions, but since Order history is no longer available, can you give me a solution track to make it work again?

      Thank!

      #48335
      Olly
      Admin & Mod

        how exactly do you mean “no longer available” ?
        is there no link on the left hand side to it, or is it just a blank page or what exactly ?
        does it work again if you disable those 2 plugins (which gateway by the way ?)
        perhaps you can post a screenshot too…..

        if it’s “just” a blank page, have you enabled debug and checked your debug.log ?
        https://docs.wp-pizza.com/troubleshooting/

        #48336
        Olly
        Admin & Mod

          and what version of wppizza and the preorder and gateway do you have installed ?

          #48337
          Dominique Gagné
          Participant

            Sorry for my bad English, I am French-speaking.

            WPPizza 3.12.1
            WpPizza Gateway Paypal 5.1.2
            Preorder 3.1.2

            I see no results found in place of my orders placed on the site, before installing the 2 extensions it worked.

            #48338
            Olly
            Admin & Mod

              anything in your debug.log ?
              how exactly do you mean “no longer available” ?
              is there no link on the left hand side to it, or is it just a blank page or what exactly ?
              perhaps you can post a screenshot too…..

              #48339
              Olly
              Admin & Mod

                ignore the last 3 lines in above post.
                what about your debug .log though ?

                #48341
                Dominique Gagné
                Participant

                  I am not able to understand what is happening, I send you the content of debug.log

                  I’m sending it to you via WeTransfer.

                  Thank you for helping me.

                  #48345
                  Olly
                  Admin & Mod

                    first of all:
                    delete your debug.log (it’s over 200mb ! – noone needs to look at notices etc from 2 years ago – it will be re-generated if needs be )
                    secondly you have lots of

                    
                    [28-Apr-2020 14:15:23 UTC] PHP Notice:  Constant WP_DEBUG_DISPLAY already defined in [path]/wp-config.php on line 94
                    [28-Apr-2020 14:15:23 UTC] PHP Notice:  Constant WP_CACHE already defined in [path]/wp-config.php on line 98
                    [28-Apr-2020 14:15:23 UTC] PHP Notice:  Constant WP_POST_REVISIONS already defined in [path]/wp-config.php on line 99
                    [28-Apr-2020 14:15:23 UTC] PHP Notice:  Constant EMPTY_TRASH_DAYS already defined in [path]/wp-config.php on line 100
                    [28-Apr-2020 14:15:23 UTC] PHP Notice:  Constant WP_MEMORY_LIMIT already defined in [path]/wp-config.php on line 101
                    

                    which means those constants above are (re)defined in the wrong place somewhere and will not do anything (other than throwing those errors 1000’s of times)

                    apart from that:
                    does it work if you de-activate the pre-order plugin ?
                    if so, can i see a screenshot of the settings (i.e [your url]/wp-admin/edit.php?post_type=wppizza&page=wppizza_preorder ) ?
                    can i also see the output of wppizza->tools->system info (if you post it here, perhaps set the reply to being a “private reply”)

                    thanks

                    #48346
                    Olly
                    Admin & Mod

                      actually , looking at your site , you are not using wppizza 3.12.1 , but 3.7.1 ,
                      if you have enabled “Order Sorting:” in the plugin , then that may well be the issue (i’ll have to add a note to th eplugin that this will only work from version xyz onwards)
                      let me know if switching that option off will let you view the order history again

                      #48347
                      Olly
                      Admin & Mod

                        actually (admittedly i need to mention that in the plugin requirements)
                        if you are using wppizza v3+ it must be version 3.8 at a minimum for the preorder plugin to work.
                        after all, v3.7.1 is over a year and a half old

                        #48412
                        Dominique Gagné
                        Participant
                          This reply has been marked as private.
                          #48583
                          Dominique Gagné
                          Participant

                            I disabled the Precommand plugin and the order history returned. I reactivated it to send you the page pizzaioli.ca/wp-admin/edit.php?post_type=wppizza&page=wppizza_preorder

                            I didn’t check “Order Sorting:” in the plugin.

                            I send you the requested screens and system info in a private message.

                            If I install version 3.8 of wppizza, would I have other problems related to the plugin this new?

                            #48585
                            Olly
                            Admin & Mod

                              >I disabled the Precommand plugin and the order history returned.
                              sure, because it requires 3.8 – at a minimum

                              >I didn’t check “Order Sorting:” in the plugin.
                              that doesnt matter actually. it needs the wppizza orders meta table – which only exists since 3.8 – to work

                              >If I install version 3.8 of wppizza, would I have other problems related to the plugin this new?
                              I cannot tell you, it all depends on what else you have running (wppizza or otherwsie) , but it’s immaterial as 3.8 does not exist for download .

                              the most recent version as of writing this is wppizza 3.12.2, so you would be advised to update anyway.
                              However , if you have customised things somewhere i cannot know what effect this might have – depends all onhow you customised things, so if you update from such an old version of wppizza to the most recent one, i would strongly suggest you make a full backup of your site first.

                              alternatively, you could *try* the following (which may or may not work, but perhaps worth a try)
                              assuming that you have perhaps access to your database in some way (and know what you are doing) you could create the meta table manually like so :

                              
                              CREATE TABLE '{prefix}_wppizza_orders_meta' (
                              'meta_id' BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
                              'order_id' INT(10) NOT NULL DEFAULT '0',
                              'meta_key' VARCHAR(190) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
                              'meta_value' LONGTEXT NULL COLLATE 'utf8mb4_unicode_ci',
                              PRIMARY KEY ('meta_id'),
                              INDEX 'order_id' ('order_id'),
                              INDEX 'meta_key' ('meta_key')
                              );
                              

                              REPLACING the {prefix} here with your WP table prefix that is being in use on your site
                              doing that might even make this all work with wppizza version < 3.8 (but not tested)

                              #48584
                              Dominique Gagné
                              Participant
                                This reply has been marked as private.
                              Viewing 14 posts - 1 through 14 (of 14 total)
                              • The topic ‘Order history no longer works’ is closed to new replies.