Problem upgrading
Post new topic   This topic is locked: you cannot edit posts or make replies.   Printer Friendly Page     Forum IndexInstallation Issues
Author Message
adrenalin85
No Credits


Joined: Apr 16, 2006
Posts: 44
Location: CA

PostPost subject: Problem upgrading
Posted: Tue Feb 19, 2008 6:06 am
Reply with quote

Im not fully sure if I did everything correctly, but I backed up all the files just incase. I left all files intact but uploaded all of the new once and ran the setup, then I receive the following error:

On /install.php?
While executing query "ALTER TABLE cms_bbattachments_desc DROP PRIMARY KEY"

the following error occured: Incorrect table definition; there can be only one auto column and it must be defined as a key

In: C:\wwwroot\sitename\includes\classes\installer.php on line: 125



Any ideas what could be wrong and how to fix this?


adrenalin85's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MS Server 2003 / IIS 6 / MySQL 5 / PHP 5 / CMS 9.0.6.1
Back to top
View user's profile
Rusty_
Nice poster


Joined: Jan 22, 2008
Posts: 51
Location: Au

PostPost subject: Re: Problem upgrading
Posted: Tue Feb 19, 2008 6:28 am
Reply with quote

Try this topic in the sticky www.dragonflycms.org/F...21859.html
HTH
Cheers



{link edited} We use dragonflycms.org please make a note of this if your going to post links. Thanks Smile


Rusty_'s server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux / 2.2.6 / 5.0.45 / 5.2.4 / Dragonfly (9.2.1)
Back to top
View user's profile Visit poster's website
adrenalin85
No Credits


Joined: Apr 16, 2006
Posts: 44
Location: CA

PostPost subject: Re: Problem upgrading
Posted: Sun Feb 24, 2008 5:24 am
Reply with quote

I am still learning PHP and MySQL, that post is a bit confused. Could someone please tell me what exactly I need to do to fix this problem? Step by step? I'd be very thankfull...

adrenalin85's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MS Server 2003 / IIS 6 / MySQL 5 / PHP 5 / CMS 9.0.6.1
Back to top
View user's profile
adrenalin85
No Credits


Joined: Apr 16, 2006
Posts: 44
Location: CA

PostPost subject: Re: _bbsearch_wordlist indexes error on upgrade
Posted: Sun Feb 24, 2008 5:36 am
Reply with quote

I am having a similar problem, I am trying to upgrade my CMS but I get the following error:
___________________________________________________
On /install.php?
While executing query "ALTER TABLE cms_blocks ADD in_module VARCHAR(255) NULL DEFAULT ''"

the following error occured: Duplicate column name 'in_module'

In: C:\wwwroot\sitedir\install\sql\upgrade\df91.inc on line: 19
___________________________________________________

I am trying to upgrade from 9.0.6.1 to the newest version.

Can someone tell me what I need to do to fix this problem?


adrenalin85's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MS Server 2003 / IIS 6 / MySQL 5 / PHP 5 / CMS 9.0.6.1
Back to top
View user's profile
Phoenix
Site Admin


Joined: Apr 19, 2004
Posts: 8729
Location: Netizen

PostPost subject: Re: Problem upgrading
Posted: Sun Feb 24, 2008 11:41 am
Reply with quote

You should use the full, latest release of 9.2.1

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
adrenalin85
No Credits


Joined: Apr 16, 2006
Posts: 44
Location: CA

PostPost subject: Re: Problem upgrading
Posted: Sun Feb 24, 2008 5:48 pm
Reply with quote

I thought I did get the latest release, I downloaded it only about several weeks ago... Did a new one come out or...?

Well ok I will try to download it again and see if it will work...


adrenalin85's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MS Server 2003 / IIS 6 / MySQL 5 / PHP 5 / CMS 9.0.6.1
Back to top
View user's profile
Mel
Forum Admin


Joined: Jul 21, 2004
Posts: 1395
Location: Eastern Time Zone

PostPost subject: Re: Problem upgrading
Posted: Sun Feb 24, 2008 5:53 pm
Reply with quote

Yeah and because you remove credits from your website, in order for you to receive support you will have to show us your site with credits intact.

Credits:
dragonflycms.org/Wiki/id=58.html#4j

www.tysovka.net
www.tysovka.net/chat/ <==your websites which we still have listed, even though you removed it from your WWW.

When you have provided a valid DF site with credits in your WWW. We will unlock your thread.

_________________
DF TIPS | Upgrade| Find Your Signature Specs|
"A bug in the code is worth two in the documentation. "


Mel's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)


Last edited by Mel on Sun Feb 24, 2008 6:06 pm; edited 1 time in total
Back to top
View user's profile Visit poster's website
adrenalin85
No Credits


Joined: Apr 16, 2006
Posts: 44
Location: CA

PostPost subject: Re: Problem upgrading
Posted: Sun Feb 24, 2008 6:06 pm
Reply with quote

Phoenix, I tried that and it didn't work... Any other ideas what to do?

Melinda, I had a credits text... Or I had to keep all of the links too? Well no problem I can do that I just didn't think that was needed...


adrenalin85's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MS Server 2003 / IIS 6 / MySQL 5 / PHP 5 / CMS 9.0.6.1
Back to top
View user's profile
Mel
Forum Admin


Joined: Jul 21, 2004
Posts: 1395
Location: Eastern Time Zone

PostPost subject: Re: Problem upgrading
Posted: Sun Feb 24, 2008 6:15 pm
Reply with quote

This is not your first time being shown our rules for credits.
Also, putting credits back on your site just so you can get help is also a no, no.
Please refresh yourself with the above link.

You are welcome as a registered member to use the site to find documentation, browse forums and to download files etc. but you will not receive support from our staff until you comply.

Thank you.

_________________
DF TIPS | Upgrade| Find Your Signature Specs|
"A bug in the code is worth two in the documentation. "


Mel's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.   Printer Friendly Page     Forum IndexInstallation Issues All times are GMT
Page 1 of 1


Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

stopsoftwarepatents.eu petition banner
User Info [x]

Welcome Anonymous

Nickname
Password
(Register)

Last CVS commits [x]

Languages [x]

Community [x]

Support for DragonflyCMS in a other languages:

Deutsch
Español

X-links [x]
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

Preview theme [x]
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.


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
This page generated in 0.3372 seconds with 17 DB Queries in 0.0378 seconds
Memory Usage: 3.11 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy