I sucessfully completed the script to move my users and info from PHPBB to Nuke, however, any user who does not have an avatar uploaded has a broken image in thier avatar in the forum section. I have tried to get the properties for this image by clicking on it.. but it does not tell me what it is supposed to be. Can anyone help with this? I would greatly appreciate it.
Tally Nuke Soldier
Joined: Dec 14, 2003
Posts: 12
Posted:
Sun Dec 14, 2003 5:35 pm
OK i think i have figured this problem out myself... so to help others i'll post what i have done here. Hopefully it will keep you from having to sit at your computer like this like i have been for the past two days.
Make a 1x1px image and name it blank.gif - put it in your avatar directory.
In MYSQL, edit nuke_users table to have blank.gif as the default. That will fix all new registrants.
The query looks like this
ALTER TABLE `nuke_users` CHANGE `user_avatar` `user_avatar` VARCHAR( 255 ) DEFAULT 'blank.gif' NOT NULL
To fix current users... you have to define the user_avatar(where they don't have one already) as blank.gif AND set the user_avatar_type type as 1.
SQL for this is:
UPDATE `nuke_users` SET `user_avatar` = 'blank.gif',
`user_theme` = NULL ,
`user_avatar_type` = '1' WHERE `user_id` = '60' LIMIT 1 ;
MAKE SURE TO CHANGE the user ID to the ID you actually want to change.
This has fixed the problem for my forum. Unfortunately, i have over 100 users without avatars to fix... i will have to run this query 100 times. If anyone has a hint to make this query fix all null avatar users at once.. please share.[img][/img]
EDIT: If an admin could validate this code... it would be awesome. I am totally new to MYSQL and wouldn't want to steer anyone wrong.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
like i have been for the past two days.