Announcement

Collapse
No announcement yet.

Comparing forums

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Jake Bunce
    replied
    If those tables have different primary keys, then you need to manually change them back to default.

    As for the blank setting, you should be able to delete it from within the Admin CP if you enable debug mode. You can enable debug mode by adding this line to your includes/config.php file:

    Code:
    $config['Misc']['debug'] = true;

    Leave a comment:


  • Alex Goodspeed
    replied
    Originally posted by Jake Bunce View Post
    Those are all modify queries that appear to reference default tables, columns, and column types. They will not add or remove any fields, only change their types which probably won't change anything.

    What does your program say those queries are for?
    Hi Jake,
    Thank you for your answer!

    These queries show difference between clean installed froum and current forum with hacks. I executed some of these queries and it looks like everything working fine ATM. But there are 5 queries left what I can't run because of errors (for example 'Multiple primary key defined'):
    Code:
    ALTER TABLE `event` MODIFY COLUMN `visible` SMALLINT(6) NOT NULL DEFAULT '0' UNIQUE;
    ALTER TABLE `post` MODIFY COLUMN `dateline` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0';
    ALTER TABLE `postindex` MODIFY COLUMN `wordid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0' PRIMARY KEY;
    ALTER TABLE `reputation` MODIFY COLUMN `reason` VARCHAR(250) COLLATE latin1_swedish_ci;
    ALTER TABLE `word` MODIFY COLUMN `wordid` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;
    Should I run this queries or these changes won't have any affect on forum stability?

    Also I have another question. I have deleted all custom phrases using the way mentioned in this topic
    Code:
    DELETE FROM phrase WHERE languageid = 0;
    And after that I found out that is 'Custom Profile Fields' and 'Control Panel Stop Message' phrases are empty. Is this normal?

    Moreover, I found some strange empty block under 'Banning Options' inside forum control settings, please check attached image, I marked it by red color. How can I delete it?

    Also I have a problem with reputation icon, it is not showing under username. I have checked all forum settings - reputation enabled everywhere. Templates were not changed too. Do you know how to resolve this problem?

    Thank you for your help!
    Attached Files

    Leave a comment:


  • Jake Bunce
    replied
    Those are all modify queries that appear to reference default tables, columns, and column types. They will not add or remove any fields, only change their types which probably won't change anything.

    What does your program say those queries are for?

    Leave a comment:


  • Alex Goodspeed
    started a topic Comparing forums

    Comparing forums

    Hi all!

    I decided to clean my forum (upgraded to 3.6.0 ver.) from all custom tables/fields what were installed by hacks.

    I'm using EMS Database Comparer (http://www.sqlmanager.net/products/mysql/dbcomparer) and after comparison of my current forum with clean installed new forum I got these lines to be modify:
    Code:
    ALTER TABLE `adminlog` MODIFY COLUMN `script` VARCHAR(50) COLLATE latin1_swedish_ci NOT NULL UNIQUE;
    ALTER TABLE `event` MODIFY COLUMN `visible` SMALLINT(6) NOT NULL DEFAULT '0' UNIQUE;
    ALTER TABLE `postparsed` MODIFY COLUMN `pagetext_html` MEDIUMTEXT;
    ALTER TABLE `profilefield` MODIFY COLUMN `type` ENUM('input','select','radio','textarea','checkbox','select_multiple') NOT NULL DEFAULT 'input';
    ALTER TABLE `profilefield` MODIFY COLUMN `data` MEDIUMTEXT;
    ALTER TABLE `profilefield` MODIFY COLUMN `optional` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0';
    ALTER TABLE `profilefield` MODIFY COLUMN `perline` SMALLINT(6) NOT NULL DEFAULT '0';
    ALTER TABLE `ranks` MODIFY COLUMN `rankimg` MEDIUMTEXT;
    ALTER TABLE `ranks` MODIFY COLUMN `type` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0';
    ALTER TABLE `reminder` MODIFY COLUMN `text` MEDIUMTEXT;
    ALTER TABLE `reputation` MODIFY COLUMN `reason` VARCHAR(250) COLLATE latin1_swedish_ci;
    ALTER TABLE `search` MODIFY COLUMN `forumchoice` MEDIUMTEXT;
    ALTER TABLE `search` MODIFY COLUMN `orderedids` MEDIUMTEXT;
    ALTER TABLE `search` MODIFY COLUMN `searchterms` MEDIUMTEXT;
    ALTER TABLE `search` MODIFY COLUMN `displayterms` MEDIUMTEXT;
    ALTER TABLE `session` MODIFY COLUMN `incalendar` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0';
    ALTER TABLE `session` MODIFY COLUMN `bypass` TINYINT(4) NOT NULL DEFAULT '0';
    ALTER TABLE `setting` MODIFY COLUMN `value` MEDIUMTEXT;
    ALTER TABLE `setting` MODIFY COLUMN `optioncode` MEDIUMTEXT;
    ALTER TABLE `setting` MODIFY COLUMN `defaultvalue` MEDIUMTEXT;
    ALTER TABLE `setting` MODIFY COLUMN `advanced` SMALLINT(6) NOT NULL DEFAULT '0';
    ALTER TABLE `setting` MODIFY COLUMN `blacklist` SMALLINT(6) NOT NULL DEFAULT '0';
    ALTER TABLE `style` MODIFY COLUMN `templatelist` MEDIUMTEXT;
    ALTER TABLE `style` MODIFY COLUMN `css` MEDIUMTEXT;
    ALTER TABLE `style` MODIFY COLUMN `stylevars` MEDIUMTEXT;
    ALTER TABLE `style` MODIFY COLUMN `replacements` MEDIUMTEXT;
    ALTER TABLE `style` MODIFY COLUMN `csscolors` MEDIUMTEXT;
    ALTER TABLE `style` MODIFY COLUMN `editorstyles` MEDIUMTEXT;
    ALTER TABLE `subscription` MODIFY COLUMN `forums` MEDIUMTEXT;
    ALTER TABLE `subscriptionlog` MODIFY COLUMN `expirydate` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0';
    ALTER TABLE `template` MODIFY COLUMN `template` MEDIUMTEXT;
    ALTER TABLE `template` MODIFY COLUMN `template_un` MEDIUMTEXT;
    ALTER TABLE `thread` MODIFY COLUMN `deletedcount` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0';
    ALTER TABLE `user` MODIFY COLUMN `options` INTEGER(10) UNSIGNED NOT NULL DEFAULT '15';
    ALTER TABLE `user` MODIFY COLUMN `birthday` VARCHAR(10) COLLATE latin1_swedish_ci NOT NULL UNIQUE;
    ALTER TABLE `useractivation` MODIFY COLUMN `activationid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
    ALTER TABLE `userfield` MODIFY COLUMN `field1` MEDIUMTEXT;
    ALTER TABLE `userfield` MODIFY COLUMN `field2` MEDIUMTEXT;
    ALTER TABLE `userfield` MODIFY COLUMN `field3` MEDIUMTEXT;
    ALTER TABLE `userfield` MODIFY COLUMN `field4` MEDIUMTEXT;
    ALTER TABLE `userfield` MODIFY COLUMN `temp` MEDIUMTEXT;
    ALTER TABLE `usernote` MODIFY COLUMN `message` MEDIUMTEXT;
    ALTER TABLE `usertextfield` MODIFY COLUMN `subfolders` MEDIUMTEXT;
    ALTER TABLE `usertextfield` MODIFY COLUMN `pmfolders` MEDIUMTEXT;
    ALTER TABLE `usertextfield` MODIFY COLUMN `buddylist` MEDIUMTEXT;
    ALTER TABLE `usertextfield` MODIFY COLUMN `ignorelist` MEDIUMTEXT;
    ALTER TABLE `usertextfield` MODIFY COLUMN `signature` MEDIUMTEXT;
    ALTER TABLE `usertextfield` MODIFY COLUMN `searchprefs` MEDIUMTEXT;
    ALTER TABLE `word` MODIFY COLUMN `wordid` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;
    The question is: is it nesesarry to run this queries?

    Thank you!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X