WordPress.org

Ready to get started?Download WordPress

Forums

CG-Referrer won't create table in WP2.1.3 (5 posts)

  1. tomhanna
    Member
    Posted 7 years ago #

    CG-Referrer returns the error:

    WordPress database error: [Table 'blo0711401101858.wp_cg_referrer' doesn't exist]
    SELECT COUNT(*) as num FROM wp_cg_referrer

    Cannot locate any existing CG-Referrer data.

    I press the "Create CG-Referrer" table and it still returns the error. This is happening on any new blog setup with 2.1.1 or later. Existing upgraded blogs are fine. Same issue on multiple hosts/servers.

    If this isn't compatible, it's a shame, but is there a comparable stats plug-in that is compatible with the latest version?

  2. MichaelH
    Member
    Posted 7 years ago #

    Any chance your DB_USER (as specified in wp-config.php) doesn't have the privilege to create tables?

  3. tomhanna
    Member
    Posted 7 years ago #

    Nope, it has all privileges. My guess is that the issue involves the change in the database structure with the switchover at the split to the 2.1 (or wherever) branch. It worked fine as recently as version 2.0.5.

  4. davidchait
    Member
    Posted 7 years ago #

    tom, if you contact me directly, I can try to take a look over the next few days. I thought I recently tested with at least 2.1.0, but admittedly have much newer code of all my plugins. ;)

    -d

  5. davidchait
    Member
    Posted 7 years ago #

    FYI, my cg-referrer is MUCH newer than what's out there (I never released the newer feature set, but could seed you a 'beta' of sorts), and I found that under MySQL 5, the create failed because the CREATE statement was missing a comma at the end of one of the row declarations.

    Check install_referer_table, look for commas at the end of every line in the create query except the last line -- the line that I had missing the comma was:
    bounceCode SMALLINT UNSIGNED DEFAULT '0'

    Don't know if that's your issue, but thought I'd toss it out there. Might just have been a bug on my end in my newer code (which has a bunch more rows!).

    -d

Topic Closed

This topic has been closed to new replies.

About this Topic