- Welcome to Simple Machines Community Forum.
Uutiset:
SMF 2.1.4 has been released! Take it for a spin! Read more.
#1
SMF 2.1.x Support / getting database errors when posting or if attaching a picture .
toukokuu 06, 2022, 01:48:23 IP tekijältä geminiman...... (`id_folder`, `id_msg`, `filename`, `file_hash`, `fileext`, `size`, `width`, `height`, ` ......
#2
IPB / Re: [SMF Converter] IPB 1.3.x
heinäkuu 11, 2024, 10:20:14 AP tekijältä norrie...... ID_THUMB ID_MSG ID_MEMBER AttachmentType Filename File_hash size downloads width height I have no data in ......
#3
Tips and Tricks / [SMF 2.0.x] How to make image attachments visible to guests?
marraskuu 27, 2022, 07:57:09 AP tekijältä dodos26...... a.id_attach, a.id_folder, a.id_msg, a.filename, a.file_hash, IFNULL(a.size, 0) AS filesize, a.downloads, a. ............ a.id_attach, a.id_folder, a.id_msg, a.filename, a.file_hash, IFNULL(a.size, 0) AS filesize, a.downloads, a. ............ , a.id_folder, a.id_msg, a.filename, a.fileext, a.file_hash, IFNULL(a.size, 0) AS filesize, a.downloads, a. ............ ', ' SELECT a.id_folder, a.filename, a.file_hash, a.fileext, a.id_attach, a.attachment_type, a. ............ SELECT a.id_folder, a.filename, a.file_hash, a.fileext, a.id_attach, a.attachment_type, a. ............ SELECT a.id_folder, a.filename, a.file_hash, a.fileext, a.id_attach, a.attachment_type, a. ......
#4
SMF 2.1.x Support / Attachments and Avatars Maintenance function in Adminconsole
maaliskuu 09, 2022, 07:32:35 IP tekijältä Spacecake...... . The scrambled name consists of <id_attach>_<file_hash> where the hashvalue and attachment id can be ............ in the database table smf_attachment, fields file_hash and id_attach. The hashvalue seems to be ............ 180 entries in the DB with empty value in field file_hash. As a workaround we generated a hash value to ............ () { echo "select id_attach, filename, file_hash from smf_attachments where id_member != 0 AND ............ smf_attachments where filename = '$FILENAME' AND file_hash = '' order by id_attach" | mysql --database= ............ }" SQL="UPDATE smf_attachments SET file_hash='$NEW_HASH' WHERE id_attach = $ID" ......
#5
SMF Coding Discussion / Query doesn't work
huhtikuu 11, 2021, 07:25:46 IP tekijältä Sir Osis of Liver...... = ', $file ,'<br />'; $sql = "SELECT id_attach, file_hash FROM smf_attachments WHERE filename=$file"; $ ............ '<br> id: '. $row["id_attach"] .' hash: '. $row["file_hash"] .'<br>'; } } else { echo "0 results"; } ............ If I remove WHERE clause it outputs id_attach and file_hash, but seems to get stuck in infinite loop. ......
#6
SMF 2.1.x Support / Member ID not being stored on attachment addition
lokakuu 13, 2020, 04:53:58 IP tekijältä Randem...... ', 'id_msg' => 'int', 'filename' => 'string-255', 'file_hash' => 'string-40', 'fileext' => 'string-8', ' ............ ], $attachmentOptions['name'], $attachmentOptions['file_hash'], $attachmentOptions['fileext'], (int) $ ......
#7
Fixed or Bogus Bugs / SMF 2.1 RC3 md5_file and array to string conversion error
joulukuu 01, 2020, 08:07:59 IP tekijältä -Rock Lee-...... ']; return $path . '/' . $attachment_id . '_' . $file_hash . '.dat'; } I am trying a conversion from 2.0 to ......
#8
SMF 2.0.x Support / A few image attachments not displayed
lokakuu 11, 2020, 10:05:11 AP tekijältä izotz...... ":"South Africa 1923 ¼d.jpg", "fileext":"jpg", "file_hash":""Hash is not recorded in the database, probably ......
#9
SMF 2.0.x Support / Upgrade.php unable to connect to the database while everything else can
maaliskuu 24, 2019, 09:24:30 IP tekijältä temeraire02...... error Koodi [Valitse] Laajenna Unknown column 'a.file_hash' in 'field list' File: /opt/bitnami/apache2/ ......
#10
Fixed or Bogus Bugs / ManageAttachments forever loop?
tammikuu 01, 2019, 06:13:10 AP tekijältä jindroush...... .id_attach, thumb.id_folder, thumb.filename, thumb.file_hash FROM XXX_attachments AS thumb LEFT JOIN ......
#11
SMF 2.1.x Support / Problem uploading attachments
elokuu 16, 2019, 04:40:13 IP tekijältä Dylert...... (`id_folder`, `id_msg`, `filename`, `file_hash`, `fileext`, `size`, `width`, `height`, ` ......
#12
SMF 2.0.x Support / [2.0.14 - newly patched] Problem with attachmentUploadDir causing 404 errors
heinäkuu 11, 2017, 07:13:47 IP tekijältä perkele...... , $attachment_id, $dir = null, $new = false, $file_hash = '') { global $modSettings, $smcFunc; // ... ............ ']; return $path . '/' . $attachment_id . '_' . $file_hash; } I did some debugging and found out that ! ......
#13
YaBB/YaBB SE / Re: [SMF Converter] YaBB SE 1.5.4
elokuu 06, 2019, 02:00:36 IP tekijältä trilogi...... in 1.1 but now there is in 2.0. There is no file_hash in those entries because it was manual input ( ......
#14
SMF 2.0.x Support / help, was unable to connect to the database. This may be caused by the server
joulukuu 31, 2016, 07:12:51 AP tekijältä nfmovil...... for table level lock SELECT id_folder, filename, file_hash, fileext, id_attach, attachment_type, mime_type, ............ for table level lock SELECT id_folder, filename, file_hash, fileext, id_attach, attachment_type, mime_type, ............ for table level lock SELECT id_folder, filename, file_hash, fileext, id_attach, attachment_type, mime_type, ............ for table level lock SELECT id_folder, filename, file_hash, fileext, id_attach, attachment_type, mime_type, ............ for table level lock SELECT id_folder, filename, file_hash, fileext, id_attach, attachment_type, mime_type, ............ for table level lock SELECT id_folder, filename, file_hash, fileext, id_attach, attachment_type, mime_type, ......
#15
SMF Coding Discussion / Apparent Premature Termination of session?
maaliskuu 09, 2016, 01:06:28 AP tekijältä Matthew K....... ;area=quiz_questions;sa=add;referer=mass_import;file_hash=ce61ad8bc6b32ddaf035173d464dcae0bae5120b; ......
#16
Français (French) / Transfert hébergeur, et plus d'avatars! :(
maaliskuu 21, 2014, 07:35:24 AP tekijältä aubrybybo...... présent (avec les droits 777), et la valeur de file_hash de la table correspond bien avec le nom des ......
#17
SMF 2.0.x Support / Attachments links dònt work more
marraskuu 05, 2014, 12:44:02 IP tekijältä musicus...... : 0 filename: Adeonesis_-_Experiment_1.mp3 file_hash: ebce3caf2e7fda03944c7968caef63880bc9bb36 fileext: ......
#18
Español (Spanish) / Problema en el traslado de fotos tras migrar foro y hacer upgrade
syyskuu 01, 2014, 07:53:26 IP tekijältä manueltrigo...... , creadas con la versión 2.0.8 tienen el campo file_hash relleno con lo que aparece en el nombre de la ............ ), además, en el foro antiguo tampoco aparece el file_hash en la BD y sí se ven. Las fotos están bien, pues ......
#19
Install and Upgrade Help / I can't see the photos after large upgrade.
syyskuu 03, 2014, 04:51:01 IP tekijältä manueltrigo...... : the new, created with version 2.0.8 have file_hash field filling with what appears in the name of ............ ), in addition, in Forum old does not appear the file_hash in the BD and I can see the photos there. The ......
#20
phpBB / Some easy fixes to the phpBB 3 to SMF 2 converter....
heinäkuu 28, 2013, 10:04:58 AP tekijältä dougiefresh...... DEFAULT '0', `filename` tinytext NOT NULL, `file_hash` varchar(40) NOT NULL DEFAULT '', `fileext` ............ ', 'png', 'bmp'))) $attachmentExtension = ''; $file_hash = getAttachmentFilename($row['filename'], $ ............ , true); $physical_filename = $id_attach . '_' . $file_hash; if (strlen($physical_filename) > 255) return; ............ ), 'filename' => $row['filename'], 'file_hash' => $file_hash, 'id_pm' => $row['id_pm'], ' ............ ', 'png', 'bmp'))) $attachmentExtension = ''; $file_hash = getAttachmentFilename($row['filename'], $ ............ , true); $physical_filename = $id_attach . '_' . $file_hash; if (strlen($physical_filename) > 255) return; ............ ), 'filename' => $row['filename'], 'file_hash' => $file_hash, 'id_msg' => $row['id_msg'], ' ......