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

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

run.exe

07-07-2004, 04:52 PM

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

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

Modin

07-07-2004, 05:29 PM

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.

run.exe

07-07-2004, 06:28 PM

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?

run.exe

07-08-2004, 02:55 AM

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

Xenon

07-08-2004, 12:29 PM

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 ;)

run.exe

07-08-2004, 03:17 PM

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?

Dark_Wizard

07-08-2004, 03:52 PM

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

run.exe

07-08-2004, 04:16 PM

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}

Dark_Wizard

07-08-2004, 04:29 PM

The file that contains this code you posted above:

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

run.exe

07-08-2004, 04:59 PM

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>TITLE</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="styles/styles.css" rel="stylesheet" type="text/css">
<style type="text/css">

</style>
</head>
<body bgcolor="#333333" text="#CCCCCC" link="#666666" vlink="#999999" alink="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<? if($bbuserinfo['userid'] == 0) { ?>
<table width="100%" height="100%" cellpadding="3" cellspacing="0" border="0">
<tr valign="middle"><td align="center">
<table width="618" height="30" border="0" cellpadding="3" cellspacing="0">
<tr>
<td colspan="2"width="612" height="27" align="center" bgcolor="#F0F0F0"><span class="section">500E OWNER REGISTRY</span></td>
</tr>
<tr bgcolor="#999999">
<td colspan="2" height="1"></td>
</tr>
<tr bgcolor="#FFFFFF">

<table width="618" height="20" border="0" cellpadding="3" cellspacing="0">
<tr bgcolor="#FFFFFF">
<td align="center"><span class="note">NOT LOGGED IN</span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center"><span class="text"><a href="http://path.to.my/forums/">log in</a></span></td>
</tr>
</table>
<tr>
<td colspan="2" align="left"><span class="text"> </span></td>
</tr>
</table>
</td></tr>
</table>
<? } else { // is logged in ?>

<?php

Xenon

07-08-2004, 05:34 PM

change the beginning of your script into:

<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'my_custom_script');

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array();

// pre-cache templates used by specific actions
$actiontemplates = array();
$self_dir = getcwd();
chdir('../');
require_once('global.php');
chdir($self_dir);
?>

maybe that helps :)

run.exe

07-08-2004, 05:39 PM

[(THANK YOU)*10^6]

MY PROBLEM IS 100% FIXED NOW!!!!

You are a PHP GOD and a gentleman!!!

THANK YOU, STEFAN!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Xenon

07-08-2004, 05:40 PM

:)

You're welcome :)