Database error

[Muamer]

Type of error: Critical

Database error, given array of string values is empty. (smiley_list)
Function: EditSmileySets
Apply Filter: Only show the errors from this file
File: .../Sources/ManageSmileys.php
Line: 338

Code Select Expand

   
318:         // Calculate whether there are any smileys in the directory that can be imported.
319: if (!empty($modSettings['smiley_enable']) && !empty($modSettings['smileys_dir']) &&      is_dir($modSettings['smileys_dir'] . '/' . $context['current_set']['path']))
320:        {
321: $smileys = array();
322: $dir = dir($modSettings['smileys_dir'] . '/' . $context['current_set']['path']);
323: while ($entry = $dir->read())
324: {
325:        if (in_array(strrchr($entry, '.'), array('.jpg', '.gif', '.jpeg', '.png')))
326: $smileys[strtolower($entry)] = $entry;
327:        }
328:       $dir->close();
329:
330:          // Exclude the smileys that are already in the database.
331:        $request = $smcFunc['db_query']('', '
332: SELECT filename
333: FROM {db_prefix}smileys
334: WHERE filename IN ({array_string:smiley_list})',
335: array(
336:          'smiley_list' => $smileys,
337: )
==>338: );
339: while ($row = $smcFunc['db_fetch_assoc']($request))
340:        if (isset($smileys[strtolower($row['filename'])]))
341: unset($smileys[strtolower($row['filename'])]);
342: $smcFunc['db_free_result']($request);
343:
344: $context['current_set']['can_import'] = count($smileys);
345:        // Setup this string to look nice.
346:         $txt['smiley_set_import_multiple'] = sprintf($txt['smiley_set_import_multiple'], $context['current_set']['can_import']);
347: }
348: }
349:
350: // Retrieve all potential smiley set directories.
351:          $context['smiley_set_dirs'] = array();
352:         if (!empty($modSettings['smileys_dir']) && is_dir($modSettings['smileys_dir']))
353: {
354:         $dir = dir($modSettings['smileys_dir']);
355: while ($entry = $dir->read())
356: {
357:         if (!in_array($entry, array('.', '..')) && is_dir($modSettings['smileys_dir'] . '/' . $entry))
358: $context['smiley_set_dirs'][] = array(






The problem is that my forum is only showing text code of smileys instead of the smiley picture

[Muamer]

can anyone help? Pls

[Kermit]

Did you try refresh your file with a new copy ?

[Muamer]

Did you try refresh your file with a new copy ?

Yes i did that

[eric1234]

So how to solve this problem?

[Aleksi "Lex" Kilpinen]

What version of 2.0 exactly are you running?
Are your smilies all the default sets, or do you have modified sets in use?