Cant upload after upgrade

[Basil]

When I try to upload a picture after upgrade to 5.6.2, I get:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.../public_html/threads/photopost/bulkupload.php on line 139

When I echo the variable userid in that script it is blank! HELP!

[Chuck S]

what type of integration here?

[Basil]

Originally Posted by Chuck S

what type of integration here?

At the moment I'm integrating with threads 6.5, same as before. Later, I intend to upgrade to Threads 7, but in I'm tryong to first get photopost upgraded under the current forum. After the upgrade when I try to upload a picture, I get that error. I added echo statement in bulkupload.php to echo the variable $upuserid and it appears to be Empty (or null). my echo statement says
echo "the userid = ".$upuserid;

And what is output is just this:

the userid =

Hope this helps,

Basil

[Basil]

Additional info. I turned on debugging in the admin and when I try to upload a picture is gives this error:

Script: bulkupload

Query: SELECT SUM(filesize) AS fsize FROM pp_photos WHERE userid= AND storecat=0

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 'AND storecat=0' at line 1

Database handle: Resource id #7

AS I stated before it looks as if userid is not getting set (althought when I log into my forum and go to PP it shows me as logged on.

Basil

[Chuck S]

Are you not suppose to be running threads 7 though not threads?

You can try removing the bold code in uploadphoto.php

Content visible to verified customers only.

[Basil]

Originally Posted by Chuck S

Are you not suppose to be running threads 7 though not threads?

You can try removing the bold code in uploadphoto.php

Content visible to verified customers only.

Chuck, I am currently running Threads 6.5.X and have my PP integrated with that. I am not ready to go live with my Threads 7 yet, and it was suggested that I first upgrade PP under my old Threads and then port it over to Threads 7 once I get it working on Threads. So for now, I am integrated with the old threads (which was working fine until I upgraded from 5.3 to 5.6.2).

Ok, I did a search and found a discussion about a similar problem and so in bulkupload.php I made the following change in line 139:

instead of userid=$upuserid
I put: userid='$upuserid'

This seems to have gotten me past THAT prolem, but now I have another:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: bulkupload

Query: UPDATE pp_cache SET timestamp=0 WHERE id=1

Result: Table 'bc_photopost.pp_cache' doesn't exist

Database handle: Resource id #7

First question, was my change to 'encapselate' $upuserid the right thing to do (and do I need to do similar in other scripts)?

Second question, why am I getting the "table doesn't exist" error? Was the upgrade supposed to create that table?

Basil

[Chuck S]

You can do that although my edit might be more along your lines to do above

Your next error is because you have not ran all applicable upgrade scripts and need to run those. We add the cache table back in the 5.2 upgrade I beleive

[Basil]

Hmm, then my mistake must have been way back when I upgraded to 5.3 because I was running 5.3 when I upgraded to 5.6.2. So, is there any danger in re-running the scripts from 5.2 up to 5.6.2 again on current install?

[Chuck S]

Nope you can rerun 5.2 to 5.6

[Basil]

Well, I re-ran the scripts and we're getting closer. I can now upload and not get that error, but on the next screen when it shows a thumbnail and has the check mark to "add picture", when I hit the button labled "process" I get this error:

Script: bulkupload

Query: INSERT INTO ppp_photos (id,user,userid,cat,date,title,description,keywords,bigimage,width,height,filesize,medwidth,medheight,medsize,approved,lastpost, watermarked,allowprint,extra1,extra2,extra3,extra4,extra5,extra6,ipaddress,allowrate,allowcoms) values(NULL,'Basil', , 523, 1166378787, 'Daimler', 'Daimler', '', 'IMG_0849.JPG', 800, 600, 89362, 600, 450, 57265, 1, 1166378787, 'no','yes','','','','','','','6X.XX.XXX.XX','1','1')

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 ' 523, 1166378787, 'Daimler', 'Daimler', '', 'IMG_0849.JPG', 800, 600, 89362, ' at line 3

What next?

[Chuck S]

Your upuserid is empty have you made the changes noted to the query and to the file uploadproduct.php as I noted?

Have you tried making sure your loginname and displayname match?

[Basil]

Ok, I had removed the wrong thing before. I took out the || $Globals['vbversion'] == "threads" and now it seems to be working (so far).

I'm a little confused why I would remove the code for threads, but it worked (remember I am running threads 6.5). So, when I am finally ready to move to Threads 7, should I then replace the above code for threads, but remove the code for threads7 ?

Thanks for all your help!
Basil

[Chuck S]

Nope the edit noted should not be in there which is why I said to remove it we dont deal with loginname at all in regular threads.