djcaseanova Posted November 27, 2013 Share Posted November 27, 2013 I see a lot of people are getting spammed by bots on reviews for their products. Is there a mod for V5 that will allow an administrator to approve reviews before they're publically posted? I would be interested in this! If there is one, I may have overlooked it... which has been known to happen! Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 27, 2013 Share Posted November 27, 2013 I fiddled with the database to give a product a review, so that I could experiment with something. That review is not showing. It has also not yet been 'approved' in the admin Reviews list. So, if your experience is such that unmoderated reviews are being displayed, that's a bad thing. Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted November 28, 2013 Share Posted November 28, 2013 Thats right. By default in CubeCart reviews are only shown once manually approved. Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 18, 2014 Share Posted January 18, 2014 I have tried to post a test review and although I get sent to the moderator site to check the review, there are no reviews there to review? I also had a 'customer' leave a review, again I went to the admin page and there was no review to check, is this a bug or just another disappointment Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 18, 2014 Share Posted January 18, 2014 We would ask that you access the database directly and look in the CubeCart_reviews database table of the database being used by your CubeCart installation. Earlier, I said that I manually added a review into CC_reviews and it all worked properly from the admin's point of view. (Why manually? At that time, inserting a record manually was simply far more quicker and easier -- for me.) So, if you determine that there are no records in the CC_reviews table, then we can proceed to trace the code that should have inserted the data of a submitted review into the table. If there are records, then we need to determine why your CubeCart fails to fetch or fails to show the reviews. Also, would you please post the exact URL of the link given to you in the email advising you there is a review to be moderated. (You can disguise the domain name.) According to the code, the link in the email (which, by the way, will not be sent if the INSERT command sent to the database fails) should look like: admin.php?_g=products&node=reviews&edit=## Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 18, 2014 Share Posted January 18, 2014 Hi I have found the database,i think, but I'm on the edge of my knowledge zone here. I have attached a screen shot. There does not appear to be anything there? The path to my review was as follows.. domain.co.uk/admin.php?_g=products&node=reviews&edit=1 Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 18, 2014 Share Posted January 18, 2014 The table you are showing appears to be part of a third-party mod -- probably from CC3. I say that because: CC525: `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `approved` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0', `product_id` INT UNSIGNED NOT NULL DEFAULT '0', `customer_id` INT UNSIGNED NOT NULL DEFAULT '0', `rating` DECIMAL(2,1) UNSIGNED NOT NULL DEFAULT '0.0', `vote_up` INT NOT NULL DEFAULT '0', `vote_down` INT NOT NULL DEFAULT '0', `anon` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `name` VARCHAR(255) NOT NULL, `email` VARCHAR(254) NOT NULL, `title` VARCHAR(255) NOT NULL, `review` TEXT NOT NULL, `ip_address` VARCHAR(45) NOT NULL COMMENT 'Supports IPv6 addresses', `time` INT UNSIGNED NOT NULL CC447: `id` int(11) NOT NULL auto_increment, `approved` smallint(1) NOT NULL default '0', `productId` int(11) NOT NULL, `type` smallint(1) NOT NULL, `rating` smallint(1) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(254) NOT NULL, `title` varchar(255) NOT NULL, `review` text NOT NULL, `ip` varchar(45) NOT NULL, `time` int(10) NOT NULL The structure in the image has almost all column names different than what is expected by CC5 (and as such, probably won't get inserted, but then, why did the database not report a failure to insert??? -- just thinking to myself). To make sure you have the right database, look at the contents of the file /includes/global.inc.php. There should be the host, database, user, and pass of the database being used. According to the image, you are using phpMyAdmin to look at "rusticc3_ccrt1". Is this the name of the database in the file? So, in phpMyAdmin, DROP (that is, delete) the CubeCart_reviews table. Then in the SQL tab (hopefully there is an edit window here), enter the following and click Execute: CREATE TABLE IF NOT EXISTS `CubeCart_reviews` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `approved` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0', `product_id` INT UNSIGNED NOT NULL DEFAULT '0', `customer_id` INT UNSIGNED NOT NULL DEFAULT '0', `rating` DECIMAL(2,1) UNSIGNED NOT NULL DEFAULT '0.0', `vote_up` INT NOT NULL DEFAULT '0', `vote_down` INT NOT NULL DEFAULT '0', `anon` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `name` VARCHAR(255) NOT NULL, `email` VARCHAR(254) NOT NULL, `title` VARCHAR(255) NOT NULL, `review` TEXT NOT NULL, `ip_address` VARCHAR(45) NOT NULL COMMENT 'Supports IPv6 addresses', `time` INT UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `product_id` (`product_id`), KEY `votes` (`vote_up`,`vote_down`), FULLTEXT KEY `fulltext` (`name`,`email`,`title`,`review`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 18, 2014 Share Posted January 18, 2014 deleted Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 18, 2014 Share Posted January 18, 2014 With phpMyAdmin, you were connecting to the correct database. An error caused by the phpMyAdmin installation is not the fault of CubeCart. It is a JustHost issue to solve. Does your storefront still operate normally? Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 18, 2014 Share Posted January 18, 2014 Sorry to be a bit thick, which bit should I 'blank out' Website appears to be working as normal. Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 18, 2014 Share Posted January 18, 2014 In post #8 delete these lines: $glob['dbpassword'] = 'xxx'; $glob['dbusername'] = 'xxx'; Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 18, 2014 Share Posted January 18, 2014 Apologises for this question, the whole line - $glob['dbpassword'] = 'zxczczczczc Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 18, 2014 Share Posted January 18, 2014 Replace 'yourActualPassword'; with hidden. Then edit the previous post as well. Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 18, 2014 Share Posted January 18, 2014 I am sorry I am trying to keep up with you.When you say my actual password, what password is that, login to admin password, customer password, $globdb['password'] = 'xxxxxx'; and then I should delete the entire two lines mentioned above. I paid CC for a license for a shop, I did not realise I would have to learn a different language to get it working, but I do appreciate you help. Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 18, 2014 Share Posted January 18, 2014 Let's skip the renaming. Please edit post #8 above so that the lines being discussed are completely gone. You really do not want anyone other than you to know the the username and password to access your database. Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 18, 2014 Share Posted January 18, 2014 Well I deleted the lines but it will not let me upload the edited file. Command: STOR global.inc.php Response: 553 Can't open that file: Permission denied Error: Critical file transfer error suggest you delete all these posts and we forget the whole conversation Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 18, 2014 Share Posted January 18, 2014 Let me try to be very clear: By posting in these forums, anything you write can be read by anyone. As such, we don't want to be posting personal or secret information in these forums. I hope that you would not want anyone to know your bank account numbers, social-security number (or what passes for a national id number in your country), credit card numbers, passwords to your Facebook account, etc. In post #8 above, you have posted the password to your database. I am asking you to edit the post above. Do not make any changes to the CubeCart file global.inc.php. Cubecart needs to know the user/pass to your database, and uses the information in the global.inc.php file to access the database. The rest of the world does not need to know this information, and you really do not want the rest of the world to know this information. Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 18, 2014 Share Posted January 18, 2014 I believe I have done as requested, but you need to ++understand that a 59yr old man may not be fully upto speed with techno. please check this post to make sure I have deleted all the 'personal' info. thanks Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 18, 2014 Share Posted January 18, 2014 Your prior posts look good. Getting back on track, and if phpMyAdmin is functioning for you, please use it execute the code I posted in post #7. Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 19, 2014 Share Posted January 19, 2014 Hi I have completed post #7 input and the reviews now work, there is an icon that appears in the review section , see attached, which take you to a sign up page for wordpress - Sign in to Gravatar with WordPress.com Connect Gravatar now allows you to use a WordPress.com account to sign in. If you have a WordPress.com account already then you can use that, or you can create a new one. how do I stop that showing? Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 20, 2014 Share Posted January 20, 2014 In your skin's template file content.product.php, find a line that looks like this:<p class="content"><a href="http://gravatar.com/emails/"><img src="http://www.gravatar.com/avatar/{$review.gravatar}?s=50" /></a>{$review.review}</p> and change it to look like this:<p class="content">{$review.review}</p> Quote Link to comment Share on other sites More sharing options...
rusticc3 Posted January 20, 2014 Share Posted January 20, 2014 I thank you very much. I now have a fully working review system without gravatar. Case closed, thanks again Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.