Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

clyde_d

Archived
  • Posts

    2
  • Joined

  • Last visited

Profile Information

  • Real Name
    Clyde Daisley

clyde_d's Achievements

  1. I solve this issue on my own.. yay.. seems that i havent been waisting my time learning and cramming all this stuff for the past few months now... ahhh the problems is , i think, is the way how the translation works when running this stuff on windows 2003. the sql string works great from any admin tool and even the command line but doesnt from the php page.. IIS??? php under 2003? mysql handler under 2003?? who knows but this is what i did - this is the original code $sql_data_array = array('vendors_id' => $vendors_id, 'vendors_name' => $vendors_name, 'vendors_contact' => $vendors_contact, 'vendors_phone1' => $vendors_phone1, 'vendors_phone2' => $vendors_phone2, 'vendors_email' => $vendors_email, 'vendors_send_email' => $vendors_send_email, 'vendors_status_send' => $vendors_status_send, 'vendor_street' => $vendor_street, 'vendor_add2' => $vendor_add2, 'vendor_city' => $vendor_city, 'vendor_state' => $vendor_state, 'vendors_zipcode' => $vendors_zipcode, 'vendor_country' => $vendor_country, 'account_number' => $account_number, 'vendors_url' => $vendors_url, 'vendor_add_info' => $vendor_add_info, 'handling_charge' => $handling_charge, 'handling_per_box' => $handling_per_box, 'tare_weight' => $tare_weight, 'percent_tare_weight' => $percent_tare_weight, 'max_box_weight' => $max_box_weight, 'zones' => $zones); $sql_data_array = array('vendors_name' => $vendors_name, 'vendors_contact' => $vendors_contact, 'vendors_phone1' => $vendors_phone1, 'vendors_phone2' => $vendors_phone2, 'vendors_email' => $vendors_email, 'vendors_send_email' => $vendors_send_email, 'vendors_status_send' => $vendors_status_send, 'vendor_street' => $vendor_street, 'vendor_add2' => $vendor_add2, 'vendor_city' => $vendor_city, 'vendor_state' => $vendor_state, 'vendors_zipcode' => $vendors_zipcode, 'vendor_country' => $vendor_country, 'account_number' => $account_number, 'vendors_url' => $vendors_url, 'vendor_add_info' => $vendor_add_info, 'handling_charge' => $handling_charge, 'handling_per_box' => $handling_per_box, 'tare_weight' => $tare_weight, 'percent_tare_weight' => $percent_tare_weight, 'max_box_weight' => $max_box_weight, 'zones' => $zones); this is what i changed it to... I believe it has to do with how the mysql handler for windows deals with certain sql calls based on column type in the table. Something i have had alot of experience with using ms sql ect... yes im a windows guy since vendors_id is a pri key with auto_increment.. i just deleted this part out of the sql string.. looks like this $sql_data_array = array('vendors_name' => $vendors_name, 'vendors_contact' => $vendors_contact, 'vendors_phone1' => $vendors_phone1, 'vendors_phone2' => $vendors_phone2, 'vendors_email' => $vendors_email, 'vendors_send_email' => $vendors_send_email, 'vendors_status_send' => $vendors_status_send, 'vendor_street' => $vendor_street, 'vendor_add2' => $vendor_add2, 'vendor_city' => $vendor_city, 'vendor_state' => $vendor_state, 'vendors_zipcode' => $vendors_zipcode, 'vendor_country' => $vendor_country, 'account_number' => $account_number, 'vendors_url' => $vendors_url, 'vendor_add_info' => $vendor_add_info, 'handling_charge' => $handling_charge, 'handling_per_box' => $handling_per_box, 'tare_weight' => $tare_weight, 'percent_tare_weight' => $percent_tare_weight, 'max_box_weight' => $max_box_weight, 'zones' => $zones); Works good now! Keep up the good work with this stuff. I Love it :thumbsup: :thumbsup:::thumbsup:
  2. I am in need of help I think it is something small i am missing... every thing works fine with my mvs 1.1 so far but i cannot add a new vendor through the vendor.php page 1264 - Out of range value adjusted for column 'vendors_id' at row 1 insert into vendors (vendors_id, vendors_name, vendors_contact, vendors_phone1, vendors_phone2, vendors_email, vendors_send_email, vendors_status_send, vendor_street, vendor_add2, vendor_city, vendor_state, vendors_zipcode, vendor_country, account_number, vendors_url, vendor_add_info, handling_charge, handling_per_box, tare_weight, percent_tare_weight, max_box_weight, zones) values ('', 'tesg2', 'heyu', '111111', '1111111', '', '0', '3', '11111', '', '', 'mn', '33333', '1', '', '', '', '', '', '', '', '', '') [TEP STOP] At first i thought maybe its a database issue or rights issue.. so i went to my database admin tools "sqlyog" and cut and paste the string directly into the query tool and it work. Tried a few other ways of this string and they all worked... i rememebr when i first installed this contrib, i had to rem out all the rem lines in the sql scrip and run it manually.. all tables were created and all table updates executed just fine.. I can edit vendors from the php page just fine as well.. i just cannot add a new one... please help
×
×
  • Create New...