All smiles work, there is something wrong with your template that blocks text inserts via javascript. This upgrade only changes links to smiles (which obviously work!) and has nothing to do with Fireboard inserting text codes for smiles into your text:
theforcefield.net/joomla/index.php?optio...catid=1&id=74#74


This and userlist problems have nothing to do with this fix!

And as I can see from the false order of new post, you even haven't run the fix right.

Thanks for checking it out. The reason some posts are out of order is because while I was testing the posts I noticed the time was off and I changed the time offset of the server in the Fireboard General Settings console. After I changed it some of the posts were out of order as they were apparently listed in sequence according to the time posted.

As for the smiley template, the template did work and inserted the smileys in the posts until after I ran the section of the script that changed jos_fb_smileys. I ran that section separately because as I posted previously I had already manually changed the other entries in MYSQL following the script and when I attempted to create the PRIMARY_KEY (id) for the smileys it gave me an error about duplicates, which there were for most, if not all, smileys.
Rather than manually edit them I ran that portion of the script and it created the Primary Key.

I did attempt to run the entire script after I manually edited the database but it gave errors about duplicates because I had already done it all except the smileys so I know the rest of my entries are okay.

The smiley template stopped working only after I ran the script to fix the smileys.

Actually none of buttons work on your site.. Pure Javascript problem: e.g. for smiles I get this error: emo is not defined.

Either your template is messed up or you are using some incompatible plugin that breaks your javascript. Either has nothing to do with sql queries.

Hmm. Everything was working fine until I ran the script. I was posting with smileys and I could use the other formatting buttons. I did not add any plugins and I did nothing to my template. I did change the server time. That is all.

kauselot wrote:


Actually none of buttons work on your site.. Pure Javascript problem: e.g. for smiles I get this error: emo is not defined.

Either your template is messed up or you are using some incompatible plugin that breaks your javascript. Either has nothing to do with sql queries.

And what are you so angry about? Everything was fine until I ran the script and changed the server time. After that the smileys broke. I did not notice the bbcode buttons were not working anymore until you mentioned it. I appreciate that you checked it out but I do not understand what you are angry about and there was no need for the bold type, either.

I did run the fix correctly. The false order of the post was caused by the time change as the posts were ordered by the time posted. I am not a guru with this forum software and I am not a programmer, or else I wouldn't be wasting my time in here asking for help in the first place. I came here for assistance with an issue, not to be scolded for my ignorance by another user. If this is open source collaboration and community support, perhaps I should go back to commercial applications and outsourced pay support instead. I don't always understand what they are saying but at least they are polite.

I ran the script and fixed the errors. It seems to have fixed most of the problems I was having. I also had the smilies stop working after the script. Everything else worked like a charm.

The script posted on the first page of this forum will not work because of what appears to be a posting error. I'm sure the right code was posted, but it is missing the smiley codes. Notice the error here:

[code:1]REPLACE into `jos_fb_smileys`(`id`,`code`,`location`,`greylocation`,`emoticonbar`) values (1,'','cool.png','cool-grey.png',1);[/code:1]
After the "(1, ", you see an empty string '' instead of the smiley code.

[code:1]REPLACE into `jos_fb_smileys`(`id`,`code`,`location`,`greylocation`,`emoticonbar`) values (1,'B )','cool.png','cool-grey.png',1);[/code:1]
In this example, the code value should be 'B', followed by ')'. However, if I write this exactly as it should be, the posting editor changes it to a smiley and you won't see it, so I've got those two characters with a space between them for illustration only.

I ran this SQL script except for the smiley update and it worked like a champ, but as the warning says, if you don't know what you are doing, don't run SQL queries. I had to clean up some inconsitencies that were created while running before these updates. Secondly, for the smiley table, I just deleted the duplicate entries manually. I'm up and running fine now.

To fix your smileys code column in the DB, look at the jos_sb_smileys table and use those code values. Manually correct them.

It worked! Thanks, bantar. I checked my database and found three pages of multiple entries. Apparenly the smiley code added to what I already had instead of replacing it. The duplicates broke both the smileys and BBcode buttons. I went into the database and deleted the duplicate entries. Both smileys and BBCode now work.

Kudos to you!

At first I said WTF, but now figured out that I forgot to put it into code brackets and smiley codes got converted into pictures. Should work now - just re-run that line (line before the last one)
A big thank you Bantar for finding this out.

Added solution that auto deletes duplicates in ALTER TABLE statemets (just change ALTER TABLE to ALTER IGNORE TABLE). But be warned - this will delete all rows that have the same key as any previous row. This could mean that some posts, attachments etc will be lost.