Help with several problems

For the shoutbox, in your skin that you are using do you see the code  {shoutbox_content} anywhere in the index.tpl

the block should look something like this

<div class="block">
      	<div class="tl"><div class="tr">
<div class="title">{shoutbox_title}</div>
</div></div>
       	<div class="content">{shoutbox_content}</div>
  </div>

i just lifted that from the standard elegance skin that comes with the 3.3 download.  Tweak it to fit what you have in your modified version

and for story of the moment, if that is random story, do the same thing in a new block, but replace the shoutbox with random

hopefully that will get it displaying for you

I believe there's a bug in the challenges because it's been reported a few times. I just checked the challenges page on one of my sites and it's blank.

The solution is to go into Admin->Page Links
Look for Challenges and click Edit
in the url box change it from challenges/challenges.php to browse.php?type=challenges
Click Submit
And your challenge page will work.

JanAQ solved it.

However, on your site if you are here:

You can still see the Issue a challenge link and it takes to to the Add a challenge page. Do a search in the bug report section, I can't remember if there was a fix mentioned yet.

As for the shoutbox, Jacci nailed it. You simply have to put the {shoutbox_contents} tag in the index.tpl

barb

It looks like there's a space needed between #43 and ORDER

'Resource id #43ORDER BY review.reviewid DESC LIMIT 0,15' at line 1 

.  I think it's line 339 in reviews.php just from looking at it quickly.  Try this, change that line to this:

	$query .= " ORDER BY review.reviewid DESC LIMIT $offset,$itemsperpage";

And see if you're still getting the query error

Thank you very much, I'll try these and let you know how it worked. 🙂

Thanks for your help. Following your advice, the shoutbox and, Story of the moment blocks are now displayed. The Challenges Problem is fixed too!!

However, the query problem still persist. I think I have to modify something in the database itself, but I don't know what or how.  😥 😥 😥

When I go to phpMyAdmin and do a query in fanfiction_reviews, I still get the same message as displayed in the site if I try to read a reported abuse:

Error
consulta SQL: 

SELECT *
FROM `fanfiction_reviews`
WHERE Resource id#43 ORDER BY review.reviewid DESC LIMIT 0,15

MySQL ha dicho: 

#1064 - 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 'id #43 ORDER BY review.reviewid DESC LIMIT 0,15' at line 1

I'd wish I knew what I have to look for in the manual to get the right syntax and fix it. It might be the simplest thing in the world to do, but I'm absolutely lost here.

Anyway, thanks for your help...

Since most problems had been fixed, except the last one, should I mark this as SOLVED?

Hi
I just ran into the same issue with the review response with the the latest efiction...

I get the following error when i click on the link notifying that an author has responded to the
review
-----------------
A fatal MySQL error was encountered.
Query: Resource id #43ORDER BY review.reviewid DESC LIMIT 0,10
Error: (1064) 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 'Resource id #43ORDER BY review.reviewid DESC LIMIT 0,10' at line
-----------------------------

I believe that is because the SQL is broken....now I went and looked at reviews.php (333-335) and
fourd the following code....
$reviewquery = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_codeblocks WHERE code_type = 'revqueries'");
while($code = dbassoc($reviewquery)) {
eval($code['code_text']);
--------------------------------
If then go and look in my fanfiction_codeblocks table....I do not have a value for 'revqueries' at which point this SQL will fail...

The database was upgrade from 3.2.1....It's a development site...so users are not impacted

I have members getting that same error when clicking on the link that the author has responded to their review, but am unsure why and what the solution is.

I believe that is because the SQL is broken....now I went and looked at reviews.php (333-335) and
fourd the following code....
$reviewquery = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_codeblocks WHERE code_type = 'revqueries'");
while($code = dbassoc($reviewquery)) {
eval($code['code_text']);
--------------------------------
If then go and look in my fanfiction_codeblocks table....I do not have a value for 'revqueries' at which point this SQL will fail...

The database was upgrade from 3.2.1....It's a development site...so users are not impacted

No it won't.  It's in a while loop.  If you don't have any revqueries then that loop never gets triggered.  Beyond that.  That section is only triggered if the review is for something other than a story or series.  So unless you've got the recommendations module installed, it's not going to be called anyway.

Upgraded to 3.3.1 from 3.2.1 ....not bridged....

The review response issue went away...
co-authors not being able to respond to reviews went away...

And the upgrade proper took less than 2 mins..

Well done...

Thanks
TPTB