DBradley Posted June 2, 2003 Posted June 2, 2003 I have recently installed oscommerce and so far it has given me nothing but trouble. When i try to create a new user it says header has already been changed, when I go into admin it shows the menus twice. but it is the fact that any email related activity causes it to crash any thought, thanks :?
DBradley Posted June 2, 2003 Author Posted June 2, 2003 oh yea the url is www.irisharmysurplus.com/catalog/ Thanks again
Daemonj Posted June 2, 2003 Posted June 2, 2003 Is this a fresh installation or have you added contributions or made modifications? If it is a fresh installation and you are getting errors, then you definitely have a problem. I would suggest re-downloading the file and reinstalling it. You should not need to reinstall the database as that is already setup and should not give you any troubles. In regards to your eMail problem, what do you mean by "crash". Does the server go down, an error message appear, what? "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
DBradley Posted June 2, 2003 Author Posted June 2, 2003 It is installed automatically by the ISP, it is a new instalation. Normally I get an error message saying the header has already been changed. The menus are still in double it says for instance: Send Emails Send Emails When I try to finisale an order I get this error: 1054 - Unknown column 'comments' in 'field list' insert into orders (customers_id, customers_name, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, comments, currency, currency_value) values ('4', 'sedrt wewrer', 'adsdadasd', '', 'asdasdasd', 'asdasdas', 'Baden-W?rttemberg', 'Germany', '0000000000', '[email protected]', '5', 'sedrt wewrer', 'adsdadasd', '', 'asdasdasd', 'asdasdas', 'Baden-W?rttemberg', 'Germany', '5', 'Cash on Delivery', '', '', '', '', now(), '1', '', 'USD', '1.00000000') [TEP STOP] Thanks For your help
DBradley Posted June 2, 2003 Author Posted June 2, 2003 I am running win Xp pro on my home computer, when i try to view php with the local intrenet, i just get lines of code. how do i run it so that the code is excuted. Thanks again David
Daemonj Posted June 2, 2003 Posted June 2, 2003 If you have the ability, I would suggest deleting what the ISP has installed and install it yourself. In regards to your local system, are you using Apache or IIS as your webserver? "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
DBradley Posted June 2, 2003 Author Posted June 2, 2003 IIS But shouldnt what the ISP installed already be configured to work on the system?
prosto Posted June 2, 2003 Posted June 2, 2003 try this: open checkout_process.php and look for this 'date_purchased' => 'now()', the next line should be something with "comments" - comment it out. Hope this helps
Rotation Posted June 3, 2003 Posted June 3, 2003 you might want to check the settings of your oscommerse.sql Table [orders] in the order_comment field which should be (pleae check I'm a newbie) comment, text,null. and is a primary key and unique index. again check elsewhere before persuing this and talk to your isp before messing around with you database. There can?t be anything wrong with hedonism if everyone?s happy... can there? :wink:
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.