9.0.2.0 already installed? :: Archived

Nopeace4u · Posted: Sun Mar 27, 2005 3:56 am Post subject: 9.0.2.0 already installed?

I tried upgrading one of my sites & thought everything was fine till i saw i was missing some new sql tables and realized when i run the 9.0.2.0 install file i get the message its already installed but never was. Anyone else have this problem?

rick_deckard · Nice poster Offline Joined: Mar 12, 2005 Posts: 73

New tables? Hmmm I didn't notice that.

Personally, I would prefer it if incremental upgrades like this just had an SQL dump file so I could just compare it to the structure of the current DB and make changes that way.

As it is now, to upgrade from 9.0.1. to 9.0.2 I have to run the install script I think, which I prefer not to do. I suppose I'm in the minority though.

Slammer · Posted: Fri Apr 01, 2005 1:31 am Post subject: Re: 9.0.2.0 already installed?

I am having this problem and it has shut my site down! I am upgrading from 8.2b, I uploaded all the files, set the permissions as in the instructions, then go to install.php. I got the "agreement" page, then it went to "We're glad you made the decision to use Dragonfly 9.0.2.0 You already have Dragonfly 9.0.2.0 installed." which I do not, The sql process never happened. index.php and admin.php simply send me back to install.php! And the circle continues! HELP!

Slammer

Slammer · Posted: Fri Apr 01, 2005 1:57 am Post subject: Re: 9.0.2.0 already installed?

Okay, I have searched this forum for 90 minutes now. Nuttin. Guess I am down until tomorrow.

Grrrrrrrrrrrrr

DJ Maze · Posted: Fri Apr 01, 2005 2:03 am Post subject: Re: 9.0.2.0 already installed?

You have cms_config_custom table ?
Does the table contain a entry: global | Version_Num
and what does that entry say ?

Slammer · Posted: Fri Apr 01, 2005 2:29 pm Post subject: Re: 9.0.2.0 already installed?

It had 9.0.2.0, so I deleted the cms_config_custom table assuming that install.php would write it. I ran install.php and it started the install, but very quickly came to this:

Code::

ALTER TABLE cms__pages CHANGE `clanguage` `language` varchar(30) NOT NULL DEFAULT ""
Unknown column 'clanguage' in 'cms__pages'

Please contact the CPG-Nuke Dev Team about the error
You cannot continue with the installation

Slammer

P.S. Please kill the April Fools day falling avatars Wink

Slammer · Posted: Fri Apr 01, 2005 6:07 pm Post subject: Re: 9.0.2.0 already installed?

I got it to suposedly "install" now, but I don't think it has done anything, well nothing good anyway. I am guessing that there are some conflicts with blocks and modules I had installed on my 8.2, but I assumed that the 9.0.2.0 upgrade would automatically set things to a working default of some sort. This is Exactly the reason why I was afraid of this upgrade. My site has been down for 17 hours now. Sure wish I could get some help. Here are the latest error messages when logging in to admin.php

Code::

 includes/db/db.php
CMS Warning line 51: On /nuke/admin.php While executing query "INSERT INTO cms__modules VALUES (NULL, 'Tell_a_Friend', 'Tell_a_Friend', '0', '0', '1', '0', '0')" the following error occured: Column count doesn't match value count at row 1 In: /home/retro/public_html/nuke/blocks/block-Sommaire.php on line: 798

Can somebody please give me some kind of direction here?

Slammer

Slammer · Posted: Fri Apr 01, 2005 6:13 pm Post subject: Re: 9.0.2.0 already installed?

I have set up a working fresh install on my server with ZERO problems. How about some guidance on moving my existing data over to this working fresh install?

Slammer

xfsunoles · Posted: Fri Apr 01, 2005 6:43 pm Post subject: Re: 9.0.2.0 already installed?

i see, you trying to use Sommaire block in 9x. please use CPG Main Menu block instead Sommaire block.

Slammer · Posted: Fri Apr 01, 2005 6:53 pm Post subject: Re: 9.0.2.0 already installed?

xfsunoles wrote:

i see, you trying to use Sommaire block in 9x. please use CPG Main Menu block instead Sommaire block.

I would love to do that if somebody can tell me how to do it since I cannot get into admin.php

Thanks,

Slammer

xfsunoles · Posted: Fri Apr 01, 2005 7:46 pm Post subject: Re: 9.0.2.0 already installed?

Slammer wrote:

xfsunoles wrote:

i see, you trying to use Sommaire block in 9x. please use CPG Main Menu block instead Sommaire block.

I would love to do that if somebody can tell me how to do it since I cannot get into admin.php

Thanks,

Slammer

admin.php?hideallblocks

it such it so handy feature Laughing

Slammer · Posted: Fri Apr 01, 2005 8:09 pm Post subject: Re: 9.0.2.0 already installed?

xfsunoles wrote:

Slammer wrote:

xfsunoles wrote:

i see, you trying to use Sommaire block in 9x. please use CPG Main Menu block instead Sommaire block.

I would love to do that if somebody can tell me how to do it since I cannot get into admin.php

Thanks,

Slammer

admin.php?hideallblocks

it such it so handy feature Laughing

Kool, Nice trick...

That did get me to the main admin menu, but I still cannot navigate through it. how can I keep the blocks hidden when I go to /admin.php?op=blocks ?

Slammer

Slammer · Posted: Fri Apr 01, 2005 8:18 pm Post subject: Re: 9.0.2.0 already installed?

My site has been down 21 hours now. I am willing to take bad advise at this point. I HAVE to get the site back up.

ANYBODY?????

Slammer

NEMINI · Diamond Supporter Offline Joined: Apr 22, 2004 Posts: 4551

go into your database and turn the module off.

Slammer · Posted: Fri Apr 01, 2005 8:34 pm Post subject: Re: 9.0.2.0 already installed?

I am sorry, I am not an SQL guru. If I knew where in my database to go to turn it off, I would have done so long ago. Which table is this setting in? I dropped the whole Sommaire tables and now get:

Code::

CMS Warning line 51: On /nuke/admin.php?op=cpgmm While executing query "SELECT invisible FROM cms__sommaire LIMIT 1" the following error occured: Table 'retro_worldwideretronet.cms__sommaire' doesn't exist In: /home/retro/public_html/nuke/blocks/block-Sommaire.php on line: 45

I am sure this is all quite obvious to you if you speak the language. I do not. I run the install scripts and assume they will work.

Slammer