![]() |
|
installation problem "Access denied for user..." - Printable Version +- ZenphotoCMS Forum (https://forum.zenphoto.org) +-- Forum: Support (https://forum.zenphoto.org/forum-1.html) +--- Forum: General support (https://forum.zenphoto.org/forum-4.html) +--- Thread: installation problem "Access denied for user..." (/thread-1947.html) |
installation problem "Access denied for user..." - Searcher78 - 2007-12-18 At the installation i get following errormessage... (ok)PHP version 4.1.0 or greater [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 :-( installation problem "Access denied for user..." - sbillard - 2007-12-18 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? installation problem "Access denied for user..." - Searcher78 - 2007-12-18 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". installation problem "Access denied for user..." - sbillard - 2007-12-18 Interesting. I cannot create a database with a '-' in the name. The message I get is 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. installation problem "Access denied for user..." - Searcher78 - 2007-12-18 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] installation problem "Access denied for user..." - sbillard - 2007-12-18 Yes, can't put the quotes around the db name. So, with a '-' in the name we can't query the table names. installation problem "Access denied for user..." - Searcher78 - 2007-12-18 Oh.. thank you for trying to help me... :-) installation problem "Access denied for user..." - sbillard - 2007-12-18 I think you can delete the lines
and run setup installation problem "Access denied for user..." - sbillard - 2007-12-18 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. installation problem "Access denied for user..." - Searcher78 - 2007-12-18 The tables are now created. in the admin-menu it shows php-errors: 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 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! installation problem "Access denied for user..." - sbillard - 2007-12-18 Will need a list of your zp-config.php file. Something is wrong on line 90. installation problem "Access denied for user..." - Searcher78 - 2007-12-18 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! |