Code: Select all
USE mytechdirect_forum; # Table: 'phpbb_attachments' ALTER TABLE phpbb_attachments MODIFY attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY physical_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY real_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY attach_comment text NOT NULL COLLATE utf8_bin, MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY mimetype varchar(100)
829computers wrote:Here is a full report, if it helps, but you have probably seen it before on others.
http://mytechdirect.net/forum/mysql_upgrader.php
No mods, straight install.
I did not want to put the whole list in to clutter up the topic, so others could navigate the thread more easily.
829computers wrote:Thank you.
I am using virtualmin and the sql command program that is built in.
I thought in the bug tracker post, he said not to use phpmyadmin?
829computers wrote:Well, I can edit posts, but cannot make new posts or private messages.