Errors

MrAnderson · Hangin' Around Joined: Nov 04, 2004 Posts: 34

My site was working 100% for a long time. But then I recently upgraded my server from windows 2000 to 2003 and when i did that, my site stopped working. I had a hassle with php4 and upgraded to php5. Now my PHP is working, but I get the following errors on my site:

Notice: Undefined variable: querystring in C:\Network\Websites\MAE\mainfile.php on line 19

Notice: Undefined variable: HTTP_USER_AGENT in C:\Network\Websites\MAE\mainfile.php on line 24

Notice: Undefined variable: HTTP_SERVER_VARS in C:\Network\Websites\MAE\mainfile.php on line 30

Notice: import_request_variables() [function.import-request-variables]: No prefix specified - possible security hazard in C:\Network\Websites\MAE\mainfile.php on line 47

Notice: Undefined variable: forum_admin in C:\Network\Websites\MAE\mainfile.php on line 125

Notice: Undefined variable: inside_mod in C:\Network\Websites\MAE\mainfile.php on line 128

Notice: Undefined variable: inside_mod in C:\Network\Websites\MAE\db\db.php on line 44

My web server is IIS6, win32, mysql 4.0.21, php 5.0.3. Please help. Thank you very much. Let me know if i need to post those lines. (probably do, but i dont wanna fish them out if i dont have to. It might be something obvious.)

-Mr.Anderson

Raven · Posted: Fri Jan 28, 2005 5:23 am

Only registered users can see links on this board!
Get registered or login to the forums!

MrAnderson · Hangin' Around Joined: Nov 04, 2004 Posts: 34

I knew about that. When I do that, all I get is a blank page, so I enable errors so I can see the problem, and thats all it shows. I know what you thought I meant, I used to get those notice errors that you can ignore, my page shows up with the errors. With this, nothing shows up except. errors. Any other ideas? Thank you.

Raven · Posted: Fri Jan 28, 2005 6:15 am

The blank page is a separate error. Turn those messages off, get the blank page, and then look in your server error log.

MrAnderson · Hangin' Around Joined: Nov 04, 2004 Posts: 34

I'm sorry if this is a stupid question. But you mean my IIS error log or another error log? If its the IIS error log, it looks normal:

"2005-01-28 13:44:37 W3SVC1 192.168.1.2 GET /mae/index.php - 80 - 192.168.1.4 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0) 200 0 0"

No errors in it. Is there another error log you are refering to?

sixonetonoffun · Posted: Fri Jan 28, 2005 7:55 am

In all honesty phpnuke works on IIS barely adding php5.03 to the mix you better really know what your doing. If at all possible I'd downgrade to php4.3.10

I know MySQL 5 and PHP 5 are coming and here but there hasn't been a large movement in the community to support either yet.

Raven · Posted: Fri Jan 28, 2005 8:11 am

Right on Six!

MrAnderson · Hangin' Around Joined: Nov 04, 2004 Posts: 34

I heard before that php 5.03 was a bad idea. Guess that was right. Thanx you guys. I guess im going back to 4.3.10.

Andrzej · Hangin' Around Joined: Jan 22, 2004 Posts: 31

Quote:

I know MySQL 5 and PHP 5 are coming and here but there hasn't been a large movement in the community to support either yet.

So - my provider changes for PHP5 - I have that:

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /includes/sql_layer.php on line 191

In sql_layer lines 165 - 212:

Quote:

function sql_query($query, $id)
{
global $dbtype;
global $sql_debug;
$sql_debug = 0;
if($sql_debug) echo "SQL query: ".str_replace(",",", ",$query)."<BR>";
switch ($dbtype) {

case "MySQL":
$res=@mysql_query($query, $id);
return $res;
break;;

case "mSQL":
$res=@msql_query($query, $id);
return $res;
break;;

case "postgres":
case "postgres_local":
$res=pg_exec($id,$query);
$result_set = new ResultSet;
$result_set->set_result( $res );
$result_set->set_total_rows( sql_num_rows( $result_set ) );
$result_set->set_fetched_rows( 0 );
return $result_set;
break;;

case "ODBC":
case "ODBC_Adabas":
$res=@odbc_exec($id,$query);
return $res;
break;;

case "Interbase":
$res=@ibase_query($id,$query);
return $res;
break;;

case "Sybase":
$res=@sybase_query($query, $id);
return $res;
break;;

default:
break;;
}
}

No chance?

Have I to migrate do another CMS ?

Raven · Posted: Sat Jan 29, 2005 9:35 am

Not at all. That message means that you have a block or module that is not correct with the table it's trying to call - it's not in sql_layer itself. Find this code

Code:

case "MySQL":
$res=@mysql_query($query, $id);
return $res;
break;;

and temporarily change it to

Code:

case "MySQL":
$res=mysql_query($query, $id);
return $res;
break;;

Now you should see all kinds of messages. Find the error one and right above it you should see what table is causing the error.

Andrzej · Hangin' Around Joined: Jan 22, 2004 Posts: 31

Problem is - the new PHP5 is on a trial serwer (backup) - they will change for PHP 5.0.3 on Monday. So I can't try now any changes in the code.

BUT...
They advised me to change the extencion from .php to .php4 (and all the calls to such files Bang Head

). the old PHP4 wile handle that in old way.

Raven, what do you think about that? Is it a lot of work?

Andrzej

Raven · Posted: Sat Jan 29, 2005 12:08 pm

??? You can't make any changes in YOUR code?

Andrzej · Hangin' Around Joined: Jan 22, 2004 Posts: 31

New PHP5 to test is

Only registered users can see links on this board!
Get registered or login to the forums!

(it is a backup for test only). I have not access to these files.

I have normal access to my files

Only registered users can see links on this board!
Get registered or login to the forums!

- but they are working till tomorrow under PHP4.

What are you thinking of changing extensions?

Raven · Posted: Sat Jan 29, 2005 3:46 pm

No reason to unless that is how they will delineate between PHP4 and PHP5. That would be a tremendous amont of work on your part. If that's what they want you to do, come host with me RavensScripts

Andrzej · Hangin' Around Joined: Jan 22, 2004 Posts: 31

Thanks Raven,

You have a nicy (price) sevice and I think - nowhere is better security. RavensScripts

But my service is in Poland.

Problem solved. They changed for PHP5 with such option: only .php5 extension is working with PHP5. Normal .php files stay with PHP4.

Wave

But the problem with PHP5 for PHPNuke is coming
HitsFan

And this element in the name of this great CMS: PHP-Nuke. And it will be not compliant with PHP Question

sixonetonoffun · Posted: Sun Jan 30, 2005 10:04 am

Only registered users can see links on this board!
Get registered or login to the forums!

But if you visit the php 5 bug reports I think you'll find that its not as pretty as all that.
Honestly I can't imagine a host opening up a php5 machine without making it opt in at this point in time.