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?
Forum Activity
- Fundraising system/module on Mar 19
- Upgrade Old Postnuke Site on Mar 18
- login hook on Mar 18
- Delete user not working on Mar 18
- 2 sites 1 database on Mar 18
- Output on Mar 18
- how to change the format of shorturls on Mar 17
Zikula Blog
- How to Become a HipHop Fan on Feb 03
- HTML5 on Feb 02
- Support Free Software on Jan 22
- Module Files available on Dec 13
- Why I love Zikula (Reason #768) on Nov 11
- Theme Creator? on Nov 08
- Time to Embrace PHP 5 on Nov 08
Login
Error when installing the SendForm module
-
-
- Rank: Professional
- Registered: 23.08.03
- last visit: 14.03.10
- Posts: 1068
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
--
campertoday.nl, erikspaan.nl
Dutch Zikula Community -
- Rank: Helper
- Registered: 14.03.03
- last visit: 19.02.10
- Posts: 104
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? -
- Rank: Professional
- Registered: 23.08.03
- last visit: 14.03.10
- Posts: 1068
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.
--
campertoday.nl, erikspaan.nl
Dutch Zikula Community -
- Rank: Helper
- Registered: 14.03.03
- last visit: 19.02.10
- Posts: 104
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
-
- Rank: Professional
- Registered: 23.08.03
- last visit: 14.03.10
- Posts: 1068
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 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, erikspaan.nl
Dutch Zikula Community -
- Rank: Helper
- Registered: 14.03.03
- last visit: 19.02.10
- Posts: 104
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? -
- Rank: Professional
- Registered: 23.08.03
- last visit: 14.03.10
- Posts: 1068
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`)
--
campertoday.nl, erikspaan.nl
Dutch Zikula Community -
- Rank: Software Foundation
- Registered: 31.12.69
- last visit: 21.10.09
- Posts: 3815
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. 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]::.. -
- Rank: Professional
- Registered: 23.08.03
- last visit: 14.03.10
- Posts: 1068
Posted: 10.04.2008, 10:25
And do check out the update of Sendform 0.5.3
here
--
campertoday.nl, erikspaan.nl
Dutch Zikula Community
- Moderated by :
- Support
