Error 1064 upgrading from 2.7.2 to 2.11.3
Development and Programming
I am upgrading my test db from 2.7.2 to 2.11.3. In production and test, the system directory is renamed ee_sys. I have changed the admin.php and index.php accordingly.
$system_path = ‘./ee_sys’;
After I created the test system from production, I tested everything to make sure that I copied everything correctly. Test worked just like production.
I followed the update procedure for the test. After I agree to the terms and hit SUBMIT, I get the following:
A Database Error Occurred
Error Number: 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 ‘IGNORE TABLE exp_members CHANGE email email VARCHAR(75) NOT NULL’ at line 1
ALTER IGNORE TABLE exp_members CHANGE email email VARCHAR(75) NOT NULL
Filename: /home/copingmag/www/www/cwc_test/ee_sys/expressionengine/libraries/Smartforge.php
Line Number: 227
have you tried disabling your add-ons then running the update. Anytime I hit a snag like this in the update process, it was always thanks to an add-on
@DeeCee, did you manage to fix the error? I am running into the same error as well and disabling extensions did not seem to do anything for me :(.
Does anyone know how to fix this issue?
Cheers
T
It sounds like you’re using a newer version of MySQL but still using the older, deprecated MySQL client driver for PHP. In your database.php file, look for:
$db['expressionengine']['dbdriver'] = 'mysql';and change it to
$db['expressionengine']['dbdriver'] = 'mysqli';Thanks for the reply, Derek. I am settling back down from the holidays and finally have a chance to look at this.
I have 2.7.2 loaded in my test directory and everything is fine except for the warnings that I get on the control panel (just like I got in production): A PHP Error was encountered Severity: 8192 Message: Non-static method Magpie::usage() should not be called statically, assuming $this from incompatible context Filename: plugins/pi.magpie.php Line Number: 28 A PHP Error was encountered Severity: Warning Message: Cannot modify header information - headers already sent by (output started at /home/copingmag/www/www/cwc_test/ee_sys/codeigniter/system/core/Exceptions.php:170) Filename: core/Common.php Line Number: 408
I have loaded 2.11.5 to my server. Before I moved my database.php file to the /config directory, I changed: $db[‘expressionengine’][‘dbdriver’] = ‘mysqli’;
Now when I run the wizard, I get:
A Database Error Occurred Unable to connect to your database server using the provided settings. Filename: controllers/wizard.php Line Number: 1618
If I change back to: $db[‘expressionengine’][‘dbdriver’] = ‘mysql’;
I get the same error as before, so that must be the problem why the wizard cannot connect to the db.
This is the php information from my server: Installed software PHP 5.6 (more info) (extensions)5.6.27 (default)- PHP 7.0 (more info) (extensions)7.0.12- PHP 5.3 (more info) (extensions)5.3.29 (obsolete)