Help > General

Just installed version 3.0 of simple review - An error has occurred. ERQD2

(1/2) > >>

classicmario:
Hello,

I am using the following
Simple Review 3.0
Joomla 1.5

I had previously been using an older version of Simple Review and upgraded (2.x) yesterday

All of my reviews etc are in the database and the main review category page displays as below

http://www.themariobros.net/reviews.html

However no reviews show, and there is an error message present "An error has occurred. ERQD2An error has occurred" etc

Could anyone kindly give me some advice on how to fix this?

Best regards

Luke

row1:
Hi,

Please turn on debug mode so we can see the exact error:
http://simple-review.com/forum/index.php/topic,381.0.html

It seems like it is a database error. Did you apply each update individually AND run all database upgrade scripts?

classicmario:
Hello mate thanks for your reply. I have done this, and here is the result!

500 - JDatabaseMySQL::query: 1054 - Unknown column 'r.metakey' in 'field list' SQL=SELECT r.reviewID, r.categoryID, r.awardID,r.score, r.name, r.pageName, r.published, r.userReview, r.status, r.content, r.blurb, r.thumbnailURL, r.imageURL, r.createdByID, r.lastModifiedByID, r.templateName, r.metakey, r.metadesc, r.metadata, u.name as createdByName, u.username as createdByUName, u1.name as lastModifiedByName, u1.username as lastModifiedByUName, DATE_FORMAT(r.createdDate, '%a %e %b %y') as createdDate, DATE_FORMAT(r.lastModifiedDate , '%a %e %b %y') as lastModifiedDate, c.name as categoryName, c.pageName as categoryPageName, a.name as awardName, a.imageURL as awardImageURL, rt.title as title1, rt.title, ct.titleOrder, IFNULL( AVG( IF(com.userRating = -1, NULL, com.userRating ) ), -1) as avgUserRating FROM jos_simplereview_review AS r LEFT JOIN jos_users AS u ON r.createdByID = u.id LEFT JOIN jos_users AS u1 ON r.lastModifiedByID = u1.id LEFT JOIN jos_simplereview_category AS c ON r.categoryID = c.categoryID LEFT JOIN jos_simplereview_comments as com ON com.reviewID = r.reviewID LEFT JOIN jos_simplereview_awards as a ON r.awardID = a.awardID LEFT JOIN jos_simplereview_category_title as ct ON ct.categoryID = c.categoryID AND ct.titleOrder = 1 LEFT JOIN jos_simplereview_review_title as rt ON rt.reviewID = r.reviewID AND ct.categoryTitleID = rt.categoryTitleID WHERE r.published = 1 GROUP BY r.reviewID ORDER BY r.score desc LIMIT 5

As a LAMER I have no idea what this means!

Any ideas?

row1:
There was a 2.2.4-3.0.0 database script that you needed to apply in: Simple_Review_2.2.4-3.0.0_Upgrade_Joomla1.5\files\database\database-2.2.4-3.0.0.sql


--- Code: ---UPDATE `jos_simplereview_comments` SET `published` =1;

ALTER TABLE `jos_simplereview_tag`
ADD `name` VARCHAR( 255 ) NOT NULL,
ADD `description` TEXT NULL ,
ADD `imageURL` VARCHAR( 255 ) NULL,
ADD `templateName` VARCHAR( 255 ) NOT NULL DEFAULT 'default';

ALTER TABLE `jos_simplereview_review`
ADD `metakey` TEXT NOT NULL DEFAULT '',
ADD `metadesc` TEXT NOT NULL DEFAULT '',
ADD `metadata` TEXT NOT NULL DEFAULT '';

--- End code ---

Please try running that script. There may also be other script that you need to run. You will need to check each individual patch.

classicmario:
Thanks for this, my problem is resolved much appreciated.

I have one further question, dont know if its possible

I would like to choose the reviews that are shown as top reviews - I have 4 'top reviews' but I would prefer to choose what is displayed rather than have the top star rated ones as I have a lot of 5 star ones, and I would like the newest ones up there really.

Is that possible?

Thanks

Luke

Navigation

[0] Message Index

[#] Next page