Thread

Hi there.. seem to have stumbled across an error that ive not come across before when upgrading..

{"error":"

Error Number: 1054<\/p>\n\n

Unknown column 'Array' in 'where clause'<\/p>\n\n

DELETE FROM `exp_module_member_groups`\nWHERE `module_id` = Array<\/p>\n\n

Filename: updates\/ud_215.php<\/p>\n\n

Line Number: 137<\/p>"}

Any ideas?

Hi Etheya,

Was that output copied directly from your browser? I’m asking because there is a lot of “extra markup” in the copy you posted. PHP escape characters and such.

What was the version of ExpresionEngine you are attempting to upgrade from? Do you have a backup of that installation that you can roll back to? If you can roll-back, would you mind doing that, and uploading a fresh copy of EE 2.2.1 and trying the update again?

If that output is directly from your browser, those extra characters have got me thinking the files may have been fouled up during FTP.

Let us know.

Best,

Etheya,

I’d also recommend reading thoroughly this troubleshooting article on upgrade error. It covers the most often experienced upgrade issues, and the one you’re experiencing is covered.

Does that article allow you to make some progress?

I have the same error when upgrade from 2.1.3 to 2.3.1 .

this lines in updates\/ud_215.php file that generate this error:

131. function _drop_blogger()
132. {
133.  $this->EE->db->select('module_id');
134.  $query = $this->EE->db->get_where('modules', array('module_name' => 'Blogger_api'));
135.   
136.  $this->EE->db->where('module_id', $query->row('module_id'));
137.  $this->EE->db->delete('module_member_groups');

this happened because there is no Blogger_api moudel. for some reason the select return array() value;

that Causes this problem.

I resolve it by add Blogger_api moduel manually to the modules table.

support team please be attention to this problem and resolve it in future

I think if(!empty($query->row(‘module_id’)) able to do that.

Hi ahmad,

Would you mind clarifying so that I can understand your predicament better? It sounds like you actually removed the Blogger API module’s folder from your installation before attempting the upgrade, is that correct?

I’ll be glad to file a bug report on this on your behalf; I just want to make sure I fully understand how to re-create the problem before doing so.

$this->EE->db->select('module_id');
$query = $this->EE->db->get_where('modules', array('module_name' => 'Blogger_api'));

this looking for Blogger_api moduel In modules table in my database.

In my database there is no Blogger_api moduel in modules table so it’s return nothing to module_id.

when execute the next lines $query->row(‘module_id’) for some reason return array().

so I add add row to the modules table In my database with Blogger_api value in module_name column.

when I did that the $query->row(‘module_id’) return value and the upgrade done successfully.

I don’t remove any folder.

so I belive there is somthing must change in this code like:

if(!empty($query->row(‘module_id’)) {
$this->EE->db->where('module_id', $query->row('module_id'));
$this->EE->db->delete('module_member_groups'); 
}

ahmad,

Based on the code starting at line 50 of ud_215.php, it should only run this code if your database actually contains the table ‘exp_blogger’ in it. If it doesn’t, it will just skip the entire section that’s giving you fits.

So if you look at your pre-upgrade database, does it have an exp_blogger table in it? If so, just delete that table and then go through with your upgrade. That table shouldn’t be there unless you have the Blogger API module installed in your system. That’s what’s causing problems with your upgrade.