Announcement

Collapse
No announcement yet.

Missing avatars after migrating

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

  • Missing avatars after migrating

    I moved my forum to another server. Simply uploaded the html and database and edited config.php.

    Everything works perfectly except avatars and profile pictures are missing (a few of them are there actually). Pictures are stored in the database.

    The links to the avatars are the same as in the old forum (except for the domain name) so that shouldn’t be the problem.

    In the database customavatar table I can se filname and size, etc... looks ok.

    What might cause this problem?
    Last edited by KrisP; Sun 9th Nov '08, 11:37am.

  • #2
    This is an example of dump with third party sql dump software:

    DROP TABLE IF EXISTS `customavatar`;
    CREATE TABLE IF NOT EXISTS `ustomavatar` ( `userid` int(10) unsigned NOT NULL default '0', `filedata` mediumblob, `dateline` int(10) unsigned NOT NULL default '0', `filename` varchar(100) NOT NULL default '', `visible` smallint(6) NOT NULL default '1', `filesize` int(10) unsigned NOT NULL default '0', `width` smallint(5) unsigned NOT NULL default '0', `height` smallint(5) unsigned NOT NULL default '0', `importcustomavatarid` bigint(20) NOT NULL default '0', PRIMARY KEY (`userid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    ALTER TABLE `customavatar` DISABLE KEYS;
    LOCK TABLES `customavatar` WRITE;

    INSERT INTO `customavatar` VALUES (2,'\0JFIF\0\0\0d\0d\0\0\0Ducky\0\0\0\0\0d\0\

    Same with dump created with phpmyadmin:

    CREATE TABLE `customavatar` (
    `userid` int(10) unsigned NOT NULL default '0',
    `filedata` mediumblob,
    `dateline` int(10) unsigned NOT NULL default '0',
    `filename` varchar(100) NOT NULL default '',
    `visible` smallint(6) NOT NULL default '1',
    `filesize` int(10) unsigned NOT NULL default '0',
    `width` smallint(5) unsigned NOT NULL default '0',
    `height` smallint(5) unsigned NOT NULL default '0',
    `importcustomavatarid` bigint(20) NOT NULL default '0',
    PRIMARY KEY (`userid`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    INSERT INTO `customavatar` VALUES (2, 0xffd8ffe000104a46494600010200006400640000ffec00114475636b790001

    Seems data is different - whats wrong with data in the top example ?

    Comment


    • #3
      customavatar
      ustomavatar

      Comment

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