rp_buddy error
 

I haven't uploaded a new product in like 2 years but when I tried today I got this message. The sucky thing is my rp just expired on the 5th and I can't even download the last version. I'm running 3.4 . I think I should be at least entitled to the versions released during that time.

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

Script:

Query: SELECT userid FROM rp_buddies WHERE buddy=

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

Database handle: Resource id #37

Try making $uid this '$uid'

anyway I can just get the download from the latest version? it just expired 3 days ago. you can see from 3.4 i haven't downloaded a new version in months.

I did a grep for the code and found it member.php ? So I changed it to

I still get the same error message.

You have incorrectly placed the variable encapsulation. try replacing it with the line I have above. ;)

I used your code:
and now it says:

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

Script:

Query: SELECT user,userid,COUNT(*) AS pcount FROM rp_products GROUP BY user ORDER BY pcount DESC LIMIT 5

Result: Got error 12 from table handler

Database handle: Resource id #37

Result: Got error 12 from table handler

Your query is different this time

mysql error: Got error 28 from table handler (error number 1030) - vBulletin Community Forum

Your host might need to assist there

Everything else works. vbulletin, classifieds etc.

Filesystem Size Used Avail Capacity Mounted on
/dev/ar0s1a 504M 68M 396M 15% /
/dev/ar0s1g 504M 24M 440M 5% /tmp
/dev/ar0s1e 2.0G 1.6G 204M 89% /usr
/dev/ar0s1f 1008M 26M 901M 3% /var
/dev/ar0s1h 24G 19G 3.0G 86% /web

I am just saying what that error tells me based on all the mysql support information posted on the net.

Make sure you use a default clean file from your backup files of member.php and just make the change noted in my post 2

The next error is one saying mysql tmp storage is used up as I noted

I usually use vi but this time I used Textpad. It gives the same message. the product actually uploads though.

I looked in photos/members and found the same line and tried that too and just changed pp_ to rp_ and get the same error. kinda sucks.

what do you mean by pp_?

You are talking about upload now that is not in our prior discussion here so now I am a little confused here.

If you change the line I noted in post 2 you can not get the same error unless your not overwriting the file on the server.

I compared the lines from photopost and reviewpost in their members.php file. They were pretty much same except the photopost was a little bit different. Of course the Photopost file refers to pp_ and reviewpost refers to rp_ respectively.

I didn't overwrite the whole files, just tried that line too as an option. I need to get this fixed please.

Feel free to download reviewpost 4.04 as anything we have discussed is in there but the fix I noted is here and works fine all your doing is encapsulating the $uid variable with single quotes.

http://www.photopost.com/forum/1235635-post2.html

I would but my download expired from the members area.

exipred 11/5/08 2:08 PM

Then simply use your clean backup file and only make sure you do as instructed in post 2

Basically your buddy variable is empty which is the error so on line 290 that query line which is the only one in that file your changing the variable $uid to '$uid' thats it.

I"ve used my clean backup and I used your line.

and I get this message.

Please do not post our code like that thanks.

Now my suggestion would be if your still getting that error is make sure your overwriting that file on the server as it would appear not. it is the member page your viewing when you get that error right?

There is also a similar query in image-inc.php you might want to also encapsulate the variable on but then my question would be why is $user['userid'] empty.

I get the error message when I upload a new product.

Then as instructed encapsulate the variable in image-inc.php

I couldn't find it.