what does this mean, I didnt edit any php files at all so why would....

[Xelation]

what does this mean, I didnt edit any php files at all so why would I be getting this...


Warning: Offset 0 is invalid for MySQL result index 25 in /home/daxio/public_html/forum/admin/db_mysql.php on line 187

Warning: Offset 0 is invalid for MySQL result index 25 in /home/daxio/public_html/forum/admin/db_mysql.php on line 187

Warning: Offset 0 is invalid for MySQL result index 25 in /home/daxio/public_html/forum/admin/db_mysql.php on line 187

Warning: Offset 0 is invalid for MySQL result index 25 in /home/daxio/public_html/forum/admin/db_mysql.php on line 187


I hope someone can help me

[Steve Machol]

Did you make any templates changes, particularly to phpinclude?

[Xelation]

yes, one sec I'll show you my php include template

[Xelation]

// This code is PHP4 only:
// ob_start();
// require("yourheader.html");
// $header = ob_get_contents();
// ob_end_clean();
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=number_format($numbersmembers['users']);

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid'];

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=number_format($countposts['posts']);

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=number_format($countthreads['threads']);

// if user is know, then welcome
if ($bbuserinfo['userid']!=0) {
$username=$bbuserinfo['username'];
eval("\$welcometext = \"".gettemplate('forumhome_welcometext')."\";");
eval("\$logincode = \"".gettemplate('forumhome_logoutcode')."\";");
eval("\$newposts = \"".gettemplate('forumhome_newposts')."\";");

} else {
$welcometext = "";
eval("\$newposts = \"".gettemplate('forumhome_todayposts')."\";");
eval("\$logincode = \"".gettemplate('forumhome_logincode')."\";");
}

[Steve Machol]

What did you add? Does the error disappear when you remove it?

[Xelation]

first off, the things I added to the template are the $logincode and this...

Welcome back, Xelation
Welcome to our newest Member, Xelation!
Members: 2, Threads: 2, Posts: 17

its so I can put it into the header without editing the php files... now second, I reverted the phpinclude template back to normal and it still does the same thing. :\

[Steve Machol]

Well these things don't happen without something changing. Unfortunately I suspect you have many hacks otherwise I would suggest you fuill out a support request. Other than reuploading all the original vB file I don't know what else to suggest. Clearly one or more scripts are causing this problem.

What exactly are you doing when you get this error? And what is the URL that generates it?

[Xelation]

I havnt added any hacks at all, thats the problem... so how could it be the templates....

it only happens when a thread recieves more than one page of posts.

[Steve Machol]

The only way I could see this happening is with a php script, and that means either the vB php files or something added to phpinclude.

Also once again - What is the URL that generates this error?

[Xelation]

http://64.46.99.77/forum/showthread.php?threadid=2

[Steve Machol]

Thanks. Have you tried the obvious yet - i.e., reupload all the original php files? Make sure you upload in ASCII and overwrite the files on the server.

[Xelation]

I did that, I will do it again though

[Steve Machol]

FWIW here's line 187 in db_mysql.php:

   return mysql_data_seek($this->query_id, $pos); 

Did you changes servers or did the server change PHP versions by any chance?

[Xelation]

nothing but fresh php files and still the same thing, the only thing I can think of would be the config.php file... thats the only thing thats edited.

[Xelation]

hmm very well could be the version of php... I'll check it out and let you know