vbbux causing Database error ??

[PinkDaisy]

Once in a while, I get a database error in 1 forum, and I have to manually fix it by going to my AdminCP and turning off vbbux, and then turning it back on. After I do that, all is fine and working. Any clues on why this is doing that?

Thanks for any help!

[HMBeaty]

Not if you don't tell us what the error is.....

[PinkDaisy]

I get the Error Number: 1054

[HMBeaty]

I get the Error Number: 1054

Whats the whole error?

[Marco van Herwaarden]

I hope you do realise that vBux was removed from this site as it contains vulnerabilities and we strongly advice not to use it.

[PinkDaisy]

This is the whole error that I get in emails.

Database error in vBulletin 3.6.4:

Invalid SQL:

UPDATE user AS user, post AS post
SET
`user.vbbux` = `user.vbbux` + `post.vbbux`
WHERE
post.threadid = '15212'
AND user.userid = post.userid;

MySQL Error : Unknown column 'user.vbbux' in 'field list'
Error Number : 1054
Date : Wednesday, April 18th 2007 @ 03:54:28 AM
Script : http://belliesbabiesnbeyond.com/forums/inlinemod.php?do=domovethreads&threadids=13163,13162
-----------------------------------------------

And yeah I realized it was removed here but I thought it was for ppl to not download it anymore. Is there a BIG risk that someone will happen to my forums? Does html enabled on my forums also have anything to do with this??

[deezelpope]

The way I understand it is that your whole site could potentially be wiped out, or so I read.

[HMBeaty]

Is there a BIG risk that someone will happen to my forums? Does html enabled on my forums also have anything to do with this??

Well, you really don't want to have html enabled anywhere on your site as that can help hackers enter your site. Same thing with vbbux, its full of exploits. So its your choice. Do you want to have board hacked? Or take actions to prevent it from being hacked?

[PinkDaisy]

Is it the whole Vbbux/plaza that I have to disable, or just parts of it??

[Coux]

you have a nice site there would be a heartbreak to lose it.. my advice is remove vbux/plasa altogether.. to be safe

[deezelpope]

Once again, I agree with Coux...no, I'm not stalking you! LOL!! He's right, your site is very cute, and that mod, as cool as it may be, just isn't worth taking that chance, IMO.

[PinkDaisy]

Thanks yall. My Members and staff are just hating to see it go away. it's a fun feature for them and they just hate not having it.. One even asked me what would a hacker get from my site, which is true since its a parenting/ttc/pregnancy/ladies community, but I dunno.. I want the site to be 100% or more safe.. so I guess I'm just being pulled.. :(

[deezelpope]

Why don't you look into iCash, iBank, and iShop? That's what I use. It doesn't have all the features of vPlaza, but it's good enough for my members and me. Something to think about. Plus, I really think it will lighten the blow with your members if you have a comparable replacement.

[PinkDaisy]

Thanks. I may look into that to see what all it offers and test it. ;)

[deezelpope]

Well, there's the points system, the bank, and the shop...you can donate points and gifts. But the gifts (items) you have to rustle up on your own, cuz the items Blaine offers are for gamers...but you can use your vPlaza items and ribbons...that's what I'm doing...

Please let me know if there's anything I can do to help you!

[PinkDaisy]

Thanks so much for your help. I am gonna try to do this on my test VB to see what I can and all. And then put it up for the members.

Thanks again! ;)

[deezelpope]

You're very welcome! I love your site, and your name here is pretty cute, too!!:)