cpmFetch blocks in Efiction

[lonebard]

$config_overrides['cfUseExistingDBConnection'] = 'false';

[vuud]

crap.

I will think about this some more... it should not be doing this.

I wonder if they are only allowed one db connection...  Hmmmm

[lonebard]

You mean maybe the host limits things to one database connection at a time?

[vuud]

You mean maybe the host limits things to one database connection at a time?

I dunno... maybe... I am running out of ideas.  Is it a "less expensive host"?

[lonebard]

Here's the hosts list of plans. http://dwhs.net/web-hosting-plans.htm

I believe it's the Advanced plan. So it's not like a el cheapo set up.

[vuud]

Here's the hosts list of plans. http://dwhs.net/web-hosting-plans.htm

I believe it's the Advanced plan. So it's not like a el cheapo set up.

Well, they should definately not be blocking you on one connection for that amount

[vuud]

Here's the hosts list of plans. http://dwhs.net/web-hosting-plans.htm

I believe it's the Advanced plan. So it's not like a el cheapo set up.

If there is any chance you could PM me a phpinfo() output that would be great.

This is really bothering me.

[vuud]

Here's the hosts list of plans. http://dwhs.net/web-hosting-plans.htm

I believe it's the Advanced plan. So it's not like a el cheapo set up.

Ah-ha... I figured it out (again?).  Its the same stupid problem with efiction and not specifiying a specific connection.

If you are still game to try it... do this:

Open up a copy of cpmfetch_dao.php for editing

Find the line that says this (its around 1231 in my version, which may be slightly different)

Code Select Expand

function dbExecuteSql ($sqlcode, $convert = true) {
$this->dbConnect();
$this->lastSQLRowsReturned = 0;
$this->lastSQLErrorMessage = "";
$results = array();

Then add this line:

Code Select Expand

mysql_select_db($this->cfg['dbname'], $this->dbconnection);

This forces CpmFetch to select the database again, its not efficent, but I suspect that the efiction system does the mysql_select_db something like this:

mysql_select_db($this->cfg['dbname']);

Which does the same thing as the other ones... hijacks the last connection.  So they re-use ours, then change the database.

[lonebard]

Hmm, that brings me back to this old friend...

A fatal MySQL error was encountered.
Query: SELECT message_text FROM fanfiction_messages WHERE message_name = 'welcome'
Error: (1146) Table 'bgmasque_coppermine.fanfiction_messages' doesn't exist

[vuud]

Hmm, that brings me back to this old friend...

GAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I've spent more time trying to work around this "feature" of eFiction (Feature in the Microsoft sense of the word) than I have on anything else.

Okay, see that same function?  Down toward the bottom of it, just before the return, enter this:

Code Select Expand

mysql_select_db("Name of stupid efiction database here", $this->dbconnection);

This tells CpmFetch to set itself back to the... you know what, I am not even going to explain it this time.  If people don't get the point that eFiction is not meant to co-exist with anything else....

#@@$&#@ *(#$@*9 #@9 $(!)$@()!$#@!!

I am gonna go hit something now... most likely with my head.  With any luck I will forget this whole experience.

Its almost funny.

More than anything I hope this works for you...

[lonebard]

Exact same problem.

Thanks for all your help. You've done MORE than I expected. I realize this problem exists because of the limitations eFiction has set forth. Which i tried to explain to this person before I started in on this project for them. Sadly because of their devs lack of enthusiasm I'm not sure how long it'll take for them to look into writing better code.

[vuud]

Exact same problem.

Thanks for all your help. You've done MORE than I expected. I realize this problem exists because of the limitations eFiction has set forth. Which i tried to explain to this person before I started in on this project for them. Sadly because of their devs lack of enthusiasm I'm not sure how long it'll take for them to look into writing better code.

I just want to clarify that you replaced "name of stupid efiction database" with the actual name???

[lonebard]

lol good thing you did.

That code font is so small I didnt even notice. I'm just running on auto pilot now. I'll add the correct name and see what happens.

[lonebard]

Hah, success! - Sort of.

Images show up, the eFiction page shows up. But the pictures are at the top of the page.

http://www.themasque.net/efiction/index.php

[vuud]

Hah, success! - Sort of.

Images show up, the eFiction page shows up. But the pictures are at the top of the page.

http://www.themasque.net/efiction/index.php

Oh thats funny... its all in CSS Layouts.

Anyway, if I look at your source for the page, the cpmfetch stuff is executing at the top.

You are on your own from here my friend

Cause this gets into an EFiction issue (placement and such) and I have learned enough about efiction already :p

[lonebard]

Hmm, well thats odd because the cpmfetch code is inside a "block" and as such it's set to display inside the "Recent Images" box. I have no idea how it could be outside of that box but oh well. I'll continue to trouble shoot.

They don't appear up there because we put that code to initialize cpmFetch above the header in index.php?

[lonebard]

Hmm. I actually removed the code from index.php and added all of it back to the block. If this block runs in the middle of a div why would the images appear at the top of the page? ... I maybe a novice with php but i cant explain the placement of the images by css.

[vuud]

Hmm. I actually removed the code from index.php and added all of it back to the block. If this block runs in the middle of a div why would the images appear at the top of the page? ... I maybe a novice with php but i cant explain the placement of the images by css.

It may be running in the div, but if you VIEW SOURCE on the page (at least the one you point to above) you will see its actually getting output before the html BODY tag.

As for the stuff we had in the index, that does not output anything, so it would not cause this.

Can you post the code you are using in your block?  If you do not change the output type, it will shoot straight to the output. 

[lonebard]

The block contains this...

Code Select Expand

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

[vuud]

The block contains this...

Code Select Expand

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

I believe the original thread by Calic0cat contains setting the result set.  I would review that thread...