Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HELP ME PLEASE


DBradley

Recommended Posts

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 :?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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:

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...