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
release MySql ?
Offline
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
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
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
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';
Offline
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
Could you set the topic to "solved" (see link under your first post).
Thanks
Offline