jeemer Posted January 31, 2007 Share Posted January 31, 2007 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. Link to comment Share on other sites More sharing options...
jeemer Posted February 7, 2007 Author Share Posted February 7, 2007 Any ideas anyone? :/ My main worries are the blank pages around the register/login and the adding a column/altering a table.. please help! Link to comment Share on other sites More sharing options...
jonquil Posted February 7, 2007 Share Posted February 7, 2007 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 It's all just ones and zeros.... Link to comment Share on other sites More sharing options...
jeemer Posted February 7, 2007 Author Share Posted February 7, 2007 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.. Link to comment Share on other sites More sharing options...
jeemer Posted February 8, 2007 Author Share Posted February 8, 2007 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 :/ Link to comment Share on other sites More sharing options...
jonquil Posted February 8, 2007 Share Posted February 8, 2007 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 It's all just ones and zeros.... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.