rp_buddy error

rcsmith · November 8th, 2008, 10:40 AM

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

Chuck S · November 8th, 2008, 10:55 AM

Code:

Content visible to verified customers only.

Try making $uid this '$uid'

rcsmith · November 8th, 2008, 10:57 AM

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.

rcsmith · November 8th, 2008, 11:08 AM

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

Code:

Content visible to verified customers only.

I still get the same error message.

Chuck S · November 8th, 2008, 08:11 PM

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

rcsmith · November 8th, 2008, 08:35 PM

I used your code:

Code:

Content visible to verified customers only.

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

Chuck S · November 9th, 2008, 09:27 AM

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

rcsmith · November 9th, 2008, 10:37 AM

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

Chuck S · November 9th, 2008, 10:47 AM

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

rcsmith · November 9th, 2008, 12:07 PM

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.

Chuck S · November 9th, 2008, 12:11 PM

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.

rcsmith · November 11th, 2008, 06:45 PM

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.

Chuck S · November 11th, 2008, 08:09 PM

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.

rp_buddy error

rcsmith · November 12th, 2008, 01:53 AM

I would but my download expired from the members area.

exipred 11/5/08 2:08 PM

Chuck S · November 12th, 2008, 08:10 AM

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.

rcsmith · November 12th, 2008, 08:23 AM

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

Code:

Content visible to verified customers only.

and I get this message.

Code:

Content visible to verified customers only.

Chuck S · November 12th, 2008, 08:34 AM

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.

rcsmith · November 12th, 2008, 10:11 AM

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

Chuck S · November 12th, 2008, 11:00 AM

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

Code:

Content visible to verified customers only.

rcsmith · November 12th, 2008, 11:02 AM

I couldn't find it.