Duplicate SQL index in comments table

rparenti

In zenphoto-1.3.1.2, phpMyAdmin reports that in the mySQL comments table there appears to be two identical indexes named ownerid and ownerid_2. It says that one of them should be removed.

Not a SQL expert myself, so is there an opinion about whether this is the right thing to do? Should I go ahead and remove one of these duplicate indexes? Or should I just leave well enough along?

acrylian

Sorry, there is no `ownerid_2` field at all neither in 1.3.1.2 nor in the CURRENT release 1.4.

rparenti

Thanks, I'll just let it go then. I'm running 1.3 because it does not have any of the very numerous SQL syntax errors of 1.4. At some point I'll go back and work on my directory permissions and give 1.4 another chance, this time in a new zp root. I think the 1.4 setup needs some tuning. Maybe it could have warned me as a fatal error if the album was not going to run.

Thanks

acrylian

I am quite sure that there was not even a `ownerid_2` field at any time actually.

very numerous SQL syntax errors of 1.4
think the 1.4 setup needs some tuning. Maybe it could have warned me as a fatal error if the album was not going to run.

To what are you referring? Please be more specific.

rparenti

In 1.4 I had SQL syntax errors whenever I tried to save in theme options. Maybe the setup could have warned me that it really wasn't going to work. I eventually found a reference to a page describing the correct folder permissions, but by that time I had already reverted to 1.3.1.2, which ran without a hitch.

It looks like 1.4 provides the capability of specifying album thumbnail rows and columns, so I am looking forward to picking that version up, again.

As far as myPhpAdmin reporting a duplication of indexes, I have no idea why it thinks that.