Upgrade > db problem :: Archived

sander · Posted: Tue Mar 22, 2005 2:49 pm Post subject: Upgrade > db problem

I just set up a duplicate of my site, so my users can use the site while I test the upgrade. Then I performed the instructions to upgrade my site. After I got to install.php, I click "build the database" the problem starts...

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

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

Does anyone has a idea what I am doing wrong or what is wrong? Smile

The url to the test site is:
http://sky.igeneration.info/kanaries/site_test
( not that it works Razz

)

Thanks in advance.

DJ Maze · Posted: Tue Mar 22, 2005 8:31 pm Post subject: Re: Upgrade > db problem

Upgrade from X to Y

but what is X and what is Y ???

sander · Posted: Thu Mar 24, 2005 7:55 am Post subject: Re: Upgrade > db problem

Sorry. Upgrade is from CPG-Nuke 8.2 to Dragonfly CMS 9.0.2.0

DJ Maze · Posted: Thu Mar 24, 2005 2:35 pm Post subject: Re: Upgrade > db problem

Strange since 8.2 has a field in cms_reviews that is named `rlanguage` and the installer tries to rename.

Can you post the original structure of your 8.2 table

sander · Posted: Thu Mar 24, 2005 3:52 pm Post subject: Re: Upgrade > db problem

Original table:

Code::

Field  Type Attributes Null Default Extra Action 
   id  int(10)   No    auto_increment              
   date  date   No  0000-00-00                
   title  varchar(150)   No                  
   text  text   No                  
   reviewer  varchar(20)   Yes  NULL                
   email  varchar(60)   Yes  NULL                
   score  int(10)   No  0                
   cover  varchar(100)   No                  
   url  varchar(100)   No                  
   url_title  varchar(50)   No                  
   hits  int(10)   No  0                
   rlanguage  varchar(30)   No

Table now:

Code::

 Field  Type Attributes Null Default Extra Action 
   id  int(10)   No    auto_increment              
   date  date   No  0000-00-00                
   title  varchar(150)   No                  
   text  text   No                  
   reviewer  varchar(20)   Yes  NULL                
   email  varchar(60)   Yes  NULL                
   score  int(10)   No  0                
   cover  varchar(100)   No                  
   url  varchar(100)   No                  
   url_title  varchar(50)   No                  
   hits  int(10)   No  0                
   language  varchar(30)   No

DJ Maze · Posted: Thu Mar 24, 2005 5:18 pm Post subject: Re: Upgrade > db problem

rename the field back to rlanguage and try the upgrader again

sander · Posted: Tue Mar 29, 2005 1:29 pm Post subject: Re: Upgrade > db problem

Thanks, that did it Smile