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)
-   -   vb3 Attachments - Including Multiple Attachments Option (https://vborg.vbsupport.ru/showthread.php?t=52294)

Boofo 05-01-2003 12:34 AM

I just got this error when I ran the portattachments.php. What do I do? ;)



Database error in vBulletin 2.2.9:

Invalid SQL: UPDATE attachment SET postid=193 WHERE attachmentid=56
mysql error: Unknown column 'postid' in 'field list'

mysql error number: 1054

Date: Wednesday 30th of April 2003 06:32:17 PM
Script: http://www.bearfacts2.com/forum/foru...ttachments.php
Referer:

Boofo 05-01-2003 12:46 AM

I have run in to a major problem trying to install this hack. I have the "Keep attachments when previewing" hack installed and the code in completely different for that. Anyone else have that hack installed and know what to change or not change?

350Chevy 05-01-2003 02:14 AM

Sorry I didn't see this until now about the "fix the file size"

Code:

ALTER TABLE `attachment_tmp` CHANGE `filedata` `filedata` MEDIUMTEXT NOT NULL
Thanks...

But is there any way to get this option in the admin panel to work when set to YES?

Code:

View Images -Do you wish to display attached images in the threads? Select no to just generate a link to download the image
I'd MUCH rather have the pictures viewed when viewing a thread.. :(

Austin Dea 05-01-2003 02:25 AM

getting a db error when trying to delete post with attachments...

Quote:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT attachmentid FROM post WHERE attachmentid=177,178 AND threadid<>'759'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '178 AND threadid<>'759'' at line 1

mysql error number: 1064

Date: Wednesday 30th of April 2003 07:00:37 PM
Script: http://forums.razael-central.com/editpost.php
Referer: http://forums.razael-central.com/edi...t&postid=11594
I'm running MySQL 4.0.12.

Austin Dea 05-01-2003 02:27 AM

Whoops, missed the fix in post #103

edit: Nope, still getting the error.

350Chevy 05-01-2003 02:40 AM

Quote:

Today at 04:27 AM Austin Dea said this in Post #135
Whoops, missed the fix in post #103

edit: Nope, still getting the error.


hehe.. yup I get that same exact error.. I didn't notice it or test it until you posted that..

Also here's a few more funny things happening with mine..

1) When posting a TOPIC I can only attach one file. If I try to attach a second file it will replace that one file with whichever new file I try to ADD. Try to add another and the same thing.. rinse.. repeat...

2) When posting a REPLY I can attach as many files as I wish. Once I hit submit I get an error:

Code:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT title FROM thread WHERE threadid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Wednesday 30th of April 2003 11:43:57 PM
Script: http://www.ls6.com/forums/forums/newreply.php
Referer: http://www.ls6.com/forums/newreply.p...threadid=15822

BUT... The post goes through just fine with all the attachment(s). If I hit back in my browser and goto view the thread my post with it's attachment(s) are there.

Still would like to get the view images working too. :P

Austin Dea 05-01-2003 02:54 AM

The code that my db error is referring to (post #134) is the 'Start delete post' section of functions.php, if that helps.

350Chevy 05-01-2003 03:29 AM

The "last post by" isn't being updated when attaching a file or files to a reply. I'm wondering if that's where the db error is kicking in.. The db error pops up but the post with all the attachments still show...

BTW Mods, This thread should be moved to Beta hacks.. I've successfully installed over 50 hacks with VERY little problem. The very few hacks that I had a problem with were fixed within the same day. This one looks like it has a little ways to go before it's "Final."

Current problems with this hack:

1) Images are not being shown in the threads currently due to a bug with the Multiple file attach hack that will not allow the option to "View Image Attachments" to be set to "YES." There are however links to each attachment and the multiple file attachments are working somewhat.

2) You can't attach more than one image when starting/creating a new thread/topic. If you try it will just replace the last image you try to attach. No database errors when submitting though which is nice.

3) When attaching images (any ammount.. 1 or 100) to a reply you will get a db error. The post will still post and the attachments will all be there but you still get a db error which is not fun. :lick: :banana:

squawell 05-01-2003 06:12 AM

rake i find another problem when i edit post and i dont attach any

file but front my thread title it show up the pic(paperclip.gif)

how fix that ??thankz.

Boofo 05-01-2003 06:35 AM

rake, do you think you can lend me a hand to install this as I have the "Save Attachments on Preview" and the "Show Image" (By Slynderdale) hacks installed which makes the code I need to find and change totally different than what I am supposed to have? I figure since it is your hack you might know who to incorporate it better with those hacks. ;)


All times are GMT. The time now is 06:42 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.01958 seconds
  • Memory Usage 1,746KB
  • 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
  • (3)bbcode_code_printable
  • (2)bbcode_quote_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