Customizing SMF > Modifications and Packages

Custom Form Mod

<< < (297/310) > >>

thechronic2001:
Hello
I've ran into some problems, yesterday I installed this mod, everything was working fine in regards to the mod working correctly.

Later on I decided to update the smiley set and added a new pack, for some reason now when i go to Admin CP/Features and Options then to custom forms section I get this error

--- Code: ---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
File: C:\Inetpub\vhosts\{domain}\httpdocs\{forum_path}\Sources\ModSettings.php
Line: 628

--- End code ---

Line 628 of ModSettings.php is as follows

--- Code: ---WHERE ID_BOARD IN (0, $board)", __FILE__, __LINE__);

--- End code ---

Here is the start of that section down to the first "else"

--- Code: --- // Array for all icons that need to revert to the default theme!
$context['javascript_icons'] = array();

if (($temp = cache_get_data('posting_icons-' . $board, 480)) == null)
{
$request = db_query("
SELECT title, filename
FROM {$db_prefix}message_icons
WHERE ID_BOARD IN (0, $board)", __FILE__, __LINE__);
$icon_data = array();
while ($row = mysql_fetch_assoc($request))
$icon_data[] = $row;
mysql_free_result($request);

cache_put_data('posting_icons-' . $board, $icon_data, 480);
}
else

--- End code ---

Does anyone have any ideas on how to fix this error?

i installed the mod on my test forum and it worked fine, fully functional, when i installed it on my real forum it installed and worked for a while then all of a sudden it stopped  I've removed and reinstalled the mod but it makes no difference.


My forum Version is as follows:
SMF File                                 Your Version   Current Version
SMF Package                          SMF 1.1.16   SMF 1.1.16
Sources                                         1.1.16   1.1.16
Default Templates                         1.1.12   1.1.12
Language Files                               1.1.15   1.1.15
Current Templates                           1.1.5   1.1

Database server type          MySQL
Database server version          5.0.45


Any help would be greatly appreciated  ;)

thechronic2001:
I finally got this problem sorted after 2 days looking at random files, basically the above error occurs when you have "Enable customized message icons" in
Admin / Forum / Smileys and Message Icons  / Settings
If the "Enable customized message icons" Checkbox is Checked it Throws this sql error

--- Code: ---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
File: C:\inetpub\vhosts\{domain}\httpdocs\{forum_directory}\Sources\ModSettings.php

--- End code ---

Just a FYI in case anyone else gets caught out with this problem and spends a few days pulling out the last few stands of hair they have left

Taglar Dreskk:

--- Quote from: umiya on August 04, 2012, 03:05:47 PM ---Is it possible to have multiple answers with maybe a check box, radio box? I have only been able to get it setup where you can only chose one answer.

--- End quote ---

I'd be interested in this feature as well...

maddoghalo:
When somebody posts the forums, how do I get the thread title to include their forum username?

I use to be able to do it but forgot how. When they click submit it makes a new thread and is says for example: Maddoghalo's Application.

FrizzleFried:

--- Quote from: PsYc0TiC on July 29, 2012, 05:56:20 PM ---I understand that... why the attitude?

--- End quote ---
Might have something to do with your sense of entitlement?  Hmmm.... could be.

Navigation

[0] Message Index

[#] Next page

[*] Previous page