[3.5] "Array" text showing in series stories.

Well, I certainly don't want you wasting your time on me, but I do appreciate any advice you can offer.

This eFiction site started off as a fresh install, but that was a year ago so I've upgraded it a couple times since then. It's never gone public yet and after this latest upgrade to 3.5 was the only time I tried to install the Story End module. I had no database problems after each install, but I had huge problems with the Challenges module (duplicate entries and such, all mentioned in the post just below this one). I had a friend who knew more about MySQL come in and fix that for me, but she couldn't figure out how to fix this "Array" thing either.

And yes, after replacing my code with yours and uploading, I'm still getting the same corefunctions.php error. 🙁

I am assuming you are using version 1.3 of the storyend module too? I'm grasping at straws but trying to cover all the basic angles before I jump headfirst into the dark muddy place that is my brain today. LOL Too much fallen snow does that to me.

URL to your eFiction: Still under construction. Not yet public
Version of eFiction: 3.5
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.7
Version of MySQL: 4.1.22
Have you searched for your problem: Yes, I've read just about every post containing the word "Array"
If so, what terms did you try: Array, Story End Array, Series Array, etc.
State the nature of your problem: The word "Array" is showing up where the story text should be on any story that is part of a series.
Do you have a test account for us? Not at this time

I stupidly deleted my first post and the 8 or 9 wonderfully helpful replies I received from Jacynthe and Lyndsie. So sorry! I'm a phpBB user and I clicked the wrong button when I meant to reply.

Anyhow, once again, here is my problem:

After upgrading to 3.5 and installing the Story End module, I'm getting a strange error on any story that has been added as part of a series. The word "Array" comes up where the story text should be, but everything else (author, word count, etc.) all shows up fine. I'm 99% sure this has something to do with the Story End module, but I can't figure out what it is. I've found a thread containing a similar problem here and one containing the exact same problem here , but unfortunately no solution has been offered.

After the helpful advice I accidentally just deleted, I've attempted changing strip_slashes on like 64 of storyend.php to stripslashes and while this worked for some, it didn't seem to work for me.

I'm re-posting in hopes that we can continue the conversation.

Oh, and this is the error I'm receiving when I turn on debug:

Notice: Array to string conversion in /home/***/public_html//includes/corefunctions.php on line 207

Hehe, I was wondering what happened.  I clicked 'reply' and it said it was gone.

Anyway, what I was going to say was that you and Jacynthe had actually posted the same thing.  Just in the one, the symbols (&#xxxx;) had been replaced by what they actually represent, for some reason.  That's for dealing with the 'smart quotes' and all those other symbols that MS Word auto-formats, I think, since some browsers don't like them and they'll show up as question marks.  What's in the actual untouched 3.5 download is what you posted, Jaded.

Anyway, that section deals with a bit of character encoding and some stripslashes.  Are you using a custom language file?  And what are all the modules/mods you've installed?

I restored your topic and put it together with the old one Jaded 🙂

Hehe, I was wondering what happened.  I clicked 'reply' and it said it was gone.

Oh, it's back! Thank you!! What happened was me being an idiot, I'm afraid. 🙄

Anyway, what I was going to say was that you and Jacynthe had actually posted the same thing.  Just in the one, the symbols (&#xxxx;) had been replaced by what they actually represent, for some reason.

I wondered if that might be the case. I'll blame that on Dreamweaver then, since that's what I used to open it.

Anyway, that section deals with a bit of character encoding and some stripslashes.  Are you using a custom language file?  And what are all the modules/mods you've installed?

Nope, no custom language file. Installed modules are as follows:

Beta-Reader List  1.3
Challenges  1.4
Story End 1.3

I restored your topic and put it together with the old one Jaded 🙂

Thank you for repairing my stupidity LOL!! I PMed Carissa to see if it could be restored, so please let her know she can just ignore that.

Actually, it was Jacynthe's that was converted.  You should probably go and overwrite your corefunctions.php again with the one from the 3.5 download, just because it's popping that message.  Who knows, sillier things have fixed stuff for me.

I'm guessing you've done a fix for the 3.5 stories.php, right?  Did you replace the four lines in the 3.5 file, or did you replace it with the stories.php from 3.4.3?

I overwrited corefunctions.php again just now and still no change.

A fix? I tried the suggested stripslashes fix for storyend.php. Have I overlooked a fix for stories.php?

Should I try replacing stories.php from 3.5 with the same file from 3.4.3? I might as well give it a shot and see if that changes anything.

Just FYI. I tried that and no luck there either.

A lot of people were getting fatal errors when they tried to upload stories with 3.5.  A couple of the most recently updated threads on this board talk about it.

https://efiction.org/forums/index.php?topic=6677.msg36148#msg36148  is the best fix.  But if you're not having issues, there nothing to fix.

Can you link to your site, or is it in maintenance mode?

Actually, I did have that fatal error come up once or twice, but not recently. It vanished as quickly as it turned up, so I didn't think anything more of it. Anyhow, I tried the fixes you linked me to on that thread just now and "Array" is still there. This was what I saw on those rare occasions when it did come up, but I didn't make any connection with it and this recent problem:

A fatal MySQL error was encountered.
Query: SELECT PENNAMEFIELD AS penname FROM DBPREFIXfanfiction_coauthors AS c WHERE sid = '129' LEFT JOIN ef_fanfiction_authors as author AS a ON a.UIDFIELD = c.uid
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN ef_fanfiction_authors as author AS a ON a.UIDFIELD = c.uid' at line 1

A fatal MySQL error was encountered.
Query: SELECT PENNAMEFIELD AS penname FROM DBPREFIXfanfiction_coauthors AS c WHERE sid = '129' LEFT JOIN ef_fanfiction_authors as author AS a ON a.UIDFIELD = c.uid
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN ef_fanfiction_authors as author AS a ON a.UIDFIELD = c.uid' at line 1

DBPREFIX... means you have at least one instance in stories.php where you need to fix ".DBPREFIX." to ".TABLEPREFIX."

Actually.. let'S do this right. In stories.php, you'll have 4 instances of:

$coQuery = dbquery("SELECT ".PENNAMEFIELD." AS penname FROM ".DBPREFIX."fanfiction_coauthors AS c WHERE sid = '$sid' LEFT JOIN "._AUTHORTABLE." AS a ON a.".UIDFIELD." = c.uid");

that you need to change to:

$coQuery = dbquery("SELECT "._PENNAMEFIELD." AS penname FROM ".TABLEPREFIX."fanfiction_coauthors AS c LEFT JOIN "._AUTHORTABLE." ON "._UIDFIELD." = c.uid WHERE sid = '$sid'");