no pictures

[shung]

Pekka,
I managed to install 1.5 and upgrade to 2.0 then applied the 2.02 update. They all appeared to be installed properly, I uploaded a picture to it, it appeared uploaded successfully. But It still will not show any picture...

Also I went to the user and updated the public to access the first exhibition and went to the structure to update it still...no picture:rolleyes:

http://www.siforce.net/eegalleries


win 2000 server
php 5.24
mysql 5.0
iis
helpppp!

Simon

[jtalerico]

Do the images successfully get uploaded to the directory?

* Not sure about windows, I run all unix stuff...

I am sure there has to be some sort of IIS error log? Anything stated in there?

[shung]

I went through all the logs. The picture went to the right place next it shows 0 picture.

[jtalerico]

So the image is in the directory.. ?

So the next thing to check is the database. I have not look at much of Pekka's code (I guess I should if I am going to try to help people :)) Look at the database tables to ensure that once the image is uploaded it inserts the information into the database.

[shung]

what is the easiest way to have a quick peek into it. I only know as much as create/show the database in command prompt.:rolleyes:

[jtalerico]

SELECT * FROM table_name;

Like I said I need to look at Pekka's code... So I have not yet looked at his database structure. From browsing through the code it seems pretty delegated! ;)

I am sure there is some sort of GUI interface for MySQL on windows, check out Google. Most of the time I work in a terminal or just log into phpMyAdmin :)

shung - Did you follow all the directions: http://photography-on-the.net/forum/showthread.php?t=223149 ?

Anyway, good luck!

[shung]

I uploaded another photo, then I went to check the table items, I can see the time and date stamp has changed, although I did not go into the table or don't know how to look inside the table data, it is obvious that some of the table was updated with new info. I also went to check the iis.log, there is no error at all.:rolleyes:

[Pekka]

The database is highly normalized so you can not really see what goes on there without knowing all relations and queries. Upload code has no bugs I know of.

Check EE editor sql error log.

See messages (all of them).

Make sure ftp paths are correct and ftp path and URL point to same physical location on disk for each size and thumb path.

[shung]

I kinda of check them all, they all appear to be fine with no unusual error, I have a feeling it has to do with the compatibility of IIS. Has anyone managed to install EE on IIS, php5 and mysql5 on win2k server with SP3? I am pretty sure the php is working fine, because I have 3 other apps running on them.

[shung]

oh by the way, I wanted to know whether or not I had the same problem on EE1.5 before the upgrade, I found out I had the same problem before it was upgraded to 2.0.

[Pekka]

I recall IIS required to have administrative permissions for folder in order to let PHP create new files in it. Maybe the whole problem is about permissions.