Announcement

#1 2017-05-09 21:01:58

mrcolj
Member
2015-05-22
20

MySQL Error 1044, Impossible to Connect, possibly corrupt View

Hello/Hi/Greetings,

Happy Birthday Piwigo!

I'm a little stuck.  I'm getting a MySQL 1044 error, "

[mysql error 1044] Access denied for user 'XXXX'@'localhost' to database 'XXXX'
Connection to server succeed, but it was impossible to connect to database

#1    my_error /home/XXXX/public_html/photos/include/common.inc.php(121)
#2    include_once /home/XXXX/public_html/photos/index.php(26)

I went into PhpMyAdmin, selected the database, and hit Repair.  Everything was good except for XXXX.forecast, a View which failed as "not base_table."  I don't see a XXXX.forecast, but I do see a row just called Forecast, with -0 rows.  When I click in it appears to be geotagging coordinates.

Okay, so that's as far as I know how to go.  Thoughts?  Are my assumptions correct so far?

I'm leaving the country for a week on vacation and would love for someone to give me a magical answer or for me to just paypal an admin to fix it. I'm about as techie as you see above but am not a programmer.



Piwigo version: 2.8.3(?, can't check while it's down)
PHP version: 4.6.6
MySQL version: 5.6.30
Piwigo URL: http://www.colinandbethany.com/photos/

Offline

 

#2 2017-05-10 06:11:45

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7207

Re: MySQL Error 1044, Impossible to Connect, possibly corrupt View

Hi :-)

Update file local/config/database.inc.php


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact