It happens every time. I go through the standard motions:
I click upload photo
I browse for a photo on my local computer and select a .jpg file
I choose a category
I select "yes" I want to be notified of new comments
I click upload/submit (which is located under the Admin Options for Bulk or Zip uploads, since I am the site Admin, but I touch nothing in within this section)
I am taken to the following page which shows a thumbnail of the image I am uploading and gives me the option of adding a title and description http://www.mysite.net/gallery/bulkup...&numprocess=10
I type in a title
I click Process Files
I get the following error
MySQL error reported!
Query: INSERT INTO ppnotify (id,userid,photo) values(NULL,,12)
Result: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '12)' at line 1
VERSION UPDATE: 4.8.2
Minor updates to fix a few files:
image-inc.php (change to notification addition to use $upuser instead of userid)
index.php (added permissions to comments view)
showmembers.php (add permissions to comments view)
forums/threads.php (fixed missing init_user_groups() function)
forums/ib.php (slight changes to styles integration
and a fix for import_user_groups to identify admins)
forums/ib2.php (slight changes to styles integration,
a fix for import_user_groups to identify admins
and an authication addition)
languages/german/* (all files updated to German strings)
There are no database changes for this upgrade, so there is no upgrade script. You only need to upload files which have changed.
Does this mean, that the new image-inc.php file for the upgrade is wrong?
"image-inc.php (change to notification addition to use $upuser instead of userid)"
So shall we "upgrade" normally and after that change only the line mentioned in the posting of Omegatron (29.8.) above?
I tried a fresh 4.8.2 installation and after the fix of that line, it worked. I can confirm that the error only appears if notification for comments is set on "yes" while uploading. If set on "no", no error occurs.
P.S.: Where to change this specific english "yes" and "no" into european languages by the way?