Extra insert_into vb3_post field (manually removing a mod)

[Guest210212002]

Invalid SQL:
INSERT INTO vb3_post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, nowplaying, dateline, ipaddress, attach)
VALUES
(1, 1, 'Chris', 23, '', whoops.', 0, 1, 224760, 13014, '', 1154370911, '69.164.74.179', 0);

MySQL Error : Unknown column 'nowplaying' in 'field list'

Now playing hack hosed me - it's not the hack's fault, my cablemodem died on the first import, and I can't get the sucker uninstalled, so I have to manually remove everything. If the product's disabled it doesn't bother with it, so I'm not really down, but I'd like to get it all out of my DB.

Where do I remove the nowplaying field from that SQL query?

[Princeton]

What do you want removed? It wasn't able to insert anything.

if you want to remove the product just UNINSTALL it via PLUGIN MANAGER.

[Guest210212002]

Yeah, I know how to uninstall products. ;) I can't uninstall it, I get this:


Database error in vBulletin 3.5.4:

Invalid SQL:
ALTER TABLE vb3_post DROP nowplaying;

MySQL Error : Can't DROP 'nowplaying'; check that column/key exists
Error Number : 1091

I want to remove whatever's looking for the nowplaying column when someone makes a new post with the plugin enabled.

[Freesteyelz]

Have you tried to reinstall it then uninstall it?

[Guest210212002]

Yeah, same deal, tried importing over it with overwrite, etc. Something's just hosed so I have to manually pluck all the bits out.

Edit: Should mention that with the plugin enabled, I get the error in the first post when I try to post a message. If it's disabled, it doesn't try writing to the missing column.

[Freesteyelz]

What if you were to manually add the "nowplaying" key into the "post" Table and then try to uninstall it?

[Guest210212002]

I gave that a shot actually, and I got the same no-key error when uninstalling it. :(

It's not a huge deal, with it disabled it's not actually hurting anything, it's just annoying to know that it's there. :D

Edit: Thank you for the suggestions though, much appreciated. :) I'm going to export the whole thing to my test forum tonight and just fart around with the DB until I figure it out. I'm decent with SQL, but it's always nice to be able to break stuff at will. :D

[Freesteyelz]

When (:D) you come across the solution can you please post back. I'm a bit curious now. :)

[Princeton]

check the product ... most likely the DROP query is in the UNINSTALL CODE edit box

PLUGINS & PRODUCTS / MANAGE PRODUCTS / click edit on the product

[Guest210212002]

Yeah, I looked at that. I can get it to drop the column itself if I run the query manually, but for some reason the plugin remains and so does whatever code calls the write to that column if someone makes a new post. (Thank you for the time, by the way. :D )

The hack just adds a $post[field] that you fill out when making a post, and sticks it into the postbit. So when someone makes a post, it's still looking for that entry even though the column itself is missing (and even if it's there, actually).

So wherever the code is that actually parses all of the fields that are entered when someone makes a new post (showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, nowplaying, dateline, ipaddress, attach), I need to find that and strip out nowplaying, that's all.

(At least, I think it's that simple, hah!)



When (:D) you come across the solution can you please post back. I'm a bit curious now.


Will do. I'm 30 now, but I still like to break stuff anyhow. The kid in me will never die. ;) I'd be a lot more unhappy about things if my site was actually down, but I'm thinking I'll probably learn some stuff along the way here anyhow.

Edit: Just want to mention again that it's not the hack's fault, it's just bad timing for my cablemodem to drop signal that made my vB so very angry with me.

[Freesteyelz]

Yup. I read the details of the first post and your dropped signal.

*I'm a tad bit older than you are and I too feel the same way. :)