Installed UploadPic v1.3.2
on a fresh install of phpBB 2.0.21, followed the instructions (long-ish but clear), and now I get a number of errors in the admin panel:
UploadPic: "Un error occured
"UploadPic config" and "UploadPic groups" seem to work (well, they display a page of settings)
UploadPic recent: "Un error occured
UploadPic users:An Error Occurred
SQL Error : 1054 Unknown column 'user_allow_uploadpic' in 'field list'
SELECT user_id, username, user_allow_uploadpic FROM phpbb_XYZforumusers WHERE user_id > 0 ORDER BY LEFT(username,1), user_allow_uploadpic DESC, username
Line : 68
File : admin_uploadpic_users.php
(Which reads "message_die(GENERAL_ERROR, '', '', __LINE__, __FILE__, $sql); )"
According to the FAQ
, the "SQL Error : 1054" means I didn't execute the SQL-query from the UploadPic-docfile. Which UploadPic-docfile?
The FAQ also states that, starting with UploadPic v1.1.2 this task will be executed by the installscript, which implies I don't have to do it myself, so I guess something went very wrong.
BTW, yes, I did
run install/install_uploadpic.php. I can't code to save my life, but I can follow instructions...
I even changed the "ADD user_allow_uploadpic TINYINT NOT NULL DEFAULT 0';" line to read 1, but I really don't think it could be the cause.
--Edited to add:
Ok, it worked at last
!! Actually the install_uploadpic.php had not run. I got redirected back to the login, and thought it was normal. Trying to launch the script a dozen more times, i eventually managed to trigger it, and it did make the changes it was supposed to. It didn't manage to create the "userpix" directory, but that's easy to make yourself.
Thanks anyway. Hope this will help anyone else having a similar problem:
Don't take it for granted that the install_uploadpic.php script did run, unless it starts asking questions and display a confirmation of all actions
. Apparently you have to be logged in as forum admin for it to work?
Anyway, now everything is shipshape.