|
View previous topic :: View next topic |
| Author |
Message |
HookerOne
Newbie
 Offline
Joined: Nov 02, 2008
Posts: 40
|
 Posted: Sun Nov 02, 2008 9:51 pm
Post subject: Installation problem |
|
I have attempted to upgrade to 9.2.1, the installation goes well until I get the following message.
On /cpgn/install.php
While executing query "ALTER TABLE cms_referer DROP rid"
the following error occured: Can't DROP 'rid'; check that column/key exists
In: includes/classes/installer.php on line: 102
I have read the following topic
dragonflycms.org/Forum...18108.html
However I only have one table named cms_referer. I have renamed this table and then rerun the installer only to get the following message.
On /cpgn/install.php
While executing query "ALTER TABLE cms_referer DROP rid"
the following error occured: Table 'cms_referer' doesn't exist
In: includes/classes/installer.php on line: 102
Can anyone help me out, my knowledge is pretty basic so any assistance will be greatfully appreciated.
HookerOne's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.4/4.1.20/5.1/9.2.1
|
|
| Back to top |
|
 |
InspectorClueNo
Heavy poster
Offline
Joined: Mar 26, 2008
Posts: 211
|
Posted: Sun Nov 02, 2008 10:18 pm
Post subject: Re: Installation problem |
|
Hi, upgrading from?
InspectorClueNo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
none available
|
|
| Back to top |
|
|
HookerOne
Newbie
Offline
Joined: Nov 02, 2008
Posts: 40
|
Posted: Mon Nov 03, 2008 12:46 pm
Post subject: Re: Installation problem |
|
6.4, I have ran it for a few years now but have recently suffered with security problem hence why I have decided to try and upgrade.
HookerOne's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.4/4.1.20/5.1/9.2.1
|
|
| Back to top |
|
|
NanoCaiordo
Developer
Offline
Joined: Jun 29, 2004
Posts: 3878
Location: Melbourne, AU
|
Posted: Mon Nov 03, 2008 3:01 pm
Post subject: Re: Installation problem |
|
PHP-Nuke 6.4?
_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
Linux 64bit / Apache 2.2 / PHP 5.4 / MySQL 5.5.22 / v9, v10
Linux 32bit / Apache 2.2 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
Windows 64bit / IIS 7.5 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
mixed
|
|
| Back to top |
|
|
HookerOne
Newbie
Offline
Joined: Nov 02, 2008
Posts: 40
|
Posted: Mon Nov 03, 2008 3:38 pm
Post subject: Re: Installation problem |
|
Sorry yes PHP-Nuke 6.4
HookerOne's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.4/4.1.20/5.1/9.2.1
|
|
| Back to top |
|
|
WebSiteGuru
1000+ Posts Club
Offline
Joined: Jun 09, 2005
Posts: 2318
|
Posted: Mon Nov 03, 2008 3:52 pm
Post subject: Re: Installation problem |
|
Ouch! Can we even go from PHP-Nuke 6.4 to DF 9.x?  I know that we have users that went from PHP-Nuke 7.x to DF. But I have never seen it done with this version.
You might want to upgade to PHP-Nuke 7.x and then go from there.
Not unless NanoCaiordo or one of the staffs can help.
_________________
Lead Theme Designer - WebSiteGuru Designs
WebSiteGuru's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.9 / Apache 2.2.6 / MySQL 5.0.27 / PHP 5 / DF Version 9.2.1
|
|
| Back to top |
|
|
HookerOne
Newbie
Offline
Joined: Nov 02, 2008
Posts: 40
|
Posted: Mon Nov 03, 2008 4:31 pm
Post subject: Re: Installation problem |
|
Ok but where do I get a copy of PHP-Nuke 7 from?
HookerOne's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.4/4.1.20/5.1/9.2.1
|
|
| Back to top |
|
|
WebSiteGuru
1000+ Posts Club
Offline
Joined: Jun 09, 2005
Posts: 2318
|
Posted: Mon Nov 03, 2008 4:56 pm
Post subject: Re: Installation problem |
|
DONNO! Try Google Search, or asked one of the PHP-Nuke community to see if they might have a copy.
_________________
Lead Theme Designer - WebSiteGuru Designs
WebSiteGuru's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.9 / Apache 2.2.6 / MySQL 5.0.27 / PHP 5 / DF Version 9.2.1
|
|
| Back to top |
|
|
HookerOne
Newbie
Offline
Joined: Nov 02, 2008
Posts: 40
|
Posted: Mon Nov 03, 2008 5:25 pm
Post subject: Re: Installation problem |
|
I will hang off doing that for a bit as the documentation that came with this version says that you can upgrade from PHP-Nuke 5.5-7.6. Thanks for the advice though.
HookerOne's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.4/4.1.20/5.1/9.2.1
|
|
| Back to top |
|
|
HookerOne
Newbie
Offline
Joined: Nov 02, 2008
Posts: 40
|
Posted: Mon Nov 03, 2008 5:27 pm
Post subject: Re: Installation problem |
|
The version I am upgrading from is actually CPG-Nuke sorry for any confusion.
HookerOne's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.4/4.1.20/5.1/9.2.1
|
|
| Back to top |
|
|
rlgura
1000+ Posts Club
Offline
Joined: Mar 27, 2006
Posts: 1146
Location: Cleveland, OH USA
|
Posted: Mon Nov 03, 2008 6:35 pm
Post subject: Re: Installation problem |
|
that error means that it can't find the column 'rid' in cms_referer table.
It looks like that line comes from the cpg9x upgrade script.
should be possible to just add a column named 'rid' to get past that point, but there'll probably be more issues
_________________
Admin - Great Lakes Web Designs
Theme Designer - WebSite Guru Designs
Site Admin - Families with Food Allergies
rlgura's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.27-grsec/Apache 2.2.11/MySQL 5.0.67-community-log/PHP 5.2.8/DF 9.2.1
|
|
| Back to top |
|
|
HookerOne
Newbie
Offline
Joined: Nov 02, 2008
Posts: 40
|
Posted: Mon Nov 03, 2008 7:05 pm
Post subject: Re: Installation problem |
|
Thanks for that and I am sure if I google it I could eventually figure out how to add a column to a table. However to try and not mess the installation any more could anyone please let me know how to add a column.
I did say my knowledge is pretty basic
HookerOne's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.4/4.1.20/5.1/9.2.1
|
|
| Back to top |
|
|
NanoCaiordo
Developer
Offline
Joined: Jun 29, 2004
Posts: 3878
Location: Melbourne, AU
|
Posted: Tue Nov 04, 2008 6:06 am
Post subject: Re: Installation problem |
|
| Wiki wrote: |
| DragonflyCMS is a powerful, feature-rich, Open Source content management system which was based on PHP-Nuke 6.5 in the early "CPG-Nuke CMS" |
6.4 its excellent to upgrade from.
You should try 6.4 -> 9.0.6.1 -> 9.2.
_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
Linux 64bit / Apache 2.2 / PHP 5.4 / MySQL 5.5.22 / v9, v10
Linux 32bit / Apache 2.2 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
Windows 64bit / IIS 7.5 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
mixed
|
|
| Back to top |
|
|
HookerOne
Newbie
Offline
Joined: Nov 02, 2008
Posts: 40
|
Posted: Tue Nov 04, 2008 9:44 am
Post subject: Re: Installation problem |
|
Where can I get a copy of 9.0.6.1 and is that the only way to go.
HookerOne's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.4/4.1.20/5.1/9.2.1
|
|
| Back to top |
|
|
HookerOne
Newbie
Offline
Joined: Nov 02, 2008
Posts: 40
|
Posted: Tue Nov 04, 2008 9:51 am
Post subject: Re: Installation problem |
|
I have managed to find 9.0.6.1 and I am going to give it a go.
HookerOne's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.4/4.1.20/5.1/9.2.1
|
|
| Back to top |
|
|
|
|
Forum FAQ
Log in to check your private messages
Login
Search
