View Full Version : droping INDEX problem...
ALTER TABLE `sometable` ADD INDEX (`someid`)
any idea why i get an sql error?
to create it, i used:
ALTER TABLE `sometable` DROP INDEX (`someid`)
i also tried this way:
ALTER TABLE sometable ADD INDEX (someid)
and:
ALTER TABLE sometable DROP INDEX (someid)
the error i get is this:
Database error in vBulletin Control Panel 2.2.8:
Invalid SQL: ALTER TABLE sometable DROP INDEX (someid)
mysql error: You have an error in your SQL syntax near '(someid)' at line 1
i also tried:
DROP INDEX (someid) ON sometable
Freddie Bingham
09-29-2002, 05:10 AM
ALTER TABLE sometable DROP INDEX someid
i tried that to. it wont work freddie... i get an error like is not there:
Database error in vBulletin Control Panel 2.2.8:
Invalid SQL: ALTER TABLE sometable DROP INDEX someid
mysql error: Can't DROP 'someid'. Check that column/key exists
i create it, i know for sure, with:
ALTER TABLE sometable ADD INDEX (someid)
What Freddie posted worked for me. Just make sure what you are dropping has been INDEXed.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.