search pnForum
latest posts
Register
Root :: Developments :: Others :: db-issues: fresh install of 0762 fails on mysql ver 5xx [is this normal?]
Moderated by:
 |
db-issues: fresh install of 0762 fails on mysql ver 5xx [is this normal?] | |
|---|---|---|
| MulinRogue | Posted: 04.09.2006, 12:17 | |
Noob
registered: Aug 29, 2006
Posts: 7
Status: offline last visit: 04.09.06 |
hi there again mulin - 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. btw.- whole server is brand new - mysql 5xx and php 4.xx what do you think!?! cheers yours mullin  [perhaps the biggest lover of the great windmill in paris the famous red windmill where so many nice people met each other ] |
|
|
|
|
| Chestnut | Posted: 04.09.2006, 16:18 | |
Site Admin
registered: Jun 02, 2002
Posts: 1320
Status: offline last visit: 07.02.08 |
That you should NOT spam my forums with the same message twice. That's a mood killer and I banned people from here for less. YARRR... as some would say. That said... The "Duplicate entry" error is clear enough that there is a duplicate in the manual SQL file. It was fixed in the SVN but as we did not released yet a fixed packaged, that is what you get in the official. The fixed sql file can be found HERE As to why the installer fails, if the DB does not exists, the user trying to create the Database might not have the right to do it. Usually, people create the database via phpMyAdmin and uncheck the "Create database" option when installing. For any other error, a little lack of information to give a more appropriate answer. I urge you to go check http://community.postnuke.com as it is the place where you'll get faster help and where all the answer is. While pnConcept is sometimes generalist, Community.PostNuke.com is THA site ! Probably some people who had the same problems you have there. Chestnut !  Site Admin |
|
|
|
|
|
| MulinRogue | Posted: 04.09.2006, 17:11 | |
|
Noob
registered: Aug 29, 2006
Posts: 7
Status: offline last visit: 04.09.06 |
Hya Chestnut many thanks for posting. I understand that you recommended me the site over at postnuke.com http://community.postnuke.com as it is the place where you'll get faster help and where all the answer is. You are right: But as i am a Francophile i love the Eiffel-tower. And i am pretty sure that this forum is closer to the Eiffel-Tower - nest pas? as i love Paris and France - i love to post here btw.- whole server is brand new - mysql 5xx and php 4.xx and some curious phenomenons occur while installing pn 1. either manually or automatically i have errors all the way... 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.. 102 /PNConfig pnAntiCracker s:1:"1"; is it normal that the module_vars has only 102 entries? Or does this tabel have more entries.? 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 the manual creation process ends up wiht a mess: after creating only 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. The db must be configured more, doesnt´tit What do you think about this Chestnut!? When installing the db manually i run into errors - eg in the module_vars table the stuff has more tables here -------------- EDITED BY C ! -------------- ideas whi it sutps on the table 102? The installment stops with this - that means the damned mysql db only installs up to line 102 in the table module_vars. What can this be!? Chestnut do you have any clue!?! MySQL tells #1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'pn_last_update' at row 1 Chestnut what can this be? Is this a configuraton issue of the MySQL database -that runs in a raw confguration...... Pleas lemme know what you tink. many greetings to the Eiffel tower... Mullin |
|
|
|
|
|
| MulinRogue | Posted: 04.09.2006, 21:09 | |
|
Noob
registered: Aug 29, 2006
Posts: 7
Status: offline last visit: 04.09.06 |
cheers guys found something useful for the bloddy strict mode in mysql http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html 5.2.5. The Server SQL Mode The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients. This capability enables each application to tailor the server's operating mode to its own requirements. Modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. that is pretty hard stuff nes pas cheers mr |
|
|
|
|
|
| Teb | Posted: 06.09.2006, 00:41 | |
|
Noob
registered: Aug 17, 2006
Posts: 2
Status: offline last visit: 06.09.06 |
So the name 'MulinRogue', 'CharlesBarrillea', Flobee, all the same person? As soon as I see someone talking about 'issues', I start shaking... and yes... here we are again. http://community.postnuke.com/module-Forum-viewtopic-topic-48954-start-15.htm#pid208040 http://community.postnuke.com/module-Forum-viewtopic-topic-48954-start-15.htm#pid208115 http://community.postnuke.com/module-Forum-viewtopic-topic-50218.htm Let's not discuss about the issues  |
|
|
|
|
|
| Chestnut | Posted: 06.09.2006, 00:51 | |
|
Site Admin
registered: Jun 02, 2002
Posts: 1320
Status: offline last visit: 07.02.08 |
Gnngnnn... grrummmpff... For the record and only because I'm a good guy: Mulin... I already answered your question about the duplicate. Read above. For the unrecord, while I am happy you love France and Paris, know that buttering my forum about how you loved the Eiffel tower or the tits of the girls at the Moulin Rouge (that I wonder if you ever saw elsewhere than on TV) in every damn posts you write won't get you anywhere. (Get a grip of yourself will ya ?) Any further help with PostNuke is to be asked at PostNuke.com (althoughI have this strange feeling that...... nevermind). Anyway ! Thanks Teb for passing by ! Chestnut ! Site Admin |
|
|
|
|
|
| Teb | Posted: 06.09.2006, 01:44 | |
|
Noob
registered: Aug 17, 2006
Posts: 2
Status: offline last visit: 06.09.06 |
Happy to save a French ass. Last mail I received: nana, you think your Eiffel tower is beautiful right? We've got our bigbig cities and lovely countryside! Who needs Moulin Rouge tits anyway!  My module? Another Amazon module?  So far OT. Cheers ;) |
|
|
|
|
|
Powered by pnForum Version 2.0.1