Freshman
Posts: 25
Posted:
4.Sep 2006 - 16:44
well what should i say - ive got terrrible probs with frehs install of 0762 - grabbed from here http://noc.postnuke.com/frs/?group_id=5&release_id=701
either - via install-script and via manual install process (that means DB install via phpMyAdmin by hand)i ve got terrrbile issues. Note; i run php4xx and Mysql 5xx
eg. i run into troubles: what is this?`!
INSERT INTO `pn_module_vars`
VALUES ( 102, '/PNConfig', 'safehtml', 's:1:"1";' ) ;
MySQL meldet: #1062 - Duplicate entry '102' for key 1
hmmm module_vars is a very very important table isnt it!? WEll if i install or better
create this on my mysql 5 then i get 102 lines . is this correct. But i get this ugliy ugly errror. What does that mean...!?
in general: can i continue running and installing the PostNuke - even if i get this message again and again - BTW; what have to look after if i install it manually - that is _without_ any auto installer via browser.
Well if i run the installerscript via bbrowser then i get errors the installation of the DB fails - often there were 12 or 20 or (max 32 ) tables chreatet not more:; What is this:
do i have to look after the settings of my MySQL server or after the setttings of the PHP!?
BTW.- whole server is brand new -
mysql 5xx and PHP 4.xx
what do you think!?!
cheers yours
charles
Software Foundation
Posts: 4482
Posted:
4.Sep 2006 - 16:59
Quote
what do you think!?!
i'd recommend to use the latest php5 version in combination with the latest mysql4 DB-backend (or if using mysql5 strictmode=off) for stabilitity reasons.
regarding the SQL-dump: please use the *updated dump* from our SVN.
--
regards from germany
..::[Zikula Application Framework]::.. ..::[SEO-Blog]::.. ..::[CMS Sicherheit]::..
Freshman
Posts: 25
Posted:
4.Sep 2006 - 18:04
Quote
i'd recommend to use the latest php5 version in combination with the latest
mysql4 DB-backend (or if using mysql5 strictmode=off) for stabilitity reasons.
regarding the SQL-dump: please use the *updated dump* from our SVN.
regards from germany
thx - running mysql 5.
and some curious phenomenons occur while installing PN
1. either manually or automatically
to begin with some of them;
first of all - it looks somewhat strange that some tables are in InnoDB- and some are in MyISAM-type.
second: if i install manually then the insert of the DB-dump gives back some errors -, very often in the
table module_vars --... see above..
Quote
102 /PNConfig pnAntiCracker s:1:"1";
is it normal that the module_vars has only 102 entries? Or does this tabel have more entries.?
charles
Freshman
Posts: 25
Posted:
4.Sep 2006 - 18:13
again me,
some more issues are the following
when trying to install manually the dump you recommended this ends up in only creating 4 tables
Freshman
Posts: 25
Posted:
4.Sep 2006 - 18:17
some more issues are the following
when trying to install manually the dump you recommended this ends up in only creating 4 tables
Quote
INSERT INTO `pn_blocks`
VALUES ( 2, 'menu', 'Incoming',
'style:=1\ndisplaymodules:=0\ndisplaywaiting:=1\ncontent:=', '', 0, 'l',
'2.0', 1, 0, '0000-00-00 00:00:00', '', 1, 1 ) ;
MySQL meldet:
#1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'pn_last_update' at row 1
-after creating 4 tables the thing stops.
Note; this was created with the dump you recommended me above
well i guess that there were some issues with teh mysl database that runs ver. 5.
Humm; perhaps i can continue to install and create the missing tables by hand. But i am not sure taht this will get finally better resoults
i am very sure taht teh DB needs some more configurations and setups since this is running in version 5 and all is very very raw configured. Teh DB must be configured more, doesnt´tit
ideas?`
Freshman
Posts: 25
Posted:
4.Sep 2006 - 18:28
the stuff has more tables here
INSERT INTO `pn_module_vars` VALUES (102, '/PNConfig', 'idnnames', 'i:0;');
INSERT INTO `pn_module_vars` VALUES (103, '/PNConfig', 'reg_allowreg', 's:1:"1";');
INSERT INTO `pn_module_vars` VALUES (104, '/PNConfig', 'reg_verifyemail', 's:1:"1";');
INSERT INTO `pn_module_vars` VALUES (105, '/PNConfig', 'reg_Illegalusername', 's:87:"root adm linux webmaster admin god administrator administrador nobody anonymous anonimo";');
INSERT INTO `pn_module_vars` VALUES (106, '/PNConfig', 'reg_noregreasons', 's:45:"Sorry, registration is disabled at this time.";');
INSERT INTO `pn_module_vars` VALUES (107, '/PNConfig', 'loadlegacy', 'i:0;');
INSERT INTO `pn_module_vars` VALUES (108, '/PNConfig', 'newspager', 'i:0;');
INSERT INTO `pn_module_vars` VALUES (109, 'pnrender', 'compile_check', '1');
INSERT INTO `pn_module_vars` VALUES (110, 'pnrender', 'force_compile', '');
INSERT INTO `pn_module_vars` VALUES (111, 'pnrender', 'cache', '');
INSERT INTO `pn_module_vars` VALUES (112, 'pnrender', 'expose_template', '');
INSERT INTO `pn_module_vars` VALUES (113, 'pnrender', 'lifetime', '3600');
INSERT INTO `pn_module_vars` VALUES (114, 'Xanthia', 'rootpath', 'modules');
INSERT INTO `pn_module_vars` VALUES (115, 'Xanthia', 'vba', '0');
INSERT INTO `pn_module_vars` VALUES (116, 'Xanthia', 'enablecache', '0');
INSERT INTO `pn_module_vars` VALUES (117, 'Xanthia', 'modulesnocache', '');
INSERT INTO `pn_module_vars` VALUES (118, 'Xanthia', 'db_cache', '0');
INSERT INTO `pn_module_vars` VALUES (119, 'Xanthia', 'db_compile', '0');
INSERT INTO `pn_module_vars` VALUES (120, 'Xanthia', 'compile_check', '0');
INSERT INTO `pn_module_vars` VALUES (121, 'Xanthia', 'use_db', '0');
INSERT INTO `pn_module_vars` VALUES (122, 'Xanthia', 'cache_lifetime', '3600');
INSERT INTO `pn_module_vars` VALUES (123, 'Xanthia', 'db_templates', '0');
INSERT INTO `pn_module_vars` VALUES (124, 'Xanthia', 'block_control', '0');
INSERT INTO `pn_module_vars` VALUES (125, 'Xanthia', 'TopCenter', '0');
INSERT INTO `pn_module_vars` VALUES (126, 'Xanthia', 'BotCenter', '0');
INSERT INTO `pn_module_vars` VALUES (127, 'Xanthia', 'InnerBlock', '0');
INSERT INTO `pn_module_vars` VALUES (128, 'Xanthia', 'shorturls', '0');
INSERT INTO `pn_module_vars` VALUES (129, 'Xanthia', 'shorturlsextension', 'HTML');
INSERT INTO `pn_module_vars` VALUES (130, 'Xanthia', 'shorturlsok', '1');
INSERT INTO `pn_module_vars` VALUES (131, 'Admin_Messages', 'itemsperpage', '25');
INSERT INTO `pn_module_vars` VALUES (132, 'Mailer', 'mailertype', '1');
INSERT INTO `pn_module_vars` VALUES (133, 'Mailer', 'charset', 'iso-8859-1');
INSERT INTO `pn_module_vars` VALUES (134, 'Mailer', 'encoding', '8bit');
INSERT INTO `pn_module_vars` VALUES (135, 'Mailer', 'contenttype', 'text/plain');
INSERT INTO `pn_module_vars` VALUES (136, 'Mailer', 'wordwrap', '50');
INSERT INTO `pn_module_vars` VALUES (137, 'Mailer', 'msmailheaders', '');
INSERT INTO `pn_module_vars` VALUES (138, 'Mailer', 'sendmailpath', '/usr/sbin/sendmail');
INSERT INTO `pn_module_vars` VALUES (139, 'Mailer', 'smtpauth', '1');
INSERT INTO `pn_module_vars` VALUES (140, 'Mailer', 'smtpserver', 'localhost');
INSERT INTO `pn_module_vars` VALUES (141, 'Mailer', 'smtpport', '25');
INSERT INTO `pn_module_vars` VALUES (142, 'Mailer', 'smtptimeout', '10');
INSERT INTO `pn_module_vars` VALUES (143, 'Mailer', 'smtpusername', '');
INSERT INTO `pn_module_vars` VALUES (144, 'Mailer', 'smtppassword', '');
INSERT INTO `pn_module_vars` VALUES (145, 'legal', 'termsofuse', '1');
INSERT INTO `pn_module_vars` VALUES (146, 'legal', 'privacypolicy', '1');
INSERT INTO `pn_module_vars` VALUES (147, 'legal', 'accessibilitystatement', '1');
ideas whi it sutps on the table 102 ?
chers
-c
Freshman
Posts: 25
Posted:
4.Sep 2006 - 18:32
well, guess that it has todo with the time and timestamp and timeconfiguration things
gotta look here:
Quote
pn_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`pn_topic` varchar( 20 ) NOT NULL default '',
`pn_language` varchar( 30 ) NOT NULL default '',
`pn_bodytext` text,
PRIMARY KEY ( `pn_qid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;
MySQL meldet:
#1067 - Invalid default value for 'pn_timestamp'
well gotta look after the myslqdb- configutation inver 5-. everytimy we have issues with the time nes pas,
-c
online
Steering Committee
Posts: 13427
Posted:
4.Sep 2006 - 21:24
--
Regards,
Simon
itbegins.co.uk - Zikula Consulting
Please read the Support Guide
Freshman
Posts: 25
Posted:
4.Sep 2006 - 23:09
gonna look at the mysqldb.
dive into the mysqlserver later tonight since i am heading for work now. After the strict-mode workaround in MySQL i will have a look at the behaviour of PostNuke.
-cb