Database error

  • Resolved darkban

    (@darkban)


    10 years, 4 months ago

    Hi Paul,

    Your plugin is really great and it works better than the ones I’ve checked (and there are a few).

    I have an error that persists and I don’t really know what it’s about. it says:

    WordPress database error: [Unknown column ‘uid’ in ‘where clause’]
    SELECT * FROM wp_achievements WHERE uid = 1 AND points != ” AND points != 0 ORDER BY id DESC LIMIT 5

    Do you know what is it about? how can i fix it?

    Many thanks in advance,
    Lior

    http://wordpress.org/plugins/achievements/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Paul Wong-Gibbs

    (@djpaul)

    10 years, 4 months ago

    Hi

    No versions of my Achievements plugin has a database table called “wp_achievements” with a column, “uid”. The old 2.x versions had a table like that, but no column with that name.

    Can you confirm which plugin you’re using, and which version of that plugin you have? Thank you.

    Thread Starter darkban

    (@darkban)

    10 years, 4 months ago

    When I first built the website I had one of the older versions of the plugin installed (probably 2.X), before I stopped using it and tried to experiment with other gamification plugins.

    The version I’ve got now is 6.10 (I’ve purchased the pro version).

    Thanks
    Lior

    Plugin Author Paul Wong-Gibbs

    (@djpaul)

    10 years, 4 months ago

    I don’t have a version 6.10 of my Achievements plugin, and I don’t sell any pro version; you must be getting the plugins mixed up. You need to go back to where you bought the plugin, and find the proper support route/forums.

    Good luck — and remember, if you ever want to try out another achievement/gamification plugin… 🙂

    @ mods: can this topic be locked, please? It’s referring to some other plugin.

    Thread Starter darkban

    (@darkban)

    10 years, 4 months ago

    sorry for the misunderstanding. my bad…

    WPyogi

    (@wpyogi)

    10 years, 4 months ago

    Sure thing, Paul :).

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