Help Needed for php/mysql

[Aussie]

:confused: I am a complete novice to programming of MYSQL or PHP so please bear with me.
I have three sites on Powweb and within them I have three different php/mysql programs running. Non of which work properly anymore. These were setup by the writers of the programs and worked fine until recently. Now the links generate different categories and the contents are all merged in with other contents.

I understand there has been some changes to powweb servers so how do I get around this? Do I have to hire a programmer to fix it or what?

Could some one please advise me as to what is happening here?

Regards
Aussie. :(

[Laume]

Can you give some links to these errors?

[Aussie]

Here are a couple.

http://affiliates.akrweb.com
This one has recently been installed and was working fine then last week it went crazy. You get the same cat come up no matter what you click on.

http://www.lochsport.com/cookbook2/index.php
This has been running successfully for a couple of years and has now gone crazy.
You will notice that when you click on a link the contents are of a lot of stuff that shouldn't be in that category

[Aussie]

Isn't there anyone with the knowledge to tell me what has happened?

A service that gets mucked up and you can't get help is no good to anyone.

At the moment I must admit I am pretty cheesed off as this had nothing to do with me.

[mitchind]

Isn't there anyone with the knowledge to tell me what has happened?

A service that gets mucked up and you can't get help is no good to anyone.

At the moment I must admit I am pretty cheesed off as this had nothing to do with me.
Relax, buddy - you'll find you might get a bit more help with a better explanation of the problem and a little less righteous indignation. No one here's obligated to help you - we're volunteers who do it because it's something we enjoy.

Speaking for myself, seeing a snotty post takes away from motivation to help.

Saying the problem just started last week doesn't make sense to me because my first thought is to:

1. Replace your php.ini with a custom one (see Knowledge Base).
2. Make sure register globals are turned on (change line register_globals=On).
3. Save file as php.ini.txt
4. Upload to your htdocs directory
5. Rename file to php.ini
6. Try again

[Laume]

I'm afraid mitch is right. Even as a PowWeb employee, I tread these php and mysql forums because I enjoy it. But phone calls and e-mails and questions that has to do with service, rather than web design and php programming, takes priority.

I've taken a look at the page but from the quick glance, all the categories seems to be fine. What should they look like?

[Aussie]

Thanks for the help Mitch.

Sorry about sounding off, I was pretty uptight at the time, didn't mean to upset anyone.
I kicked my self in the butt.

========
Laume,
Apparently the problem is caused because of the change in php as suggested by mitch.

What is happening is the category links don't give the right requests to MYSQL or serve up the correct response.

Example: http://www.lochsport.com/cookbook2/index.php - click on any category in the cookbook and the results throw up every recipe in the data base instead of just the ones that are supposed to be in that category. Apparently one solution to this would be for Powweb to set register globals to 'on' locally.

I tried using a .htaccess command but that just caused a server error. I used - php_flag register_globals ON - tried it on both sites but got the same result.

Apparently every one who is still running an old script will be affected by this change over to the new method. (this is according to a php script writer) He has to re-write all his scripts because of the change.

My other site is affected in the same way but as that script is newly installed it hasn't created such a headache. It is not separating link/category requests just serving up the one answer no matter what the request yet when it was installed it worked fine.

As I have not had anything much to do with php, I have found it hard to get my head around this problem and being an old bloke I get a bit stroppy, sorry about that.

Regards
aussie

[Aussie]

Maybe this will help: http://www.lochsport.com/cookbook2/info.php

[mitchind]

Apparently one solution to this would be for Powweb to set register globals to 'on' locally.
I've already described my suggestion on how to fix your problem in my previous post - nowhere did I mention using .htaccess to set globals on - that will definitely cause Internal Server Error. Use the custom php.ini method I described.

When someone does take time to respond it's always a nice gesture to read their post - especially if it provides a solution

[Aussie]

Thanks Mitch, I did use the php.ini solution but I'm afraid it did not work.
Maybe I did it wrong. I used the one on knowledge base as is and changed the line register_globals=On and uploaded it exactly as you said.

The .htaccess suggestion came from someone else.

Cheers
Aussie