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)

rake 05-01-2003 09:58 AM

Quote:

Today at 02:34 AM Boofo said this in Post #131
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:


You've missed a query.
Yes, i'll gladly help, Boofo.


Current TO DO List:
Fix the first two errors reported by 350Chevy.
Fix the Delete Error.

Boofo 05-01-2003 11:30 AM

I was starting to do a fresh install. I ran the queries in the part of the code for the new install. Do I need to run portattachments.php on a new install. If so, can you please tell which query I missed?

Thank you for the help. What files do I need to PM to you to do the code changes?

Boofo 05-01-2003 01:16 PM

I need to reverse the queries for this hack until I can get the code changes to get it installed. I can't post or make any new threads. Here is the error I am getting:

Quote:

Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT a.attachmentid
FROM attachment AS a
LEFT JOIN post ON (post.attachmentid = a.attachmentid)
LEFT JOIN privatemessage ON (privatemessage.attachmentid = a.attachmentid)
WHERE postid IS NULL AND privatemessageid IS NULL

mysql error: Column: 'postid' in where clause is ambiguous

mysql error number: 1052

Date: Thursday 01st of May 2003 07:11:40 AM
Script: http://www.bearfacts2.com/forum/foru...ead&forumid=11
Referer: http://www.bearfacts2.com/forum/foru...?s=&forumid=11
Can anyone please tell me how to revert the queries back to what they were before I ran them for this hack for now? These are the queries I think that need to be converted back to the originals until rake can help me with the coding.

ALTER TABLE `post` CHANGE `attachmentid` `attachmentid` VARCHAR( 50 ) DEFAULT '0' NOT NULL;
ALTER TABLE `post` ADD INDEX ( `attachmentid` );
ALTER TABLE `attachment` ADD `postid` INT NOT NULL;
ALTER TABLE `attachment` ADD INDEX ( `postid` );

350Chevy 05-01-2003 01:23 PM

Quote:

Today at 11:58 AM rake said this in Post #141
You've missed a query.
Yes, i'll gladly help, Boofo.


Current TO DO List:
Fix the first two errors reported by 350Chevy.
Fix the Delete Error.


Thanks Rake... This is still probably the best hack out there. :classic: :banana:

Boofo 05-01-2003 02:51 PM

Can anyone please lend a hand with my problem (posted in Post # 143 above)? My forums are down until I can get this fixed.

rake 05-01-2003 02:56 PM

If you don't count the errors, that is. :nervous:
You have to try to see this from my point of view too. The hack makes changes in 4 of the most important vbulletin files. You never know when a new error might come up. I tested it on a few boards and everything seemed allright, so i thought putting it in the Full Releases forum was a good idea.



====================

Version 1.3

This new version fixes all of the reported bugs:

1. The view image atachments option now works
2. Attaching more than one file with a new thread now works
3. Deleting a post with attachments now works

Please re-download the file in the first post. Thank you :)
https://vborg.vbsupport.ru/showthrea...561#post388561

Boofo: That isn't from my hack, but replacing:
WHERE postid IS NULL AND privatemessageid IS NULL
with
WHERE post.postid IS NULL AND privatemessageid IS NULL
should work

Austin Dea 05-01-2003 03:11 PM

I'm still getting the db error when trying to delete a post. I did all of the 1.3 updates..

rake 05-01-2003 03:25 PM

Quote:

Today at 05:11 PM Austin Dea said this in Post #147
I'm still getting the db error when trying to delete a post. I did all of the 1.3 updates..

the two functions.php changes handle that.

iggy123 05-01-2003 03:29 PM

RAKE


Your latest update has fixed all of my problems - thnx for spending the time to fix it - i bet next time you wont offer support ;)

Austin Dea 05-01-2003 03:34 PM

Sweet, cleared my cache and it works.


All times are GMT. The time now is 07:14 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.01300 seconds
  • Memory Usage 1,745KB
  • 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
  • (4)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