Thank you for working on PN_zClassifieds

backharlow
backharlow's Avatar
  • Registered: 15.01.07
  • last visit: 15.01.07
  • Posts: 1
Posted: 15.01.2007, 18:29
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. icon_cool

vedrine
vedrine's Avatar
Site Admin
  • Rank: Site Admin
  • Registered: 06.12.03
  • last visit: 25.02.10
  • Posts: 274
Posted: 10.02.2007, 13:50
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.
Invité
  • Registered: 06.12.03
  • last visit: 15.08.09
  • Posts: 4294967292
Posted: 23.08.2007, 08:37
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
vedrine
vedrine's Avatar
Site Admin
  • Rank: Site Admin
  • Registered: 06.12.03
  • last visit: 25.02.10
  • Posts: 274
Posted: 23.09.2007, 19:09
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 !
Invité
  • Registered: 06.12.03
  • last visit: 15.08.09
  • Posts: 4294967292
Posted: 16.10.2007, 19:35
now:

Quote

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