Sat May 8 07:33:31 2010 - Backup Filesize was less than 1kb Sat May 8 07:33:31 2010 - Command used for mysqldump: /usr/bin/mysqldump -hlocalhost -u<hidden> -p***** -Q <hidden> > "/var/www/glfusion/backups/glfusion_db_backup_2010_05_08_07_33_31.sql"
Sat May 8 07:33:41 2010 - 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 'WHERE uid=887' at line 1. SQL in question: SELECT block FROM WHERE uid=887 Sat May 8 07:33:52 2010 - 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 'WHERE uid=1126' at line 1. SQL in question: SELECT block FROM WHERE uid=1126
I've been getting this since about 1.1.7 - but I think it's the new version of MySQL or possibly PHP - and nothing to do with glfusion's backup function.
But I'm not sure - because if I do it at the command line - it works - but if do it through the web interface - I get the above in the error log.
I think it may have something to do with the fact that I use a bunch of crazy characters and non-alphanumeric (ie. punctuation and symbols) in our database password.
Marco, are there any other special characters in the password, like a quote (single or double). I've tested the new code on Windows and Unix (Linux) hosts and it is working fine when a | (pipe character) is in the password.
Do this, check your web server's error log and let's make sure we aren't overlooking some other issue. See if the web server logs show anything about the exec() PHP call or any other info like a permission issue...
I don't see any complaints from PHP or Apache in the webserver logs - but I'll go ahead and give you all the strange characters in our database password with the suspicion that it's not gonna help anyone discover what it is.
There is a "!", "@", and a "$" in the password. Is one of those the problem?
Notice I put the '' after the -p - and that worked... so now at least I know what the problem is - I think it's the order of my symbols - now that I look at it - the password could be interpreted as a variable (I think that's the right coding term - lol!)...