🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#1 2013-07-27 12:15:36
- luckiec2
- Member
- 2013-03-14
- 5
Tried to fix the tables ....
First I got this message:
Warning: [mysql error 145] Table './fliepeldepienl_1/piwi_sessions' is marked as crashed and should be repaired
SELECT data
FROM piwi_sessions
WHERE id = '4D7Bbbkitkljg64s4dhpc3p7gnaug1'
; in /var/www/vhosts/fliepeldepiep.nl/httpdocs/include/dblayer/functions_mysqli.inc.php on line 813
So I went to mysql thing and repaired and optimized the tables... but now it completely has crashed..
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (28000/1045): Access denied for user 'fliepeldepienl_1'@'localhost' (using password: YES) in /var/www/vhosts/fliepeldepiep.nl/httpdocs/include/dblayer/functions_mysqli.inc.php on line 40
Warning: my_error() [function.my-error]: Couldn't fetch mysqli in /var/www/vhosts/fliepeldepiep.nl/httpdocs/include/dblayer/functions_mysqli.inc.php on line 805
Warning: my_error() [function.my-error]: Couldn't fetch mysqli in /var/www/vhosts/fliepeldepiep.nl/httpdocs/include/dblayer/functions_mysqli.inc.php on line 805
Piwigo encountered a non recoverable error
[mysql error ]
Can't connect to server
#1 my_error /var/www/vhosts/fliepeldepiep.nl/httpdocs/include/common.inc.php(119)
#2 include_once /var/www/vhosts/fliepeldepiep.nl/httpdocs/index.php(26)
any idea how to fix this?
Offline
#2 2013-07-27 14:01:32
- flop25
- Piwigo Team
- 2006-07-06
- 7037
Re: Tried to fix the tables ....
Hi
luckiec2 wrote:
Access denied for user 'fliepeldepienl_1'@'localhost' (using password: YES)
an error message already discussed there many times! The password of the mysql user doesn't match or more probably, the user hasn't enough privileges on the database
To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website
Offline
#3 2013-07-27 14:20:20
- luckiec2
- Member
- 2013-03-14
- 5
Re: Tried to fix the tables ....
so how do you fix it? or delete everything and start over?
Offline
#5 2013-08-14 20:20:57
- luckiec2
- Member
- 2013-03-14
- 5
Re: Tried to fix the tables ....
I guess this is a dead program, to bad...
Offline
#6 2013-08-14 20:23:51
- mistic100
- Former Piwigo Team
- Lyon (FR)
- 2008-09-27
- 3277
Re: Tried to fix the tables ....
well it's because we can't really say more than flop25 already said
The error says that the user you configured in local/config/database.inc.php can't access the database
you must find by yourself why or ask your host
Offline
#7 2013-08-14 20:29:57
- luckiec2
- Member
- 2013-03-14
- 5
Re: Tried to fix the tables ....
What does it mean? I do not understand. I think it has something to do with the rights piwigo has to make changes...
Offline
#8 2013-08-14 20:35:39
- flop25
- Piwigo Team
- 2006-07-06
- 7037
Re: Tried to fix the tables ....
hi again
first rule of the forum: search
like http://dev.mysql.com/doc/refman/5.0/en/ … enied.html
To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website
Offline
#9 2013-08-22 14:35:20
- roadrash
- Guest
Re: Tried to fix the tables ....
There seems to be a problem when using PHP5.5 and Piwigo with MySQLi
Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /var/www/vhosts/<snip>/public/piwigo/include/dblayer/functions_mysqli.inc.php on line 61
Warning: my_error(): Couldn't fetch mysqli in /var/www/vhosts/<snip>/public/piwigo/include/dblayer/functions_mysqli.inc.php on line 826
Warning: my_error(): Couldn't fetch mysqli in /var/www/vhosts/<snip>/public/piwigo/include/dblayer/functions_mysqli.inc.php on line 826
Piwigo encountered a non recoverable error
[mysql error ]
Can't connect to server
#1 my_error /var/www/vhosts/<snip>/public/piwigo/include/common.inc.php(119)
#2 include_once /var/www/vhosts/<snip>/public/piwigo/index.php(26)
And believe me: my login credentials are OK.
Switching over to PHP 5.4.18 or 5.3.27 has no problems.
(I am using Plesk with multiple PHP versions installed)
#10 2013-08-22 14:55:57
- flop25
- Piwigo Team
- 2006-07-06
- 7037
Re: Tried to fix the tables ....
I had an issue and that was not the credential or the mysql permission, just an mysql bug : I had to delete/set the mysql user and its permissions on tables. (can't remember if it was on local or on the server...)
and honestly Piwigo just use the mysql fonctions... or a missing parameter for the connexion?
To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website
Offline
#11 2013-08-22 15:00:25
- flop25
- Piwigo Team
- 2006-07-06
- 7037
Re: Tried to fix the tables ....
in fact a server side issue : http://stackoverflow.com/questions/1376 … rough-sock
To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website
Offline
#12 2013-08-22 15:36:56
- roadrash
- Guest
Re: Tried to fix the tables ....
In fact I just fixed the problem.
PHP5.5 now uses mysqlND by default:
Client API library version: mysqlnd 5.0.11-dev - 20120503 - $Id: 40933630edef551dfaca71298a83fad8d03d62d4 $
So I recompiled PHP 5.5 with following configure options:
'--with-mysql=/usr' '--with-mysqli=/usr/bin/mysql_config' '--with-pdo-mysql=shared'
and now it says:
Client API library version 5.5.33
My Piwigo install works like a charm again.
#13 2014-02-09 05:43:40
- jim1562
- Guest
Re: Tried to fix the tables ....
well, you've said so many times that you have to ask you host, but the host does not know why your install deos not work. so maybe you could look into another answer instead of blowing people off. i am looking for another app. can't install this one. what a lousy board.
#14 2014-02-09 13:11:29
- flop25
- Piwigo Team
- 2006-07-06
- 7037
Re: Tried to fix the tables ....
jim1562 wrote:
well, you've said so many times that you have to ask you host, but the host does not know why your install deos not work. so maybe you could look into another answer instead of blowing people off. i am looking for another app. can't install this one. what a lousy board.
lol
you don't know even know what you're talking about and you come here to judge... -_-*
To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website
Offline
#15 2014-02-09 20:51:39
- luckiec2.1
- Guest
Re: Tried to fix the tables ....
Somehow I put a password on the tables, and I didnt know how it happened.. Finaly someone from the hosting removed it and now it works.. Otherwise I had to look up all the geographic coordinates again...