pasopaso Posted December 14, 2009 Share Posted December 14, 2009 Hi All, Seeking for a solution since some time now, related to Reviews. > Reviews problem Reviews never worked, unactivated first (removed line from column_right.php) as I did not want the functionnality initially. And then when I wanted to activate, could not do it by just regenerating original code in column_rigt. After spending a lot of time and since a few months that I am thinking / trying to solving it, my zero php skills do not allow me for any thing to solve this. Currently: -You can start writing a review, but then after checking rating button, next button "Continue" is uneffective: Reviews seem not to be submitted, and you get into a reviews.php page that says "There are currently no product reviews." (Tried with an existing test account, from an ordered product). Code in product_reviews_write.php, is uneffective although it seems ok, idem to original file. Line 125. Tried altering or modifying this intuitively (different action, or return different form/section) 'action=process&products_id=' 'onSubmit="return checkForm() Not effective. - When hover the button "Continue" no link appear. - Reviews are not even recorded in the database, nor they appear in the Admin, nor do you see a record under MySql Admin directly in the hosting 1and1. NOTE: Had a similiar issue wit "Add-to-cart" function, Buttons "Add to cart" were inactive from the sections "New Products" and "Specials". You could only buy and add product to cart by clicking on a "Buy" button from the Product Listing table (once you have clicked on a category). After revising the code in product_info.php, I finally just replaced line 49 in shopping product_info with a a modified line 49, with action is: buy_now, instead of 'action=add_product', which is not an elegant solution but in functionnal terms it looks like it is working. Could not find a way to progress similarly with reviews. Checking the OSC support forum, could not find an exactly related case and a fix, excepted some tracks: - Tried modifying configure.php in particular SSL set-up, after many modifs and trys, uneffective strategy, - Tried different sessions config, false / true, inc session ID, not working, - Checked that sessions are recorded in mysql, it is the case. - Removed tmp/ directory in the admin in case sessions were not going out of the DB. Uneffectice, reinstalled tmp/ dir. - Tried to find a different "action" like "record_review" if there was info related, or to alter "onSubmit="return checkForm()" line 125 from products_review_write; if existing in declared variables or related info somewhere... But did not find anything making sense to try, by google search or forums. - Some forum reponses mention cause may be due to SEO contributions, indeed I have installed 2 SEO contributions: Header Tags SEO: updated "Novice SEO Header tag v3" to "seo header tags version 5.00". which does Prouct Tags and also Catgeory tags. - In resulting pages html code compared with other websites where this functionnality works, it may be related to "&s" added in the line 125 that codes submitt review, process=review, like "process&products_id". Working reveis 1 "&" appears, mine version not working you see 2 of them?¿. It may mean that php does not generate the "right" correct html code? or browser compatibility issue? In such a case is there a fix to the existing SEO files and modifs, "in situ", or shall I remove everything related to this SEO contrib and retest, re-start from scratch? My contributions: - SEO header tags version 5.00 - French - FCKeditor - Center shop 5 - Cyberpack (payment) - Ultimate HTLM mail - ZonesWordl shipping. Site affected: ibericdelice.com In case it is related to SEO contrib, is there a way to fix it with keeping SEO functionality, instead of removing it completely... or replace by other equivalent contrib (then which one may be recommended). Many Thanks in advance to any of you who may be able to dedicate some time to this and help. Regards. Roberto Link to comment Share on other sites More sharing options...
pasopaso Posted December 18, 2009 Author Share Posted December 18, 2009 If anyone has any idea please let me know, before I uninstall everything and try step by step... Thanks. Rgds Roberto -------- Hi All, Seeking for a solution since some time now, related to Reviews. > Reviews problem Reviews never worked, unactivated first (removed line from column_right.php) as I did not want the functionnality initially. And then when I wanted to activate, could not do it by just regenerating original code in column_rigt. After spending a lot of time and since a few months that I am thinking / trying to solving it, my zero php skills do not allow me for any thing to solve this. Currently: -You can start writing a review, but then after checking rating button, next button "Continue" is uneffective: Reviews seem not to be submitted, and you get into a reviews.php page that says "There are currently no product reviews." (Tried with an existing test account, from an ordered product). Code in product_reviews_write.php, is uneffective although it seems ok, idem to original file. Line 125. Tried altering or modifying this intuitively (different action, or return different form/section) 'action=process&products_id=' 'onSubmit="return checkForm() Not effective. - When hover the button "Continue" no link appear. - Reviews are not even recorded in the database, nor they appear in the Admin, nor do you see a record under MySql Admin directly in the hosting 1and1. NOTE: Had a similiar issue wit "Add-to-cart" function, Buttons "Add to cart" were inactive from the sections "New Products" and "Specials". You could only buy and add product to cart by clicking on a "Buy" button from the Product Listing table (once you have clicked on a category). After revising the code in product_info.php, I finally just replaced line 49 in shopping product_info with a a modified line 49, with action is: buy_now, instead of 'action=add_product', which is not an elegant solution but in functionnal terms it looks like it is working. Could not find a way to progress similarly with reviews. Checking the OSC support forum, could not find an exactly related case and a fix, excepted some tracks: - Tried modifying configure.php in particular SSL set-up, after many modifs and trys, uneffective strategy, - Tried different sessions config, false / true, inc session ID, not working, - Checked that sessions are recorded in mysql, it is the case. - Removed tmp/ directory in the admin in case sessions were not going out of the DB. Uneffectice, reinstalled tmp/ dir. - Tried to find a different "action" like "record_review" if there was info related, or to alter "onSubmit="return checkForm()" line 125 from products_review_write; if existing in declared variables or related info somewhere... But did not find anything making sense to try, by google search or forums. - Some forum reponses mention cause may be due to SEO contributions, indeed I have installed 2 SEO contributions: Header Tags SEO: updated "Novice SEO Header tag v3" to "seo header tags version 5.00". which does Prouct Tags and also Catgeory tags. - In resulting pages html code compared with other websites where this functionnality works, it may be related to "&s" added in the line 125 that codes submitt review, process=review, like "process&products_id". Working reveis 1 "&" appears, mine version not working you see 2 of them?¿. It may mean that php does not generate the "right" correct html code? or browser compatibility issue? In such a case is there a fix to the existing SEO files and modifs, "in situ", or shall I remove everything related to this SEO contrib and retest, re-start from scratch? My contributions: - SEO header tags version 5.00 - French - FCKeditor - Center shop 5 - Cyberpack (payment) - Ultimate HTLM mail - ZonesWordl shipping. Site affected: ibericdelice.com In case it is related to SEO contrib, is there a way to fix it with keeping SEO functionality, instead of removing it completely... or replace by other equivalent contrib (then which one may be recommended). Many Thanks in advance to any of you who may be able to dedicate some time to this and help. Regards. Roberto Link to comment Share on other sites More sharing options...
spooks Posted December 19, 2009 Share Posted December 19, 2009 the default revies is bugged & limited have you looked at: Complete Reviews System http://addons.oscommerce.com/info/4397 Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
pasopaso Posted December 19, 2009 Author Share Posted December 19, 2009 Hi, Thanks spooks, was not aware of the issue and of these Review contribs. Should I understand well the situation, I should be able to make it work installing: 1. The first Complete Reviews System Eagle1 18 Jul 2006 2. Some upgrades for the admin, Upgrade admin - Complete Reviews System (Admin) 1.5.3 spooks 3 Aug 2009. Please let me know if I understood well the process with these contribs. Do you think it is better however to uninstall some of the contribs I have (SEO?) or should this work with my current setup, as it is? Thanks again Rgds the default revies is bugged & limited have you looked at: Complete Reviews System http://addons.oscommerce.com/info/4397 Link to comment Share on other sites More sharing options...
spooks Posted December 19, 2009 Share Posted December 19, 2009 Hi, Thanks spooks, was not aware of the issue and of these Review contribs. Should I understand well the situation, I should be able to make it work installing: 1. The first Complete Reviews System Eagle1 18 Jul 2006 2. Some upgrades for the admin, Upgrade admin - Complete Reviews System (Admin) 1.5.3 spooks 3 Aug 2009. Please let me know if I understood well the process with these contribs. Do you think it is better however to uninstall some of the contribs I have (SEO?) or should this work with my current setup, as it is? Thanks again Rgds No, I would suggest you do first the one from Hotclutch 15 Sep 2008 then 1.5.3, I don't think there will be much, if any clashing with any of your existing. I`ll do a combined version when I`ve time. PS Don't forget to apply the SQL, or you will get errors. Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
pasopaso Posted December 19, 2009 Author Share Posted December 19, 2009 Hi, thanks again for your rapid and precise feedback. Will work on it and try after christmas... that I wish you Merry & Happy 2010 rgds ll keep you posted No, I would suggest you do first the one from Hotclutch 15 Sep 2008 then 1.5.3, I don't think there will be much, if any clashing with any of your existing. I`ll do a combined version when I`ve time. PS Don't forget to apply the SQL, or you will get errors. Link to comment Share on other sites More sharing options...
pasopaso Posted January 27, 2010 Author Share Posted January 27, 2010 Hi Sam The install of the Hotclutch 15 sept 08 generates an error, seems one file at leasts is missing. See ibericdelice-com ------------------------- Warning: include(includes/languages/english/FILENAME_DEFINE_MAINPAGE) [function.include]: failed to open stream: No such file or directory in /homepages/46/d273053972/htdocs/index.php on line 343 Warning: include() [function.include]: Failed opening 'includes/languages/english/FILENAME_DEFINE_MAINPAGE' for inclusion (include_path='.:/usr/lib/php5') in /homepages/46/d273053972/htdocs/index.php on line 343 ------------------------ Did not see any FILENAME_DEFINE_MAINPAGE in the contrib download. Is it in another contrib or shall I correct some code elsewhere, and how? Will redownload the Hotclucth contrib and double check if I missed something. As you mention also to add after that the Contrib 1.5.3, this one only modifies or adds Reviews file in Admin, do not see this as the fix to the previous error, or am I missing something?? Any comment welcome. Thanks in advance cheers ------------------------- No, I would suggest you do first the one from Hotclutch 15 Sep 2008 then 1.5.3, I don't think there will be much, if any clashing with any of your existing. I`ll do a combined version when I`ve time. PS Don't forget to apply the SQL, or you will get errors. Link to comment Share on other sites More sharing options...
pasopaso Posted January 28, 2010 Author Share Posted January 28, 2010 Hi Uninstalled and put everything back again from backup, and after checking correct previous set-up yesterday, tried again. > Same Corruption of the Home. Does not affect navigation other sections, only Home (definemainpage). DB seems to have registered the new modif. New fields and correction adds Column Right that was removed, and appears again when registered user enters a Review > guess just a question of removing requires/column_right from new files. > Serious other problem: simply review is still not working. Registered existing customer can enter a review, new fields appear with new Reviews-write interface ok, then after adding review and clicking on submitting, page with review is submitted appear, but uneffective. > Admin > Reviews: nothing is registered. > No notification is received. > PhpMyadmin: no review entered and registered there either aparently. Can forward links with screen copies to those who may have an idea or wih to chek this out. Status: preferably not to lose anymore time on this and forget definiteley installing in a simple way a Reviews system. rgds pasopaso ----------------------------------------------- Hi Sam The install of the Hotclutch 15 sept 08 generates an error, seems one file at leasts is missing. See ibericdelice-com ------------------------- Warning: include(includes/languages/english/FILENAME_DEFINE_MAINPAGE) [function.include]: failed to open stream: No such file or directory in /homepages/46/d273053972/htdocs/index.php on line 343 Warning: include() [function.include]: Failed opening 'includes/languages/english/FILENAME_DEFINE_MAINPAGE' for inclusion (include_path='.:/usr/lib/php5') in /homepages/46/d273053972/htdocs/index.php on line 343 ------------------------ Did not see any FILENAME_DEFINE_MAINPAGE in the contrib download. Is it in another contrib or shall I correct some code elsewhere, and how? Will redownload the Hotclucth contrib and double check if I missed something. As you mention also to add after that the Contrib 1.5.3, this one only modifies or adds Reviews file in Admin, do not see this as the fix to the previous error, or am I missing something?? Any comment welcome. Thanks in advance cheers ------------------------- Link to comment Share on other sites More sharing options...
spooks Posted January 28, 2010 Share Posted January 28, 2010 FILENAME_DEFINE_MAINPAGE is not part of the reviews system its something else u added but made errors I don't know where u may have got it, but FILENAME_DEFINE_MAINPAGE should be defined within filenames.php, but as your seeing FILENAME_DEFINE_MAINPAGE it clearly hasn't. Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
pasopaso Posted February 1, 2010 Author Share Posted February 1, 2010 Hi I think define main page i used buy FCK editor to define mainpage. As of now this contrib is too much for me, no time and no tech capacity to move foward. Closed issue for the moment. Thanks for you help again. rgds --- FILENAME_DEFINE_MAINPAGE is not part of the reviews system its something else u added but made errors I don't know where u may have got it, but FILENAME_DEFINE_MAINPAGE should be defined within filenames.php, but as your seeing FILENAME_DEFINE_MAINPAGE it clearly hasn't. Link to comment Share on other sites More sharing options...
Guest Posted June 26, 2010 Share Posted June 26, 2010 No, I would suggest you do first the one from Hotclutch 15 Sep 2008 then 1.5.3, I don't think there will be much, if any clashing with any of your existing. I`ll do a combined version when I`ve time. PS Don't forget to apply the SQL, or you will get errors. How do I apply the sql? I uploaded it with the other complete review files but something is not working as in Admin when I go to look at reviews I get the message: 1054 - Unknown column 'approved' in 'field list' select reviews_id, products_id, date_added, last_modified, reviews_rating, approved from reviews order by date_added DESC limit 0, 20 [TEP STOP] and on the main page I get the error message in the reviews box: 1054 - Unknown column 'r.approved' in 'where clause' select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and r.approved = '1' order by r.reviews_id desc limit 10 [TEP STOP] I tried to install this on a fresh oscommerce install, so nothing has been changed. I'm at a loss what to do to fix it so any help would be appreciated. Link to comment Share on other sites More sharing options...
Guest Posted June 26, 2010 Share Posted June 26, 2010 How do I apply the sql? I uploaded it with the other complete review files but something is not working as in Admin when I go to look at reviews I get the message: 1054 - Unknown column 'approved' in 'field list' select reviews_id, products_id, date_added, last_modified, reviews_rating, approved from reviews order by date_added DESC limit 0, 20 [TEP STOP] and on the main page I get the error message in the reviews box: 1054 - Unknown column 'r.approved' in 'where clause' select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and r.approved = '1' order by r.reviews_id desc limit 10 [TEP STOP] I tried to install this on a fresh oscommerce install, so nothing has been changed. I'm at a loss what to do to fix it so any help would be appreciated. I've managed to sort it out - being new to databases and SQL it took a bit of time, but I found the answer on another forum. So in case anyone other osc newbies are struggling with this anytime, you have to go to your database administration and make sure the sql file that is included in the package has been uploaded to the database - I had to upload the sql file from my computer, you might need to paste it into a box ( I don't know since I have only used one host and had to upload it). But it worked!! :D 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.