ansaurus

Question

Converting varchar to int using phpmyadmin

Answer 1

+2 A:

You have a full text index associated with your referrals column that needs to be dropped before the data type change will successfully execute:

ALTER TABLE your_table DROP INDEX (fulltext_index_name);

But check before you drop the index to see if it references other columns in the table, because you'll need to recreate the index (excluding the referrals column) for Full Text Search to work.

OMG Ponies 2010-09-26 19:28:11

Thankyou for your reply!!Im sure it works I just need a little more help.. I've used your solution like this ALTER TABLE referrals DROP INDEX (fulltext_index_name) do I have to put something into the index_name bit? Thankyou!

Martin Cooper 2010-09-26 19:33:19

@Martin Cooper: Yes, you need to specify the name of the full text index that referrals is attached to. Use the [SHOW INDEX syntax](http://dev.mysql.com/doc/refman/5.0/en/show-index.html) to find the name. You want to look at your table in particular, where the `index_type` is "fulltext".

OMG Ponies 2010-09-26 19:35:31

Hmm.. I get this error 1142 - SELECT command denied to user '***********' for table 'pb_users'

Martin Cooper 2010-09-26 19:37:02

@Martin Cooper: You need to use an account with higher privileges, or increase the privilege to the `pb_users`

OMG Ponies 2010-09-26 19:43:31

Hmm.. This is the account 1and1 have given me.. I am the main admin.. Ok well I have the solution. Thankyou you've been VERY helpful!!! Much appreciated!

Martin Cooper 2010-09-26 19:45:35

ansaurus

tags:

views:

answers:

Converting varchar to int using phpmyadmin

related questions