Alright I am on roll today.. first of all attached to this post is my modified global.php that works with my news. Just require it, instead of global.php (I have had no problems doing this) this will address stripslash errors

Second I have resolved the issue with including multiple news, and headlines on one page. The problem seems to be the script trying to do everything on one SQL connection. This is easily fixed:

Find this
And change it to

Now, after you do this you will have to find every instance of $connection and change it to what you set on that line. You can call it whatever.. $connectionilikecheese for example :p Put any further questions here, all these things worked for me :D

Check it all out here: http://www.dragonwolves.com

I get the following error:
I just uploaded and required only your global2.php (making sure to change all the path info to my own paths)

Ok, did you put the include lines at the top of your index page? (the page your including the news on)

<?
require("/path/to/global2.php");
require("/path/to/admin/config.php");
require("/path/to/PluhConfig.php");
?>

The only require line in the phuhnews.php should be

require("PluhConfig.php");

Rename and update to your paths of course.

Hamma, did you ever get this error:

Warning: 1 is not a valid MySQL-Link resource in /my/path/forumz/admin/db_mysql.php on line 93

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin: Invalid SQL: UPDATE session SET lastactivity=1014310822,location='/forumz/testpage.php',styleid=1 WHERE sessionhash='864316a4ee913aaef151a03edd678015'
mysql error:
mysql error number:
Date: Thursday 21st of February 2002 09:00:24 AM
Script: /forumz/testpage.php
Referer:

and If you did, how did you fix it? I keep getting it at the bottom of my page. I only have 1 headlines and 1 news on the page, but it gives that error, and I have no idea how to get rid of it. :(

Any help from anybody would be appreciated.

Thanks.

My post above entitled "2 for 2" explains how i fixed that. Its trying to do all those DB queries on one connection and dying out. I made it so it does the query on a different connection for each script :D

Hamma, so if I have say 2 different news things on one page, both headlines and news, I would rename all the $connection in one headline file to $connection1, and in one news file $connection2 and in the other news file $connection3?

So that in one headline it called $connection (the default), the 2nd headlines it called $connection1, in one of the news in called $connection2 and in the 2nd news it called $connection3.

Is that correct?

Yes, thats pretty much it.. each script needs its own connection name. So each headline/news script would have a seperate one.. make sure you rename every instance of $connection (im pretty sure it shows in only the script, and not the config file)

This worked like a charm for me :D And you were getting pretty much the same errors.

Example:

Ive incuded 1 news, and 2 headlines on my index.php

News
$connection in the mainnews.php was renamed to

$connectionnews

Headlines
$connection in the t2headlines.php script was renamed to

$connectiont2

$connectoin in my daocheadlines.php was renamed to

$connectiondaoc

Let me know how it works out..

Seems to work. Got rid of the error and everything. Great work. After how many times and people have been to this thread, it's surprizing it was something soo simple... Although I had a feeling that it would be something simple.

Many thanks.

Also for anybody using a lot of different connections you may want to double check your config.php file in your admin directory and make sure that you DON'T have persistant connection on, because if you have a lot of different news scripts each taking a spot on your mysql connections to the database, it could limit the access to your site.

Thanks Hamma, we finally traced down that pesky bug. I doubt everybody else that replied in those earlier pages knows that we fixed it. Maybe you should post something on one of the main forum pages and let everybody know that the PluhNews script is working again. :D

Good job.

In my index.php file:

I don't have PluhConfig.php because all the config options were moved into the PluhNews.php. I have multiple pages that access different news forums, so I had to do this.

I still get the following error:

Check your other files sccr410 and make sure they aren't "requiring" the same files that you are requiring in the index.php file. I know I had that problem before too, and I think that was the cause, is that there were multiple files requiring the same files.

Let me know.