Member
Member
Searcher78   2007-12-18, 02:11
#1

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 :-(

Member
Member
sbillard   2007-12-18, 03:07
#2

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?

Member
Member
Searcher78   2007-12-18, 03:17
#3

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".

Member
Member
sbillard   2007-12-18, 03:48
#4

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.

Member
Member
Searcher78   2007-12-18, 03:50
#5

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]

Member
Member
sbillard   2007-12-18, 03:51
#6

Yes, can't put the quotes around the db name. So, with a '-' in the name we can't query the table names.

Member
Member
Searcher78   2007-12-18, 03:53
#7

Oh..

thank you for trying to help me... :-)

Member
Member
sbillard   2007-12-18, 03:56
#8

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

Member
Member
sbillard   2007-12-18, 04:01
#9

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.

Member
Member
Searcher78   2007-12-18, 04:13
#10

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!

Member
Member
sbillard   2007-12-18, 04:23
#11

Will need a list of your zp-config.php file. Something is wrong on line 90.

Member
Member
Searcher78   2007-12-18, 04:39
#12

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!

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.