vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Attachments as files (https://vborg.vbsupport.ru/showthread.php?t=35193)

Bison 03-05-2003 02:11 AM

I hope you backed up your files & database. This puppy is *Dangerous* ... once you've got errors they can't be fixed properly...

FleaBag 03-05-2003 03:13 PM

There was no point me backing up my database, I installed this hack a long time ago, my database has trebbled in size since then. There must be a way of re-importing the files into the database.

Bison 03-05-2003 05:50 PM

I ead somewhere in this thread that one of the guys were going to create a file importer program for this hack. The author hasn't supported this hack in several months, and I believe that he was working on making this file importer.

I feel for you, but I would have made a backup (Of everything) before upgrading my forum... if I was successful installing this hack the first time.

It's a nice idea with a deadly bite ...

wooolF[RM] 03-05-2003 08:02 PM

nah... it works on all versions exept 2.3.x
and that's bad... otherwise it's a nice hack... I use it and have no problems

FleaBag 03-05-2003 11:34 PM

I do back up my forums, and in fact all of my site on a monthly basis - all I'm saying is that a backup from a month ago would be useless to me.

Is it possible for me to downgrade to 2.2.9?

FleaBag 03-06-2003 12:21 AM

Looks like this hack is never gonna work for me, so I think it's time to say goodbye to this thread permanantly [and to over a years worth of attachments]. Oh well...

Bison 03-06-2003 12:26 AM

Like I said before ... Nice Idea, but with no support, your playing a game of "russian roulette!"

NoAhBoDy 03-06-2003 04:16 AM

..so I guess if you have this hack installed and don't want to lose your attachment db, you're stuck at 2.2.9 ??

FleaBag 03-08-2003 01:33 AM

More or less - yes. And you won't be able to upgrade to version 3 either.

FleaBag 03-12-2003 10:52 AM

OK I've found a solution for anyone wishing to remove this hack so that they can continue with versions 2.3.x onwards.

BY DOING THIS YOU WILL LOSE ALL OF YOUR ATTACHMENTS

Uninstall the hack using the install file.

Run this query...

Code:

DROP TABLE IF EXISTS attachment;
CREATE TABLE attachment (
  attachmentid smallint(5) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL,
  dateline int(10) unsigned NOT NULL,
  filename varchar(100) NOT NULL,
  filedata mediumtext NOT NULL,
  visible smallint(5) unsigned NOT NULL,
  counter smallint(5) unsigned NOT NULL,
  PRIMARY KEY (attachmentid)
);

You can now delete the folder with attachments as files inside.

You will lose ALL attachments in your BB, do not blame me if what I tell you to do here messes anything in your site up - MAKE A BACKUP.

Over and out. :)


All times are GMT. The time now is 09:41 PM.

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.02057 seconds
  • Memory Usage 1,732KB
  • 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
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete