Review Reminder issue

[Bruce1952]

Hi All,

This is my server info:
Server Date: 15/09/2023 00:09:07
Server Up Time: Disabled/Unavailable
HTTP Server: Apache
PHP Version: 5.6.40 (Zend: 2.6.0)
PHP File Uploads: On
Upload Max Size: 128M
PHP Memory Limit: 1024M
POST Max Size: 512M
Database: MySQL 5.7.43
Database Host: localhost (127.0.0.1)
Database Date: 15/09/2023 00:09:07
Database Data Size: 1,940,563 kB
Database Index Size: 119,130 kB
MySQL Slow Query Log Status: On
MySQL Slow Query Log File: /var/lib/mysql/server-slow.log
MySQL Mode: NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

I have just installed the Product Reviews Reminder and all seems ok except for one thing which is when I press edit (button) in the reviews folder I get this following error message below:
WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I can press the delet buton and that works how it should and also the details button works as it should to.

Any assistance would be great because it seems very easy for the customer to do reviews and would love to start using.

[lat9]

That plugin hasn't been updated for 6 years (eons in programming time)! When you see that "An error occurred ..." message during admin processing, there's a myDEBUG-adm-*.log file in your site's /logs directory waiting to let you know what the underlying issue is.

If you post a copy of that log (xxx-ing out the name of your Zen Cart admin directory) between "CODE" tags (the big # in the menu bar you see when you write your response), that will provide the details we'd need to help you further.

[dbltoe]

No log file in the logs directory? If so, use the # above to post it here.

typed while lat9 posted.

[Bruce1952]

Here is what you requested:

[15-Sep-2023 00:14:21 Australia/Sydney] Request URI: /xxxx/reviews.php?page=1&status=1&rID=4459&action=edit, IP address: 45.125.247.117
#1 trigger_error() called at [/home/xxxx/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/xxxx/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/xxxx/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/xxxx/public_html/xxxx/reviews.php:140]
--> PHP Fatal error: 1054:Unknown column 'rd.reviews_reply_text' in 'field list' :: select r.reviews_id, r.products_id, r.customers_name, r.date_added,
r.last_modified, r.reviews_read, rd.reviews_text, rd.reviews_reply_text, r.reviews_rating
from reviews r, reviews_description rd
where r.reviews_id = '4459' and r.reviews_id = rd.reviews_id ==> (as called by) /home/xxxx/public_html/xxxx/reviews.php on line 140 <== in /home/xxxx/public_html/includes/classes/db/mysql/query_factory.php on line 167.

[Bruce1952]

Can anyone help with this issue please

[Bruce1952]

Here is some more information from the files which might help correcting the problem.

Lines 135 to 141 query factory.php
function set_error($zp_err_num, $zp_err_text, $dieOnErrors = true) {
$this->error_number = $zp_err_num;
$this->error_text = $zp_err_text;
if ($dieOnErrors && $zp_err_num != 1141) { // error 1141 is okay ... should not die on 1141, but just continue on instead
$this->show_error();
die();
}

Lines 167 to 170 query factory.php
trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql . $query_factory_caller, E_USER_ERROR);
if (defined('IS_ADMIN_FLAG') && IS_ADMIN_FLAG==true) echo 'If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.<br />';
echo '</div>';
}

Lines 265 to 275 query factory.php
if (FALSE === $zp_db_resource) {
$this->set_error(mysqli_errno($this->link), mysqli_error($this->link), $this->dieOnErrors);
} else {
$obj->resource = $zp_db_resource;
if ($obj->RecordCount() > 0) {
$zp_result_array = mysqli_fetch_array($zp_db_resource);
if ($zp_result_array) {
while (list($key, $value) = each($zp_result_array)) {
if (!preg_match('/^[0-9]/', $key)) {
$obj->fields[$key] = $value;
}

Lines 136 to 153 admin reviews.php
//Added rd.reviews_reply_text to $reviews below (reviews reply edit 3 of 6)
$reviews = $db->Execute("select r.reviews_id, r.products_id, r.customers_name, r.date_added,
r.last_modified, r.reviews_read, rd.reviews_text, rd.reviews_reply_text, r.reviews_rating
from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd
where r.reviews_id = '" . (int)$rID . "' and r.reviews_id = rd.reviews_id");

$products = $db->Execute("select products_image
from " . TABLE_PRODUCTS . "
where products_id = '" . (int)$reviews->fields['products_id'] . "'");

$products_name = $db->Execute("select products_name
from " . TABLE_PRODUCTS_DESCRIPTION . "
where products_id = '" . (int)$reviews->fields['products_id'] . "'
and language_id = '" . (int)$_SESSION['languages_id'] . "'");

$rInfo_array = array_merge($reviews->fields, $products->fields, $products_name->fields);
$rInfo = new objectInfo($rInfo_array);
?>

I would like to get this sorted out so I can send out review emails to customers.

[swguy]

The original error said

Unknown column 'rd.reviews_reply_text'

But this plugin: https://www.zen-cart.com/downloads.php?do=file&id=2148
(Which is called Product Review Reminders)
doesn't create a field called reviews_reply_text, nor does the default database installer.

And the plugin I linked above doesn't contain or modify reviews.php.

[balihr]

I remember seeing a plugin that uses the 'rd.reviews_reply_text', but can't remember which one it was. If the review REPLIES are not important to you, you could edit your
/home/xxxx/public_html/xxxx/reviews.php on line 140
and simply remove the 'rd.reviews_reply_text' from the list of fields that are being selected.
So, from

select r.reviews_id, r.products_id, r.customers_name, r.date_added,
r.last_modified, r.reviews_read, rd.reviews_text, rd.reviews_reply_text, r.reviews_rating

to

select r.reviews_id, r.products_id, r.customers_name, r.date_added,
r.last_modified, r.reviews_read, rd.reviews_text, r.reviews_rating

[Bruce1952]

I remember seeing a plugin that uses the 'rd.reviews_reply_text', but can't remember which one it was. If the review REPLIES are not important to you, you could edit your
/home/xxxx/public_html/xxxx/reviews.php on line 140
and simply remove the 'rd.reviews_reply_text' from the list of fields that are being selected.
So, from

select r.reviews_id, r.products_id, r.customers_name, r.date_added,
r.last_modified, r.reviews_read, rd.reviews_text, rd.reviews_reply_text, r.reviews_rating

to

select r.reviews_id, r.products_id, r.customers_name, r.date_added,
r.last_modified, r.reviews_read, rd.reviews_text, r.reviews_rating

Thank for the information it is now working as it should.

[Bruce1952]

Having an issue with reviews in the My Account section and when clicking on it I get returned to the home page.

Can someone tell me where I should look to get this back again.

It was working in the past and I am thinking that I must have changed something when checking other modules.