• backharlow
  

  • Inscrit en : 15.01.07
  • Dernière visite : 15.01.07
  • Messages : 1

  Envoyé le : 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.
  
  

  • 
  •  
• vedrine
  
  

  • Rang : Site Admin
  • Inscrit en : 06.12.03
  • Dernière visite : 25.02.10
  • Messages : 274

  Envoyé le : 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é

  • Inscrit en : 06.12.03
  • Dernière visite : 15.08.09
  • Messages : 4294967292

  Envoyé le : 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
  
  

  • Rang : Site Admin
  • Inscrit en : 06.12.03
  • Dernière visite : 25.02.10
  • Messages : 274

  Envoyé le : 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é

  • Inscrit en : 06.12.03
  • Dernière visite : 15.08.09
  • Messages : 4294967292

  Envoyé le : 16.10.2007, 19:35

  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

  • 
  •  
•  
•  

Utilisateurs en ligne

• 13 visiteurs

Données pour les 15 dernières minutes