the MYsql database version has been upgraded and now if a user logs in add a listing the listing is NOt added You can view the d/b all Ok and the end user see no change just admin users/agents can't add listings. On the d/b a new column has appeared 'Collation' and then in some of the fields rows it says: latin1_swedish_ci I think this is the problem, but I don't know how to get it back to how it was before, it never had collation and I'm unsure what character setting it should be (if any!) Any help pointers etc.... Thanks Ian Venta Sanlucar Sales Sotogrande

It sounds like a new field was added to one of the database tables, although you wouldn't expect that from upgrading the mysql software. But if a table has a new field, there is a good chance that the insert statement (used during add functionality) will fail. If that is the case, then the program doing the insert needs to be adjusted to account for the new field. Be sure to come back and let us know if our suggestions helped!

Yes for some reason it did insert a new column. Anyhow I've managed to sort the problem out....I was thinking it was due to the character set being changed and this new field BUT it wasn't.... I've added some code to one of the files and the htaccess which has enabled gloabals. Thanks Ian Venta Sanlucar Sales Sotogrande