Error when installing the SendForm module :: Zikula Community

Start

latest posts

RSS

Print topic

Start :: Extensions and Distributions Support :: Modules :: Error when installing the SendForm module

Moderated by: Support Team

Error when installing the SendForm module

Posted: 09.04.2008, 04:27

rank:

Freshman

registered:

March 2003

Status:

offline

last visit:

09.04.08

Posts:

33

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?

notify mod
Posted: 09.04.2008, 04:50

rank:

Helper

registered:

August 2003

Status:

offline

last visit:

02.09.08

Posts:

394

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

-----
http://www.erikspaan.nl
http://www.avwijchen.nl

Involved in: BlankTheme, StoriesExt, Menu templates, SmugView, ValueAddon News and zikula.nl

notify mod
Posted: 09.04.2008, 05:10

rank:

Freshman

registered:

March 2003

Status:

offline

last visit:

09.04.08

Posts:

33

Thanks for your effort.
And thanks for sending me a link to the SendForm module.

I will consider upgrading to RC3. Is it risky?

notify mod
Posted: 09.04.2008, 05:41

rank:

Helper

registered:

August 2003

Status:

offline

last visit:

02.09.08

Posts:

394

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.

-----
http://www.erikspaan.nl
http://www.avwijchen.nl

Involved in: BlankTheme, StoriesExt, Menu templates, SmugView, ValueAddon News and zikula.nl

notify mod
Posted: 09.04.2008, 06:24

rank:

Freshman

registered:

March 2003

Status:

offline

last visit:

09.04.08

Posts:

33

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

notify mod

Posted: 09.04.2008, 14:35

rank:: Helper
registered:: August 2003
Status:: offline
last visit:: 02.09.08
Posts:: 394

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 ;

-----
http://www.erikspaan.nl
http://www.avwijchen.nl

Involved in: BlankTheme, StoriesExt, Menu templates, SmugView, ValueAddon News and zikula.nl

notify mod

Posted: 09.04.2008, 18:05

rank:

Freshman

registered:

March 2003

Status:

offline

last visit:

09.04.08

Posts:

33

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?

notify mod
Posted: 09.04.2008, 19:47
rank:

Helper

registered:

August 2003

Status:

offline

last visit:

02.09.08

Posts:

394
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`)
-----
http://www.erikspaan.nl
http://www.avwijchen.nl

Involved in: BlankTheme, StoriesExt, Menu templates, SmugView, ValueAddon News and zikula.nl
notify mod
Posted: 09.04.2008, 19:56

rank:

Software Foundation

registered:

Status:

offline

last visit:

31.08.08

Posts:

4474

"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]::..

notify mod
Posted: 10.04.2008, 15:25

rank:

Helper

registered:

August 2003

Status:

offline

last visit:

02.09.08

Posts:

394

And do check out the update of Sendform 0.5.3 here

-----
http://www.erikspaan.nl
http://www.avwijchen.nl

Involved in: BlankTheme, StoriesExt, Menu templates, SmugView, ValueAddon News and zikula.nl

notify mod

Start :: Extensions and Distributions Support :: Modules :: Error when installing the SendForm module

Support Forum

Main Menu

Extensions Database

Documentation

Development

Login

Donate to Zikula