Error when installing the SendForm module :: Zikula Community

Start [1]
Search [2]
latest posts [3]
RSS [4]
Login [5]
Register [6]

[10]
Print topic [11]
[12]

Start [13] ::
Extensions and Distributions Support [14] ::
Modules [15] ::
Error when installing the SendForm module

Moderated by:
Support [16]

[17]

Error when installing the SendForm module

[18]Posted: 09.04.2008, 04:27

[19]

rank:

Freshman

registered:

March 2003

Status:

offline

last visit:

28.09.08

Posts:

48

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?
[20]
- notify mod [21]
[23]Posted: 09.04.2008, 04:50

[24]

rank:

Helper

registered:

August 2003

Status:

offline

last visit:

01.12.08

Posts:

468

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 [25], StoriesExt, Menu templates, SmugView and zikula.nl
[26]
- notify mod [27]
[29]Posted: 09.04.2008, 05:10

[30]

rank:

Freshman

registered:

March 2003

Status:

offline

last visit:

28.09.08

Posts:

48

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

I will consider upgrading to RC3. Is it risky?
[31]
- notify mod [32]
[34]Posted: 09.04.2008, 05:41

[35]

rank:

Helper

registered:

August 2003

Status:

offline

last visit:

01.12.08

Posts:

468

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 [36], StoriesExt, Menu templates, SmugView and zikula.nl
[37]
- notify mod [38]
[40]Posted: 09.04.2008, 06:24

[41]

rank:

Freshman

registered:

March 2003

Status:

offline

last visit:

28.09.08

Posts:

48

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
[42]
- notify mod [43]
[45]Posted: 09.04.2008, 14:35

[46]

rank:

Helper

registered:

August 2003

Status:

offline

last visit:

01.12.08

Posts:

468

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 [47] 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 [48], StoriesExt, Menu templates, SmugView and zikula.nl
[49]
- notify mod [50]
[52]Posted: 09.04.2008, 18:05

[53]

rank:

Freshman

registered:

March 2003

Status:

offline

last visit:

28.09.08

Posts:

48

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?
[54]
- notify mod [55]
[57]Posted: 09.04.2008, 19:47

[58]

rank:

Helper

registered:

August 2003

Status:

offline

last visit:

01.12.08

Posts:

468

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 [59], StoriesExt, Menu templates, SmugView and zikula.nl
[60]
- notify mod [61]
[63]Posted: 09.04.2008, 19:56

[64]

rank:

Software Foundation

registered:

December 1969

Status:

offline

last visit:

15.11.08

Posts:

4481

"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 [65]. 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 [66]]::.. ..::[SEO-Blog [67]]::.. ..::[CMS Sicherheit [68]]::..
[69]
- notify mod [70]
[72]Posted: 10.04.2008, 15:25

[73]

rank:

Helper

registered:

August 2003

Status:

offline

last visit:

01.12.08

Posts:

468

And do check out the update of Sendform 0.5.3 here [74]

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

Involved in: BlankTheme [75], StoriesExt, Menu templates, SmugView and zikula.nl
[76]
- notify mod [77]

Users online:

AllKnightAccess [79],
Petzi-Juist [80],
Topiatic [81],
gf [82],
hilope [83],
philipp2 [84],
rgasch [85],
shoshia [86],
ukracer [87]

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

Code

Code

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