At the installation i get following errormessage...
(ok)PHP version 4.1.0 or greater
(ok)PHP GD support
(ok)PHP mySQL support
(ok)zp-config.php file
(ok)mySQL setup in zp-config.php
(ok)connect to MySQL
(ok)MySQL version 3.2.3 or greater
(ok)connect to the database db1019932-zp
(ok).htaccess file (RewriteEngine is ON)
(ok).htaccess RewriteBase
(ok)albums folder
(ok)cache folder
[b]DB Error, could not list tables MySQL Error: Access denied for user 'dbu1019932'@'localhost' to database 'db1019932'[/b]
db-settings are copied from wordpress(working)...
Who can help me?
Sorry for my poor english :-(
setup is trying to do a SHOW TABLES FROM query that apparently is not being allowed. The interesting thing about the print-out above is the database names. In the check the database seems to be db1019932-zp but the query only shows db1019932 with out the -zp suffix.
Is it possible for you to name the database without the "-"? also, are you using a database prefix?
Hello,
no, it is not possible to create a database without the "-" :-(. I tried the DB-prefixes "_zp", "_zen" and without a prefix. Wordpress use the db "db1019932-wp" with the prefix "_wp".
Interesting. I cannot create a database with a '-' in the name. The message I get is Database names must be 2-32 characters in length. Database names must consist of lowercase letters, numbers, and underscores with at least one non-numeric character. when I try.
Anyway, I think that character is the cause of the problem. I also do not know of a way to fix setup so that it can do the query.
Hi,
after the chance, the errormessage is now:
[b]DB Error, could not list tables MySQL 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 ''db1019932-zp' LIKE '%'' at line 1[/b]
Oh..
thank you for trying to help me... :-)
I think you can delete the lines
` $sql = "SHOW TABLES FROM ".$_zp_conf_vars['mysql_database']." LIKE '".$_zp_conf_vars['mysql_prefix']."%';";
$result = mysql_query($sql, $mysql_connection);
if (!$result) {
echo "DB Error, could not list tablesn";
echo 'MySQL Error: ' . mysql_error();
exit;
}`
and run setup
it also looks like you can change the single quote of the first patch to the peckmark (which won't show on this forum since it is the "code" delimiter. On the us keyboard it is the key to the left of the 1 key. kind of a backward single quote. That at least does not give me an error. But since I can't create a DB with a slash, I can't see if it fixes your problem. If it does, let me know.
The tables are now created.
in the admin-menu it shows php-errors:
[b]
Warning: Cannot modify header information - headers already sent by (output started at /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/zp-config.php:90) in /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/auth_zp.php on line 45
Warning: Cannot modify header information - headers already sent by (output started at /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/zp-config.php:90) in /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/auth_zp.php on line 48
Warning: Cannot modify header information - headers already sent by (output started at /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/zp-config.php:90) in /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/admin-functions.php on line 48
[/b]
Now I go to bed... it´s now 4:10 a.m. and at 8 a.m. I have to to attend a lecture. I retry when I´m at home.
Thanks a lot!
hey,
yes, line 90 is the Problem. I don´t know how, but there was an "enter", after erasing this line, the problem is fixed. :-)
Thank you very much :-))))
greetings from germany!