I have actually been trying to initialize PN_zClassifieds since postnuke .750, and your beta 2.3 is the first version to actually succeed. I just wanted to thank you. What held me back before was the reserved name in Mysql 5.X, issue. However, one thing, when I first tried to initialize PN_zClassifieds beta 2.3 I got the following error:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /usr/local/4admin/apache/vhosts/eternalimageandsound.com/httpdocs/nuke/html/modules/PN_zClassifieds/pninit.php on line 350

I checked pninit.php on line 350, and it looks to be related to that condition that was changed. But since I was not upgrading I just removed the entire upgrade function, and then the mod worked perfectly. Thanks again.

Thanks a lot for your kind words.
There seems to be a problem in this line.
I will look at it
In the meantime, people installing a new version can suppress this line as you did.
People upgrading from a previous version can also suppress the line and manually change the name of the field from 'condition' to 'itemcondition' because as you said condition is now a reserved name in Mysql 5 so it can no more be used as a field name.

BUG in MySQL 5:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /motosdeagua.es/modules/PN_zClassifieds/pninit.php on line 350

Hello,
This problem is now corrected in the zipfile available in the Downloads section.
There was a bug in that line
Line 350 in pninit.php was :

Code

$sql = "ALTER TABLE $table CHANGE condition $column['itemcondition'] varchar(50) DEFAULT '' NOT NULL";

and it should have been

Code

$sql = "ALTER TABLE $table CHANGE condition ". $column['itemcondition'] . " varchar(50) DEFAULT '' NOT NULL";

Sorry it has taken so long to find the time to look at this problem !

now:

Citation

query: ALTER TABLE pn_classifieds_ads CHANGE condition itemcondition varchar(50) DEFAULT '' NOT NULL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition itemcondition varchar(50) DEFAULT '' NOT NULL' at line 1