1and1 mysql problem

plsk

Good morning,

im a zenphoto new user and i have a problem with installation. I know, this problem is in another post in this forum but im not found solution. Please help me

`

MySQL access rights [unknown]

Your MySQL user must have Create, Drop, Select, Insert, Alter, Update, and Delete rights.

The SHOW GRANTS query failed.

`
and

`

Zenphoto Error

MySQL Query ( SELECT * FROM ``zp_albums` ) Failed. Error:Table 'db251161969.zp_albums' doesn't exist
It looks like your zenphoto tables haven't been created.You may need to run the setup script.

by advance, thank you

sbillard

We have had one other report of a problem like this. In that case it was a problem with zenphoto trying to set the colating sequence on the Database. Unfortunately that person has not been active so we do not yet know what the problem is. You can run setup.php?debug to get output of the database actions setup has tried. Also you can try the nightly build where setup will display error messages if it fails to create a databasse table.

plsk

in fact, i have taking mysql5 option and its ok zenphoto run. but i hope than my database choice don't create other problems.
for this moment no problems
thank for you reply,

Alex (french user)

sbillard

What option did you change to make this work? I am sure others will want to know.

Jacques

Hey guys,

I got the same Problem at 1&1 and my only idea to solve it was to change database from mysql 4.xx to mysgl 5.0 as well. Now it works.

regards
Jacques

sbillard

What version of MySQL did you have originally? That syntax is supposed to be in MySQL 3.23. I don't have any versions prior to 5, so I cannot check. Maybe the folks having this problem can list their MySQL versions. Then we can put a check in on the version.

Jacques

According to 1&1 Control-Center it is version 4.0 -- but I´m not sure, if one should believe that

sbillard

Thanks for the info. Seems at least two people report the problem on 4.0, so I am guessing that the documentation lied. We will change the code to only use this syntax when MySQL is version 5 or greater.

Users with version < 5 will have to set their collating sequence manually if they care.

northboundlane

Hi,

I'm having this same problem -- same error message as outlined in the first post, I have 1&1, and my assumption is that my mySQL is 4.0, but quite frankly I have no idea because I'm not super tech-savvy. Thus, I don't exactly understand what it means to set a collating sequence manually. Can someone please give me steps on how to do this?

sbillard

use the nightly build.