vb.org Archive
Page 8 of 11 « First 67 8 910 Last »
Show 40 post(s) from this thread on one page

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. :)

Stud_Muffin 03-21-2003 11:33 AM
Quote:
03-12-03 at 12:52 PM GamerForums said this in Post #290
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. :)


Did that, lots of files to sieve through now :cry:

FleaBag 03-21-2003 04:04 PM
What do you mean?

Stud_Muffin 03-21-2003 04:08 PM
I still have the attachments on my server but not on the forum. Just loads of files like so. beca544936ecfacf43c7076feb61d140.file so i need to load them up to see if i need to keep or delete them, that was all.

FleaBag 03-21-2003 04:10 PM
Ah I see what you mean. I didn't go to that much effort... My site has been open for 15 months, so there was a fair few to look through... I just deleted them all. :(

Bison 03-21-2003 06:39 PM
IMO ... this thread and this hack needs to be removed since no one's gonna help anyone with this !

wolfman 03-22-2003 02:53 PM
Well I am glad I was able to see this before installing this hack.

wooolF[RM] 03-29-2003 12:46 PM
]or just run 2.2.9 :D and no problems

storing all attachments in the database is pain in the ass as for the speed of it and as for backuping

FleaBag 03-29-2003 01:45 PM
But still, your attachments won't work in version 3.x.

Bison 03-29-2003 07:17 PM
Quote:
Today at 09:46 AM wooolF[RM] said this in Post #297
or just run 2.2.9 :D and no problems

storing all attachments in the database is pain in the ass as for the speed of it and as for backuping
I Guess you don't plan on updating to vB3! :smoke:

wooolF[RM] 03-29-2003 09:12 PM
]exactly my point, Rolodex! ;) :D

Scott MacVicar 04-05-2003 07:41 AM
Silly question how isn't it working for vB 2.3.0 I didn't see any changes in the attachment code.

I will test this now on a fresh cvs copy.

Scott MacVicar 04-05-2003 07:42 AM
and there has been 2 users who upgraded to vB3 as well as using this hack, I provided a script to do so and you only need vB 2.2.9 to upgrade to vB3.

Scott MacVicar 04-05-2003 07:59 AM
Installed file on a 2.3.0 board following the instructions exactly. How exactly did you go about the upgrade?
All you needed to do was make the file changes, you didn't need to uninstall the hack beforehand as this would remove the hash column and you would lose the association with the attachments in the directory.

scotty 04-05-2003 08:18 AM
I followed the instructions exactly, the hash is still in the databse, can access the files per browser (supply the filename directly), but get the error:

Quote:
Warning: stat failed for /home/web3/html/ioff/attachments/84902300622b0d0ded64d1ddcb68ff5e.file (errno=2 - No such file or directory) in /home/www/web3/html/ioff/attachment.php on line 53

Warning: fopen("/home/web3/html/ioff/attachments/84902300622b0d0ded64d1ddcb68ff5e.file", "rb") - No such file or directory in /home/www/web3/html/ioff/attachment.php on line 54

Warning: fread(): supplied argument is not a valid File-Handle resource in /home/www/web3/html/ioff/attachment.php on line 55

Warning: fclose(): supplied argument is not a valid File-Handle resource in /home/www/web3/html/ioff/attachment.php on line 56
chmod 777 done
php 4.2.2
php_admin_flag safe_mode Off
php_admin_value open_basedir none

Scott MacVicar 04-05-2003 08:35 AM
is this with all attachments or just some and was the attachment before or after the hack install?

scotty 04-05-2003 08:52 AM
copy 2.2.8 to new directory (with all attachments! ~2000)
upgrade to 2.3.0
installed:
- dynamic templates
- quickreply
- avatar as file (no problem!)
- welcome panel
- and now attachment as file

attachment was uploaded with the 2.2.8 version and your hack

when I try to upload, then this error appears:

Quote:
Warning: Unable to create '/home/web3/html/ioff/attachments/bea992c8f4cdf9729c408c93a7deb10b.file': No such file or directory in /home/www/web3/html/ioff/admin/functions.php on line 1776

Warning: Unable to move '/home/www/web3/phptmp/phpfcMMqX' to '/home/web3/html/ioff/attachments/bea992c8f4cdf9729c408c93a7deb10b.file' in /home/www/web3/html/ioff/admin/functions.php on line 1776

Warning: stat failed for /home/web3/html/ioff/attachments/bea992c8f4cdf9729c408c93a7deb10b.file (errno=2 - No such file or directory) in /home/www/web3/html/ioff/admin/functions.php on line 1780

scotty 04-05-2003 08:58 AM
error even apperas, if "upload safe mode" in CP is activated

(avatar as file does work without it)

Scott MacVicar 04-05-2003 10:06 AM
you said you copied the entire directory to a new folder, did you move the attachments back to /home/web3/html/ioff/attachments or adjust the path in settings to reflect this?

scotty 04-05-2003 11:01 AM
Quote:
Today at 01:06 PM PPN said this in Post #308
you said you copied the entire directory to a new folder, did you move the attachments back to /home/web3/html/ioff/attachments or adjust the path in settings to reflect this?
copied entire forum to new folder incl. attachments and adjusted path

Scott MacVicar 04-05-2003 01:28 PM
mk if you can pm me your ftp details and admincp details. Its definately a setting somewhere thats causing this.

The only thing i notice different is
/home/www/web3/html/ioff/attachments
and
/home/web3/html/ioff/admin/functions.php

missing www but that is probably intended

scotty 04-05-2003 01:32 PM
we have at the moment huge server probs, so I get back to you later - maybe it's a "safe mode" problem (the upload) ...

Scott MacVicar 04-06-2003 02:25 AM
going to
http://www.ioff.de/attachments/84902...dcb68ff5e.file

shows the actual file so add the missing www from the path and try that.

scotty 04-06-2003 09:39 AM
PPN - thanks - I try it, when we solved the load issues in our board (load average: 22.04, 22.29, 22.99 ).

scotty

sumandy 04-11-2003 02:35 AM
Urgent need PPN help.. or any other great hacker !

I'm now using VBB2.2.9 and installed the attachment to file hack. The hack can sucessfully install and all attachment can load to file in attachments folder. But there are some problem........

1. Cant retrieve those attachment when I delete all data in attachment.filedata after hack installed (all attachement transfer as file in specified folder) .!!!!!
2. Seems those data still upload in database. !!!!!

I need help ASAP.. any one can help me? Thanks a lot

sumandy 04-11-2003 02:35 AM
Urgent need PPN help.. or any other great hacker !

I'm now using VBB2.2.9 and installed the attachment to file hack. The hack can sucessfully install and all attachment can load to file in attachments folder. But there are some problem........

1. Cant retrieve those attachment when I delete all data in attachment.filedata after hack installed (all attachement transfer as file in specified folder) .!!!!!
2. Seems those data still upload in database. !!!!!

I need help ASAP.. any one can help me? Thanks a lot

GlitterKill 04-11-2003 12:10 PM
I successfully installed this hack but right after doing so the load averages on my site increased dramatically from around .5 to 1.5. Any ideas as to why this is happening?

sumandy 04-12-2003 03:12 AM
No one can help me????

Tim Wheatley 04-23-2003 09:29 PM
Maybe can help someone...

http://www.vbulletin.com/forum/showt...?postid=445219

sumandy 04-24-2003 01:17 AM
Thanks. go to take a look! :D
Quote:
Today at 06:29 AM Tim Wheatley said this in Post #318
Maybe can help someone...

http://www.vbulletin.com/forum/showt...?postid=445219

Tim Wheatley 04-24-2003 08:36 PM
I'm using 2.3.0 by the way, I installed the hack using the file in the 1st post of this thread on an unhacked 2.3.0 and altered the tables as shown in the thread link I posted above, worked for me. BACKUP though if you try it. My host backs mine up every night. :)


All times are GMT. The time now is 08:10 AM.
Page 8 of 11 « First 67 8 910 Last »
Show 40 post(s) from this thread on one page

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.02183 seconds
  • Memory Usage 1,821KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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