What version of 68 Classifieds are you running? v4.2.4 Developer What template are you using? 3col Please describe in detail the issue you are having: Hello all, I am back I'm getting my site updated to the latest go faster software, and have got a little problem, its a weird one (yeah I know its typical of me!) that is probably very easy to solve if you know what you are looking at! I am getting an error message When I look at the list of extra fields the one for Sex is there as a drop down list, but not with the Mare gelding or stallion options. It is linked to the for sale sections but even though its set as required it does not show when I am inputting an advert, but if I click to submit the advert it says I need to select an option. I have installed the pedigree module and had to create extra listing type firlds for that and it was fine for those and pedigree worked perfectly first time! I have reloaded /includes/classes/database/mysql.php in case I had had a problem with the upload but it is still the same, and I have tried with all the modules turned off. Don't think there is anything else I should have tried, if t here is my appologies for forgetting in my old age
Sounds like your database table may be messed up. the error states: Unknown column 'optSub' the column is the "field name" within the table SQL: INSERT INTO `class_fields_options` SET fieldID='39', optValue='mare', optSub='0' So it's looking in the 'class_fields_options' database table and is stating that the last insert to column/field, 'optSub' is unknown. e.g. there isn't a column/field by that name when it tried to do that. It refers to the 'mysql.php' file, only because that is the class file that the method is being called from, not to be confused with that file being wrong. I would check the database using the hosting control panel for your hosting service tool to check the database itself. Usually they offer something like phpMyAdmin for working with the databases in your hosting account directly. Check to see if their actually is an optSub column/field in the 'class_fields_options' table. Most likely there is. Have it check the table. If it finds an issue have it repair the table.
Thanks a lot, will have a look and report back tomorrow, worst way now I know what to look for is I can do a fresh instal and copy whatever is in the new database to the old one
Thanks a lot, it was exactly as you said and I have got it sorted - also discovered a lot of rather old tables that were still on the database so got rid of them and now have a nice new clean database
