osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Defaults not set on fresh install Windows...

This is a discussion on Defaults not set on fresh install Windows... within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; Should the script that generates the oscMax db be updated on windows side to include the defaults for customer_payment_allowed, and ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Installation issues

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 02-27-2008, 05:03 AM
rkah's Avatar
New Member
 
Join Date: Feb 2008
Location: Midwest
Posts: 21
Thanks: 2
Thanked 2 Times in 2 Posts
Rep Power: 0
rkah is on a distinguished road
Default Defaults not set on fresh install Windows...

Should the script that generates the oscMax db be updated on windows side to include the defaults for customer_payment_allowed, and customer_shipping_allowed. (set default values for those fields in the oscmax db create sql script). Im not totally familiar with the insides of this store yet, so Im wondering how that information should come over. I would think that as a customer creating their own account, they would be retail, and that value should cascade down from the group. But this is not happening. Im just thinking of others who try to set this up (atleast from a windows perspective, cause maybe there are differences in the code base). I had a heck of a time getting to the conclusion and for those who are not at all database savvy they would never find the answers I did.


The gender is also not included on the main account creation page, so should the value for gender be set to true initially in the admin page under customer details? Because it is set to a be a required field in the customer table.

One last question before I go. How do I set the store to default to use authorize.net? I know how to set it in the db, but is there not a place in the admin tool for this?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Advertisement
  #2  
Old 02-29-2008, 03:47 PM
gordnm's Avatar
Lurker
 
Join Date: Feb 2008
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 0
gordnm is on a distinguished road
Lightbulb Re: Defaults not set on fresh install Windows...

Just thought this might help you.
This excerpt was from MySql's website (http://dev.mysql.com/doc/refman/5.0/ ).

As of MySQL 5.0.2, if a column definition includes no explicit DEFAULT value, MySQL determines the default value as follows:
If the column can take NULL as a value, the column is defined with an explicit DEFAULT NULL clause. This is the same as before 5.0.2.
If the column cannot take NULL as the value, MySQL defines the column with no explicit DEFAULT clause. For data entry, if an INSERT or REPLACE statement includes no value for the column, MySQL handles the column according to the SQL mode in effect at the time:
  • If strict SQL mode is not enabled, MySQL sets the column to the implicit default value for the column data type.
  • If strict mode is enabled, an error occurs for transactional tables and the statement is rolled back. For non-transactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, the preceding rows will have been inserted.
So turn off strickt SQL mode.

Hope this helps.

gordnm
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to gordnm For This Useful Post:
rkah (03-01-2008)
Sponsored Links
Advertisement
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Fresh install and all over the place Celtic Tuning osCMax v2 Installation issues 5 06-04-2007 10:38 AM
htmlspecialchars() -error in fresh install mazhar osCMax v2 Installation issues 10 08-13-2006 08:27 AM
Fresh install... trench osCMax v2 Installation issues 2 07-31-2005 09:18 PM
Fresh Install..... ProjectShadow osCMax v1.7 Installation 8 10-18-2004 02:54 AM
Fresh install error Anonymous osCMax v1.7 Installation 2 02-10-2004 06:38 AM


All times are GMT -8. The time now is 11:34 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax