The Arcive of vBulletin Modifications Site. |
|
redo original query... Details »»
|
|||||||||||||||||||||||||
i was installing a hack for attaching more than 1 image to the board, and i figured i didnt need it, plus my site was down and creating errors. But when i went to restore my backup .phps it still won't work. that hack did something to 4 major tables on the vb board.
ALTER TABLE `post` CHANGE `attachmentid` `attachmentid` VARCHAR( 50 ) DEFAULT '0' NOT NULL; ALTER TABLE `post` ADD INDEX ( `attachmentid` ); Be patient - the above queries might take some time, depending on the size of your post table. ALTER TABLE `attachment` ADD `postid` INT NOT NULL; ALTER TABLE `attachment` ADD INDEX ( `postid` ); --------------- how can i get it back to normal? help me please, my forums are down now. thanks. Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
|||
|
|||
|
nevermind, i did a backup of my vbulletin sql and it's been restored.
|
![]() |
|
|