vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Help with a db query please (https://vborg.vbsupport.ru/showthread.php?t=143119)

bashy 03-25-2007 02:47 PM
Help with a db query please
 
Hi

I had the PM Attachments installed but as it never worked i have decided to uninstall it.
No since doing this i am geting db errors, such as below

When i installed the hack i had to run the following queries
Code:
ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid);
Now in the instructions there is no advice as to uninstalling the hack nor removing the said queries, it looks like my db error is something to do with the said queries as well.

Can anyone advise on how to undo what the queries did please?

Code:
  Database error in vBulletin 3.6.4:
 
  Invalid SQL:
 
        SELECT userid,itemid,usedin
        FROM attachment AS attachment
        WHERE attachmentid = 3920;
 
  MySQL Error  : Unknown column 'itemid' in 'field list'
  Error Number : 1054
  Date        : Sunday, March 25th 2007 @ 04:41:36 PM
  Script      : http://www.bashys-place.com/forums/a...0&d=1174816559
  Referrer    : http://www.bashys-place.com/forums/s...ad.php?t=20049

MarkPW 03-25-2007 05:30 PM
It looks as though you haven't disable the plug-ins.

Disable/remove the plugin-in, "private attachments - can view the attachment" and "private attachments - get posthash and allow attachments".

bashy 03-25-2007 05:38 PM
I uninstalled the product.... thats how this has happened
Looking at the plugins, it looks as though they are still there....

private attachments - can view the attachment attachment_start
private attachments - get & show attachments postbit_display_start
private attachments - get posthash and allow attachments private_newpm_start
private attachments - update attachment info private_insertpm_complete

are these what i need to remove?

Just disabled them and the issue as gone away, so i take it i am safe to remove these now?

MarkPW 03-25-2007 05:47 PM
Yes, all four (I only had a quick look at the xml file, seeing 2 - sorry). It's safe to remove them too.

bashy 03-25-2007 06:33 PM
Excellent, thank you very much for your help....


All times are GMT. The time now is 05:27 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01105 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete