Title: Database errors
Last modified: August 20, 2016

---

# Database errors

 *  [J.D. Grimes](https://wordpress.org/support/users/jd55/)
 * (@jd55)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-errors-18/)
 * There is a database error thrown when this plugin is activated:
 *     ```
       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 16 for query CREATE TABLE ds_total_cur (
         id INT, login VARCHAR (300), first_name VARCHAR (300), last_name VARCHAR (300), minutes INT, period_one INT, computer_one INT, period_two INT, computer_two INT, period_three INT, computer_three INT, totalxp INT, totalgold INT, temp_comp INT,
           ) made by activate_plugin, do_action('activate_cube-gold/cube_gold.php'), call_user_func_array, jal_install, dbDelta
       ```
   
 * The problem is in cube-gold.php on line 130:
    `);";`
 * It should be this:
    `)";`
 * Also, the database prefix is hardcoded as `wp_` in select queries, etc. Instead
   it should be called like `$wpdb->prefix` there as well.
 * I didn’t have time to go any further, but the plugin will not work at all if 
   you are using a different table prefix.
 * [http://wordpress.org/extend/plugins/cube-gold/](http://wordpress.org/extend/plugins/cube-gold/)

The topic ‘Database errors’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/cube-gold.svg)
 * [CubeGold](https://wordpress.org/plugins/cube-gold/)
 * [Support Threads](https://wordpress.org/support/plugin/cube-gold/)
 * [Active Topics](https://wordpress.org/support/plugin/cube-gold/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/cube-gold/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/cube-gold/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [J.D. Grimes](https://wordpress.org/support/users/jd55/)
 * Last activity: [13 years, 5 months ago](https://wordpress.org/support/topic/database-errors-18/)
 * Status: not resolved