WP database error

  • Resolved mjhenterprises

    (@mjhenterprises)


    7 years, 7 months ago

    I update WP to 4.7.3 and when I went to Pages via the Dashboard, the display was error codes. I updated and optimized the database and received the following errors:

    wp_wpsc_cart_item_meta: Table ‘wastatcc_wrdp1.wp_wpsc_cart_item_meta’ doesn’t exist
    wp_wpsc_purchase_meta: Table ‘wastatcc_wrdp1.wp_wpsc_purchase_meta’ doesn’t exist
    wp_wpsc_visitors: Table ‘wastatcc_wrdp1.wp_wpsc_visitors’ doesn’t exist
    wp_wpsc_visitor_meta: Table ‘wastatcc_wrdp1.wp_wpsc_visitor_meta’ doesn’t exist

Viewing 6 replies - 1 through 6 (of 6 total)

  • Was WP E-Commerce working before your update? Seems like you are missing those tables in your database can you confirm they are present? It is possible that when you optimized the database it killed off those tables.

    • This reply was modified 7 years, 7 months ago by RemedyWP.
    Thread Starter mjhenterprises

    (@mjhenterprises)

    This is the error code I get when trying to get to Pages:

    Warning: preg_match() [function.preg-match]: Compilation failed: unrecognized character after (? or (?- at offset 3 in /home/wastatcc/public_html/wp-includes/class-wp.php on line 231

    Warning: preg_match() [function.preg-match]: Compilation failed: unrecognized character after (? or (?- at offset 3 in /home/wastatcc/public_html/wp-includes/class-wp.php on line 232

    Warning: preg_match() [function.preg-match]: Compilation failed: nothing to repeat at offset 1 in /home/wastatcc/public_html/wp-includes/class-wp.php on line 231

    Warning: preg_match() [function.preg-match]: Compilation failed: nothing to repeat at offset 1 in /home/wastatcc/public_html/wp-includes/class-wp.php on line 232

    And this is what lines 231 and 232 look like in class-wp.php:
    if ( preg_match(“#^$match#”, $request_match, $matches) ||
    preg_match(“#^$match#”, urldecode($request_match), $matches) ) {

    Do you use a plugin called WP E-Commerce ? If you don’t need it and it’s still installed. Uninstall it. If you need it and your shop doesn’t work, install it again.

    Thread Starter mjhenterprises

    (@mjhenterprises)

    I uninstalled the WP eCommerce plugin and still cannot access Pages. It is still displaying the following script:

    Warning: preg_match() [function.preg-match]: Compilation failed: unrecognized character after (? or (?- at offset 3 in /home/wastatcc/public_html/wp-includes/class-wp.php on line 231

    Warning: preg_match() [function.preg-match]: Compilation failed: unrecognized character after (? or (?- at offset 3 in /home/wastatcc/public_html/wp-includes/class-wp.php on line 232

    Warning: preg_match() [function.preg-match]: Compilation failed: nothing to repeat at offset 1 in /home/wastatcc/public_html/wp-includes/class-wp.php on line 231

    Warning: preg_match() [function.preg-match]: Compilation failed: nothing to repeat at offset 1 in /home/wastatcc/public_html/wp-includes/class-wp.php on line 232

    Very hard to analyze without knowing what you have done before that happened, and what the first error was before you have “optimized” the database. Also, how have you done this? With a plugin?

    But it looks like it could have something to do with the permalinks rewriting. Go to “Settings – Permalinks” and try another option, e.g. plain. Save it and see if that helps.

    Thread Starter mjhenterprises

    (@mjhenterprises)

    I reset to a previous backup and uninstalled ecommerce plugin.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WP database error’ is closed to new replies.