Title: Table is missing
Last modified: October 17, 2017

---

# Table is missing

 *  Resolved [thenicnic](https://wordpress.org/support/users/thenicnic/)
 * (@thenicnic)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/table-is-missing/)
 * Hello,
 * I’m very glad that there is this (apparently) very good plugin. Thank you that
   much! Unfortunately it does not work on my page, there isn’t even a created table;
   the Update feature puts out:
    _[Table ‘DB29xxx.wp\_statpress’ doesn’t exist]_
 * I tried _Remove_, _Repair _ and even reinstall the plugin (from direct download
   and from repository) but there is still no table – so the widget and the _Details_
   area are not showing any visitors 🙁
 * I’m using the _SportsPress _theme and a customzied _.htaccess_ and I thought 
   the last one is causing the trouble, but nope – the problem residents also with
   the default one.
 * Is there anybody out there who may help me?
 * Best regards,
 * Nico
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftable-is-missing%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Thread Starter [thenicnic](https://wordpress.org/support/users/thenicnic/)
 * (@thenicnic)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/table-is-missing/#post-9601983)
 * Hi,
 * problem solved. The SQL query generated in your PHP was:
 * `CREATE TABLE wp_statpress ( id mediumint(9) NOT NULL AUTO_INCREMENT, date int(
   8), time time, ip varchar(39), urlrequested varchar(250), agent varchar(250),
   referrer varchar(512), search varchar(250), nation varchar(2), os varchar(30),
   browser varchar(32), searchengine varchar(16), spider varchar(32), feed varchar(
   8), user varchar(16), timestamp timestamp DEFAULT 0, UNIQUE KEY id (id), INDEX
   spider_nation (spider, nation), INDEX ip_date (ip, date), INDEX agent (agent),
   INDEX search (search), INDEX referrer (referrer), INDEX feed_spider_os (feed,
   spider, os), INDEX os (os), INDEX date_feed_spider (date, feed, spider), INDEX
   feed_spider_browser (feed, spider, browser), INDEX browser (browser)) DEFAULT
   CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;`
 * which ended up in
 * `Query error: Index column size too large. The maximum column size is 767 bytes.`
 * That’s why I added _ROW\_FORMAT=DYNAMIC_ in the PHP code (at the end of the query):
 * `$sql_createtable.=") $charset_collate ROW_FORMAT=DYNAMIC;";`
 * Works like a charme.
 * Hint: Problem occured while using _InnoDB_ at _STRATO_ webspace (German webhoster).
 *  Plugin Author [ice00](https://wordpress.org/support/users/ice00/)
 * (@ice00)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/table-is-missing/#post-9609745)
 * hi,
 * thanks for the report.
    Actually my servers did not uses InnoDB, so the problem
   was not popped up before
 *  [mandalacreation](https://wordpress.org/support/users/mandalacreation/)
 * (@mandalacreation)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/table-is-missing/#post-10046467)
 * Bonjour, 2 jours que je cherche pourquoi Newstatpress ne fonctionne pas. Hé bien
   je ne suis pas sur, mais aprés lecture de ce post, je suis allé voir ma base 
   de donnée, et il n’y a pas de tables statpress et pourtant quand je fais mise
   à jour dans les options newstatpress, il me dit que tout va bien et que les tables
   structure statpress et index statpress et les reste sont bien cochées en vert.
   
   Sous PHP My Admin les tables sont de type InnoDB. est ce que cela vient de là?
   J’ai déja désisntaller plusieurs fois, mais rien n’y fait. toujours pas de tables
   sous Php My Admin. Je suis pas aussi doué que Thenicnic, alors j’ose pas trop
   tripoter la base de donnée. Est ce qu’il y a une autre solution? Merci pour vos
   réponses.
 * Michel
 *  [mandalacreation](https://wordpress.org/support/users/mandalacreation/)
 * (@mandalacreation)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/table-is-missing/#post-10046590)
 * Super,Thenicnic, j’ai osé le faire et ça fonctionne.
    Grand merci à toi d’avoir
   partagé la solution.

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

The topic ‘Table is missing’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/newstatpress.svg)
 * [NewStatPress](https://wordpress.org/plugins/newstatpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/newstatpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/newstatpress/)
 * [Active Topics](https://wordpress.org/support/plugin/newstatpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/newstatpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/newstatpress/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [table](https://wordpress.org/support/topic-tag/table/)

 * 4 replies
 * 3 participants
 * Last reply from: [mandalacreation](https://wordpress.org/support/users/mandalacreation/)
 * Last activity: [8 years, 2 months ago](https://wordpress.org/support/topic/table-is-missing/#post-10046590)
 * Status: resolved