By Stefan Peeters on

Hi everyone,

I made a backup yesterday. Today I installed some modules and now my site is doesn't work that good anymore. I get a lot of errors. Now I tried to restore the backup I made yesterday but it doesn't work. I get following message:

PDOException: SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters in backup_migrate_destination_db_mysql->_restore_db_from_file() (regel 198 van /home/deb56228n3/domains/blogberichten.be/public_html/sites/all/modules/backup_migrate/includes/destinations.db.mysql.inc).

I really don't know what to do about it. Please does someone got the answer and able to explane me in detail because I just starting to use drupal.

Thanks guys and girls

⋅ Categories: Drupal 7.x

Comments

vm’s picture

vm commented

disable the modules you enabled by setting their status to 0 in the system table of the database.
test

learn to use phpmyadmin to backup your database
learn to test your backed up database to ensure it works

Learning to use phpmyadmin can be a huge benefit because if your site is broken to the point of not beiing able to use the administration area of drupal and you can't reach the backup and migrate features then you will be in a world of hurt.

Learn to use a test site of your production site to employ new modules so you can be ready for whatever issues occur without your production site breaking causing panic and loss of hair.