Guest Posted January 23, 2007 Share Posted January 23, 2007 Hi- I am experiencing an error when trying to activate logging. The error I'm getting is this: Warning: error_log(STORE_PAGE_PARSE_TIME_LOG): failed to open stream: Permission denied in /home3/mysite/mysite-www/mystore/includes/application_bottom.php on line 20. I get this when setting "store database parse times" = true. When I try to set "Store Database Queries" = true, all hell breaks loose with this error repeated ad nauseum. Warning: error_log(STORE_PAGE_PARSE_TIME_LOG): failed to open stream: Permission denied in /home3/mysite/mysite-www/mystore/admin/includes/classes/logger.php on line 49 I have the multi-site contrib installed which does have some changes in the admin area so I can't elimanate this as the problem but it seems obvious that the problem is a permissions issue. It seems like it would be simple to resolve but I'm hitting a brick wall. My index.php page is extremely slow in loading and I'm trying to find out why (approx. 30 seconds to load). Thanks in advance Link to comment Share on other sites More sharing options...
davidinottawa Posted January 23, 2007 Share Posted January 23, 2007 Warning: error_log(STORE_PAGE_PARSE_TIME_LOG): failed to open stream: Permission denied in /home3/mysite/mysite-www/mystore/includes/application_bottom.php on line 20. Warning: error_log(STORE_PAGE_PARSE_TIME_LOG): failed to open stream: Permission denied in /home3/mysite/mysite-www/mystore/admin/includes/classes/logger.php on line 49 Your error is becuase you do not have the permissions to write to the *log* file and/or the directory. What path and filename have you told the log file to go ? Should be something like /home/username/public_html/log/file/log.file Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2007 Share Posted January 23, 2007 Your error is becuase you do not have the permissions to write to the *log* file and/or the directory. What path and filename have you told the log file to go ? Should be something like /home/username/public_html/log/file/log.file I can hunt around and pretend like I know where this path is defined or I can admit my ignorance and just ask where it is defined ;). Can you please point me in the right direction? Link to comment Share on other sites More sharing options...
satish Posted January 23, 2007 Share Posted January 23, 2007 I can hunt around and pretend like I know where this path is defined or I can admit my ignorance and just ask where it is defined ;). Can you please point me in the right direction? check a value equivalent to this in the configuation table. INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Log Destination', 'STORE_PAGE_PARSE_TIME_LOG', '/var/log/www/tep/page_parse_time.log', 'Directory and filename of the page parse time log', '10', '2', now()); If not found(should not be in your case) then run this query thru phpMyAdmin so as to populate data base. Regards, Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
davidinottawa Posted January 23, 2007 Share Posted January 23, 2007 I can hunt around and pretend like I know where this path is defined or I can admit my ignorance and just ask where it is defined ;). Can you please point me in the right direction? David - It is actaully a value set in the configuration_key column of your configuration table within your database. Like this : configuration_title configuration_key Ascending configuration_value Log Destination STORE_PAGE_PARSE_TIME_LOG /var/log/www/tep/page_parse_time.log This can be set in your admin/config section : /admin/configuration.php?selected_box=configuration Your Log Destination PATH needs to be to somewhere you have the rights to write to. d Link to comment Share on other sites More sharing options...
davidinottawa Posted January 23, 2007 Share Posted January 23, 2007 check a value equivalent to this in the configuation table.INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Log Destination', 'STORE_PAGE_PARSE_TIME_LOG', '/var/log/www/tep/page_parse_time.log', 'Directory and filename of the page parse time log', '10', '2', now()); If not found(should not be in your case) then run this query thru phpMyAdmin so as to populate data base. Regards, Satish Hm. Not a good idea really. better to do a select : select configuration_value from configuration where configuration_key = 'STORE_PAGE_PARSE_TIME_LOG' then if nothing returned, update : update configuration set configuration_value = '/path/to/directory' where configuration_key = 'STORE_PAGE_PARSE_TIME_LOG' david Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2007 Share Posted January 23, 2007 Thank you! I think I see where the slow down is occuring. There are an incredible amount of queries involving taxes when loading the index page. Either of you happen to know anything I can do to alleviate this to some degree? Thanks in advance Link to comment Share on other sites More sharing options...
davidinottawa Posted January 23, 2007 Share Posted January 23, 2007 Thank you! I think I see where the slow down is occuring. There are an incredible amount of queries involving taxes when loading the index page. Either of you happen to know anything I can do to alleviate this to some degree? Thanks in advance don't worry about that. log files _are_ massive. and basic selects to the db are what php and db's are designed to do. you never mentioned anything about it being slow - you said you wanted to fix the log file error. d Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2007 Share Posted January 23, 2007 don't worry about that. log files _are_ massive. and basic selects to the db are what php and db's are designed to do. you never mentioned anything about it being slow - you said you wanted to fix the log file error. d Well, I mentioned it in my first post but it was at the very end. It only seems to be my index.php that is sloooooow. It takes around 25 to 30 seconds for it to load. The rest of the store runs very well. I've tried playing with the GZIP compression, disabling the banners, etc. but nothing seems to phase it. And yes, the log file is massive. Link to comment Share on other sites More sharing options...
davidinottawa Posted January 23, 2007 Share Posted January 23, 2007 Well, I mentioned it in my first post but it was at the very end. It only seems to be my index.php that is sloooooow. It takes around 25 to 30 seconds for it to load. The rest of the store runs very well. I've tried playing with the GZIP compression, disabling the banners, etc. but nothing seems to phase it. And yes, the log file is massive. how about a url ? Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2007 Share Posted January 23, 2007 how about a url ? sure... http://www.teachersorchard.com/classroomstore Link to comment Share on other sites More sharing options...
davidinottawa Posted January 23, 2007 Share Posted January 23, 2007 sure... http://www.teachersorchard.com/classroomstore crap. you're not kdding. what mods have you installed ? run it through here as a start : http://www.websiteoptimization.com/services/analyze/ Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2007 Share Posted January 23, 2007 crap. you're not kdding.what mods have you installed ? run it through here as a start : http://www.websiteoptimization.com/services/analyze/ Thanks for the link! Here is what has happened. When I first created this store, it was my first with osCommerce. Naturally, I ended installing more contribs than I really needed. The stores started running very slow. I am running two stores on the same site so I was using a contrib called mini-stores which worked great. When installing the new stores (one of which I linked to), I used a different contrib, multi-stores. However, not wanting to lose all the data (products, categories, customers, etc.), I am currently using the same database with all of the previously installed contributions. Just before I typed this, I started to link to a clean DB to check the speed. I'll let you know what I find. Link to comment Share on other sites More sharing options...
davidinottawa Posted January 23, 2007 Share Posted January 23, 2007 Thanks for the link! Here is what has happened. When I first created this store, it was my first with osCommerce. Naturally, I ended installing more contribs than I really needed. The stores started running very slow. I am running two stores on the same site so I was using a contrib called mini-stores which worked great. When installing the new stores (one of which I linked to), I used a different contrib, multi-stores. However, not wanting to lose all the data (products, categories, customers, etc.), I am currently using the same database with all of the previously installed contributions. Just before I typed this, I started to link to a clean DB to check the speed. I'll let you know what I find. Well - you need to do something for sure. I can't see anyone hanging around long enough to view your page. People will bail out before it loads. Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2007 Share Posted January 23, 2007 Well - you need to do something for sure.I can't see anyone hanging around long enough to view your page. People will bail out before it loads. Agreed. I linked to a clean db and it does appear to be a database problem. Now the fun of importing customers and products. Ugh. Well, if nothing else, this helped me talk my way through it! :) thanks Link to comment Share on other sites More sharing options...
davidinottawa Posted January 23, 2007 Share Posted January 23, 2007 Agreed. I linked to a clean db and it does appear to be a database problem. Now the fun of importing customers and products. Ugh. Well, if nothing else, this helped me talk my way through it! :)thanks well - it must be trying to query data or table or columns that no longer exists. moving your customers and products should not be too strenuous. Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2007 Share Posted January 25, 2007 well - it must be trying to query data or table or columns that no longer exists. moving your customers and products should not be too strenuous. Just thought I'd share the problem I found. The culprit? The New Products infobox called in index.php. The reason it was fast on a clean database is easy...there were no new products. When I moved all the data over, it immediately slowed again. I commented out the line and it flies now. I installed the featured products contribution and had the exact same issue. I guess it has to do with the web server the site is on. I didn't really need the new products box so I didn't go into depth on figuring out what the heck was going on. I would be interested in hearing if anyone else has found this to be an issue. I would think it may be due to using the multi-store contrib but I had the exact same problem with the mini-store contrib. Anyway, problem solved. Link to comment Share on other sites More sharing options...
davidinottawa Posted January 25, 2007 Share Posted January 25, 2007 Just thought I'd share the problem I found. The culprit? The New Products infobox called in index.php. The reason it was fast on a clean database is easy...there were no new products. When I moved all the data over, it immediately slowed again. I commented out the line and it flies now. I installed the featured products contribution and had the exact same issue. I guess it has to do with the web server the site is on. I didn't really need the new products box so I didn't go into depth on figuring out what the heck was going on. I would be interested in hearing if anyone else has found this to be an issue. I would think it may be due to using the multi-store contrib but I had the exact same problem with the mini-store contrib. Anyway, problem solved. David - are you refering to this line : <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> which calls : /includes/modules/new_products.php ?? I'm asking to see which select you refering to. This one : $new_products_query in /include/modules/new_products.php or this one : $listing_sql hard-coded in /index.php ?? thanks - david Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2007 Share Posted January 25, 2007 David - are you refering to this line : <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> which calls : /includes/modules/new_products.php ?? I'm asking to see which select you refering to. This one : $new_products_query in /include/modules/new_products.php or this one : $listing_sql hard-coded in /index.php ?? thanks - david This one... <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> 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.