• gudmann [15]
  
  

  • Rank: Softmore
  • Registered: 15.03.03
  • last visit: 30.03.09
  • Posts: 88

  [16] Posted: 08.04.2008, 23:27

  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?

  • [17]
  •   [18]
• espaan [20]
  
  

  • Rank: Professional
  • Registered: 24.08.03
  • Posts: 757

  [21] Posted: 08.04.2008, 23:50

  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
  
  --
  erikspaan.nl [22], avwijchen.nl [23]
  
  BlankTheme [24], News module [25], zikula.nl [26]

  • [27]
  •   [28]
• gudmann [30]
  
  

  • Rank: Softmore
  • Registered: 15.03.03
  • last visit: 30.03.09
  • Posts: 88

  [31] Posted: 09.04.2008, 00:10

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

  • [32]
  •   [33]
• espaan [35]
  
  

  • Rank: Professional
  • Registered: 24.08.03
  • Posts: 757

  [36] Posted: 09.04.2008, 00:41

  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.
  
  --
  erikspaan.nl [37], avwijchen.nl [38]
  
  BlankTheme [39], News module [40], zikula.nl [41]

  • [42]
  •   [43]
• gudmann [45]
  
  

  • Rank: Softmore
  • Registered: 15.03.03
  • last visit: 30.03.09
  • Posts: 88

  [46] Posted: 09.04.2008, 01:24

  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
  

  • [47]
  •   [48]
• espaan [50]
  
  

  • Rank: Professional
  • Registered: 24.08.03
  • Posts: 757

  [51] Posted: 09.04.2008, 09:35

  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 [52] 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 ;

  
  
  --
  erikspaan.nl [53], avwijchen.nl [54]
  
  BlankTheme [55], News module [56], zikula.nl [57]

  • [58]
  •   [59]
• gudmann [61]
  
  

  • Rank: Softmore
  • Registered: 15.03.03
  • last visit: 30.03.09
  • Posts: 88

  [62] Posted: 09.04.2008, 13:05

  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?

  • [63]
  •   [64]
• espaan [66]
  
  

  • Rank: Professional
  • Registered: 24.08.03
  • Posts: 757

  [67] Posted: 09.04.2008, 14:47

  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`)

  
  
  
  
  --
  erikspaan.nl [68], avwijchen.nl [69]
  
  BlankTheme [70], News module [71], zikula.nl [72]

  • [73]
  •   [74]
• larsneo [76]
  
  

  • Rank: Software Foundation
  • Registered: 31.12.69
  • last visit: 27.06.09
  • Posts: 4458

  [77] Posted: 09.04.2008, 14:56

  "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 [78]. 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 [79]]::.. ..::[SEO-Blog [80]]::.. ..::[CMS Sicherheit [81]]::..

  • [82]
  •   [83]
• espaan [85]
  
  

  • Rank: Professional
  • Registered: 24.08.03
  • Posts: 757

  [86] Posted: 10.04.2008, 10:25

  And do check out the update of Sendform 0.5.3 here [87]
  
  --
  erikspaan.nl [88], avwijchen.nl [89]
  
  BlankTheme [90], News module [91], zikula.nl [92]

  • [93]
  •   [94]
•  
•  

Users online

• Simon [97],
• Teb [98],
• craigh [99],
• espaan [100],
• shyra [101]

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