mzlogical
05-20-2003, 05:38 PM
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.
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.