CG-Referrer won’t create table in WP2.1.3

  • 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?

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

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

    Thread Starter tomhanna

    (@tomhanna)

    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.

    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

    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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘CG-Referrer won’t create table in WP2.1.3’ is closed to new replies.