Broken link Thumb/Microthumb + Not updated in EE (MYSQL STRICT MODE)

[Richie256]

Hi,

I have do a fresh Install of EE: I have deleted all the files in my gallery and cleared all the tables in MySQL, then I've install the version 1.5 rc4, upgraded to version 2.0 and then upgraded to 2.01.

Everything work fine except this: When I upload a file to database, I got the message that everything was succesfully, but they are not in EE database. the microthumb and thumb pictures appear as broken link. when I check the properties of those broken links, it is : http://127.0.0.1/gallery/ee_admin/doors.jpg When I browse the files on the webserver, I can see that the thumb, microthumb and normal photos are there. See the pictures below

Thanks for any help

http://pages.videotron.com/richie27/screen.JPG

http://pages.videotron.com/richie27/screen2.JPG

[Pekka]

Do not use admin folder in any of the image paths.

[Richie256]

Do not use admin folder in any of the image paths.

Hi Pekka,

I do not use the admin path for the image, I use images/thumb/ . For example: http://127.0.0.1/gallery/images/thumb/ The images are there, I can see them at the right place, but it is not added un EE in the update process. The path settings are correct too. Any idea what might cause that?

Thanks

[Pekka]

One reason for getting broken links that point to admin (when viewed in admin) is that path is empty. Can you send me a database dump of your EE 2 (in PM), I would like to see it how you have set it up. Or, if this EE is accessible though www let me know the URL and passes.

[Richie256]

Hi Pekka,

I've send you a private message concerning this bug. Thanks alot for your help.

[Pekka]

Thanks, PM sent. This a MySQL STRICT mode problem, and needs couple of fixes in EE.

[Richie256]

Thanks, PM sent. This a MySQL STRICT mode problem, and needs couple of fixes in EE.

Okay! Here is another one STRICT mode problem, when updating Photo page settings, Thanks for your help

CountTime of last errorEE source pointMySQL error text
2 2006-10-18 22:19:54 'update_settings' in 'settings' Incorrect integer value: '' for column 'ee_show_photopage_detail_switch' at row 1

[Richie256]

About the MySQL restrict mode, I've installed the version 5.0.26. This is the last version available for Windows on MySQL.com. By default, the MySQL is in Restrict mode. If you want to remove this mode, find your my.ini file and remode the STRICT_TRANS_TABLES in sql-mode like this:

Chande this line:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_ SUBSTITUTION"To this one:
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_ SUBSTITUTION"
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"And then go in your Services and restart your MySQL service.