Title: dlsilverman's Replies | WordPress.org

---

# dlsilverman

  [  ](https://wordpress.org/support/users/dlsilverman/)

 *   [Profile](https://wordpress.org/support/users/dlsilverman/)
 *   [Topics Started](https://wordpress.org/support/users/dlsilverman/topics/)
 *   [Replies Created](https://wordpress.org/support/users/dlsilverman/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/dlsilverman/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/dlsilverman/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/dlsilverman/engagements/)
 *   [Favorites](https://wordpress.org/support/users/dlsilverman/favorites/)

 Search replies:

## Forum Replies Created

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

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Statistics – Simple, privacy-friendly Google Analytics alternative] Database Table Missing After Installing Version 8.2](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/)
 *  Thread Starter [dlsilverman](https://wordpress.org/support/users/dlsilverman/)
 * (@dlsilverman)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/page/2/#post-5464951)
 * Thank you. My problem had to do with using the keyword “key” as a column name,
   not enclosed in back-ticks.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Statistics – Simple, privacy-friendly Google Analytics alternative] Database Table Missing After Installing Version 8.2](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/)
 *  Thread Starter [dlsilverman](https://wordpress.org/support/users/dlsilverman/)
 * (@dlsilverman)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/#post-5464896)
 * When I used the option in phpMyAdmin to dump the table structure, it created 
   an SQL statement with all of the column names enclosed in back quotes. This will
   solve the problem.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Statistics – Simple, privacy-friendly Google Analytics alternative] Database Table Missing After Installing Version 8.2](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/)
 *  Thread Starter [dlsilverman](https://wordpress.org/support/users/dlsilverman/)
 * (@dlsilverman)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/#post-5464895)
 * I think you’re right Vandman – the keyword “key” probably cant be used as a column
   name in that syntax. When I created the table manually using the graphical user
   interface in mySQL it didn’t object to using “key” as a column name, but when
   it is done in the “CREATE TABLE” command it is confusing the mySQL engine. That
   would be my guess.
 * David
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Statistics – Simple, privacy-friendly Google Analytics alternative] Database Table Missing After Installing Version 8.2](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/)
 *  Thread Starter [dlsilverman](https://wordpress.org/support/users/dlsilverman/)
 * (@dlsilverman)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/#post-5464878)
 * Greg,
 * For some reason my mySQL rejects that CREATE TABLE as well. I would guess it 
   has to do with the version of mySQL that I am running. If I have time I’ll try
   narrowing down the problem, but I am thinking it may have to do with the “NOT
   NULL” syntax.
 * I’ve created the table manually with the keys you suggested and everything seems
   to be working fine. Thanks for your attention to this !
 * David
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Statistics – Simple, privacy-friendly Google Analytics alternative] Database Table Missing After Installing Version 8.2](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/)
 *  Thread Starter [dlsilverman](https://wordpress.org/support/users/dlsilverman/)
 * (@dlsilverman)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/#post-5464763)
 * do I need an index on that table?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Statistics – Simple, privacy-friendly Google Analytics alternative] Database Table Missing After Installing Version 8.2](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/)
 *  Thread Starter [dlsilverman](https://wordpress.org/support/users/dlsilverman/)
 * (@dlsilverman)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/#post-5464759)
 * I created it through the phpMyAdmin User Interface but I couldnt figure out how
   to do the AUTOINCREMENT=48 or DEFAULT CHARSET … but the table is created now …
   is the autoincrement important ?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Statistics – Simple, privacy-friendly Google Analytics alternative] Database Table Missing After Installing Version 8.2](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/)
 *  Thread Starter [dlsilverman](https://wordpress.org/support/users/dlsilverman/)
 * (@dlsilverman)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/#post-5464748)
 * I am using mySQL Version 5.1.67
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Statistics – Simple, privacy-friendly Google Analytics alternative] Database Table Missing After Installing Version 8.2](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/)
 *  Thread Starter [dlsilverman](https://wordpress.org/support/users/dlsilverman/)
 * (@dlsilverman)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/#post-5464746)
 * I couldnt run that SQL – received the following error:
 * #1064 – 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 ‘bigint(20) NOT
   NULL, type varchar(25) NOT NULL, id bigint(20) NOT NULL, ur’ at line 2
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Statistics – Simple, privacy-friendly Google Analytics alternative] Database Table Missing After Installing Version 8.2](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/)
 *  Thread Starter [dlsilverman](https://wordpress.org/support/users/dlsilverman/)
 * (@dlsilverman)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/database-table-missing-after-installing-version-82/#post-5464745)
 * I checked with phpMyAdmin and the table does NOT exist. I think I will simply
   use the SQL to create it. Thanks for the advice !

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