the plugin blocks don´t work right with new version.
Databasequery failed. ( .owner_name) failed any solutions? ???
pn .765 worked with cpg1.4.26
[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
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
ALTER TABLE `CPG_pictures` DROP `owner_name`;
so this querys failes in plugin blocks
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 ";
Quote from: Mader6000 on April 30, 2010, 11:37:31 PM
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.
Why does that stop you posting a link?
- 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.