I am sorry to have to be asking this question here I have tried over efiction.org and have been totally ignore ignored.
My Problem is I want to bridge efiction with my smf 2.04 and Iam having trouble understanding one small part its the part where the instructions says to
Edit queries.php to point to your SMF tables and directory.
I know how to edit php files but I have no ideal as to just what you are suppose to edit enclosed is a copy of the queries file.
Quote from: Methen on October 25, 2008, 10:06:29 AM
I am sorry to have to be asking this question here I have tried over efiction.org and have been totally ignore ignored.
My Problem is I want to bridge efiction with my smf 2.04 and Iam having trouble understanding one small part its the part where the instructions says to
Edit queries.php to point to your SMF tables and directory.
I know how to edit php files but I have no ideal as to just what you are suppose to edit enclosed is a copy of the queries file.
Assuming you already have SMF installed and running, open up your SETTINGS.PHP file
and look for the following,,
SETTINGS.php (smf)
########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = '/homepages/blahblahblah2/htdocs/SMF' ; # The absolute path to the forum's folder.
where it says $boarddir copy the path inside to
// The table prefix for SMF
$db_prefix = "smf_";
// The RELATIVE path to your SMF install from your eFiction install.
// The example given is an SMF and eFiction install as sibling folders.
define("PATHTOSMF", "
../smf/");
Note: This message is awaiting approval by a moderator.
Ok I did that ( ithink I did it right)
Now I get the following error when I go to the efiction to make the other changes
Warning: require_once(PATHTOSMFSSI.php) [function.require-once]: failed to open stream: No such file or directory in /home/allbridg/public_html/XXXX.com/Storys/includes/get_session_vars.php on line 23
Fatal error: require_once() [function.require]: Failed opening required 'PATHTOSMFSSI.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/allbridg/public_html/XXXX.com/Storys/includes/get_session_vars.php on line 23
XXX.com for Privacy reasons
Note: this post will not display until it's been approved by a mooderator.Quote from: Methen on October 25, 2008, 07:04:58 PM
Ok I did that ( ithink I did it right)
Now I get the following error when I go to the efiction to make the other changes
Warning: require_once(PATHTOSMFSSI.php) [function.require-once]: failed to open stream: No such file or directory in /home/allbridg/public_html/XXXX.com/Storys/includes/get_session_vars.php on line 23
Fatal error: require_once() [function.require]: Failed opening required 'PATHTOSMFSSI.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/allbridg/public_html/XXXX.com/Storys/includes/get_session_vars.php on line 23
XXX.com for Privacy reasons
no... I think you messed it up somehow.
It's trying to include a file called PATHTOSMFSSI.PHP which is totally wrong...
However I do see from the example in your query.php THAT THE PATH TO SMF HAS A SLASH "/" AT THE END!
make sure yours does too!
it should look like...
define("PATHTOSMF", ".'/home/allbridg/public_html/XXXX.com/Storys/smf/');
*assuming the folder for SMF is called "smf" AND it is a subdirectory of the "Storys" folder.
Remember all these path items are CASE SENSITIVE!
I think you mean:
define("PATHTOSMF", "/home/allbridg/public_html/XXXX.com/Storys/smf/");
Assuming SMF is installed in stories/smf on your site
Nope... that won't work...
The eFiction does not want a PATH! it wants a relative URL
i.e. smf is installed in site.com, efiction is installed in site.com/efic, then the "path" is "../"
if they are in sister directories...
i.e. smf is installed in site.com/forum, efiction is installed in site.com/efic, then the "path" is "../forum"
The way my site is installed is the following each is in its own indpendent folder
with the exception of x7 chat which is in the forum folder.
cgi-bin
forum + chat which contains smf script
gallery which contains the coppermine script
Storys which contain the efiction script
ftpquota
htaccess
So is my problem in the queries file or the get_session_vars file as I have been trying to edit the get_session_vars with no luck.
I do have x7 chat in the forum folder which i am trying to intergrate but am also having problems
but that is required to intergrate.
see my response over on the efiction support forums.
Also, I do not believe that the current deisgn will work with smf 2.0, since I can not get it to work, even with the correct settings in efiction/includes/queries.php and the correct code updated in smf/sources/querystring.php
Go back to efiction a responce was given to your post to indicate it still might be possible.
Note: this post will not display until it's been approved by a moderator.
Quote from: Kindred on October 26, 2008, 09:12:32 AM
I think you mean:
define("PATHTOSMF", "/home/allbridg/public_html/XXXX.com/Storys/smf/");
Assuming SMF is installed in stories/smf on your site
Nope... that won't work...
The eFiction does not want a PATH! it wants a relative URL
i.e. smf is installed in site.com, efiction is installed in site.com/efic, then the "path" is "../"
if they are in sister directories...
i.e. smf is installed in site.com/forum, efiction is installed in site.com/efic, then the "path" is "../forum"
^eh?
what you gave is not a URL relative or otherwise! lol
And if a relative path can be used, then an absolute path will work just as well too
I have it working just fine, thanks.
I think he must have something else messed up somewhere
Methen - if you are still interested, post your queries.php again
yes... what I gave is a relative url.
By using the absolute PATH (my original statement, above), when I set it up, it tried to go to
http://www.site.com/Stories/home/allbridg/public_html/XXXX.com/Storys/smf/index.php?action=login2.
by using the relative URL/path, (../smf) it goes to
http://www.site.com/smf/index.php?action=login2
however, even if it was using the absolute path correctly... YOUR absolute path has an error in it.
we definitely have to nail down verbiage here.
URL vs PATH
For the sake of discussion: URL is accessible via http://url
whereas path refers to local path folders?
I'm still somewhat convinced that he has some values messed up somewhere....at this point, w/o actually LOOKING at his actual entries -or him being more explicit, we may just be wasting time here.
I think I may be pasting it in the wrong place please show me just where you are suppose to paste it at.
Oh and what are you suppose to do with the index file that comes with the smf bridge the instructions don't say one way or the other?
<?php
// The table prefix for SMF
$db_prefix = "smf_";
// The RELATIVE path to your SMF install from your eFiction install.
// The example given is an SMF and eFiction install as sibling folders.
define("PATHTOSMF", "../smf/");
$db_connection = $dbconnect;
// Default query strings used throughout the script. You may need to alter these to bridge to other scripts or databases.
define ("_UIDFIELD", "author.ID_MEMBER"); // Do not change the aliasing (the "author." part)!
define ("_PENNAMEFIELD", "author.realName"); // Do not change the aliasing (the "author." part)!
define ("_EMAILFIELD", "author.emailAddress"); // Do not change the aliasing (the "author." part)!
define ("_PASSWORDFIELD", "author.passwd"); // Do not change the aliasing (the "author." part)!
define ("_AUTHORTABLE", $db_prefix."members as author"); // Do not change the aliasing (the "as author" part)!
define ("_STORYQUERY", "SELECT stories.*, "._PENNAMEFIELD." as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM ("._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_stories as stories) WHERE "._UIDFIELD." = stories.uid AND stories.validated > 0 ");
define ("_STORYCOUNT", "SELECT count(sid) FROM ".TABLEPREFIX."fanfiction_stories as stories WHERE validated > 0");
define ("_SERIESQUERY", "SELECT series.*, "._PENNAMEFIELD." as penname FROM "._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_series as series WHERE "._UIDFIELD." = series.uid ");
define ("_SERIESCOUNT", "SELECT COUNT(seriesid) FROM ".TABLEPREFIX."fanfiction_series as series ");
define ("_MEMBERLIST", "SELECT count( stories.sid ) as stories, "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs AS ap ON "._UIDFIELD." = ap.uid LEFT JOIN ".TABLEPREFIX."fanfiction_stories AS stories ON stories.validated > 0 AND (FIND_IN_SET("._UIDFIELD.", stories.coauthors) > 0 OR stories.uid = "._UIDFIELD.") ");
define ("_MEMBERCOUNT", "SELECT COUNT(DISTINCT "._UIDFIELD.") FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_stories as stories ON stories.validated > 0 AND (FIND_IN_SET("._UIDFIELD.", stories.coauthors) > 0 OR stories.uid = "._UIDFIELD.") LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs as ap ON "._UIDFIELD." = ap.uid");
?>
Yes, URL versus path...
However, under most circumstances, a relative url will look the same as a relative path.
In this case, if I put in an absolute PATH, it screws up.
If I put in an absolute URL, it also screws up...
it must be relative (url or path) to the efiction installation.
Methen,
As I said over on eFiction, SMF 2.0 changed the database field names...
(also, please use the CODE BBC tags when you paste code)
<?php
// The table prefix for SMF
$db_prefix = "smf_";
// The RELATIVE path to your SMF install from your eFiction install.
// The example given is an SMF and eFiction install as sibling folders.
define("PATHTOSMF", "../smf/");
$db_connection = $dbconnect;
// Default query strings used throughout the script. You may need to alter these to bridge to other scripts or databases.
define ("_UIDFIELD", "author.id_member"); // Do not change the aliasing (the "author." part)!
define ("_PENNAMEFIELD", "author.real_name"); // Do not change the aliasing (the "author." part)!
define ("_EMAILFIELD", "author.email_adress"); // Do not change the aliasing (the "author." part)!
define ("_PASSWORDFIELD", "author.passwd"); // Do not change the aliasing (the "author." part)!
define ("_AUTHORTABLE", $db_prefix."members as author"); // Do not change the aliasing (the "as author" part)!
define ("_STORYQUERY", "SELECT stories.*, "._PENNAMEFIELD." as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM ("._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_stories as stories) WHERE "._UIDFIELD." = stories.uid AND stories.validated > 0 ");
define ("_STORYCOUNT", "SELECT count(sid) FROM ".TABLEPREFIX."fanfiction_stories as stories WHERE validated > 0");
define ("_SERIESQUERY", "SELECT series.*, "._PENNAMEFIELD." as penname FROM "._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_series as series WHERE "._UIDFIELD." = series.uid ");
define ("_SERIESCOUNT", "SELECT COUNT(seriesid) FROM ".TABLEPREFIX."fanfiction_series as series ");
define ("_MEMBERLIST", "SELECT count( stories.sid ) as stories, "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs AS ap ON "._UIDFIELD." = ap.uid LEFT JOIN ".TABLEPREFIX."fanfiction_stories AS stories ON stories.validated > 0 AND (FIND_IN_SET("._UIDFIELD.", stories.coauthors) > 0 OR stories.uid = "._UIDFIELD.") ");
define ("_MEMBERCOUNT", "SELECT COUNT(DISTINCT "._UIDFIELD.") FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_stories as stories ON stories.validated > 0 AND (FIND_IN_SET("._UIDFIELD.", stories.coauthors) > 0 OR stories.uid = "._UIDFIELD.") LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs as ap ON "._UIDFIELD." = ap.uid");
?>
Ok do I paste the path here? define("PATHTOSMF", "../smf/"); right where is says pathtosmf
as far as bbc codes I know nothing about them never used them.
update
Would it look something like this ?
define("http://mysite.com/forum/ (http://mysite.com/forum/)", "../smf/");
Ok I change the code in the querystring like you had over efiction
then I did this to the queries file: the results were the same no difference
define("", "../smf/");
this http://mysite.com/Forum was in there with the url tags but it is not showing right above this for some reason
dang it why is everything comeing out in url format?!!!!
(http://mysite.com/Forum%5B/url)
NO.....
define("PATHTOSMF", "../forum/");
I thought you said it had to be a url to me a url is Http:// and added url bcc tags
ok I took that out a put in define("PATHTOSMF", "../forum/");
and got this
Notice: Undefined index: db_query in /home/allbridg/public_html/mysite.com/forum/Sources/Load.php on line 144
Fatal error: Function name must be a string in /home/allbridg/public_html/mysite.com/forum/Sources/Load.php on line 144
well, what's on line 144 of your load.php?
What other mods do you have installed?
Does your forum work WITHOUT efiction?
Did you make the other changes to queries.php?
URL?
Note: this post will not display until it's been approved by a moderator.
Quote from: Methen on October 27, 2008, 06:39:07 PM
I thought you said it had to be a url to me a url is Http:// and added url bcc tags
ok I took that out a put in define("PATHTOSMF", "../forum/");
and got this
Notice: Undefined index: db_query in /home/allbridg/public_html/mysite.com/forum/Sources/Load.php on line 144
Fatal error: Function name must be a string in /home/allbridg/public_html/mysite.com/forum/Sources/Load.php on line 144
It's clear you have a typo somewhere - lets take this up via PM, or MSN
The forum is working fine
I had x7 chat installed and intergrated but it didnt work and I just took that out and deleted the tables in it
as far as the querys file all I did was paste in define("PATHTOSMF", "../forum/"); nothing more
asfar as what is on line 144 word processor does not show line numbers
so I have no ideal what is on line 144 IAm trying to find a php viewer that will tell me
line 144 says:
$smcFunc['db_query']('set_character_set', '
1- I told you already, both here and on efiction, you have to change more of the queries.php file than the single line. I even gave you the code you needed to use (see above)
2- what program are you using to edit php files?
You obviously have done something wrong... because, even if I don't have efiction completely linked, it does not give me any errors.
If you PM me your FTP address, FTP login and a forum login, I will take a look.
Here is a copy of the files
I was useing jarte then I got php editor to
see the 144 error
Quote from: Methen on October 27, 2008, 07:53:09 PM
The forum is working fine
I had x7 chat installed and intergrated but it didnt work and I just took that out and deleted the tables in it
as far as the querys file all I did was paste in define("PATHTOSMF", "../forum/"); nothing more
asfar as what is on line 144 word processor does not show line numbers
so I have no ideal what is on line 144 IAm trying to find a php viewer that will tell me
"word processor does not show line numbers"???
Note: this post will not display until it's been approved by a moderator.
good lord!
Maybe you mean something else, but a 'word processor' is trouble!
Google Crimson Editor or Emerald Editor, both good code editors with syntax highlighting and line numbering (you need to turn on line numbers in Options.)
Having Kindred look at it directly is really the best option, you are either doing something different than what you are saying (or your Wordprocessor may be introducing errors into the file?)
I have told you three times now, here and on efiction. You need to change the database field names. You also did not make all of the required changes to QueryString.php
You really need to pay attention to instructions.
Also... you should never, ever, ever, ever use a word processor to edit php files.
You should use a text editor, like conText, EditPlus, notepad++ or UltraEdit
I suspect your load.php problems are related to your incorrect edits.
updated files are attached below
I am sorry I did miss read about the bcc code part but as far as the db field names
you only briefly meation them on efiction something about them in smf being in lower case
and that was all that I seen i am not no php coder all I know how to do it to open the files and make changes in them I have no ideal what any of that php code means to me its just a bunch of jumble as far as mysql data bases I know how to create drop export and import that's it.
One problem I do have is people expecting me to remember every little part of instructions especially when the instructions are broke up in parts with me complete instruction in detail
step by step all in one post will always work best.
Quote from: Methen on October 28, 2008, 12:40:56 AM
I am sorry I did miss read about the bcc code part but as far as the db field names
you only briefly meation them on efiction something about them in smf being in lower case
and that was all that I seen i am not no php coder all I know how to do it to open the files and make changes in them I have no ideal what any of that php code means to me its just a bunch of jumble as far as mysql data bases I know how to create drop export and import that's it.
One problem I do have is people expecting me to remember every little part of instructions especially when the instructions are broke up in parts with me complete instruction in detail
step by step all in one post will always work best.
I agree....it's ALWAYS somebody else's fault! What's next, people will expect you to actually read the bits of advice and FOLLOW it?
Of course, the advice comes in bits and pieces because the INFORMATION YOU SUPPLY came in bits and pieces too!
Personally, I blame Kindred. I would demand a full refund if I were you!
(update: oh, he did all his help for free out of the goodness of his heart? good for him then, hope he has more to give, I'm outta this thread! lol)
I've been trying to for the past six months (at least) getting eFiction 3.5.2 to bridge with SMF 2.0RC3, and have been hitting my head against a wall. I've followed all the instructions, even used the two attached files from above...modified the RC3 version of QueryString.php, still I always get:
Quote
Notice: Undefined index: db_query in /var/www/sites/ayeka/Sources/Load.php on line 144
Fatal error: Function name must be a string in /var/www/sites/ayeka/Sources/Load.php on line 144
Nobody has answered my requests for help on the eFiction site, and I'm hoping that
somebody here can shed some light as to what the problem is.
Thank you very much.
I had the same problem back with beta 4 and pretty much gave up for a while... I'll probably look again after 2.0 final is released
I would be very grateful for any help you can provide when you get the opportunity. Thanks!! :)