Joomla 3.02
JoomSEF = com_joomsef4-4.3.0.zip

New Install

Backend install error: cannot find xml file

No JoomSEF component menu item

Home-front-end runs 404 with error:
SQL=SELECT `id`, `alias` AS `name`, `catid`, `metakey`, `metadesc`, `metadata`, `language`,`misc` FROM `xxxx_contact_details` WHERE `id` = 1-contact-us

Uninstalled
Reinstalled
Now no backend error
Component menu item for JoomSEF now exists
but front-end 404 and sql error the same

Hi,

It seems that there's a malformed link to a contact containing ID of "1-contact-us" somewhere on your website, which is not handled correctly by JoomSEF.
Thank you for your report, we'll fix our code in next version of JoomSEF to handle it correctly. In the meantime try to find the link and fix it - the ID and alias should be separated by a colon, so it should be "id=1:contact-us".

apologies, I didn't do a very good job reporting the errors

on installing 4.3.0 first time on j3.02, there were 2 errors and I didn't record them so can only go from memory
1/ first was that .xml file could not be found and I think it actually said "joomla.xml"
2/ second was that "com_banners could not be removed"

I have looked around but can't figure out how to fix the link, there's no apparent way in the db menu table as the contact entry follows the same structure as all the other links.

I trashed the contact us link in main menu and alias link in top menu, db menu entry is not removed and error persists.
Removed the menu link manually from the db
Then removed the contact item in com_contacts backend
Item gone in db table "xxxx_contact_details"
SQL Error persists front end
Deleted all JoomSEF SEF's, SQL error persists
Cleared all chaches/tmp/browser cache, SQL front-end error persists
Turned off JoomSEF

Would have purchased the extension but no guarantee I'll get it working.

Anyway, the extra error info I've given may help you, tks

Deinstalled JoomSEF extension
removed _bak tables
Frontend ok
Created a new contact item
created a new main menu item for it
Frontend ok
Reinstalled JoomSEF, no errors
Turned on JoomSEF
Original error back again: SQL=SELECT `id`, `alias` AS `name`, `catid`, `metakey`, `metadesc`, `metadata`, `language`,`misc` FROM `xxxx_contact_details` WHERE `id` = 1-contact-us

If you think you can get this fixed, we'll buy priority support

Please try disabling the Search Engine Friendly URLs in your Joomla's Global Configuration and post a link that will be used for your contact menu item. Thank you.

www.xxxxxxxxxx.org/index.php?option=com_...;id=1&Itemid=214

only runs the SQL error on the home page now