MySQL error 1064 in vB 3.0.3 + PHP5.0.0 using forums/global.php user authentication
 

MySQL error 1064 in vB 3.0.3 + PHP5.0.0 (gold/release)

--------------------------------------------------------------------------------

Hello and thank you for your time.

I am running vBulletin v3.0.3 (no hacks whatsoever), within the following context:


- Microsoft Windows Server 2003 Enterprise
- Apache 2 v2.0.50 (as a module, *NOT* CGI)
- mod_ssl v2.0.50
- MySQL v4.0.20d
- PHP5.0.0 (gold/release)


I receive the following error when attempting to access a forum link in vBulletin - which passes variables to a PHP page -
which, in turn, should access a MySQL database (via: action=new).

Said link remains unchanged since before my upgrade from vB 3.0.1-->3.0.3.

Any/all help will be MOST appreciated; thank you, in advance...


**************************************************


Database error in vBulletin :

Invalid SQL:
SELECT * FROM style
WHERE (styleid = 0 AND userselect = 1)
OR styleid =
ORDER BY styleid ASC
LIMIT 1

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY styleid ASC
LIMIT 1' at line 4

mysql error number: 1064

Date: Wednesday 07th of July 2004 09:44:55 AM
Script: http://www.500ecstasy.com/forums/re....php?action=new
Referer:
IP Address: xxx.xxx.xxx.xxx


**************************************************

well, the sql string is missing a value after "OR styleid ="

this means a variable is empty somewhere, are you sure you haven't touched the code? I'm not sure what would cause this.

Upon further investigation, it appears that this problem is directly related to the inclusion/requirement of forums/global.php for user authentication (in my vBulletin 3.0.3 user-group permission specified link).

Specifically, the code in question follows:


<?
$self_dir = getcwd();
chdir('../');
require_once('global.php');
chdir($self_dir);
?>


Of note is the fact that browsing directly to forums/global.php yields the identical MySQL error noted above (1064).

Is anyone else using the above method of user authentication?

If not, what is the recommended method, please?

{EDIT: preemptive bump deleted, in the interest of netiquette}

there is no need to bump a thread within 24h, that will just reduce your chance of getting help..

have you tried to add the importat variables/arrays before you call global.php.
there's a reason why these are on every page ;)

Thank you very much for your time and assistance.

Being a network engineer and not a coder (by any real standard), I do not follow your suggestion/implication; please pradon my (PHP) ignorance.

Given that nothing has changed in my PHP or HTML code - or environment - save the "upgrade" to PHP5 RC3, what is now missing that wasn't missing before? Has PHP syntax changed, somehow, post v4.3.6?

Would you be so kind as to provide some (generic, code) examples, please?

Post the top part of your code...about 100 lines or so so we can see whats going on.

Which code, please?

global.php

or

index.php {the file I cannot open, successfully}

The file that contains this code you posted above: