datakick

@movieseals is there a file CryptBlowfish in /home/publichtml/classes? If there is, try to delete cache/classindex.php

@pedalman there are no commits related to 1.0.3. Version 1.0.3 is just a tag, a bookmark in history of branch 1.0.x. Everything and anything committed after this point in time is part of upcoming version 1.0.4 Now, if there is some fix that's really important to you, and you are not willing to wait for next version, you can cherry-pick this commit. Start by creating your own branch git checkout -b branch1.0.3 1.0.3 This will create new branch named branch1.0.3 from commit associated with tag 1.0.3. It's like you have traveled back in time and have the same codebase as it was at the time 1.0.3 was released. Now, you can use git cherry-pick <commit-hash> where commit-hash is id of commit (from the future) you wish to merge to your 1.0.3 branch. Obviously, this can be a dangerous operation, as the commit can depend on code that didn't exists in 1.0.3 yet... so test it properly.

@slick_303 this option is available only when guest reviews are disabled. Maybe that's the problem...? Edit: also, I've found a bug in the code , so use this version instead

Definitely don't delete products, google juice is way too precious. I personally would go with redirect to similar product, or to parent category if no product is close enough alternative. This doesn't need to be such pain when you use mass update / inline editing tools.

@slick_303 yes, git repository is NOT a valid module. You need to build it first, and for that you need nodejs and gulp. I've described how to do it in this dev manual

@slick_303 said in [Free Module]Revws - Product Reviews: It would be nice that if a product didn't have a review, and you were not allowed to write one, that the review tab and button would not even show. Done, will be released in upcoming version. I've added new settings option that is available only when you disable guest reviews. You can now choose one of the three behaviors: show empty reviews tab -- this is current behavior. Review tab will be rendered with No customer reviews for the moment message hide reviews tab completely -- this is what you've requested. All references to reviews will be removed from product page show sign in button - I vaguely remember that someone requested this one. If there are no reviews yet then we will render Sign in to write a review button.

version 1.0.3 has been released. This is just a bunch of bugfixes that have been reported recently, no new functionality.

Thanks @slick_303 for sharing this. I think that date condition shouldn't be there at all, though. Number of unapproved reviews is a snapshot metric. We can't really create a sql to determine how many unapproved reviews were at any given time (or time interval). It doesn't make sense to filter on review date here. Different situation would be if we were interested in number of newly created reviews. That we can measure for any time interval. This date condition will filter out unapproved reviews that are older than from date. So the metric can say there are 1 unapproved review, but in fact when you click on the link you can see more. The same applies for original code for productcomments reviews.

@wakabayashi hmmm, productcomments module doesn't save emails for reviews created by guests, so when I import these reviews I don't have anything to store to email field. That will later cause this problem. I'll come with some solution. Meanwhile, you can edit file sql/migrate-productcomments.sql and replace COALESCE(`cust`.`email`, '') with COALESCE(`cust`.`email`, '[email protected]') And then reimport product comments reviews. This will associate guest reviews with '[email protected]'. Replace this email with your own, or use some throwaway

Also, maybe use dateupd field instead of dateadd, to count old reviews that needs to be re-approved

@slick_303 you didn't properly escape deleted and validated fields. Use this sql: (new DbQuery()) ->select('COUNT(*)') ->from('revws_review') ->where('`deleted` = 0') ->where('`validated` = 0') ->where('`date_add` BETWEEN "'.pSQL($params['date_from']).'" AND "'.pSQL($params['date_to']).'" ')

get rid of shop restriction and it should work

@slick_303 said in [Free Module]Revws - Product Reviews: @datakick Is there a way to change the css look of the js popups? You know, those grayish/rose colored guys... the js app depends on this library that uses jss instead of css. So it's not possible to extract css, but we can set palette for the components. I plan to add this option to settings page. I think normal users will prefer to set colors in UI instead of via css. It's definitely not a best way for power users, but they have an option to rebuild js app with their own settings if they wish. @luv said in [Free Module]Revws - Product Reviews: 2) In product list review displayed upon hover other wise hidden. How to do that. You can copy css file /modules/revws/views/css/front.css to /themes/<THEME>/css/modules/revws/revws.css and modify it as you see fit. For example you can try to add this to the end: ``` .revws-product-list { transition: opacity 200ms ease; opacity: 0; } .product-container:hover .revws-product-list { opacity: 1; } ``` 3) Can you add a feature in review display tab for customer who have made a purchase as "Verified Buyer" below name. (It is going to make review more trustworthy). A small feature but very powerful. Sure, nice idea. 4) I see in setting tap Review request. did not understand what it does. Does that send review request mail to the customer. If it is so, this module is a gem. If not please consider adding. Sorry, not a gem yet :) When logged-in customer goes to My Reviews in My Account, he will be asked to review recently purchased products. This option only limits max number of displayed products. Revws module will never contain ask by email functionality. But I'm (slowly) developing another module for this.

thanks @chandra, unfortunately that didn't help much. The problem is that the javascript file (back_app.js) with the application is not loaded into your page, for some reason. It's probably issue with url (possibly caused by your multistore configuration), or it could be problem with your server settings (for example some .htaccess rule that prevents downloading this file), or anything else. I can't really tell without access to your backoffice. If you manage to set up test instance, let me know. Thank you

Hi @30knees, datakick module has it's own expression language. Expressions are something like excel formulas, and you can find them everywhere in my module (if you look hard enough). In lists (csv export), xml templates, mass updates, and even imports. I will show you how expression works on List example. I will create a list that will show products and their reviews. To start, create a list based on Products collection, and then in dataset tab join Review collection: Now we have list displaying all my products with their review. Something like this: In left column you will find any field from both products and reviews, and you can add it to list output. But you can also edit column, and change it's expression. For example, when I click on Review Title column in left panel, I get this As you can see, expression says revwsReview.title. revwsReview is collection alias of Review collection, and title is field from this collection. This is the easiest expression possible, it simply returns review title. But we can change it, for example to: products.name + ': ' + toLowerCase(revwsReview.title) This will make the column display name of the product concatenated with review title, in lowercase: And we can do some crazy stuff, there are plenty of function you can use. We have conditionals: if(products.basePrice < 100, 'cheap', 'expensive') will show text cheap/expensive based on product price arithmetics: (products.basePrice - products.wholesalePrice) calculates your profit margin. string operations: replace(products.name, 'm', '-') will replace character m with dash in product name Now, you can use these expressions anywhere. Here we used them to format list output. But you can use them to define conditions as well - you can filter your list and show only subset of data. Or you can use them to highlight some rows - in above example I highlighted cheap stuff. And, you can use them else in the system. For example, in Mass Update. Now I'm getting back to your original question. Mass Updates To generate meta title, just create new mass update based on Products collection. First step is to define what products to update. By default, all products would be updated. To change this, switch to Dataset tab, and create a condition. I will create a condition that match only products with 'IBIZA' in name: The condition builder let you easily create some common conditions in UI. But if you want, you can always click on the condition, and change it whatever you want. Now, switch to the fields list, and find field you want to update. In our case, it's Meta title. Once you add it to list of Fields to update, click on in once again to edit: As you can see, the Update action is set to 'Set value', and New value is empty. If you have executed mass update now, it would set empty meta title. We don't want that. So, click on Action, and choose Custom expression. Now you can enter your update expression. For example product.name +' just for ' + round(toNumber(product.basePrice),0) + ' EUR' Mass update shows you how this will impact your data. In preview list, you see current value, and new value, so you can adjust your update expressions without actually modifying your data: Once you are satisfied, you can click on Execute Update button, and your products will be updated. Simple as that. You can, also, save this mass update and use it later. You can also schedule it to run every day or every hour, so your meta title will stay in sync with price. Parameters This is one thing that's very useful, but not very people knows about it. You can create a parameter and use it in expression. You will need to enter it's value when you run the mass update (or list,...). This let you create reusable mass update. I'll show on example. Say you want to add 20% profit margin to your product price. You can create mass update that will use wholesale(purchase) price to calculate product price using this expression: product.wholesalePrice * 1.2 Or, we can make this mass update generic, and create numerical parameter margin. Once we create this parameter, we can use it in our expressions: product.wholesalePrice * ((100 + runtime.margin)/100) Now, when you run this mass update, you will need to provide value for margin parameter, and this value will be used in expression during runtime (parameters are accessible using runtime alias) Following example don't show wholesale price, but it's $50. New base price = 50 * (100 + 40 / 100) = $70 Uff, that was long. I hope it answered your question :)

@lesley sure, fallback to another (well configured) encryption mechanism would solve this problem. There should also be some warning in back office to inform administrator that config is not in valid state.

@lesley yes. There was invalid Rijndael key/vector in config file which caused the error. I simply switched ciphering method directly in database: update <DB_PREFIX>_configuration set value=0 where name = ‘PS_CIPHER_ALGORITHM’

What was the last thing you did? Did you install some module, made some changes using ftp?

Although the protection probably won't help much, I don't think it's the root cause of this problem. I based this on Internal Server Error message, which is usually php problem. Did you look to your php error log?

New version 1.0.2 has been released. You can now migrate review and criteria settings from native product comments module.

@chandra could you give me access to your shop, so I could look this?

@chandra that means that module has been installed, but javascript application wasn't loaded. Try to clear cache (both browser, and in thirtybees in Advanced Parameters > Performance). If this does not help, please open developer console, open Product reviews, and look for errors in Console / Network tab

@chandra is it really during install? Could you please check if there's a menu entry Catalog > Product reviews?

Is there a way to import the current reviews from the stock Product Comments module? No, currently not. I'll look what I can do I hope I'm not being to forward, but I forked your module, and made a couple of Pull Requests, do with what you will.... Awesome! Thanks @SLiCK_303 . That's why it's an open source, so anyone can contribute

@nickon sure.Currently I keep my backlog in asana, but that can't be made public. I'll migrate it to github issues