My osCommerce is working.. to an extent! A few more noobish questions..

[jeemer]

I'm currently working on an osCommerce site on a windows server.

 

I used a recommended contribution to turn off prices for users who haven't logged in, it's working! I've also set up paypal - wow, I didn't expect it to be that easy!

 

I've come across a couple of stumbling blocks however..

 

1. Ok, as for turning off prices for non-logged-in users. I set this up, went to the page ( http://www.additionzltd.com/catalog/index.php ) and it says 'log in to view prices'

 

So I signed up for an account, entered all my details and hit enter. At this point I was directed to a blank page. I then went back to the main page and used my email/password to log in, and it directed me to another blank page. However, when I went back to the homepage it had recognised that I'd registered and logged in and was now showing prices! Any idea why it is directing me to a blank page directly after registration/login? How can I get around this?

 

2. I wanted it set up so that accounts had to be activated by the administrator before they could be used. I was directed to the following contribution; ( http://www.oscommerce.com/community/contri...user+activation )

 

This seems to be lots more cut/paste jobs, which is fine, but at the start it says;

 

"create new column in table Customers.

ALTER TABLE customers ADD customers_status int(1) NOT NULL default '0';"

 

How would I go about doing this? I'm really new to mysql/php.

 

3. The last thing is that I want to set a minimum order of £75 for standard shipping, so that anyone spending under £75 on the site will be charged a much higher shipping fee, in order to discourage this (it's a wholesale website)

 

I was directed to the following contribution;

 

http://www.oscommerce.com/community/contri...rch,orders+over

 

This, however, is all geared towards ups/usps... Will this have any effect on me, or can I somehow adapt it to do what I need it to do? I'm based in the UK, you see!

 

Thanks for any help or suggestions anyone can offer.

[jeemer]

Any ideas anyone? :/

 

My main worries are the blank pages around the register/login and the adding a column/altering a table.. please help!

[jonquil]

2. I wanted it set up so that accounts had to be activated by the administrator before they could be used. I was directed to the following contribution; ( http://www.oscommerce.com/community/contri...user+activation )

 

This seems to be lots more cut/paste jobs, which is fine, but at the start it says;

 

"create new column in table Customers.

ALTER TABLE customers ADD customers_status int(1) NOT NULL default '0';"

 

How would I go about doing this? I'm really new to mysql/php.

 

1. Log in to your phpMyAdmin. The bold bit is a query you need to run.

 

2. From the data base list, choose oscommerce.

 

3. Click the SQL tab.

 

4. Paste the exact query above into the text box under "Run SQL query/queries on database oscommerce:"

 

5. Go. :)

 

jon

[jeemer]

1. Log in to your phpMyAdmin. The bold bit is a query you need to run.

 

2. From the data base list, choose oscommerce.

 

3. Click the SQL tab.

 

4. Paste the exact query above into the text box under "Run SQL query/queries on database oscommerce:"

 

5. Go. :)

 

jon

 

ack.. I don't have phpmyadmin installed :/ I'll try to install it just now..

[jeemer]

ack.. I don't have phpmyadmin installed :/ I'll try to install it just now..

 

I couldn't seem to get phpmyadmin installed :/ Is there any other way around that?

 

My main concern right now is the blank page on registering/login - has anyone experienced that before?

 

Additionally I'm getting the " Warning: I am able to write to the configuration file: catalog/includes/configure.php. This is a potential security risk - please set the right user permissions on this file." - I've seen that a lot of people get that and it's best not to fix it till the end, but I tried to fix it temporarily by changing the write permissions on the file, and they just keep changing back. I even tried downloading it, setting it to read only, uploading it, and changing the write permissions. I still get the message though :/

[jonquil]

You might contact your host and see if phpmyadmin is already installed. Set permissions on your

includes/configure.php and

admin/includes/configure.php

 

to 644.

 

http://www.oscommerce.info/docs/english/e_..._procedure.html

 

Good reading :)

 

jon