Calendar in Efiction index.tpl

The include is fine, I think, the error is just telling you that:

Error: (1146) Table 'ccgrove_calendar.fanfiction_pagelinks' doesn't exist

Is the calendar on its own DB or?

This is odd. It looks like the database connections are in conflict (eFiction didn't support any modification (including a bridge) that needed to connect to another database than eFiction is installed on earlier), but is should not be happening in the current version, as far as I can see. Are you using the latest eFiction version? (Or is the calendar even using a different database?)

Sorry, I been busy and took it down but yes, it has its own database.

If I put in the full web address to the include then the calendar doesn't show up at all.

Yes, I am up to date in efiction.

Any help is lovely.

Off topic, but...I llove your orange skin! 🙂

Sounds almost like the problem I had getting the coppermine fetch mod/bridge to work on my efiction installation. What the problem ended up being was that efiction would close all database connections before it opened its own connection. Thus killing off any other databases that try and get access.

I'll have to dig back through the coppermine fetch mod threads and see what it was we did to sort that problem out and if its a similar fix for a calendar.

Edit: it's my understanding that the original poster is using Easy PHP Calendar?

I've set up the trial of said Calendar on my site and the block just shows up empty. But the calendar page works fine - http://themasque.net/calendar/

The block's init.php contains...

<?php
dbquery("INSERT INTO ".$tableprefix."fanfiction_blocks(`block_name`, `block_title`, `block_status`, `block_file`, `block_variables`) VALUES('calendar', 'Calendar', '0', ' http://themasque.net/calendar/index.php',  '');");
$blocks["calendar"] = array("title" => "Calendar", "status" => "0", "file" => " http://themasque.net/calendar/index.php"); 
?>

Going just off the error but it looks like the calender is resetting $tableprefix to match it's own settings.  So eFiction loads fine, then the calender block resets this value, and when the pagelinks area goes to get data it no longer has the correct information.

If this is the case, then giving both the calender and eFiction the same table prefix would work to patch the problem without altering any code.  Otherwise you will need to edit the calender script, or eFiction.

To Becca:  Thank you, I like the color orange on a website. I creating three more with orange as the main color.

To Ionebard: I am not using the trial Easy PHP Calendar but something very similiar and free :  PHP Calendar

That's probably why I am not seeing what you're seeing. I couldn't find a block's init.php in the files. 😕

To Calash: I think you will have to talk slowly to me about that because I only learn from doing.  I think I understand some but I wouldn't know how to find the tableprefix of the calendar to connect and I guess it would be prudent to mess with the calendar than efiction.:-D

Thanks in Advance

PS. If I change the include to this:

<div class="content"><!-- INCLUDE BLOCK : calendar/index.php --></div>

I have what you see if you look at the orange skin now. i will leave it up for the rest of the day if needed.

I just download the script to take a look, I may be wrong about the $tableprefix...I can not find it listed in the calender

This is definitely some sort of database connection issue.  The error that you are seeing....

A fatal MySQL error was encountered.
Query: SELECT * from fanfiction_pagelinks ORDER BY link_access ASC
Error: (1146) Table 'ccgrove_calendar.fanfiction_pagelinks' doesn't exist

This is from eFiction in the pagesetup.php file

Here is the original code

$linkquery = dbquery("SELECT * from ".TABLEPREFIX."fanfiction_pagelinks ORDER BY link_access ASC");

I had thought TABLEPREFIX was the issue since we are seeing the "ccgrove_calender" appended to the query in the error. 

Actually....now that I am looking at this I think lonebard is correct.  The calender is replacing the eFiction connection with it's own to a database that does not have eFiction data in it.

If you install the calender in the same database as eFiction do you get the same errors?

Actually....now that I am looking at this I think lonebard is correct.  The calender is replacing the eFiction connection with it's own to a database that does not have eFiction data in it.

Yeah, it looks like that, but it's odd because eFiction is supposed to have its own DB connection handler.

I'm looking at the calendar code. Haven't you considered putting the calender in an iframe? Because the output code it gives looks like a completely independant HTML document exaclty like an iframe. (Putting the calender in an iframe would be to write something like "<iframe src ="calendar/index.php" width="200" height="200"></iframe>" instead of "<!-- INCLUDE BLOCK : calendar/index.php -->".) Unless you've already customized that HTML output.

To Eyedam : Well it worked! I haven't used iframes in such a long time but I guess like you said code is independent so the iframe does what it does. I didn't customize any html output but the most I want to do with it is customize the css for each skin I use this with.

If you install the calendar in the same database as eFiction do you get the same errors?

To Calash: Well I don't know how to combine the two databases without help so I couldn't answer that question. But I am willing to try this on a unused archive I have to see if this works but I would need a tutorial.  I still want to try it this way too. Even though iframes is a solution, it may not work for everybody. 🙂

The best bet would be to reinstall it, but select your eFiction database.  Moving stuff would be too much work for a test script.

Not sure how this gets installed....I have not read the instruction that deep 🙂

In case you decide to stick with the iframes. One way to customize the calendar along with eFiction skin change, would be to give something like this as the source instead: "src ="calendar/index.php?style=orange"" and then in the "calendar/index.php" instead of "@import "style.css"" put something like this "@import "css/<?=$_GET['css']?>.css"" (if all style CSSes are put into folder "css").