SQL error -

uploading photo to group albums module, have emailed Andrew but as its evening may not get reply until tomorrow.

I have a presentation tomorrow and would like to use this in it, so any help appreciated!

This error after uploading photo into this module.

Regular photos upload fine.

Query:
INSERT INTO `agrp_palbums_units` SET `AlbumID` = '11', `Title` = '2014-autumn-styleguide-images-1600x546-campaign-01', `Uri` = '2014-autumn-styleguide-images-1600x546-campaign-01', `When` = '1424707484', `Size` = '650x221', `Filename` = 'f7d3e82a079e21605b46d6a02429663b.jpg', `owner` = '1'
Mysql Error:
Unknown column 'owner' in 'field list'
Found error in the file '//Public_html/website/Modules/Andrew/Gpalbums/Classes/AGpalbumsDb.Php' at line 60.
Called 'Query' function with erroneous argument #0.
Quote · 23 Feb 2015

Looks like the field `Owner` is missing in the table `agrp_palbums_units`

This query should correct the error by adding the missing field to the table, but you should still have the modules owner look into it.

ALTER TABLE `agrp_palbums_units` ADD `Owner` INT NOT NULL ;

https://www.deanbassett.com
Quote · 23 Feb 2015

Sorry. The above query is incorrect. Incorrect case on Owner field.

Use this one instead.

ALTER TABLE `agrp_palbums_units` ADD `owner` INT NOT NULL ;

I can no longer edit the older post. I wish boonex would remove that, or allow much longer to edit posts.

https://www.deanbassett.com
Quote · 23 Feb 2015

thanks Deano, will give it a go

Quote · 23 Feb 2015

worked a treat :-)

Quote · 23 Feb 2015
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.