Jump to content


[problem] Etogal11beta3b not writing to mySQL


  • You cannot reply to this topic
6 replies to this topic

#1 djspawn

    Etomite Forum Newbie

  • Member
  • 7 posts

Posted 21 November 2007 - 03:24 PM

Newbie to this stuff, here is my setup details:

IIS
PHP 5.2.4
MySQL 4.1.22
Etomite 0.6.1 Final PL4 Prelude

I install the auth_vistor on a page with the EtoGal and everything works. I can login, Manage Pictures and even upload them to the folder. I can see the pictures in the folder with the thumbs, but there are no entries to the etomite_etogal db. Even when I add the EtoGalGallery snip I get a placeholder thumb. I've been reading a lot of these forms but I can't find if its an API issue or a mySQL issue. A little direction would be greatly appreciated...HELP!

#2 mikef

    Loves Etomite Forums!

  • Member
  • PipPipPipPip
  • 1,551 posts

Posted 21 November 2007 - 04:23 PM

Please explain exactly what you can do, step by step, with etogal and say what is visible on the screen.

where do you 'see the pictures in the folder with the thumbs'
how are you checking for data in the table (not a separate database, just a table in the etomite database).

have you checked all the etomite configuration settings? Its not unusual for some to be set wrong if you are using IIS

#3 djspawn

    Etomite Forum Newbie

  • Member
  • 7 posts

Posted 21 November 2007 - 05:07 PM

View Postmikef, on Nov 21 2007, 11:23 AM, said:

Please explain exactly what you can do, step by step, with etogal and say what is visible on the screen.

where do you 'see the pictures in the folder with the thumbs'
how are you checking for data in the table (not a separate database, just a table in the etomite database).

have you checked all the etomite configuration settings? Its not unusual for some to be set wrong if you are using IIS

The snippet code for the page(63) is:

etogal
[[EtoGal?display=none]]

[[EtoGalGallery]]

login/out
[[authenticate_visitor?id=63&use_captcha=0]]

EtoGal Check
[[EtoGalCheck]]



I get this:
Posted Image

I log in and get this screen:

Posted Image


Go to Manage Pictures and get this:

Posted Image


Upload a picture and get this:



Posted Image

I can see the image file in the assets/galleries/63 folder. I'm using DBA Central to veiw the etomite_etogal table and there is no data in any of the fields.

I hope this helps.

#4 mikef

    Loves Etomite Forums!

  • Member
  • PipPipPipPip
  • 1,551 posts

Posted 21 November 2007 - 05:54 PM

well, almost immediately after the creation of the files, a call is made to the etomite dbQuery function to write the data to the database. The dbQuery function doesn't seem to return any diagnostics so there's not much I can do unless Ralph has some suggestions. (This part of the code has survived unchanged for well over a year, without problems that I'm aware of!)
The only thing I can think of is possibly some strange characters in the filename. Is the filename restricted to purely A-Za-z0-9 and underscore characters (and no accents etc on the characters)?

edit: IIS is not in common use with etomite, and I don't know whether your version of PHP is either, but i don't see why either should cause this problem.

Edited by mikef, 21 November 2007 - 05:57 PM.


#5 Ralph

    Loves Etomite Forums!

  • Admin
  • 6,524 posts
  • Gender:Male

Posted 21 November 2007 - 06:07 PM

Several possibilities why the images aren't working come to mind...

Have you checked your phpinfo to make sure uploads are enabled...??? I don't think you will receive an error if they are disabled...

Does the version of PHP, as installed on IIS, include a graphics library such as GD2 for doing any processing that may be required...??? Depending on server configuration, again, you may not receive any errors if one is not present...

As Mike pointed out, filenames could be the culprit, but I would assume that you have eliminated that possibility before posting here...

Are you running in localhost mode or is this a true domain...??? The use of localhost on IIS is a known issue with many PHP applications...

Is there a possibility that you could either PM me login details or provide a URL to a script with phpinfo() in it so I can see the server configuration...??? I might be able to save a lot of guessing by looking at the server settings and available resources...

#6 djspawn

    Etomite Forum Newbie

  • Member
  • 7 posts

Posted 22 January 2008 - 08:29 PM

[Fixed] I figured it out. Thanks for all your help

#7 mikef

    Loves Etomite Forums!

  • Member
  • PipPipPipPip
  • 1,551 posts

Posted 23 January 2008 - 12:06 AM

could you summarise the cause and solution please, fo the benefi of anyone else with the similar problems, or, if relevant, so I can add some protective code?

thanks,
mike





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users