got this from mu hosting company
Hello and thank you for contacting HostGator support.
We would be happy to help you. You won't be able to access the mysql log files. We do see that you currently have two databases. Additionally, we have reviewed the log files for you but don't see any errors in the log files. Is there an issue you are experiencing with mysql or a database? If you are experiencing an issue, "Would you please let us know?" We would be happy to help in any way we can. If we can be of any further assistance, please let us know. Thank you.
Best regards,
Juan B.
Linux Systems Administrator
HostGator.com LLC
I somehow doubt that this is a mysql issue and the changing anything directly will really help your overall issue. But sadly we did never encounter this.
Do you have cookies really enabled in your browser? If you have any kind of blocker installed, exclude your site from it please.
I went into the ALBUMS table via cpanel. All the values in the field named THUMB were set to NULL.
When I changed the value to 0 (zero) on a particular album, that album now has random photos as thumbnails.
I did an export of the ALBUMS table and changed all the values to 0 (zero) in the THUMB field.
Then I imported back into the ALBUMS table overwriting all data.
Now all my albums and sub albums show random thumbnails like I wanted them to.
The question now is how do I make that the default? I guess that is in the OPTIONS table.
any help what field that might be?
UPDATE.....
Looking in the OPTIONS table on line 154 field name "AlbumThumbSelect". The value was set to 1 (which is "Most recent"). That is what my album thumbs were defaulted to.
I changed the value of this field to 0 (zero) for random.
I uploaded another album and subalbum and each time i refresh the webpage the thumbnil changes.
So I am where I wanted to be. Whooooo
I installed a second copy of zenphoto on my server in another directory.
Zenphoto version 1.4.2.4 [10045] (Official Build)
I am able to set all the text fields with no problems on version 1.4.2.4 [10045].
I have this version set for auto update, so I guess I will have to wait for 1.4.3. Once updated I will compare the OPTIONS table of each database (if this database continues to work after the upgrade).
Ok, so at least that works. Why don't you try another 1.4.3 beta install and compare the databases right away?
Set to "auto update" via your host's installer? Note that we frequently get reports about issues with these installers especially regarding upgrades.
i'm unable to do a clean install of 1.4.3. after i put in the mysql info all I get is a white screen.
HOLD THE PRESSES
I figured out my problem. I am not sure if this is supossed to happen or if it is a bug. Maybe someone else can verify.
In the OPTIONS>GENERAL tab, the only language I had selected was HTTP_Accept_Language
Once I selected America also, everything is working.
I can now set my gallery title and other options without loosing them after hitting apply.