Dizkus

hi there

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

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

hi



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..




is it normal that the module_vars has only 102 entries? Or does this tabel have more entries.?


charles

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

some more issues are the following

when trying to install manually the dump you recommended this ends up in only creating 4 tables




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

hummm

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

gain charles,

well, guess that it has todo with the time and timestamp and timeconfiguration things
gotta look here:



well gotta look after the myslqdb- configutation inver 5-. everytimy we have issues with the time nes pas,

-c

Have you turned off strict mode in MySQL? That is what generates those errors.

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

hi

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