You would have to use something like myPHPadmin to view your database.

Hi sbillard,

As I mentioned above, I have the same issues with no comments. Also, when I run setup I get:

" mySQL access rights [insufficient]
Your mySQL user must have Select, Insert, Update, and Delete rights."

I have checked using myphpadmin and my mySQL user does have full rights.

Maybe this is the same problem as Nico and will help. Thanks in advance.

-jc

sbillard:
yes, I have PHPmyadmin but I don't know where find this informations. My gallerie is host with 1and1 ?
I think I have all permissions.

Thanks.

dismalhiker:
yes, it's the same problem.

Nico:

If you wish, you can e-mail me the url and login for your phpmyadmin and I will take a look at the database. e-mail to stephen sbillard org.

Hi there. I encountered the same problem when I used stopdesign. What I did was switch to another theme .I was able to see the comment link/button and made a test comment. When I switched back to stopdesign, i refreshed the page and the comment button showed up.

I dont know why and how it happened. Just sharing, maybe that could help. Thanks

sbillard:
I have the error only when I choose in theme option "random images". With "recent images" I don't have this error.

Button "add comment" disappeared !!!! I don't understand. How view comments?
I think problem come from "comments.js"

I am personally not familiar with the stopdesign theme, but what browser you are using?

firefox

Nico:

There is a different query for random images from recent images, so that is why you could see a problem on one but not another.

Thanks, I solved the problem supressing "function" showhide. I will see random images tomorrow in order to solve this problem.

Nico...

How did you "suppress" function showhide? Could you provide more detailed information?

in "image.php" line 78 79 80 supress "$showhide". This will supress buton show and hide.
in "comments.js" replace all "hidecomments" with "showcomments".

That's all. This hack is OK on my gallerie: http://nicospeech.fr

This will not really supress the function showhide.

A ticket for this problem has been entered in Trac. Perhpas next month our expert will be able to investigate the problem.

Nico, thank you for the help.

Thanks also to sbillard... I will follow in Trac.

Hi guys, i'm new to all this gallery thing and i definitely don't know any codings. I am using the stopdesign theme and completely stuck after encountering the same problem as Nico was back in Jan...i'm getting the same :

--->MySQL Query ( SELECT zp_images.filename,zp_images.title, zp_albums.folder, zp_images.show, zp_albums.show, zp_albums.password FROM zp_images INNER JOIN zp_albums ON zp_images.albumid = zp_albums.id WHERE zp_albums.folder!="" ORDER BY RAND() LIMIT 1 ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'show, zp_albums.show, zp_albums.password FROM zp_images

If you are not running on the nightly build of Zenphoto you should upgrade to it. Nico's problem has been corrected there.

hmmm...ok, thanks for the help...but how do i know if i am already running on nightly build or not? and where do i get it from?

btw, i am currently running ZenPhoto version 1.1.5...is that nightly build?

No, 1.1.5 is the last official version. You see the actual version in the footer of the zenphoto admin. The nightly build is the developer version that is updated frequently to become the next version some time. The current version is zenphoto version 1.1.5 [1459] (the version number is written in the footer of the zenphoto admin)

You can download the nightly on our download page.

Thank you, the nightly build versions defintely help solve some issues. Is there a way to update these nightly version without having me to go into the codes and doing all my custom settings again?

I guess my question is, what are the files that i MUST update when installing the newer nightly build versions? For example, can i not change the .htaccess file? Can i not change the zp_config.php file? etc...