Print

[Mader6000]

the plugin blocks don´t work right with new version.
Databasequery failed. ( .owner_name) failed any solutions?
pn .765 worked with cpg1.4.26

[phill104]

[Sarcastic Mode] I went to the doctor last week and said my mate was sick with this pain. Funnily enough he just couldn't work out what was wrong with him. [/Sarcastic Mode]

At least post a link - http://forum.coppermine-gallery.net/index.php/topic,55415.0.html

[Mader6000]

i can`t post a link becouse if i have enabled the block (random) complete site white with ^^error.
In release 1.5.3rc1 the owner_name field is dropped from table pictures

Code: [Select]

ALTER TABLE `CPG_pictures` DROP `owner_name`;so this querys failes in plugin blocks

Code: [Select]

if ($vars['nouser'] == 'y'){
$query = "SELECT $cpgprf"._pictures.".owner_name, $cpgprf"._albums.".title, $cpgprf"._pictures.".caption,$cpgprf"._pictures.".filepath,$cpgprf"._pictures.".filename,$cpgprf"._pictures.".hits,$cpgprf"._albums.".aid,$cpgprf"._pictures.".pid  from $cpgprf"._pictures.",$cpgprf"._albums."   WHERE $cpgprf"._pictures.".aid = $cpgprf"._albums.".aid and $cpgprf"._pictures.".approved = 'YES' and category < 10000  and find_in_set( visibility, '$view_list') > 0 and UPPER(RIGHT($cpgprf"._pictures.".filename,3))='JPG' order by RAND() limit 1 ";
} else {
$query = "SELECT $cpgprf"._pictures.".owner_name, $cpgprf"._albums.".title, $cpgprf"._pictures.".caption,$cpgprf"._pictures.".filepath,$cpgprf"._pictures.".filename,$cpgprf"._pictures.".hits,$cpgprf"._albums.".aid,$cpgprf"._pictures.".pid  from $cpgprf"._pictures.",$cpgprf"._albums."   WHERE $cpgprf"._pictures.".aid = $cpgprf"._albums.".aid and $cpgprf"._pictures.".approved = 'YES' and find_in_set( visibility, '$view_list') > 0 and UPPER(RIGHT($cpgprf"._pictures.".filename,3))='JPG' order by RAND() limit 1 ";

[Joe Carver]

n release 1.5.3rc1 the owner_name field is dropped from table pictures

There are many deep differences between cpg1.4.x and cpg1.5.x.

That also includes where the support requests should be posted. If you are using 1.5.x then you should be posting in that area of the support forum.

[phill104]

Why does that stop you posting a link?

[Joachim Müller]

• cpg1.5.x can't be used with pnCPG
• The thread starter misbehaved by posting on the wrong board and failed to post a link although being told.

Subsequently, I'm closing and locking this thread.

@Mader6000: do as suggested per board rules in the future or don't bother posting at all.