Fresh Install – DB Errors?

WPPizza – A Restaurant Plugin for WordPress › Support › General Support › Fresh Install – DB Errors?

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • 2 September, 2015 at 8:20 pm #11935
    bdluk
    Participant

      Hi,

      I’ve done a fresh install of WordPress, and WPPizza, just to ensure I’m not going mad.

      However on selecting items, adding them to the cart, and trying to place the order I get the following in the Debug logs

      [02-Sep-2015 19:04:41 UTC] WordPress database error Table ‘caspers_wp.wp_wppizza_orders’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_wppizza_orders made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/twentyfifteen/page.php’), get_template_part, locate_template, load_template, require(‘/themes/twentyfifteen/content-page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, WPPIZZA_ACTIONS->wppizza_add_shortcode, include(‘/plugins/wppizza/views/shortcode.php’), WPPIZZA_ACTIONS->wppizza_include_shortcode_template, include(‘/plugins/wppizza/templates/wppizza-order.php’), do_action(‘wppizza_choose_gateway’), call_user_func_array, WPPIZZA_GATEWAYS->gateway_db_initialize_order

      Checking the DB server previously there were no tables called wp_pizza_orders – and no tables at all other than wordpress ones that I could see.

      Have I missed something rather obvious or has the install not worked correctly?

      2 September, 2015 at 8:26 pm #11938
      Olly
      Admin & Mod

        >Checking the DB server previously there were no tables called wp_pizza_orders –

        i can positively assure you there were (unless the plugin never ever worked for you)
        it does not work without that table . period.

        >or has the install not worked correctly?
        that would be my guess. when you install the plugin that table HAS TO be created (and does, unless something else is wrong.)

        reinstall i’d suggest and – before you do – turn on WP_DEBUG to find out if something goes wrong (and why)

        2 September, 2015 at 10:28 pm #11946
        bdluk
        Participant

          Hi I’ve not actually had the plugin “working” at all before, I’ve edited menu items and stuff and worked out most stuff, but kept getting that error on checkout.

          This is a fresh instal of WordPress and wppizza and still have no table entries other than standard wp ones.

          I can give you access to debug or look at what the issue is, I’ve enabled debug and once again installed the plugin but there’s no debug.log file.

          2 September, 2015 at 10:38 pm #11947
          Olly
          Admin & Mod

            >I can give you access to debug
            might be worth a look

            > or look at what the issue is,
            i know what the issue is. it’s that the table does not get created without it it will not work

            > I’ve enabled debug and once again ….but there’s no debug.log file.
            how exactly did you do that ?

            2 September, 2015 at 10:40 pm #11948
            Olly
            Admin & Mod

              also, what version of mysql are you using ?

              perhaps you could send me the output from wppizza->tools->system info to
              dev[at]wp-pizza.com

              3 September, 2015 at 1:25 am #11970
              Olly
              Admin & Mod

                you can also try the following after you installed it and if the table has not been created.
                open wppizza/wppizza.php

                edit as follows (and save when done)

                approx line 8: change
                Version: 2.15.0.5
                to
                Version: 2.15.0.5.1

                approx line 39: change
                define(‘WPPIZZA_VERSION’, ‘2.15.0.5’);
                to
                define(‘WPPIZZA_VERSION’, ‘2.15.0.5.1’);

                then go to any page of the admin section (plugins would be a good one, but it doesnt matter)

                after that , check if that table has now been created and let me know

                4 September, 2015 at 8:14 pm #12023
                bdluk
                Participant

                  Brilliant support from Author – issue resolved, down to an old Maria/SQL version i had missed that was installed

                  Can’t say thanks enough, and ensures I’ll be using this plugin 🙂

                • Author
                  Posts
                Viewing 7 posts - 1 through 7 (of 7 total)
                • The topic ‘Fresh Install – DB Errors?’ is closed to new replies.