CwisWard Posted August 2, 2006 Share Posted August 2, 2006 I'm pretty much brand new to OsCommerce, but I am however a semi-experienced web developer. And at first gland OsCommerce, looked like a solid e-commerce store solution. However, after setting it up I'm a little more skeptical. I'm sorta hoping to hear it's because my dumb a$$ only has a windows box available to run this on right now. I installed OsCommerce on a windows server running IIS, installed the lastest version of PHP, already had MySql ODBC drivers installed. Setup OsCommerce to connect to my local MySQL server. Everything seems to be up and running properly. But now the downfall, I feel as though OsCommerce is plauged with errors that could be prevented with a little validation. And I dont mean to bash OsCommerce (as I'm sure most people here are enthusiasts) because most of these have been in the admin section, which is ok, because my customers would never see these errors. But now I've found ones the customer would encounter. Ex: When creating a new customer acct, if I put a postal code that is too long (first time I just figured city was gonna be next field and didn't read) I get the error message "1406 - Data too long for column 'entry_postcode' at row 1" Shouldn't something like that be validated. Also, this works just fine in the demo's DB different? Does this have anything to do with me running on windows? As a software developer myself I have a great deal of respect for the people who put their time into anything open source. So for this I say thanks, and I hope this didn't come off too rude. Link to comment Share on other sites More sharing options...
Guest Posted August 2, 2006 Share Posted August 2, 2006 It seems to me to be an error in your DB. Check your "address book" table and see that the postal code is set to "varchar(10) so that it will take 10 characters. Also in your admin under Configuration -> Minimum Values you can set the minumum length for the postal code. Osc runs much easier on Linux IMO, a lot less headaches from what I hear. Maybe set up something like easyphp on your computer and try it with that. HTH Link to comment Share on other sites More sharing options...
CwisWard Posted August 2, 2006 Author Share Posted August 2, 2006 It seems to me to be an error in your DB. Check your "address book" table and see that the postal code is set to "varchar(10) so that it will take 10 characters. Also in your admin under Configuration -> Minimum Values you can set the minumum length for the postal code. Osc runs much easier on Linux IMO, a lot less headaches from what I hear. Maybe set up something like easyphp on your computer and try it with that. HTH My point is shouldn't I not have to change any settings like that on a fresh install? Link to comment Share on other sites More sharing options...
raceonusa.com Posted May 4, 2007 Share Posted May 4, 2007 My point is shouldn't I not have to change any settings like that on a fresh install? Yep I get the same error.. No time to troubleshoot.. Off to zencart for now.. But I will return to OSC! I'm running IIS7 btw Link to comment Share on other sites More sharing options...
clint317 Posted June 17, 2007 Share Posted June 17, 2007 Yep I get the same error.. No time to troubleshoot.. Off to zencart for now.. But I will return to OSC! I'm running IIS7 btw I'll try Zen Cart, thanks for the info bro. I hope Zen Cart works for me better than OSCommerce. I like OSCommerce on Linux but not Windows. OSCommerce just doesn't work with PHP5 or Windows. These guys need to get their stuff together and get a version or update out that works with PHP5 at least. I'm switching to Zen Cart - if it works. Looks the same anyways. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.