Home Private Messages Search
CPG Dragonfly™ CMS stopsoftwarepatents.eu petition banner
Toggle Content
 
Forums ⇒ DragonflyCMS ⇒ Switch from PHP-Nuke :: Archives ⇒ Trouble upgrading from 7.8 to 9.1.1. - Unknown column? :: Archived


Trouble upgrading from 7.8 to 9.1.1. - Unknown column? :: Archived


Topic Archived View previous topic :: View next topic  
Author Message
oceana
Newbie
Newbie

Offline Offline
Joined: Jun 04, 2006
Posts: 38
Location: Norway
PostPosted: Wed Jan 31, 2007 11:39 pm
Post subject: Trouble upgrading from 7.8 to 9.1.1. - Unknown column?

Hello, I've been trying to upgrade to 9.1.1. for some time now...
I've run into a lot of trouble, as I had an old PHP-nuke install, which was upgraded to 7.8 today.

After that, I started upgrading to 9.1.1...
But I've run into trouble...

During install, i got a lot of questions relating to tables in nuke_users, which it tried to drop from the SQL, but no success...The tables did not exist...
Well, I created them to make the installer continue, but got a new error:

"UPDATE nuke_modules SET uninstall=1 WHERE title='coppermine'
Unknown column 'uninstall' in 'field list'
Please contact the CPG-Nuke Dev Team about the error
You cannot continue with the installation"

Any ideas whats wrong?

The Coppermine folders turned yellow during initial installation, but I din't bother to perform the CHMOD...
I'm too tired to start debuging, I admit it...Just hoping someone else has a clever explanation on this one...


oceana's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FreeBSD/1.3.31//4.3.11/
Back to top
View user's profile Visit poster's website
Phoenix
• Many Posts •
• Many Posts •

Offline Offline
Joined: Apr 19, 2004
Posts: 8799
Location: Netizen
PostPosted: Wed Jan 31, 2007 11:43 pm
Post subject: Re: Trouble upgrading from 7.8 to 9.1.1. - Unknown column?

This may be of interest.
dragonflycms.org/Forum...18108.html

In fact, you will probably get a better result if you upgrade 7.8 with the current CVS snapshot, soon to be 9.1.1.1 (7.8 was not yet supported)
dragonflycms.org/Downl.../id=7.html

_________________
DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website Photo Gallery
sarah
Debugger
Debugger

Offline Offline
Joined: Mar 25, 2005
Posts: 2130

PostPosted: Wed Jan 31, 2007 11:44 pm
Post subject: Re: Trouble upgrading from 7.8 to 9.1.1. - Unknown column?

You can try adding that column manually

Code::
ALTER TABLE `nuke_modules` (
ADD `uninstall` tinyint(4) NOT NULL default '0';

_________________
Diagon Alley - Top Design

sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1
Back to top
View user's profile Send e-mail Visit poster's website
oceana
Newbie
Newbie

Offline Offline
Joined: Jun 04, 2006
Posts: 38
Location: Norway
PostPosted: Wed Jan 31, 2007 11:50 pm
Post subject: Re: Trouble upgrading from 7.8 to 9.1.1. - Unknown column?

Thanks to both of you, I will try this in the morning ! Smile
I knew I could count on you to help me out Smile
Time for some zZz....


oceana's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FreeBSD/1.3.31//4.3.11/
Back to top
View user's profile Visit poster's website
oceana
Newbie
Newbie

Offline Offline
Joined: Jun 04, 2006
Posts: 38
Location: Norway
PostPosted: Thu Feb 01, 2007 4:16 pm
Post subject: Re: Trouble upgrading from 7.8 to 9.1.1. - Unknown column?

Still a lot of issues, I'll give the CVS a go...Hopefully not a too painfull experience... Wink


oceana's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FreeBSD/1.3.31//4.3.11/
Back to top
View user's profile Visit poster's website
oceana
Newbie
Newbie

Offline Offline
Joined: Jun 04, 2006
Posts: 38
Location: Norway
PostPosted: Thu Feb 01, 2007 5:29 pm
Post subject: Re: Trouble upgrading from 7.8 to 9.1.1. - Unknown column?

Sarah: I tried adding the column, but still problems...
So far, it has requested these tables:
nuke_users
-> popmeson
-> user_theme
-> user_regdate_cp

nuke_referer
-> rid
nuke_topics
-> topicname

I will it another go later this evening.


oceana's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FreeBSD/1.3.31//4.3.11/
Back to top
View user's profile Visit poster's website
oceana
Newbie
Newbie

Offline Offline
Joined: Jun 04, 2006
Posts: 38
Location: Norway
PostPosted: Thu Feb 01, 2007 8:59 pm
Post subject: Re: Trouble upgrading from 7.8 to 9.1.1. - Unknown column?

The latest error displayed:
"On /install.php
While executing query "ALTER TABLE nuke_pages CHANGE clanguage language varchar(30) NOT NULL DEFAULT ''"

the following error occured: Unknown column 'clanguage' in 'nuke_pages'

In: /home/sites/hpbk.org/www/includes/classes/installer.php on line: 111"

This was after I had put in the different tables that were missing, as well as the table mentioned by Sarah.

Will continue to try and work around it and post here...


oceana's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FreeBSD/1.3.31//4.3.11/
Back to top
View user's profile Visit poster's website
oceana
Newbie
Newbie

Offline Offline
Joined: Jun 04, 2006
Posts: 38
Location: Norway
PostPosted: Thu Feb 01, 2007 9:09 pm
Post subject: Re: Trouble upgrading from 7.8 to 9.1.1. - Unknown column?

(Isn't there an edit post option here somewhere?)

I looked at the error, and it seems the installer looks for the "clanguage" table, but it is named "language" in the DB...
I tried renaming the table to clanguage, and the installer continued, but halted on the same line, same thing here...Another name that doesn't match...

Ideas? Think I will put my page back up unntil the 9.1.1.1 comes out...


oceana's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FreeBSD/1.3.31//4.3.11/
Back to top
View user's profile Visit poster's website
Display posts from previous:   
All times are GMT

Archive Revive
Username:
This is an archived topic - your reply will not be appended here.
Instead, a new topic will be generated in the active forum.
The new topic will provide a reference link to this archived topic.
 
   Toggle Content User Info

Welcome Anonymous

Nickname
Password
(Register)

   Toggle Content Last CVS commits
· Fixed .ico Expires header.
· Removed domain name from cookies so subdomains wont access them anymore.
· CSS and JS, case insensitives.
· CSS and JS, send correct HTTP 1.1 headers and fixed issues where themes and...
· Further security class improvements.
· 301 redirects on LEO changes
· Option to force 3xx http status codes
· Validate googlebot.com and google.com crawlers.
· CCBot
· Rss with etag and atom.

lesa meira...

   Toggle Content Community

Support for DragonflyCMS in a other languages:

Deutsch
Español

   Toggle Content X-links
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
Interactive software released under GNU GPL, Code Credits, Privacy Policy