When I post it exits Joomla and comes up with the message header and this error message in an otherwise blank screen.

Reply/Quick reply/New Post all produce the same error

Serious db problem:You have an error in your SQL syntax near 'ON id=mesid WHERE userid=63 AND name='Frank' AND email=' This e-mail address is being protected from spam bots, you need JavaScript enabled to view it ' AND subjec' at line 1 SQL=SELECT id FROM jos_fb_messages JOIN jos_fb_messages_text ON id=mesid WHERE userid=63 AND name='Frank' AND email=' This e-mail address is being protected from spam bots, you need JavaScript enabled to view it ' AND subject='Re:Error message in forum display after posting' AND ip='xxx.xxx.xxx.xxx' AND message='post bombs' AND time>='1201113143'

This part appears to be the error if the above is the complete string: AND subjec' at line 1 SQL=SELECT it is missing t=

Note this is SQL generated by 1.0.4 after an upgrade, not a script I ran.

Everything else Seems to be OK back and front, apart from the emoticons and I think that is because the short hand codes are missing in the back end.

I think the best method of implementing FB is to do a clean install. If you have files such as Images, Avatars, emoticons and files that have been uploaded to the site, back these all up. Uninstall FB and reinstall. The other thing you can do is FTP all the files to your system, uninstall FB and reinstall. Then go through your files and put back anything your missing.

This usually works very well and only takes a few minutes to do.

But how do I keep all the existing set up and threads if I do that!

I have just re-run all the scripts from the 1.0.3 distribution and every command failed so whatever they are supposed to do has been done!

I did read something about sql versions, mine is 3.23.54-log, but I cannot find anything specifying what version is required.

When uninstalling and reinstalling, you don't loose your database. All your tables stay in tact. Just be sure to backup your images, files, avatars and so on that you want to keep.

Well, I am steeling myself to restore 1.0 and then go through the whole upgrade again

Nut can anyone confirm if my SQL version, 3.23.54-log, is not the problem

your mysql 3X could be. Are you with a hosting company and are you sure the mysql is that version?

Yes. That is the version Joomla! reports in the back end.

Minimum System Requirement

To run FireBoard, the webserver you're hosted on must meet a few simple requirements. These are not terribly high, and as such most hosts meet them.

*
Any webserver that properly supports PHP, such as Apache or Internet Information Services (IIS).
*
PHP 4.1.0 or higher. The following directives are required to be set correctly in php.ini:
o
the engine directive must be On.
o
the magic_quotes_sybase directive must be set to Off.
o
the session.save_path directive must be set to a valid directory.
o
the file_uploads directive must be On.
o
the upload_tmp_dir must be set to a valid directory.
*
MySQL 3.25 or higher.
*
at least 512 kilobytes of storage space in the database, although more is highly recommended.
*
about two and a half megabytes of storage space on the web server, although more is recommended

Check with your hosting company if they have a newer version of php. If not, change providers. I realize this may be a bit much but even mysql 4.1 is beginning to get old yet alone 3.X.
Also be sure you are using php 4+ or 5+. I'm not sure that joomla or any current php is compatible with the older versions.