http://wordpress.org/support/ WordPress › Support Topic: [Plugin: Wordpress Download Monitor] DB Table Names Caps vs Lower Case? en Thu, 26 Nov 2009 15:16:07 +0000 http://wordpress.org/support/topic/280933#post-1107291 Wed, 17 Jun 2009 16:51:21 +0000 jolley_small 1107291@http://wordpress.org/support/ <p>They are supposed to be in caps like you listed - I really should make them lower case so this type of problem does not occur but making that compatible with everyones existing databases is going to be a royal pain in the ass. Sorry for the inconvenience. </p> http://wordpress.org/support/topic/280933#post-1106481 Tue, 16 Jun 2009 23:27:43 +0000 orbalon 1106481@http://wordpress.org/support/ <p>I have been working on a site locally within an XAMPP Setup on my windows box. When installing your plugin it created tables that were all lower case, like this: "wp_dlm_cats".</p> <p>But, when I moved the site over to my LAMP box on a live domain, somehow the plugin created new tables which looked like this:</p> <p>wp_DLM_CATS<br /> wp_DLM_DOWNLOADS<br /> wp_DLM_FORMATS<br /> wp_DLM_LOG<br /> wp_DLM_META<br /> wp_DLM_STATS</p> <p>Since they were all empty (my data was in the lower case versions) none of my downloads displayed.</p> <p>So, did a dump of just the lower case version with all the data. Changed the create lines to be upper case, cleared my live site of all dlm/DLM tables and imported the ones (with upper case in the table names) into my site. Now everything works.</p> <p>My question is, why is this going on. I assume its a bug? Maybe an incompatibility with 2.8 (I just upgraded). I cant see a reason for this. If it is download monitor, its probably an easy fix? If you point me to the line where its happening I could probably figure it out.</p> <p>Nice work with the plugin in general. </p>