Topic: Latest Quiz Block (Code) doesnt work on SP 2.3

[pnreddy]

Hello,

I have upgraded to SP 2.3 today. But the following code which is for latest quizes is not working on sp 2.3

Code: [Select]

global $smcFunc, $settings, $scripturl;

$result = $smcFunc['db_query']('', '
      SELECT       Q.id_quiz,
               Q.title,
               Q.image,
               Q.updated
      FROM       smf_quiz Q
      WHERE      Q.enabled = 1
      ORDER BY   Q.updated DESC
      LIMIT      0, 8'
   );
echo '<table border="0">';
while ($row = $smcFunc['db_fetch_assoc']($result)) {
   echo '<tr><td><img width="15" height="15" src="' , !empty($row['image']) ? $settings["default_images_url"] . '/quiz_images/Quizes/' . $row['image'] : $settings["default_images_url"] . '/quiz_images/Quizes/Default-64.png' , '"/></td><td><a href="' , $scripturl , '?action=SMFQuiz;sa=categories;id_quiz=' , $row['id_quiz'] , '">' , $smcFunc['db_unescape_string']($row['title']) , '</a></td></tr>';
}
echo '</table>';
   
$smcFunc['db_free_result']($result);
I see the following error..

Database error in block code. Please check the code

It used to work fine on SP 2.2

Can any one help what has to be done now.

Thanks in adv!

[simply sibyl]

This one works fine for me with 2.3

Code: [Select]

global $smcFunc, $settings, $scripturl;

$result = $smcFunc['db_query']('', '
SELECT Q.id_quiz,
Q.title,
Q.image,
Q.updated
FROM smf_quiz Q
WHERE Q.enabled = 1
ORDER BY Q.updated DESC
LIMIT 0, 8'
);
echo '<table border="0">';
while ($row = $smcFunc['db_fetch_assoc']($result)) {
   echo '<tr><td><img width="15" height="15" src="' , !empty($row['image']) ? $settings["default_images_url"] . '/quiz_images/Quizes/' . $row['image'] : $settings["default_images_url"] . '/quiz_images/Quizes/Default-64.png' , '"/></td><td><a href="' , $scripturl , '?action=SMFQuiz;sa=categories;id_quiz=' , $row['id_quiz'] , '">' , $smcFunc['db_unescape_string']($row['title']) , '</a></td></tr>';
}
echo '</table>';

$smcFunc['db_free_result']($result);

[pnreddy]

Hey thanks for the code..

I have checked your code, I can see the preview of the block but when i click on 'add block' i see the error

Database error in block code. Please check the code

please..any help?

[pnreddy]

I hate to BUMP.. I need support though..

This block is important on my site because it gives an idea to the members about the latest quizes and encourages to take them.

Thanks!

[pnreddy]

Hello Guys,

The problem persists with another code too...

Code: [Select]

global $smcFunc, $settings, $scripturl;

$result = $smcFunc['db_query']('', '
SELECT I.entry_date,
                                        I.entry
FROM smf_quiz_infoboard I
ORDER BY I.entry_date DESC
LIMIT 0, 5'
);
echo '<table border="0">';
while ($row = $smcFunc['db_fetch_assoc']($result)) {
   echo '<tr><td>' , date("M d Y H:i", $row['entry_date']) , '</td><td>' , $row['entry'] , '</td></tr>';
}
echo '</table>';

$smcFunc['db_free_result']($result);

The error is database error in block code. SP 2.3 is having these issues. What would be the reason.

Please help!!

[pnreddy]

Guys, Let me know if I should consider that this topic will not be supported here.

Then, I may consider seeking support some where else or downgrading for SP 2.3

Thanks!

[simply sibyl]

Hey thanks for the code..

I have checked your code, I can see the preview of the block but when i click on 'add block' i see the error

Database error in block code. Please check the code

please..any help?

humm   no idea why it wont work for you...  same code works just fine on a friends forum here:

http://www.ourhangout.org/forum/

Also works on my own forum -  did nothing more too it - same exact code I gave you.

[pnreddy]

That is exactly what I am not able to understand. This is happening only after the upgrade..

I have no clue what is the database error..!

Help- Some one? Any one?

[Old Fossil]

That is exactly what I am not able to understand. This is happening only after the upgrade..

I have no clue what is the database error..!

Help- Some one? Any one?

Hi

Sorry I have just seen this topic.

Please let me know which mod you use for the quiz then I can add to my test forum to see if it happens to me too.

[pnreddy]

Thanks listener. Its the SMF Quiz mod.

Unfortunately, the author of the mod only supports porta mx portal and he recommends that for that mod.

[Old Fossil]

can I ask if you had any errors when installing the quiz?

Also please confirm your smf version.

[pnreddy]

I did not have any errors while installation. The problem is with SP 2.3 block not with the quiz mod. The custom php blocks with the above codes were working fine SP 2.2, after the upgrade, its showing the db error which I posted above.

I am using smf 2.0 rc 1.2 and sp 2.3. Thanks!

[Old Fossil]

It may be worth you making a report in the bug tracker.

Hope you don't get squeamish with insects.

[Nathaniel]

It may be worth you making a report in the bug tracker.

Hope you don't get squeamish with insects.

Lets have a go at trying to work out what the problem actually is, before posting a bugreport.

I suspect that there is an issue relating to the PHP validator within SimplePortal (especially as we have already had some other issues).

For now you can use this solution:
Turn on the 'Disable PHP Validation' setting, in your admin panel under SimplePortal -> Configuration -> General Settings.

[pnreddy]

Ok Nathaniel,

I have done it and the custom blocks are live. Thanks much listener and nathaniel!

[ccbtimewiz]

The issue is because of the WHERE clause. It is not properly formatted.

I am assuming it is the PHP validation check that SP is doing is somehow removing the set in the SQL "WHERE" statement. While turning this off will perhaps solve it, I would suggest at least making it clean.

The format should be: FROM column AS extension

In the example you have shown, you have the following syntax:

Code: [Select]

      FROM       smf_quiz Q
This is incorrect as you did not set the extension of which all the previous fields were grabbed. Technically they're not required as you're only grabbing information from one specific source and you are not joining in any other resources, so you could set completely get rid of the "Q." extensions and remove the stray "Q" from the "FROM" statement

[pnreddy]

Very sorry ccbtimewiz,

I dont know PHP- Did you mean to say that I should delete this code?

Code: [Select]

   FROM       smf_quiz Q

[ccbtimewiz]

Take this:

Code: [Select]

global $smcFunc, $settings, $scripturl;

$result = $smcFunc['db_query']('', '
      SELECT       Q.id_quiz,
               Q.title,
               Q.image,
               Q.updated
      FROM       smf_quiz Q
      WHERE      Q.enabled = 1
      ORDER BY   Q.updated DESC
      LIMIT      0, 8'
   );
echo '<table border="0">';
while ($row = $smcFunc['db_fetch_assoc']($result)) {
   echo '<tr><td><img width="15" height="15" src="' , !empty($row['image']) ? $settings["default_images_url"] . '/quiz_images/Quizes/' . $row['image'] : $settings["default_images_url"] . '/quiz_images/Quizes/Default-64.png' , '"/></td><td><a href="' , $scripturl , '?action=SMFQuiz;sa=categories;id_quiz=' , $row['id_quiz'] , '">' , $smcFunc['db_unescape_string']($row['title']) , '</a></td></tr>';
}
echo '</table>';
   
$smcFunc['db_free_result']($result);
Replace with:

Code: [Select]

global $smcFunc, $settings, $scripturl;

$result = $smcFunc['db_query']('', '
SELECT id_quiz, title, image, updated
FROM smf_quiz
WHERE enabled = {int:enabled}
ORDER BY updated DESC
LIMIT 0, 8',
array(
'enabled' => 1,
)
);

$quizzes = array();
while ($row = $smcFunc['db_fetch_assoc']($result))
{
$quizzes[] = array(
'image' => $row['image'],
'title' => stripslashes($row['title']),
);
}
$smcFunc['db_free_result']($result);

echo '
<table border="0">';

foreach ($quizzes as $content)
{
echo '
<tr>
<td>
<img width="15" height="15" src="' , !empty($content['image']) ? $settings['default_images_url'] . '/quiz_images/Quizes/' . $content['image'] : $settings['default_images_url'] . '/quiz_images/Quizes/Default-64.png' , '"/>
</td>
<td>
<a href="' , $scripturl , '?action=SMFQuiz;sa=categories;id_quiz=', $row['id_quiz'] , '">' , $content['title'], '</a>
</td>
</tr>';
}

echo '
</table>';

[navjotjsingh]

What code should I use for SMF 2.0RC2 and SimplePortal 2.3.2? None of the code listed above works.