0 Members and 1 Guest are viewing this topic.

User Comments on User Rating
« on: February 16, 2017, 07:44:59 PM »
Hi all,

maybe it's a stupid question, but after intensiv searching.. I can't find where Users can add Comments with the Ratings.

When i look at the Rating Page for a User can i see "No Comments" but nowhere to put a comment

I forgot to mention i use the "FreshDate" Template

Best regards
Dave

*

Pharg

  • *****
  • 3,106
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: User Comments on User Rating
« Reply #1 on: February 16, 2017, 09:17:20 PM »
Hi Dave,

Yes this had been fixed before but you might still have an old file, checked the uploads and it's been fixed also.

Here is the fix:
Rating Comments - Comment Form Not Showing Issue Fix

showprofile.php - Around line 333

Find this code from:
Code: [Select]
$c = $osDB->getOne( 'SELECT count(*) as c  FROM !  WHERE userid = ? AND profileid = ? and ratingid = ? and comment is not null', array( USER_RATING_TABLE, $_SESSION['UserId'], $_REQUEST['id'], $item["id"] ));

Change to this:

Code: [Select]
$c = $osDB->getOne( 'SELECT count(*) as c  FROM !  WHERE userid = ? AND profileid = ? and ratingid = ? and comment <> ?', array( USER_RATING_TABLE, $_SESSION['UserId'], $_REQUEST['id'], $item["id"], '' ));
Or download the attached showprofile.php then upload it to your site.

If it still fails, then you must have it turned off in the admin area, go to the admin, site globals, then the drop down tab at the top select Profile Ratings and check to see it says Y to comments.
« Last Edit: February 16, 2017, 09:19:48 PM by Pharg »
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.1.15 | MySQL: 5.5.35

Re: User Comments on User Rating
« Reply #2 on: February 17, 2017, 10:14:48 AM »
Hi Phil,

i replaced the file and checked the admin area. Ratings are enabled.

I checked on 2 installations and i am still not able to see the comment field, even with the original design. Where should the comment field appear ??

Do you know by any chance where in the Database i have to check the setting?

Thank you very much
Dave

*

Pharg

  • *****
  • 3,106
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: User Comments on User Rating
« Reply #3 on: February 17, 2017, 09:17:56 PM »
Good morning Dave,

Yes that is very strange, not sure what the problem is on yours.

The comments show at the bottom of the profiles where the comments are made.

The comments go into the osdate_userrating table

I will check the FreshDate template to see if there is a issue but I don't think there will be.

Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.1.15 | MySQL: 5.5.35

*

Pharg

  • *****
  • 3,106
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: User Comments on User Rating
« Reply #4 on: February 18, 2017, 02:09:07 AM »
Hi Dave,

Just checked the comments in the FreshDate template and it seems it's not working.  :(

Works fine in the default templates.  ;D
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.1.15 | MySQL: 5.5.35

Re: User Comments on User Rating
« Reply #5 on: February 18, 2017, 04:52:32 PM »
Hey Phil,

thnx for checking.

It works now for me in the FreshDate Template.. For what reason , but it does ;)
« Last Edit: February 18, 2017, 08:24:20 PM by Pharg »

*

Pharg

  • *****
  • 3,106
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: User Comments on User Rating
« Reply #6 on: February 18, 2017, 08:59:17 PM »
Hi Dave,

Got mine working to, wasn't anything to do with the templates or script, it was the database wasn't turning on the comments, sorted it out in the database itself, will have to look if there is a issue on turning it off and on maybe.
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.1.15 | MySQL: 5.5.35

*

chris99

  • *
  • 26
  • osDate Version: osDateEvo v1.2
Re: User Comments on User Rating
« Reply #7 on: March 14, 2017, 02:29:12 AM »
Hi, i just upload the attached showprofile.php and it still did not work for me. Can you help me?

*

Pharg

  • *****
  • 3,106
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: User Comments on User Rating
« Reply #8 on: March 14, 2017, 05:37:11 AM »
Hi Chris99,

If it still fails, go to the admin, site globals, then the drop down tab at the top select Profile Ratings and check to see it says Y for YES to the comments.
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.1.15 | MySQL: 5.5.35

*

chris99

  • *
  • 26
  • osDate Version: osDateEvo v1.2
Re: User Comments on User Rating
« Reply #9 on: March 14, 2017, 05:44:53 AM »
Its says Y for YES to the comments in my admin site globals

*

Pharg

  • *****
  • 3,106
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: User Comments on User Rating
« Reply #10 on: March 14, 2017, 05:55:38 AM »
Hi Chris99,

PM me your FTP details and admin details please?

Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.1.15 | MySQL: 5.5.35

*

Pharg

  • *****
  • 3,106
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: User Comments on User Rating
« Reply #11 on: March 14, 2017, 07:01:16 AM »
Hi Chris99,

It's working fine now, I think you uploaded an old copy not the one you downloaded as it had the old code still.

Plus the other reason yours didn't work, when you disable the Gold and Silver and the profiles already have Gold membership you must add a new membership to the account or it will make them all with no permissions at all which
all your members had.

I have changed your members to Free and Activated them all so the site works correctly.

I have attached a pic below.
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.1.15 | MySQL: 5.5.35

*

chris99

  • *
  • 26
  • osDate Version: osDateEvo v1.2
Re: User Comments on User Rating
« Reply #12 on: March 14, 2017, 07:10:10 AM »
Ok, thank you very much