vjwebb Posted February 2, 2009 Share Posted February 2, 2009 I moved my shop to a new ISP. Now when the first page loads I get the following 2 error messages: Warning: I am able to write to the configuration file: /home/vjwebb/public_html/shop/includes/configure.php. This is a potential security risk - please set the right user permissions on this file. [/size] The permission on the file is set to rw-r--r-- (644) which is the same as it was on my old ISP. What should it be set to? Also, I am getting the following message when it attempts to display the featured product and I have no idea what it means: Featured Product 1054 - Unknown column 'p.products_id' in 'on clause' select substring(pd.products_description, 1, 600) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from products p, products_description pd, star_product sp left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '1' [TEP STOP] My new ISP is running php5 and the old one was running php4 if that makes any difference. Any help would be greatly appreciated. V J -- A ship in a harbor is safe, but that is not a ships ultimate purpose. Link to comment Share on other sites More sharing options...
FIMBLE Posted February 2, 2009 Share Posted February 2, 2009 Hiya 1- set it to 444 or 400 2- click this http://www.google.co.uk/search?rlz=1C1CHMI...;on+clause' Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
vjwebb Posted February 5, 2009 Author Share Posted February 5, 2009 Hiya 1- set it to 444 or 400 2- click this http://www.google.co.uk/search?rlz=1C1CHMI...;on+clause' Nic Thank you, I found the contribution about the same time your message was posted. The changes turned out to be pretty trivial and I'm up and running again. V J -- A ship in a harbor is safe, but that is not a ships ultimate purpose. Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 "1- set it to 444 or 400" I have the same problem with the config.php file. I did change the permission to 444 and even tried 400 but without luck. Any help is welocme! Hans Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 "1- set it to 444 or 400" I have the same problem with the config.php file. I did change the permission to 444 and even tried 400 but without luck. Any help is welocme! Hans Are you on a windows server? If so you need to change it via the Web site control panel. BTW there are 2 configure files Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 No, I am on a Linux server. I have tried to change the permission but it seems not to change. Have used SmartFTP. Do you mean the config under admin/include? Now I have another proble: Can't acces the admin login or the store. Get the following message: Forbidden You don't have permission to access /store/admin on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. Apache/1.3.41 Server at yourdomain.com Port 80 Have tried to upload the backup again, but same problem. Hans Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 this is a permissions error, think back to what you done to it since it last worked. It is possibly the configure files with permisions too high. Some server can be funny things! Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 OK, I have only changed the permission on the config.php in includs and in admin/includes. But they are still set to 644 (both). Have tried to change it in cPanel X (on the server control panel) but it seems not to allow me. Get the following: Set permissions on configure.php -> 0444 [a fatal error or timeout occurred while processing this directive] Can it be a permission setting for the server? (I am allow to upload files via FTP) Thx for you help! Hans Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 what is you url? Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 www.lernestal.com/store Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 Have you got htaccess in your root folder ? its not an osc issue as the www.lernestal.com shows this error also Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 755 Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 i edited the post please read again Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 No, I have not. Should I? Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 Well something on your server is missbehaving and i dont see it being OSC as its in its own folder and the main domain is not working UNLESS there is something in the /store .htacces file stopping it Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 I looked in the .htaccess and all the rows in the code starts with a hash "#". I assume this is not correct, right? Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 Yes they should have a hash at the begining, EXCEPT the ones you are using Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 Do I have more than one (files)? All lines in the one I have looked in have # in front of them. Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 one way to make sure its not osc is to download the store folder to your desktop. delete it from the server see if the error is still there. Make sure it has all downloaded properly first though. If still an error then you need to get in touch with your hosts Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 OK, I will try that. Just one more question before I do. Can you check the code in the .htaccess for me to see if it's something wrong there? Is this a file that is generated by the server or by osc? CODE: # $Id: .htaccess 1739 2007-12-20 00:52:16Z hpdl $ # # This is used with Apache WebServers # # For this to work, you must include the parameter 'Options' to # the AllowOverride configuration # # Example: # # <Directory "/usr/local/apache/htdocs"> # AllowOverride Options # </Directory> # # 'All' with also work. (This configuration is in the # apache/conf/httpd.conf file) # The following makes adjustments to the SSL protocol for Internet # Explorer browsers #<IfModule mod_setenvif.c> # <IfDefine SSL> # SetEnvIf User-Agent ".*MSIE.*" \ # nokeepalive ssl-unclean-shutdown \ # downgrade-1.0 force-response-1.0 # </IfDefine> #</IfModule> # If Search Engine Friendly URLs do not work, try enabling the # following Apache configuration parameter # AcceptPathInfo On # Fix certain PHP values # (commented out by default to prevent errors occuring on certain # servers) # php_value session.use_trans_sid 0 # php_value register_globals 1 Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 OK, I will try that. Just one more question before I do. Can you check the code in the .htaccess for me to see if it's something wrong there? Is this a file that is generated by the server or by osc? CODE: # $Id: .htaccess 1739 2007-12-20 00:52:16Z hpdl $ # # This is used with Apache WebServers # # For this to work, you must include the parameter 'Options' to # the AllowOverride configuration # # Example: # # <Directory "/usr/local/apache/htdocs"> # AllowOverride Options # </Directory> # # 'All' with also work. (This configuration is in the # apache/conf/httpd.conf file) # The following makes adjustments to the SSL protocol for Internet # Explorer browsers #<IfModule mod_setenvif.c> # <IfDefine SSL> # SetEnvIf User-Agent ".*MSIE.*" \ # nokeepalive ssl-unclean-shutdown \ # downgrade-1.0 force-response-1.0 # </IfDefine> #</IfModule> # If Search Engine Friendly URLs do not work, try enabling the # following Apache configuration parameter # AcceptPathInfo On # Fix certain PHP values # (commented out by default to prevent errors occuring on certain # servers) # php_value session.use_trans_sid 0 # php_value register_globals 1 It come with OSC they are options that some users may need to use, thats why they are all initially commented out as they WILL cause errors if un commented Please make sure that ALL the folder has downloaded properly if not you will have problems Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 Hi, would you suggest to do a totally new installation of osc after delete and then upload the files or just delete the folder and files and upload the copy? Thanks for you patience and help! Hans Link to comment Share on other sites More sharing options...
FIMBLE Posted February 6, 2009 Share Posted February 6, 2009 Not if its not the problem Hans, you will still have the same problem. Just see if this is the problem, i suspect not but your host will, in all expectation just say the it IS osc causing the problem, then at least you can say what you have done Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
hanler Posted February 6, 2009 Share Posted February 6, 2009 Hi, just finished the new upload. Still the same problem. Can't change the permission on the files and can't access the site. Can only access via ftp. I have sent a question to my host. let's see what they say. Hans Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.