JM,

Following our discussion on the Zikula forum, I've upgraded from 2.1 to 2.4 in preparation for the upgrade to 2.5 with Zikula.

All looks fairly good, but there's a few problems we've seen so far.

- Create a new ad. When you submit the ad, you get an error message "Error: Unknown column 'itemcondition' in 'field list'". The "New Ad" email is sent, but the add doesn't appear in the validation queue.

- Click on any existing ad. You get "Error: Unknown column 'a.itemcondition' in 'field list'" and "Invalid page 'details.php'"

Fairly major problems...

Hello,
This is a "known" problem :
To acheive mysql5 compatibility I had to rename the "condition" field in the ads table because "condition" is a reserved word in mysql5 so it was not possible to have a field with this name.
To solve the problem ue phpMyAdmin and rename the "condition" field to "itemcondition"
The upgrade procedure should take care of that but the problem was that depending if your mysql is in strict mode or not sometimes any sql query with the word "condition" was refused with "you have any error in your sql query ..." error message. So in the 2.4 version I have removed this line.
Sorry for the inconvenience. I should add a little word about this in the readme.txt
If you have another problem or question, don't hesitate to post on this forum.

Merci!

That worked fine. For future reference, in case anybody else is having this problem and not using PHPMyAdmin, the MySQL command line to do the change manually is alter table nuke_classifieds_ads change condition itemcondition varchar(50);