VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: dark_hatchling on January 28, 2015, 01:31:41 AM

Title: Ratings not publishing...
Post by: dark_hatchling on January 28, 2015, 01:31:41 AM
Hey, I have this issue with VM3.0.2 and Joomla 3 where the reviews are being auto published but not the rating. The stars remain white and unfilled though the review has been published. I have "auto-publish" checked in the back end. When I add a review and look at the back end it shows them as being unpublished. If i manually publish them from the back end it then publishes the review AND rating. I am stuck...I have searched around but can't find a direct solution.

Thanks for reading.
Title: Re: Ratings not publishing...
Post by: GJC Web Design on January 28, 2015, 10:04:50 AM
Have u tried VM3.0.3 - lots of bug fixes - 3.0.4 will be released soon..
Title: Re: Ratings not publishing...
Post by: dark_hatchling on January 28, 2015, 10:36:03 AM
No, I have not. I was unaware that it was released. But the problem I am having does seem to be some type of bug and not a setting or one of my overides/hacks. I installed a brand new J3 and VM3 install on a test drive. I added a product and commented on it and rated it. everything worked fine. review and rating both published. I then deleted those reviews in the VM back end and tried to rate the products again. Now I get the same issue where it does not show the rating, but it does show the comment. Weird.
Title: Re: Ratings not publishing...
Post by: GJC Web Design on January 28, 2015, 10:39:28 AM
I am not saying this is fixed in 3.0.3 but the purpose of these early life updates is 90% bug fixes .. before bothering trying to troubleshoot a problem it makes common sense to be on the latest release
Title: Re: Ratings not publishing...
Post by: dark_hatchling on January 28, 2015, 10:43:14 AM
Well, I'm going to go with a fresh install of VM on my site and go from there. Question..where do we d/l v3.0.3 at? I'm at their site right now and its giving me 3.0.2.

Thanks.
Title: Re: Ratings not publishing...
Post by: jenkinhill on January 28, 2015, 10:48:23 AM
Ratings are fixed in VM3.0.4 which is available on SVN or will be released on http://dev.virtuemart.net/projects/virtuemart/files once final testing is completed.
Title: Re: Ratings not publishing...
Post by: dark_hatchling on January 28, 2015, 10:51:30 AM
Thank you for that link.
Title: Re: Ratings not publishing...
Post by: GJC Web Design on January 28, 2015, 11:04:09 AM
http://dev.virtuemart.net/projects/virtuemart/files
Title: Re: Ratings not publishing...
Post by: dark_hatchling on January 28, 2015, 11:47:52 AM
Wow this is just insane..........................................
I tried to uninstall VM and the VM AIO from the Extension manager and it told me I needed to "install the core files before INSTALLING" ??????? Ok, so it removed VM but not the VM AIO and now I get a fat error every time I attempt to install VM again. And ideas? I just need VM gone completely for now, every piece of it from the Joomla install.

'An error has occurred.
1050 La table 'pdb_virtuemart_adminmenuentries' existe déjà SQL=-- VirtueMart table SQL script -- This will install all the tables need to run VirtueMart -- -- Table structure for table `PDB_virtuemart_adminmenuentries` -- CREATE TABLE IF NOT EXISTS `PDB_virtuemart_adminmenuentries` ( `id` tinyint(1) unsigned NOT NULL AUTO_INCREMENT, `module_id` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'The ID of the VM Module, this Item is assigned to', `parent_id` tinyint(1) unsigned NOT NULL DEFAULT '0', `name` char(64) NOT NULL DEFAULT '0', `link` char(64) NOT NULL DEFAULT '0', `depends` char(64) NOT NULL DEFAULT '' COMMENT 'Names of the Parameters, this Item depends on', `icon_class` char(96), `ordering` int(1) NOT NULL DEFAULT '0', `published` tinyint(1) NOT NULL DEFAULT '1', `tooltip` char(128), `view` char(32), `task` char(32), PRIMARY KEY (`id`), KEY `module_id` (`module_id`), KEY `published` (`published`), KEY `ordering` (`ordering`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Administration Menu Items' AUTO_INCREMENT=1 ;"
Title: Re: Ratings not publishing...
Post by: GJC Web Design on January 28, 2015, 12:38:36 PM
just drop the table pdb_virtuemart_adminmenuentries if still in the DB b4 u start again
Title: Re: Ratings not publishing...
Post by: dark_hatchling on January 28, 2015, 13:05:17 PM
I have been trying to go through the whole DB and delete everything. It now says the table`pdb_virtuemart_carts` exists. I deleted that from the mysql folder because dropping it from the DB removed all tables but the vm_carts. Tried installing, same thing. Went through and dropped all VM tables again with no issues except the fact that it leaves virtuemart_carts.idb in the mysql data folder though it doesnt show in the DB through PHPMyADMIN. deleted it. tried installing. ERROR 1050..  :'(
Title: Re: Ratings not publishing...
Post by: GJC Web Design on January 28, 2015, 13:08:54 PM
if u start deleting stuff directly in your mysql folders you on the road to hell... 

You should just manage your DB thru the correct interfaces .. or just start with a fresh db is this one is now corrupt

Just copy all the non VM tables to it - connect it in the jadmin and install VM
Title: Re: Ratings not publishing...
Post by: dark_hatchling on January 29, 2015, 23:52:52 PM
Yeah... I was definitely on the road the hell..
It was just weird cause when I dropped all the VM tables from the PHPMyAdmin page, it said it dropped them all. but when I looked in the mysql data folder it still the "vm_carts" table even tho it was not showing in the DB from PHPMyAdmin. Anyways... I just redid everything.. That was a long night lol.

Still having an issue with the reviews publishing but NOT the rating. Hopefully in the new release Jenkinhill mentioned.
Anyone know if VM plans on allowing guest users to rate and review? Seems to be an extremely wanted option. People are paying programmers on freelance sites to incorporate that option. lol
Title: Re: Ratings not publishing...
Post by: dark_hatchling on January 30, 2015, 02:06:55 AM
Upgraded VM 3.0.4 on my Joomla! 3.3.6 Stable [ Ember ] and the issue I am having still persists. Comments will auto publish but the ratings DO NOT. In the back end it shows them as being unpublished. When I manually publishing them from there the ratings and comment post fine.

I've looked through the core files in the default_reviews.php file and "auto-publish=1" is set. IDK.
Title: Re: Ratings not publishing...
Post by: dark_hatchling on January 30, 2015, 08:16:34 AM
Annnnd the race is off to find a better e-cart! Plugins = Waisted money too!
Title: Re: Ratings not publishing...
Post by: Milbo on February 03, 2015, 08:06:41 AM
I just tested it and autopublishing works. But I work on joomla 2.5, because joomla 3.3 has too many bugs.
Title: Re: Ratings not publishing...
Post by: PhotonVideo on August 02, 2016, 08:17:48 AM
I'm having the same problem.  Manually publishing the ratings seems to be a laborious workaround.  This is my first time using VM and I am trying to get everything working perfectly before replacing the old site with this new one.  I am using VM 3.0.16 and Joomla 3.6.0

If this problem persists, I may just remove the rating system from the product page and leave the reviews.