EE 1.5

[UweB]

Hi,

after some days of testing EE 1.5 on my Server at home today i took the time to setup EE 1.5 on my outside Webserver... It went Ok so far except for a few errors which i do not understand...

I can access the DB and imported the install.sql which created the tables on so on without problems. I created some exhibitions to see how it looks but when i click on the link of one of the exhibitions i get this error:

Exhibit Engine MySQL error!
ERROR FROM QUERY lock in page 'list':

------------------------------
Access denied for user: 'user@localhost' to database 'db_name'

but when i click on the thumbnails i get to the bigger pics. From there back via the "Exhibition Browser" link i get the same message.

The thumbnails and microthumbnails are missing, the directories are empty but i checked the path and it seems right for me. To upload pics works fine...

FTP log window shows me this error message:

get_message_lock: Access denied for user: 'ftp@user' to database 'db_name' msg 689 | ftp
UPLOAD FINISHED SUCCESFULLY.
[Mon Aug 11th, 2003 18:52:29]

msg 688 | ftp
Photo id 2773 added to database.
[Mon Aug 11th, 2003 18:52:29]

...and after testing the FTP Server i get a long list of similar errors:

Temp file is ./temp/100.jpg (size 100 bytes)
Uploading to server 'ftp....ch', path '/gallery/': OK
Downloading (1):
Warning: ftp_login() [function.ftp-login]: Password required for ftp@user.ch. in /../../public_html/gallery/../ftp_servers.php on line 864

Warning: ftp_chdir() [function.ftp-chdir]: User ftp@user.ch logged in. in /.../.../public_html/gallery/.../ftp_servers.php on line 865
FAILED
Downloading (2):
Warning: ftp_login() [function.ftp-login]: Password required for ftp@user.ch. in /.../.../public_html/gallery/.../ftp_servers.php on line 864

What is confusing for me is this mix of working pages and actions and this deny and error messages. I believe that i made a mistake somewhere but after some hours of searching i am at a loss...

What to do ?

regards, Uwe

[Pekka]

UweB wrote:
Hi,

after some days of testing EE 1.5 on my Server at home today i took the time to setup EE 1.5 on my outside Webserver... It went Ok so far except for a few errors which i do not understand...

I can access the DB and imported the install.sql which created the tables on so on without problems. I created some exhibitions to see how it looks but when i click on the link of one of the exhibitions i get this error:

Exhibit Engine MySQL error!
ERROR FROM QUERY lock in page 'list':

------------------------------
Access denied for user: 'user@localhost' to database 'db_name'



You see this error because you do not have permissions in MySQL to do table locks. Nothing serious. I'll have to remove those messages, or perhaps all locks.



FTP log window shows me this error message:

get_message_lock: Access denied for user: 'ftp@user' to database 'db_name' msg 689 | ftp
UPLOAD FINISHED SUCCESFULLY.
[Mon Aug 11th, 2003 18:52:29]

msg 688 | ftp
Photo id 2773 added to database.
[Mon Aug 11th, 2003 18:52:29]

...and after testing the FTP Server i get a long list of similar errors:

Temp file is ./temp/100.jpg (size 100 bytes)
Uploading to server 'ftp....ch', path '/gallery/': OK
Downloading (1):
Warning: ftp_login() [function.ftp-login]: Password required for ftp@user.ch. in /../../public_html/gallery/../ftp_servers.php on line 864

Warning: ftp_chdir() [function.ftp-chdir]: User ftp@user.ch logged in. in /.../.../public_html/gallery/.../ftp_servers.php on line 865
FAILED
Downloading (2):
Warning: ftp_login() [function.ftp-login]: Password required for ftp@user.ch. in /.../.../public_html/gallery/.../ftp_servers.php on line 864


Ok, you may have wrong ftp username or password or then you are trying to reach outside your ftp account. If the ftp test folder is not in your allowed ftp root, then you will get those errors.

Read manual (in editor) and there "FTP FOLDER" explanation or ftp root folder. It should make it a bit clearer to understand. Set your ftp test directory to ftp root folder.

Ftp returns sometimes error messages that are not very clear, sorry about that. All I can do is just display them.

As always I offer my help in installing EE, but you may need to wait a little for 1.5 beta 2 before that. If you'd want me to to take a look of your setup, you should email me to pekka@photography-on-the.net info how to access your system (ftp access and input folder access).

I'm hoping to get beta 2 out on wednesday afternoon (GMT) because on thursday I have to do a small concert trip to Lappland for three days.

[UweB]

Hello Pekka

thank's for this fast answer...

I will see what i can do till the publishing of the new version and after that too. If nothing helps i will be glad to get back to your offer with the FTP server... Perhaps i can have a chat with my webhoster about this access rights too... this is because i can't even see my exhibitons...

Regards, Uwe, Switzerland

[UweB]

Hi Pekka,

again, thank's for your help.

The hint to read again more about the path variables was indeed helpful.

Some impressions of working with EE on a live server...

Yesterday, i think for all afternoon, my webhoster had problems with the server and i only realised that in the evening because i suddenly could not log into my CPanel. I opend a ticket... I don't know what they did but after this the LOCK errors disappeared.

Again at the same time till today i had problems to create small/big/default images. All images always had the same big size. This morning i switched to GD functions and now everything works... I created some galleries to play around with all the functions.... about 100 photos so far.

Sometimes the thumbnails are created on the "local" FTP server which i set to OFF because it is not deletable. Then of course i miss the thumbs on my life server. Now i set both (local/remote) FTP to the remote path...

Again, sometimes during the upload to gallery (not to the upload directory) process i get an FTP error (that's all i can see) and no images can be found... I think it is the same error as with the the thumbnail creating.

Only i can't remeber where i saw the link to 127.0.0.1 instead of to my domain... and why does it sometimes want to go to 127.0.0.1 ?

Still, great piece of software and work... i am really impressed about all the ideas you put into this. Much more though because i make photos since about 30years and can therefore "see" all the options for photo, camera, lens... etc.

regards, Uwe, Switzerland.