OW Debug - Exception

Chris hopefully he will reply soon but the error message 

" Column 'entityType' in on clause is ambiguous "  means that the name is not specifically addressed to the specific data.  In other words lets say that two tables have the same field.

table 1  has entityType

table 2  has entityType

If we join the two tables together in one lump of data we must specify so that the server knows what data we want.. Example    table1.entityType  or table2.entityType   if we just say entityType the server will toss that  ambiguous  error.

Hopefully the dev will fix that asap for you.

Let me install it chris an see if i can help you.  By the way you prob should edit your post and remove the second item, never give out that info just do this home3/xxxxxx/public_html  it is a security issue.

Also why dont you go ahead and send Aliia a message and let her know the dev is not replying to you.  I will see if i can get this working in the mean time :)

Aliia looks like is comming from here,   bol/hotphoto_service.php

LEFT JOIN `".OW_DB_PREFIX . 'base_rate'."` AS `rate`  ON ( `photo`.`id`=`rate`.`entityId` AND `entityType`='photo_rates')

It probably just needs a table prefix on the name.

maybe like this.

AND `rate`.`entityType`=`photo_rates`)

so the whole thing should look like this now

LEFT JOIN `".OW_DB_PREFIX . 'base_rate'."` AS `rate` ON ( `photo`.`id`=`rate`.`entityId` AND `rate`.`entityType`='photo_rates')

Chris give that a try buddy. :)

ps. i also sent a message to the dev

UPDATE well i installed it and no errors at all.   But here is the table layout just to save you some time Aliia or Dixie or any team member or dev.  Its not going to hurt to add the prefix there anyway.

I add the prefix and its working fine, no difference either way, but maybe it might help chris.

table name is   ow_base_rate  and fields are   id -  entityType -  entityId -  score - timeStamp -  active 

Also in ow_plugins/hotphoto/views/components/random_photo.html   430 is a much better width otherwise the header bar bleads into the photo.  So change both widths to 430 if you want..