While upgrading a friend's 3.2 install to 4.25 I got the following error:
Error during upgrade: Statement has no result columns to bind (perhaps you need to successfully call execute first) at /home/www/friend'surl.com/htdocs/extlib/Data/ObjectDriver/Driver/DBI.pm line 128.
uhhh, halp?
Reported on Movable Type 4.2
Well for fun I decided to run the install again, and now I get this:
Error during upgrade: failed to execute statement ALTER TABLE mt_ts_funcmap ADD CONSTRAINT mt_ts_funcmap_funcname UNIQUE (ts_funcmap_funcname): Duplicate key name 'ts_funcmap_funcname' at lib/MT/Upgrade.pm line 2587.
Hi Sweetney
This is an sql error, and means that you (actually mt) want to create an unique index in a column containing duplicated values.
You need to delete those duplicated values, then run the upgrade.
Kind regards
Yeah now it's stuck on that 2nd error and the upgrade won't proceed.
I assume you are using MySQL. If you are, try running this SQL command in mysql or phpMyAdmin before trying the upgrade again:
alter table mt_ts_funcmap drop constraint mt_ts_funcmap_funcname;
Well I tried to run that command and i got back:
#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 'constraint mt_ts_funcmap_funcname' at line 1
Contact your host and see if they have phpMyAdmin or another graphic tool that you can use to drop that uniqueness constraint off of that table.
I'm using phpMyAdmin. Not sure if I'm doing something wrong, but that's the error.
Click on the table on the left side of phpMyAdmin. That will load the information for mt_ts_funcmap. You should see the constraint you are looking for there, with an "X" next to it that you can click to drop it.
Thanks, Mike T, I'll try that and let you know!
try this please
alter table mt_ts_funcmap drop ts_funcmap_funcname;
alter table mt_ts_funcmap add ts_funcmap_funcname varchar(255);
alter table mt_ts_job drop ts_job_uniqkey;
alter table mt_ts_job add ts_job_uniqkey varchar(255);
alter table mt_ts_job drop ts_job_funcid;
alter table mt_ts_job add ts_job_funcid int(11);
i just found this in the older forums
Arrgh.
#1146 - Table 'friend'sURL_com.mt_ts_funcmap' doesn't exist
did you drop the table mt_ts_funcmap previously?
Nope. Just tried to run the upgrade again, it hung up again at:
Error during upgrade: failed to execute statement ALTER TABLE mt_ts_funcmap ADD CONSTRAINT mt_ts_funcmap_funcname UNIQUE (ts_funcmap_funcname): Duplicate key name 'ts_funcmap_funcname' at lib/MT/Upgrade.pm line 2587.
No idea what to do.
Hi Sweetney,
Provide me access to your control panel (or phpmyadmin) as well as your mt admin via email and I will try to fix this for you.
Cheers,
Mihai