Zikula Community

• gudmann
  
  

  • Rank: Softmore
  • Registered: Mar 14, 2003
  • Last visit: Apr 19, 2010
  • Posts: 116

  Posted: Apr 08, 2008 - 11:27 AM

  Hope someone can help me. I have Postnuke 0.8 RC2 installed and tried to install the SendForm module. When initializing I get this error in the admin panel.
  
  _PNC_DBCREATETABLEERROR - (users) - 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 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMES
  
  Any ideas?

  • 
  •  
• espaan
  
  

  • Rank: Developer
  • Registered: Aug 23, 2003
  • Last visit: May 31, 2010
  • Posts: 1401

  Posted: Apr 08, 2008 - 11:50 AM

  mmh, I would have to try what it does in my install now. Hold on ...
  
  I tried on SVN version from last weekend. Install goed ok, only one remark about dir pnTemp/SendForm not existing. But the install goes ahead and succeeds. A good idea would be to use RC3 at least.
  
  
  
  edited by: espaan, Apr 09, 2008 - 12:55 AM
  
  --
  campertoday.nl, Module development, Dutch Zikula Community

  • 
  •  
• gudmann
  
  

  • Rank: Softmore
  • Registered: Mar 14, 2003
  • Last visit: Apr 19, 2010
  • Posts: 116

  Posted: Apr 08, 2008 - 12:10 PM

  Thanks for your effort.
  And thanks for sending me a link to the SendForm module.
  
  I will consider upgrading to RC3. Is it risky?

  • 
  •  
• espaan
  
  

  • Rank: Developer
  • Registered: Aug 23, 2003
  • Last visit: May 31, 2010
  • Posts: 1401

  Posted: Apr 08, 2008 - 12:41 PM

  You're running RC2, that's a Release Candidate already. In RC3 a lot of bugs have been resolved already. So IMO only benifcial. Release Candidates come without waranties off course.
  
  --
  campertoday.nl, Module development, Dutch Zikula Community

  • 
  •  
• gudmann
  
  

  • Rank: Softmore
  • Registered: Mar 14, 2003
  • Last visit: Apr 19, 2010
  • Posts: 116

  Posted: Apr 08, 2008 - 01:24 PM

  I upgraded to RC3. The site went down. After a few minutes with the heart pounding it went up and running with RC3. Sadly it didn´t change anything. The SendForm module still gives the same error.
  
  _PNC_DBCREATETABLEERROR - (users) - 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 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMES
  

  • 
  •  
• espaan
  
  

  • Rank: Developer
  • Registered: Aug 23, 2003
  • Last visit: May 31, 2010
  • Posts: 1401

  Posted: Apr 08, 2008 - 09:35 PM

  mmhh, strange. What version of MySQL and PHP are you running?
  I tested with PHP 5.2.3 and MySQL 5.0.19
  
  it's the DB creation piece of code that is executed in pninit.php that gives the error. Aparantly the ON UPDATE statement is not taken in.
  Do you have phpMyAdmin available for database access? You can try to get the database in there manually and see if it gives the same error:
  
  

  Code

  create table `pn_sendform` (
    `FormID` int(11) not null auto_increment,
    `Name` varchar(100) not null default '',
    `Subject` varchar(100) default null,
    `MaxField` tinyint(4) default null,
    `Recipient` varchar(250) default null,
    `CCMail` varchar(250) default null,
    `okPage` varchar(150) default null,
    `htmlPage` varchar(150) default null,
    `Charset` varchar(15) default null,
    `Format` varchar(2) default null,
    `FormType` char(1) default null,
    `FormName` varchar(150) default null,
    `SecurityType` char(1) default null,
    `SecurityAttr` varchar(255) default null,
    `date_add` timestamp not null default '0000-00-00 00:00:00',
    `date_mod` timestamp not null default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    primary key  (`FormID`)
  ) ENGINE=MyISAM default CHARSET=utf8 auto_increment=1 ;

  
  
  --
  campertoday.nl, Module development, Dutch Zikula Community

  • 
  •  
• gudmann
  
  

  • Rank: Softmore
  • Registered: Mar 14, 2003
  • Last visit: Apr 19, 2010
  • Posts: 116

  Posted: Apr 09, 2008 - 01:05 AM

  I am running on mysql-4.0.27. This code doesn´t work with older than MySql 5. Is there a way around this if updating to version 5 is not an option?

  • 
  •  
• espaan
  
  

  • Rank: Developer
  • Registered: Aug 23, 2003
  • Last visit: May 31, 2010
  • Posts: 1401

  Posted: Apr 09, 2008 - 02:47 AM

  The easiest way is to leave out the ON UPDATE statement. You should adapt pninit accordingly:
  

  Code

  `date_add` timestamp not null default '0000-00-00 00:00:00',
    `date_mod` timestamp not null default current_timestamp,
    primary key  (`FormID`)

  
  
  
  
  --
  campertoday.nl, Module development, Dutch Zikula Community

  • 
  •  
• larsneo
  
  

  • Rank: Software Foundation
  • Registered: Dec 31, 1969
  • Last visit: Oct 21, 2009
  • Posts: 3814

  Posted: Apr 09, 2008 - 02:56 AM

  "http://community.postnuke.com/Article2785.htm"

  Minimum MySQL and PHP versions
  
  The minimum version for MySQL has been raised to 4.1.x, due to some installer problems that are related to old 3.x databases. See also MySQL's lifetime philosophy at Planet MySQL. Due to security reasons, the recommended minimum PHP-version is at least 4.3.10.

  
  
  you should at the very least upgrade to the latest mysql 4.1.x build - mysql 4.0.x had various 'strange' issues and is completly deprecated.
  
  --
  regards from germany
  ..::[Zikula Application Framework]::.. ..::[SEO-Blog]::.. ..::[CMS Sicherheit]::..

  • 
  •  
• espaan
  
  

  • Rank: Developer
  • Registered: Aug 23, 2003
  • Last visit: May 31, 2010
  • Posts: 1401

  Posted: Apr 09, 2008 - 10:25 PM

  And do check out the update of Sendform 0.5.3 here
  
  --
  campertoday.nl, Module development, Dutch Zikula Community

  • 
  •  
•  
•  

Users on-line

• 0 users

This list is based on users active over the last 60 minutes.