SID-01246: PeerPlugin Reviews not showing

Status:	Unanswered	TWiki version:	5.0.2	Perl version:	5.10
Category:	PeerPlugin	Server OS:	Linux SLES 11	Last update:	14 years ago

The PeerPlugin works fine and I can submit reviews and the reviews are in the Peer table, but I cannot get the reviews to show on the page and it says 'No review list available'.

Here is what I have on the page:

Add a Review of %PROBJECT% %INCLUDE{"%SYSTEMWEB%.PeerPluginForm"}%

-- RonMascarenhas - 2011-08-04

Discussion and Answer

I am still having a problem seeing the Reviews:

1. Created a topic PeerPluginUser with this line: %PRLIST{format="userview"}%

2. Created another topic and added the following:

Add a Review of %PROBJECT% %INCLUDE{"%TWIKIWEB%.PeerPluginForm"}%

%PRLIST{format="%TWIKIWEB%.topicreview"}%

Topic Peer Review Statistics

%PRSTATS{web="all", limit="100"}%

%PRUSERVIEW%

Show a link 'ViewMyReviews'

3. Logged in and added a review

4. Go back to the topic and clikc on 'ViewMyReviews" I get the following message in the browser: TWiki detected an internal error - please check your TWiki logs and webserver logs for more information.

Could not execute SQL statement ... maybe invalid?

The logs have this message:

view: Use of uninitialized value $value in pattern match (m//) at /opt/IBM/twiki/lib/TWiki/Plugins/PeerPlugin/Review.pm line 559., referer: http://tecs.pifss.local:83/bin/view/BPMN/DevelopTrainingCatalog

view: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /opt/IBM/twiki/lib/TWiki/Plugins/PeerPlugin/Review.pm line 403., referer: http://tecs.pifss.local:83/bin/view/BPMN/DevelopTrainingCatalog

-- RonMascarenhas - 2011-08-09

I notice that in the Peer table the Topic column is always blank.

-- RonMascarenhas - 2011-08-10

Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider engaging one of the TWiki consultants if you need timely help. We invite you to get involved with the community, it is more likely you get community support if you support the open source project!

-- PeterThoeny - 2012-01-23

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.