UBB.Developers Forums UBB.threads 6 V6 Modifications Forum Design Integration Mysql error on line 121

Hi

Please forgive me if is not the correct thread to post to.

I have this displayed when I come from the (II5) front page to the forum page (Threads)................

When I start on the
Index page then go to the
Forum Page..........This time it's OK
Then back to
Index Page then go to the
Forum..........This time and all other times I get the below msg.

"SQL ERROR: Unable to do_query: SELECT DISTINCT Cat_Title,Cat_Number FROM w3t_Category WHERE Cat_Number = /ubbthreads/index.php?Cat= ORDER BY Cat_Number
You have an error in your SQL syntax near '/ubbthreads/index.php?Cat= ORDER BY Cat_Number ' at line 4
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /ubbthreads/mysql.inc.php on line 121"

Below is the link that is attached to the FORUM link at the top of page after the 2nd time.

/ubbthreads.php?Cat=/ubbthreads/index.php?Cat=/ubbthreads/index.php?Cat=

As you can see it has placed "/ubbthreads/index.php?Cat=" 3 times

Thx

Where is this happening? Here at ThreadsDev?

I can't quite figure out what's going on by what you have posted. It's probably just me though as I am having a hard time consintrating at the moment... lol

Hi

On my own web page.

click here for my web page

If you check the links on top of page via the status bar after you have clicked some a few time you should see it reads (as above Cat= etc ) 3 to even 5 times as many.

George

OK - I see what's wrong.

The link that says "home" back to IIP is wrong.

You can edit that in the ubbt_registerednav.tmpl and ubbt_unregisterednav.tmpl files.

That bit should look like this:

code:

<a href = "{$config['homeurl']}/index.php?Cat=$Cat" $target>Home</a>
 |

---

I expect you've got something different....with the index part repeated twice.

You may want to edit your navigation templates again. I believe you have extra code stuck in that shouldn't be there for the "Home" link.


Yeah what Josh said... lol

What's it a race to see who answers first????????? Startin' the timer.......hehe

He he.... that usually happens to me. I answer but end up being second after having looked up code and such.

Somehow this time I beat Dave. Maybe that massage therapist showed up.

Hi all

Sorry all but that nid not work........

Was........... <a href = "{$config['homeurl']}/ubbthreads/index.php?Cat=$Cat" $target>Home</a>
|
Changed to <a href = "{$config['homeurl']}/index.php?Cat=$Cat" $target>Home</a>
|

Deleted all my IE temp files.

Still the same error except for the "/ubbthreads" as it was taken out.

Now look at this one seach link instead of home

SQL ERROR: Unable to do_query: SELECT DISTINCT Cat_Title,Cat_Number FROM w3t_Category WHERE Cat_Number = /index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat= ORDER BY Cat_Number
You have an error in your SQL syntax near '/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/index.php?Cat=/inde' at line 4
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/hillcrestknitwear/ubbthreads/mysql.inc.php on line 121


Look how many times Cat=/index.php? shows now it also does the same with the search link.

It keeps ADDING [:"red"] Cat=/index.php? [/] each time I click back and forward between Home and Forum or Home and Search?

========================================

Also if I logout then click the "main Index" link I get .........

SQL ERROR: Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/hillcrestknitwear/ubbthreads/mysql.inc.php on line 121


Aach: now all the links are displaying lots of "Cat=/index.php?" in the status bar now.

Hi

OK it's got to be something to do with II5.1 index page hack.

As when I logout then login

then bounce back and forth between any link except the index page II5.1 alls ok

then as soon as I click the index page link...forum link... index page link....forum link....

NOW IS STARTS ADDING THE EXTRA LINKS

Something is corrupting the Cat variable. This must have happened while you were editing though. It looks to be a path or url value. IIP adds no such values to that variable.

Upload a fresh copy of the index.php and the navigation templates. Edit the navigation templates online and be sure to add exactly what is displayed in the initial setup box of IIP.

Let me know what happens.

Hi

Change address in new index.php

Uploaded new index.php to ubbthreads dir
Uploaded new ubbt_registerednav.tmpl
Uploaded new ubbt_unregisterednav.tmpl

Added one line to each tmpl file via admin.

Still the SAME

Any thing else

I'd like to take a look at your template files if possible. I'll need admin access to view them in your online editor. The other Cat variables in your navigation bar are not being corrupted so there must be an error in the "home" editing.

Hi

The search cat is the same

OK

Iv'e emailed you with login password

George

If you can PM me a username/password for admin I'll take a look.

Hi Dave

It's done but normal email

Cross links

George

Ok I fixed it.

The problem was that in your Home URL link in the configure section of threads also included /index.php?Cat= so when the link was displayed in the navigation bar it made a duplicate.

Make sure you delete that admin account.

Hi Dave

Well done, It's great to just pop in somewhere when they are in trouble, great idea.

1st class fixing.

Just checked the config and both are changed - [:"red"] for the better [/] -

Thanks