[ ContetBox v.2.1.0.00123 ] Duplicated rows

Communities ContentBox CMS
1

Hi guys,

I uploaded from my local server to production, and some issues came up: ( attached image )
some rows which were lowercase now they are camel case and this creates duplicated rows…

There are some other issues but, some are probably related to this. Can you check that up?

Local: Coldfusion 11
Production: Railo 4.2.1.008 final
Coldbox: v.3.8.1.00076
ContentBox: v.2.1.0.00123

Thanks

rows.jpg
rows.jpg320×507 27.2 KB

2

Possibly related to a mySQL server setting and different OS?
https://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

I’ve had this bite me not being consistent with my table names in cfquerys before going from local (OSX) to prod (Ubuntu) etc…

As to the fix from a coldbox / contentbox side I couldn’t really say, but my guess is it’s related to the doc link above.

3

Yes, I have had case sensitivity issues before. Make sure they are case sensitive and reflective of the table declaration in eac.

Luis Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com
P/F: 1-888-557-8057
Direct: (909) 248-3408

ColdBox Platform: http://www.coldbox.org

ContentBox Platform: http://www.gocontentbox.org
Linked In: http://www.linkedin.com/pub/3/731/483

Social: twitter.com/ortussolutions | twitter.com/coldbox | twitter.com/lmajano | twitter.com/gocontentbox

4

I see… Thanks guys Tim and Luis :wink: