The board just emailed me this MySQL Error????

[taubin]

repair is weird on this

I run

http://www.myplace.com/bb/admin/extras/repair.php?html=1&check=1

and I receive a blank page, no output.

trying to troubleshoot this problem on php 4.2.0

i tried adding forum=vbulletin as well, same deal, blank page

I am on IE 6.0
Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT userid
FROM user
WHERE username='sdfvsv'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

[lawnmowerman]

Error

I also received this one;

Database error in vBulletin :

cannot use database wassellforum
mysql error: Unknown database 'wassellforum'

mysql error number: 1049

Date: Wednesday 24th of April 2002 07:52:30 PM
Script: /vblite/register.php?a=act&u=6&i=92171813
Referer:

[Steve Machol]

Re: repair is weird on this

Originally posted by taubin
I run

http://www.myplace.com/bb/admin/extr...html=1&check=1

Don't run repair.php from the extras directory. Upload it to the admin directory and run it from there.

trying to troubleshoot this problem on php 4.2.0

There are known issues between vB and PHP 4.20. Make sure the register_globals in 'On' in your phpinfo.php page.

[Steve Machol]

Re: Error

Originally posted by lawnmowerman
I also received this one;

You'll need to submit a support ticket atL:

http://www.vbulletin.com/members/support.php

Be sure to include the login info to access your Admin CP and FTP.

[taubin]

thanks

sm:

the phpinfo.php file is not on my system. I looked in the main area and under admin.
sorry.
I ran repair the correct way and it did process, I will test and get back to you asap.

[taubin]

same error

even after the repair I am receiving the same error when I try to modify a user's group.

I saw freddie's reply to me regarding changes the error message code in the db class to be fully quoted. that did not fix it either.

other than doing what freddie asked I have not other hacks or anything on this system.

[taubin]

not to be dense

I reread over my notes. if you mean do the results of phpinfo.php ( a test program) show the globals as being on or off in the php.ini, then I can answer that. the host has the globals off for security reasons and does not intend to change it.

I was told to get an upgraded copy of my software that was compatible with php 4.2.0

[Steve Machol]

As I said there are known problems with PHP 4.20. In addition to register_globals sSee this thread for several fixes posted by freddie, including user.php, template.php and db_mysql.php replacements made for PHP 4.2.0:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=42414

For phpinfo.php, create a new file with that name and this content:

<?php
phpinfo();
?>

Upload it to your forums directory and post the URL here.

[Steve Machol]

Re: not to be dense

Originally posted by taubin
I reread over my notes. if you mean do the results of phpinfo.php ( a test program) show the globals as being on or off in the php.ini, then I can answer that. the host has the globals off for security reasons and does not intend to change it.

I was told to get an upgraded copy of my software that was compatible with php 4.2.0

Yikes! Unfortunately all current versions of vB require register_globals to be on. If they are unwilling to cooperate your only option may be to find another host. Good luck!

[taubin]

will do

I just bought vbulletin from you you 3 weeks ago, its strange to think I have to do all those code changes, but I will try.

I don't see a specific list of modules to change and what lines to change listed in that thread you pointed me to.

if did a search on the one piece of code I could see marked as "change this" "to this" and it found one occurrenc, in the db class module in admin. that change did not help it.
where are the other changes referring to.

do you have an update to the source, it seems with so many people have this issue you could mark up your 2.2.5 code far easier and more reliably than all of us.

when will 2.2.6 or a fix be out?

- updated --

I ran the phpinfo, but couldn't I send the path to you instead of posting here, it has a lot of personal information and paths in there I cannot let be public.
I ran it and here is the line you wan to see

register_globals
On On

it looks like it is on, the host made a typo in their response.

its not the register_globals that is the problem here.

[Freddie Bingham]

If you look at my posts in that thread you will find 3 attachments, user.php, template.php and db_mysql.php

All of these files are replacements that go in your admin directory. Since we are still trying to work out all of the oddities that php 4.2.0 has introduced, I don't have a date for a v2.2.6 release.
It will resolve this problem:

Invalid SQL: SELECT userid 
FROM user 
WHERE username='sdfvsv' 
AND userid <> 
mysql error: You have an error in your SQL syntax near '' at line 4 

That being said, if register_globals is indeed off than vBulletin will not work until we release v3 which is still a few months away.

[Steve Machol]

Unfortunately the 'fixed' files will not help you because your host will not set register_globals to on, and as I said all versions of vB require this to be on. AFAIK there is no easy fix or patch for this.

If you host does decide to relent and set this on, then all you need to do is download and reupload the user.php, template.php and db_mysql.php files posted by freddie. No code editing is required.

[taubin]

okay okay 8-)

we have a crossing in the mail problem here.

Understood and have read your latest posts.

The host has the

register_globals On On

Misunderstanding of my question on their part, the phpinfo was helpfull.

I will now gladly download his attachments and perform the upload, thus replacing those files.

Will get back to you as soon as I can.

thanks, I will stay on this.

thank you for your great support.

[taubin]

its WORKING!!!! (users can be changed)

Very nice and easy fix. I uploaded those files.
I went into the List Users, found my test person,
and changed him from Registered to Moderator and Saved.

THIS PROBLEM IS FIXED!!!!!!!

suggesstion, can you put all three of those attachments in Freddie's post right in the php 4.2.0 announcement? may be easier so you can point people with one line.

I missed the attachments several times through that post.

But all is fine and wonderful now.

rock on!