Topic: Coopermine cpmfetch block shows database error

[vas]

I have installed Coopermine Gallery nad added cpmfetch to get images to the portal.

I added the code below in the "Custom PHP"

<?php
  include "./../photos/cpmfetch/cpmfetch.php";
  $objCpm = new cpm("./../photos/cpmfetch/cpmfetch_config.php");
  $objCpm->cpm_viewLastAddedMedia(1,4);
  $objCpm->cpm_close();
?>

and I was able to see the image in the preview but when I try to add the block it says "Database error in block code. Please check the code."

I dont know what is conflicting with Simple Portal. I am using SMF 1.1.10 and Simple Portal 2.3.

Help Please. Thanks.

[Nathaniel]

Turn on the 'Disable PHP Validation' setting, in your admin panel under SimplePortal -> Configuration -> General Settings.

It seems that the inbuilt SP php validation function has some issues.

[vas]

Turn on the 'Disable PHP Validation' setting, in your admin panel under SimplePortal -> Configuration -> General Settings.

It seems that the inbuilt SP php validation function has some issues.

Thanks. It Worked. But will it affect other codes any way?

[Nathaniel]

Yes it will affect all your PHP blocks/pages, SimplePortal will not perform PHP validation for any of your PHP blocks/pages. This will only cause problems if you have bugs in one of them.

[vas]

Yes it will affect all your PHP blocks/pages, SimplePortal will not perform PHP validation for any of your PHP blocks/pages. This will only cause problems if you have bugs in one of them.

Thanks for your reply.

If My php Codes are Alright, It should not have problem is it not? Otherwise when we load the page in which the php code used that page will display error message. Am I correct in my interpretation.

Also,

Turn on the 'Disable PHP Validation' setting, in your admin panel under SimplePortal -> Configuration -> General Settings.

It seems that the inbuilt SP php validation function has some issues.

Is it a issue in Simple portal that has to be looked into? If so will it be noted down for future correction? If the problem is with my code... what to say I will live with this.

[Nathaniel]

Yes it will affect all your PHP blocks/pages, SimplePortal will not perform PHP validation for any of your PHP blocks/pages. This will only cause problems if you have bugs in one of them.

Thanks for your reply.

If My php Codes are Alright, It should not have problem is it not? Otherwise when we load the page in which the php code used that page will display error message. Am I correct in my interpretation.

If your PHP code has no issues, then it should work okay. If it does have issues, then an error message will be displayed.

Turn on the 'Disable PHP Validation' setting, in your admin panel under SimplePortal -> Configuration -> General Settings.

It seems that the inbuilt SP php validation function has some issues.

Is it a issue in Simple portal that has to be looked into? If so will it be noted down for future correction? If the problem is with my code... what to say I will live with this.

I have already noted down this possible issue in the bugtracker, so that it will be looked into, and hopefully resolved with the next version of SimplePortal.

[vas]

I have already noted down this possible issue in the bugtracker, so that it will be looked into, and hopefully resolved with the next version of SimplePortal.

Thanks for the information.

[vas]

One more issue cropped up on the same above issue. I tried to have one more php code in the right block. it showed in the preview but when added it only showed the header and below nothing was present. Also, all the blocks following it did not display.

The code I used is

Code: [Select]

<?php
  include "./../photos/cpmfetch/cpmfetch.php";
  $objCpm = new cpm("./../photos/cpmfetch/cpmfetch_config.php");
  $objCpm->cpm_viewLastAddedMedia(1,1);
  $objCpm->cpm_close();
?
The first php code was in the top blocks and the second one I tried is in the right block.

One more...

Now after the failure to add one more php block, I tried turning "Off" the 'Disable PHP Validation' to see any improvement.

I found no improvement i.e., the second block and the following blocks still did not display but the first block (which displayed block code error with php validation on) surprisingly displayed even after enabling the php validation function which mean that only when adding php blocks I require to  disable the php validation. Strange.

[Nathaniel]

Try using absolute paths instead of relative paths.

ie:
/user/www/forum/photos/cpmfetch/cpmfetch.php
not
./../photos/cpmfetch/cpmfetch.php

[vas]

Try using absolute paths instead of relative paths.

ie:
/user/www/forum/photos/cpmfetch/cpmfetch.php
not
./../photos/cpmfetch/cpmfetch.php

Changed as you suggested but there is no change.

[Nathaniel]

The exact code I used on my test server, to test this issue was the code below:

Code: [Select]

require_once('/var/www/coppermine/cpmfetch/cpmfetch.php');
$objCpm = new cpm("/var/www/coppermine/cpmfetch/cpmfetch_config.php");
$objCpm->cpm_viewLastAddedMedia(1,4);
$objCpm->cpm_close();
It worked perfectly for SMF 2 RC1.2 + SP 2.3.1.