Announcement

#1 2010-05-19 16:20:25

webdesign
Member
2009-10-25
6

db_problems

hi, i have changed my hoster, so i made i backup from my site and then i have reuploaded it to my new hoster; but when i import the db then i get this error:

"#1064 - 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 '
Fatal error: Allowed memory size of 134217728 bytes exhausted (tr' at line 1"

Offline

 

#2 2010-05-19 17:39:30

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

Re: db_problems

release MySql ?


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

 

#3 2010-05-19 23:09:56

webdesign
Member
2009-10-25
6

Re: db_problems

the version of phpadmin is 3.2.4 from my new and old hoster

i get this error
http://afghanshow.com/gallery/

Last edited by webdesign (2010-05-19 23:15:59)

Offline

 

#4 2010-05-19 23:21:27

pauldaytona
Translation Team
2010-04-22
30

Re: db_problems

webdesign wrote:

hi, i have changed my hoster, so i made i backup from my site and then i have reuploaded it to my new hoster; but when i import the db then i get this error:

"#1064 - 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 '
Fatal error: Allowed memory size of 134217728 bytes exhausted (tr' at line 1"

Fatal error: Allowed memory size of 134217728 bytes exhausted (tr' at line 1"

This looks like the database is to big to import at once. Split it in two or more parts.
How big is it?

Offline

 

#5 2010-05-20 17:14:43

webdesign
Member
2009-10-25
6

Re: db_problems

php admin show; 58.18 MB

Offline

 

#6 2010-05-23 02:08:35

webdesign
Member
2009-10-25
6

Re: db_problems

i get this error message now;


"Piwigo encountered a non recoverable error

[mysql error 1045] Access denied for user 'afghan_foto'@'localhost' (using password: YES)
mysql_connect

#1    my_error /home/afghan/public_html/gallery/include/common.inc.php(107)
#2    include_once /home/afghan/public_html/gallery/index.php(26)
"

http://afghanshow.com/gallery/

i need your help

Offline

 

#7 2010-05-23 07:26:04

tosca
Former Piwigo Team
Cévennes (France)
2006-09-23
567

Re: db_problems

webdesign wrote:

[mysql error 1045] Access denied for user 'afghan_foto'@'localhost' (using password: YES)
mysql_connect

#1    my_error /home/afghan/public_html/gallery/include/common.inc.php(107)
#2    include_once /home/afghan/public_html/gallery/index.php(26)

Database password is probably wrong or missing in the Piwigo configuration file.
Check these lines in /local/config/database.inc.php (Piwigo 2.1.0) or /include/mysql.inc.php (previous versions)

$conf['db_base'] = 'mydb';
$conf['db_user'] = 'myuser';
$conf['db_password'] = 'mypassword';
$conf['db_host'] = 'myhost';


My galleries : Photos, Watercolours, Recipes

Offline

 

#8 2010-05-25 15:37:18

webdesign
Member
2009-10-25
6

Re: db_problems

hi, i have split the db in 14 parts, the error was in the "piwigo_history" i have then update piwigo and now its works

Offline

 

#9 2010-05-25 19:04:31

tosca
Former Piwigo Team
Cévennes (France)
2006-09-23
567

Re: db_problems

Could you set the topic to "solved" (see link under your first post).
Thanks


My galleries : Photos, Watercolours, Recipes

Offline

 

Board footer

Powered by FluxBB

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