Help! Problem Needs Solving Fast!

[Nanana]

Major problem, really need help fast!

Database error in vBulletin 3.6.8:

Invalid SQL:

			SELECT info_hash, attachment.size,comment,created_by,announce_list,completed_by, completed, seeders, leechers, ulspeed, dlspeed, dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
				postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
				attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
			FROM attachment
			LEFT JOIN attachmenttype AS attachmenttype USING (extension)
			WHERE postid IN (-1,445,446,451,454,455,457,460,470,474,476,486,488,494,499,502,565,574,596,597)
			ORDER BY attachmentid;

MySQL Error  : Unknown column 'info_hash' in 'field list'
Error Number : 1054
Date         : Monday, March 10th 2008 @ 03:00:00 PM
Script       : http://www.XXXXX.net/forums/showthread.php?p=596
Referrer     : http://www.XXXXX.net/forums/index.php
IP Address   : XX.XXX.XXX.XXX
Username     : X
Classname    : vB_Database

 

[Nanana]

I really need to fix this, otherwise attachments just crash my forums >_<

 

[SpeedRazors]

did you install any hacks lately ? drupal hack ? other hacks..... its missing a field in your database called info_ mostly this is because the hack didn't do the database changes

 

[SpeedRazors]

http://www.vbulletin.com/forum/archive/index.php/t-230125.html

here someone has the same problem....

 

[Nanana]

disabled all hacks, problem still there, >_<

other suggestions?

 

[SpeedRazors]

well there is another way create a table yourself as far as i can see it needs to be made in the attachements table..... go in your phpmyadmin and open the table attachement, now create a new field with this info:

info_hash varchar(20) binary NOT NULL default ''

now it should work

 

[Nanana]

not too sure how to enter what you said

theres the screenie, so can you tell me what goes where? after that I have a tick box to decide if I want it:

primary

index

unique

....

fulltext


What exactly do I need to set these as ?

EDIT: damn resizing images >_< guess I'll type it out

here are the fields I need to fill in:

Field
Type
Length/Values1
Collation
Attributes
Null
Default2
Extra

followed by the tick boxes:

Primary
Index
Unique
---
Fulltext
Comments

what goes where, I'm hopeless with phpmyadmin XD

 

[SpeedRazors]

Field = info_hash
Type = VARCHAR
Lenght/Values = 20
--> leave callation blank
--> leave attributes blank
Null = NOT NULL

Leave the rest like it is just add the thing and your done

 

[Nanana]

Still not working T_T

Database error in vBulletin 3.6.8:

Invalid SQL:

			SELECT info_hash, attachment.size,comment,created_by,announce_list,completed_by, completed, seeders, leechers, ulspeed, dlspeed, dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
				postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
				attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
			FROM attachment
			LEFT JOIN attachmenttype AS attachmenttype USING (extension)
			WHERE postid IN (-1,674,677,705,739)
			ORDER BY attachmentid;

MySQL Error  : Unknown column 'attachment.size' in 'field list'
Error Number : 1054
Date         : Tuesday, March 11th 2008 @ 05:38:05 PM
Script       : http://www.XXXXXX.net/forums/showthread.php?p=739
Referrer     : http://www.XXXXXX.net/forums/newreply.php?do=newreply&noquote=1&p=705
IP Address   : XX.XXX.XXX.XXX
Username     : X
Classname    : vB_Database

 

[Morpheus]

Do not store your attachments on the database, store files on FTP. You can change it in your vBulletin Options.

 

[Nanana]

which settings group? can't find this option >_<

 

[SpeedRazors]

goto your vbulletin options and go to the line that displays your hack...... there you can change the options of the hack

 

[Nanana]

the problem isn't a hack, its the attachments. Morpheus said there was a setting in vbulletin options to set attachments to FTP intsead of from the database, but I can't find the option he's talking about.

 

[SpeedRazors]

send me your attachment table from your database please

 

[SpeedRazors]

table seems oke.........

well read this thread http://www.vbulletin.com/forum/archive/index.php/t-230125.html the file info_hash is not standard on vbulletin software so an installed modification is responsible for this...

 

[Nanana]

I have already tried by disabling all mods and plugins, and it was exactly the same. Morpheus said something about it being the way they were stored, but I'm not sure how to change it to FTP like he suggested.

 

[PBX1]

I have already tried by disabling all mods and plugins, and it was exactly the same. Morpheus said something about it being the way they were stored, but I'm not sure how to change it to FTP like he suggested.

AdminCP -> Attachments -> Attachment Storage Type
It moves your attachments from the database into the file system.

 

[Spinifex]

heres a handy php file you can upload to your FTP and then goto www.yourdomain/forumpath.php and it will tell you your forum path to the FTP to put into the attachment path!

example: /home/sqlname/public_html/

Instructions: extract and upload to your www folder on ftp

Spinifex.

 

[Nanana]

none of these suggestions is working either, following these still results in the database error.

 

[SpeedRazors]

disable the hacks isn't really the way... the hack is not active but all database entries etc etc still there, uninstall the hacks will totaly remove the hack.. can you make a list for me what hacks your using please.......