This hack had been working fine for weeks, but now I have some major problems. I added some avatars last night, and then when I tried to do more this morning, I got this error:
Database error in vBulletin Control Panel 2.2.1:
Invalid SQL: INSERT INTO avatar (title,minimumposts,avatarpath,avatarcat) VALUES
('Monster','0','images/avatars/Buffy the Vampire Slayer/monster.jpg',3)
mysql error: Duplicate entry '208' for key 1
mysql error number: 1062
Date: Friday 28th of December 2001 05:24:55 PM
Script:
http://britpack.com/forums/forums/ad...atar_categ.php
Referer:
http://britpack.com/forums/admin/avatar_categ.php
So, I checked over the files and I've been having a problem with the last few lines of my files being cut off, and my member.php was like that, so I added the missing lines and uploaded in ASCII.
Now, when I even go to my main page, I get this error:
Database error in vBulletin 2.2.1:
Invalid SQL: SELECT user.avatarid,avatarpath,avatarrevision,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid='1'
mysql error: Can't open file: 'avatar.MYD'. (errno: 145)
mysql error number: 1016
Date: Friday 28th of December 2001 05:46:05 PM
Script:
http://britpack.com/forums/forums/
Referer:
Can anyone help me? I have no idea what to try next.
Does anyone know what this 'avatar.MYD' file is?