Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Initial install of v1.2 resulted in DB error.

Status Resolved
Add-on / Version Reel
Severity Critical
EE Version 16

Megan Jane D-S

Jul 11, 2012

First time to install Wyvern Video on EE2.4.

DB error because WV wanted site_id in db - but db row just called “id”.

Edited “id” to “site_id” in db - everything seems to be working fine.

Thought it best to alert and double check that was the sensible solution.

#1

Megan Jane D-S

Actually I changed my mind and put the site_id back to id and edited the helper.wyvern_video.php file at around line 309 instead with the following:

$row = $this->EE->db->select('settings')
                                    ->where('addon', WYVERN_VIDEO_SHORT_NAME)
                                    ->where('id', $this->site_id)
                                    ->get('boldminded_settings')
                                    ->row('settings');
#2

BoldMinded (Brian)

Mega, sorry about that. I just uploaded a new version to Devot:ee. You will need both the id and site_id columns. You can un-install and re-install the module to fix it, or rename the site_id column to id, then add the site_id column separately as an int field. The id column is an auto_increment field, so if I use that table for another add-on settings in the future it might mess things up.

#3

Megan Jane D-S

Cheers! Am giving it a go now.

#4

Megan Jane D-S

OK un-installing and re-installing didn’t fix.

I added the site_id column and got errors until I added the correct site id into site_id in the db.

MJ

#5

BoldMinded (Brian)

This should be fixed in the 1.2.2

Login to reply