Guest Posted September 7, 2005 Share Posted September 7, 2005 Hi, Ive just been trying to transfer my Localhost DB to my online shop, but im having issues with Cubecart or the server being case sensitive for table names etc. Is their a way around this other than going through and checking all of the table data? On my windows box when I installed the orig. CC3 the tables they have no capitol letters. Anyideas? Cheers! Quote Link to comment Share on other sites More sharing options...
Guest Posted September 7, 2005 Share Posted September 7, 2005 Welcome to the stupidity of Microsoft-based software. Only MS would think that "a" = "A". You'll have to either fix the case manually on your Unix/Linux box or start over. Quote Link to comment Share on other sites More sharing options...
Guest Posted September 7, 2005 Share Posted September 7, 2005 Welcome to the stupidity of Microsoft-based software. Only MS would think that "a" = "A". You'll have to either fix the case manually on your Unix/Linux box or start over. Thanks I tried it again on my own localhost and decided that it was the problem so ive been going through it adjusting the tables Cheers! Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted September 8, 2005 Share Posted September 8, 2005 I had the exact same problem today! I just renamed the mySQL files on my windows machine. But i couldn't rename the tables through phpMySQL, so i did it manually. I renamed all the ".frm" files in mysql/data/DBNAME, and this seems to have worked fine. Estelle. Quote Link to comment Share on other sites More sharing options...
Guest rickyvee Posted January 5, 2006 Share Posted January 5, 2006 i just went through this, doing a global search/replace on the sql export/import query file. it worked for cubecart > CubeCart but there was more i only saw from execution errors. so that i don't have to create a dummy shop on my production server just to find out the Unix up/low case names of the tables, and priort to cubecart (CubeCart) making case-transparent code, please send me a list, if you would of the table names under Unix so that I can make the appropriate changes. Thanks, Rich :sourcerer: Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted January 5, 2006 Share Posted January 5, 2006 There's also: CubeCart_Modules and CubeCart_Downloads Quote Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2006 Share Posted January 5, 2006 I cheat to run it on my PC here.... I setup another DB on my server then access it remotely from my PC here. I never have to worry about it. The connection is not quite as fast as having everything in one place, but it's handy for testing without having to deal with upload a file, change directories, upload another file, change directories, upload another file. Then test....crap. Make an adjustment and start the uploading dance again. :sourcerer: Quote Link to comment Share on other sites More sharing options...
Guest rickyvee Posted January 5, 2006 Share Posted January 5, 2006 I cheat to run it on my PC here.... I setup another DB on my server then access it remotely from my PC here. I never have to worry about it. The connection is not quite as fast as having everything in one place, but it's handy for testing without having to deal with upload a file, change directories, upload another file, change directories, upload another file. Then test....crap. Make an adjustment and start the uploading dance again. i'm dial-up and do a lot of fiddling before uploading to production, so i need to understand and resolve it. changing cubecart CubeCart handled most, then as estelle said, above, i had to change those others. so CC is close to being case-insensitive about this, i hope they go the rest of the way. There's also: CubeCart_Modules and CubeCart_Downloads thanks! i got those by seeing it fail, after fixing cubecart_ to CubeCart in the sql export/import. i just wanted to make sure no other landmines are waiting on the unix side. Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted January 6, 2006 Share Posted January 6, 2006 thanks! i got those by seeing it fail, after fixing cubecart_ to CubeCart in the sql export/import. i just wanted to make sure no other landmines are waiting on the unix side. Thats all there is. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.