:: Forums ⇒

_bbsearch_wordlist indexes error on upgrade

#1: _bbsearch_wordlist indexes error on upgrade Author: Eestlane, Location: Estonia

Posted: Wed Feb 06, 2008 11:17 pm
----
On /install.php
While executing query "ALTER TABLE cms_bbsearch_wordlist CHANGE word_id word_id INT UNSIGNED NOT NULL AUTO_INCREMENT NOT NULL DEFAULT NULL"

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

In: /home/xxx/public_html/includes/classes/installer.php on line: 115

#2: Re: _bbsearch_wordlist alter error on install Author: Eestlane, Location: Estonia

Posted: Wed Feb 06, 2008 11:34 pm
----
I tried to upgrade from 9.1.2.1 btw.

#3: Re: _bbsearch_wordlist alter error on install Author: Eestlane, Location: Estonia

Posted: Wed Feb 06, 2008 11:42 pm
----
Mhm, maybe it's because most of the words have id 0 in my database. Maybe I have done something wrong in past.

#4: Re: _bbsearch_wordlist alter error on install Author: Eestlane, Location: Estonia

Posted: Thu Feb 07, 2008 12:02 am
----
Well, I got it installed by dropping the modified database failed install made.

Then reuploading the backup.

Then ran this code:
DELETE FROM cms_bbsearch_wordlist where word_id = 0

Then made new PRIMARY key from word_id

Thats all! All these steps were required btw.

#5: Re: _bbsearch_wordlist alter error on install Author: Eestlane, Location: Estonia

Posted: Thu Feb 07, 2008 12:02 am
----
Well, only problem is that I won't have a lot of results from forum search now.

#6: Re: _bbsearch_wordlist alter error on install Author: rlgura, Location: Cleveland, OH USA

Posted: Thu Feb 07, 2008 12:41 am
----
Nobody posts on your forums anyway! Laughing

#7: Re: _bbsearch_wordlist alter error on install Author: Eestlane, Location: Estonia

Posted: Thu Feb 07, 2008 12:44 am
----
Twisted Evil

You are just envious, that you can't speak Estonian. Cool

#8: Re: _bbsearch_wordlist alter error on install Author: layingback,

Posted: Thu Feb 07, 2008 1:33 am
----
Have same problem on upgrade to 9.2.1. This is on (a copy of) an old db that started on PHP-Nuke and has been through CPG 8 and 9 - up to 9.0.6.1.

Code::

On .../install.php
While executing query "ALTER TABLE nuke_bbsearch_wordlist DROP INDEX word_id"

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

In: ..../public_html/includes/classes/installer.php on line: 125

Guess I could try similar to Eestlane, but I have to keep all the search words ...

#9: Re: _bbsearch_wordlist alter error on install Author: Phoenix, Location: Netizen

Posted: Thu Feb 07, 2008 2:03 am
----
That appears to be a slightly different issue - I would wait until investigated.

It may well be that MySQL4 is the issue.

#10: Re: _bbsearch_wordlist indexes error on upgrade Author: DJ Maze, Location: http://tinyurl.com/5z8dmv

Posted: Thu Feb 07, 2008 8:17 am
----
ALTER TABLE cms_bbsearch_wordlist CHANGE word_id word_id INT UNSIGNED NOT NULL AUTO_INCREMENT NOT NULL DEFAULT NULL

Looks like a wrong query.

#11: Re: _bbsearch_wordlist indexes error on upgrade Author: NanoCaiordo, Location: Melbourne, AU

Posted: Thu Feb 07, 2008 10:32 am
----
Yes query is totally wrong but also there is one more thing. word_id is a AUTO_INCREMENT field and it has a PRIMARY or an UNIQUE key depends the history of his site. Both field and indexes does not allow to have duplicate values, but Eestlane got all of them 0 which make me think that field and/or indexes were heavily modified by something.

For layingback's issue there it shouldn't be any problem if the the field is AUTO_INCREMENT and the PRIMARY key exists and is UNIQUE (which it has to be). If the PRIMARY key doesn't exists then i can justify the error and tune up the order on how the queries are executed. Otherwise its something to do with MySQL 4.

#12: Re: _bbsearch_wordlist indexes error on upgrade Author: NanoCaiordo, Location: Melbourne, AU

Posted: Thu Feb 07, 2008 12:08 pm
----
I've manually run few tests in mysql 4.1.22 and mysql 5.0.22 and they both returned the same results, its not a MySQL issue unless it does happen in 4.1.21 only (not even reported in bugs.mysql).

It seems that you (layingback) are missing the PRIMARY KEY which should be already there. Please run the following query and let us know:

Code::

SHOW INDEXES FROM nuke_bbsearch_wordlist

#13: Re: _bbsearch_wordlist indexes error on upgrade Author: Eestlane, Location: Estonia

Posted: Thu Feb 07, 2008 3:42 pm
----
I think I'll need (to make) something similar to phpBB's Rebuild Search to rebuild my search values, as I had them messed up already before.

#14: Re: _bbsearch_wordlist indexes error on upgrade Author: Phoenix, Location: Netizen

Posted: Thu Feb 07, 2008 3:54 pm
----
It certainly did appear that you had a previous problem, complicated by the upgrade.

dragonflycms.org/Forum...=6612.html - it's old now, and needs to be adapted to DF, but then again, our forum db structure hasn't changed much either. Just ensure your basic table structures are correct to start with.

#15: Re: _bbsearch_wordlist indexes error on upgrade Author: Eestlane, Location: Estonia

Posted: Thu Feb 07, 2008 4:03 pm
----
Thanks, Phoenix, will try.

-> Installation Issues

All times are GMT

Go to page 1, 2, 3 Next :| |: Page 1 of 3