Hi

i have import a lot of avatars via phpmyadmin like these.

but later i find that a lot of avatars disapeared.

i thought it maybe caused by someone changed a avatar then the old avatar was deleted.

Is the any way to avoid these happens? or is there anything wrong with the sql file?

Thanks

Hi there, if you look closely to your sql code you will see that you are overwriting the avatar_id that is an auto_increment field, every time you run a new file in the format above you will overwrite the information in the table at worst or be given a reffirrential integrity error at best.

#
# Table structure for table `avatar`
#

CREATE TABLE avatar (
avatar_id mediumint(8) unsigned NOT NULL auto_increment,
avatar_file varchar(30) NOT NULL default '',
avatar_name varchar(100) NOT NULL default '',
avatar_mimetype varchar(30) NOT NULL default '',
avatar_created int(10) NOT NULL default '0',
avatar_display tinyint(1) unsigned NOT NULL default '0',
avatar_weight smallint(5) unsigned NOT NULL default '0',
avatar_type char(1) NOT NULL default '',
PRIMARY KEY (avatar_id),
KEY avatar_type (avatar_type,avatar_display)
) TYPE=MyISAM;

Always try to use sql that specifies the collumn to insert to like:
INSERT INTO `xoops_avatar` (`avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_display`, `avatar_type`) VALUES ('Animaniacs001.gif', 'Animaniacs001.gif', 'image/gif', 1, 'S');
INSERT INTO `xoops_avatar` (`avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_display`, `avatar_type`) VALUES ('Animaniacs002.gif', 'Animaniacs002.gif', 'image/gif', 1, 'S');
INSERT INTO `xoops_avatar` (`avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_display`, `avatar_type`) VALUES ('Animaniacs003.gif', 'Animaniacs003.gif', 'image/gif', 1, 'S');
INSERT INTO `xoops_avatar` (`avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_display`, `avatar_type`) VALUES ('Animaniacs004.gif', 'Animaniacs004.gif', 'image/gif', 1, 'S');


Grotmis
Riaan
http://www.craftsonline.co.za

Hi

Thanks

I have delete these avatar_id i want to add.

The things real troubles me is that some avatar will get lost after some days. So i thought it is because that these lost avatar was once used by someone else. but then these avatar was deleted as when changing a avatar says"Your old avatar will be deleted!"

But as a system avatar it shouldn't be deleted??

高手教教我啊。。