Now I've tried Slynderdale's fixes that were in that zip.
When I did that, I made all file chages again, then I got to the database part to do those changes again. I executed all those queries again (I assumed there were changes) and then it told me that they already existed so the query didn't finish or something.
so I ignored it. Then I finished the directions, and I still have red x's for pictures.
I decided I would try to re-upload my profile pic as a test. So I deleted in in my user CP, then I went to re-upload it and I got a database error something like this:
Code:
Database error in vBulletin 3.0.3:
Invalid SQL:
INSERT INTO customprofilepic
(userid, profilepicdata, thumbnaildata, comment, visible, thumbnaildata, comment, visible, dateline, filename, filesize)
VALUES
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
can someone help me by giving me some sql queries I need to run so at least people can add profile pictures again without a database error, because I don't know any SQL.
thank you.