Having installed quite a few MODs without trouble - this one isn't completely working for me. Let's assume for sake of argument that I am a complete dunce.
While executing the MOD, I found that I did not have a line in member.php that read
$msg .= $lang['image_add_success'].": <b>".stripslashes($image_name)."</b> (".$new_name.")";
the closest I had was
$msg .= $lang['image_add_success'].": <b>".format_text(stripslashes($image_name))."</b> (".$new_name.")";
So I replaced that with
$msg .= $lang['image_add_success'].": <b>".stripslashes($image_name)."</b> (".$new_name.")<br>";
as instructed.
However, when testing, the top of the confirmation page (/member.php) read
[qcode]
DB Error: Bad SQL Query: INSERT INTO 4images_images (cat_id, user_id, image_name, image_description, image_keywords, image_date, image_active, image_media_file, image_thumb_file, image_download_url, image_allow_comments) VALUES (7, 1, 'Swim', '', 'swim river', , 1, 'IMG_9373.jpg', 'IMG_9373.jpg', '', 1)
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 ' 1, 'IMG_9373.jpg', 'IMG_9373.jpg', '', 1)' at line 4
DB Error: Bad SQL Query: INSERT INTO 4images_images (cat_id, user_id, image_name, image_description, image_keywords, image_date, image_active, image_media_file, image_thumb_file, image_download_url, image_allow_comments) VALUES (7, 1, 'Swim 2', '', 'swim river', , 1, 'IMG_9446.jpg', 'IMG_9446.jpg', '', 1)
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 ' 1, 'IMG_9446.jpg', 'IMG_9446.jpg', '', 1)' at line 4[/qcode]
Suspecting the different original code was important (I do not know php, I just follow instructions), I compared the expected original line with mine (which I may have changed when installing another MOD) and applied the differences to the replacement, thus:
$msg .= $lang['image_add_success'].": <b>".format_text(stripslashes($image_name))."</b> (".$new_name.")<br>";
I tested this with 2 images and again the top of the confirmation page (/member.php) read
[qcode]DB Error: Bad SQL Query: INSERT INTO 4images_images (cat_id, user_id, image_name, image_description, image_keywords, image_date, image_active, image_media_file, image_thumb_file, image_download_url, image_allow_comments) VALUES (5, 1, 'scenes', '', '', , 1, '_MG_8981.jpg', '_MG_8981.jpg', '', 1)
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 ' 1, '_MG_8981.jpg', '_MG_8981.jpg', '', 1)' at line 4
DB Error: Bad SQL Query: INSERT INTO 4images_images (cat_id, user_id, image_name, image_description, image_keywords, image_date, image_active, image_media_file, image_thumb_file, image_download_url, image_allow_comments) VALUES (5, 1, 'scenes 2', '', '', , 1, '_MG_9057.jpg', '_MG_9057.jpg', '', 1)
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 ' 1, '_MG_9057.jpg', '_MG_9057.jpg', '', 1)' at line 4[/qcode]
Can anyone help? Thanks in advance