Help With WordPress DB Error and Random ? Tags

  • Hi,
    I have tried unsuccessfully three time to upgrade from 2.2 to 2.2. Each time, I get the followed error message displayed on my home page in the right rail:

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
    SELECT cat_id, cat_name FROM

    I also end up with a bunch of ? tages everywhere.

    Can anyone help with this ( https://www.webcontentstrategy.com/ ).
    Thanks,
    Bianca

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

  • What version are you upgrading from?

    Thread Starter bprade

    (@bprade)

    From 2.0 to 2.2

    Thread Starter bprade

    (@bprade)

    Using fantastico through BlueHost I should add…

    After the upgrade is completed, delete the following two lines from your wp-config.php file:

    define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

    That should solve your strange character issue.

    The SELECT error is likely from your theme using the old linkcategory table. Your theme needs to be updated to use the template tag, wp_list_bookmarks().

    Hi,

    I’m having the same ‘?’ text error, among others. I went into the wp-config.php file, but those two define lines of code were not there. Just this:

    <?php
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘romaniaa_wpdb’); // The name of the database
    define(‘DB_USER’, ‘romaniaa_wpuser’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘bca753h’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

    // You can have multiple installations in one database if you give each a unique prefix
    $table_prefix = ‘wpi4f_’; // Only numbers, letters, and underscores please!

    // Change this to localize WordPress. A corresponding MO file for the
    // chosen language must be installed to wp-includes/languages.
    // For example, install de.mo to wp-includes/languages and set WPLANG to ‘de’
    // to enable German language support.
    define (‘WPLANG’, ”);

    /* That’s all, stop editing! Happy blogging. */

    define(‘ABSPATH’, dirname(__FILE__).’/’);
    require_once(ABSPATH.’wp-settings.php’);
    ?>

    Suggestions please. I’m a long-winded blogger. Manually fixing this will take eons.

    Grazie.

    Leif

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Help With WordPress DB Error and Random ? Tags’ is closed to new replies.