MySQL error reported! Script: bulkupload

[janet22]

Whats this all about?.......



MySQL error reported!

Script: bulkupload

Query: INSERT INTO photopostnotify (id,userid,photo) values(NULL,1,)

Result: You have an error in your SQL syntax near ')' at line 1

Database handle: Resource id #7

Try changing line 681 of image-inc.php from

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,{$User['userid']},$photoid)";

to

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,{$User['userid']},$lastphotoid)";

[banjolawyer]

I am getting an error also when uploading

Content visible to verified customers only.

The suggested fix is not working for me. Any other suggestions?

[banjolawyer]

I have searched for a long time on these forums and can't find the solution. Should I email support instead?

[Chuck S]

How about this

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,{$User['userid']},$photoid)";

to

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,$upuser,$photoid)";

[banjolawyer]

That is what I have.

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,$upuser,$photoid)";

I'm using version 4.8.2 just downloaded last night.

[Michael P]

How about some info about your setup?

[banjolawyer]

Linux
Apache version 1.3.31
PHP version 4.3.8
MySQL version 4.0.20
PhotoPost Pro 4.8.2
vBulletin 3.0.3
vbPortal 3.0.0 beta 3

What else do you need to know?

[Michael P]

Does this happen on every upload or just some? Anything more than a few sentenceas is going to help, so please be as descriptive as possible.

[banjolawyer]

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!

Script: bulkupload

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

Database handle: Resource id #42

[domrep]

windows 2003 server

MySQL error reported!

Script: bulkupload

Query: INSERT INTO pop_notify (id,userid,photo) values(NULL,,5397)

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 '5397)' at line 1

Database handle: Resource id #6

[domrep]

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,{$User['userid']},$photoid)";

to

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,$upuser,$photoid)";

seems it helped.

[Chuck S]

Yes and that should be in the current released version of 4.8.2

[banjolawyer]

seems its not a fix for everyone. That's exactly the code I have

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,$upuser,$photoid)";

and I'm still getting the error.

I'm not sure what other info. I can give. If there's anything else I can do to help photopost support help me, please let me know.

[Chuck S]

try this

Line 685 of image-inc.php

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,$upuser,$photoid)";

change to

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,$upuserid,$photoid)";

[banjolawyer]

Woot !!! that did the trick.. Thanks very much !!!

[sbb]

someone on our site just had the same problem and I made the latest change suggested by Omegatron and am awaiting her response on the issue

[snoopy5]

how does this affect upgrades from 4.8.1 to 4.8.2?

The upgrade information are as follows:

-------------------------------------------------------------------

=====================
VERSION UPDATE: 4.8.2
=====================

Minor updates to fix a few files:

pp-inc.php
adm-approve.php
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?

Quote:

"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?

[Chuck S]

The change is only in image-inc.php with the lines posted no other files to edit

[smgvbest]

Thank you,

This fixed the problem on my site as well.

Originally Posted by omegatron

try this

Line 685 of image-inc.php

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,$upuser,$photoid)";

change to

$query = "INSERT INTO {$Globals['pp_db_prefix']}notify (id,userid,photo) values(NULL,$upuserid,$photoid)";