php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #10526 Possible problem with query
Submitted: 2001-04-27 11:37 UTC Modified: 2001-04-30 13:26 UTC
From: mgrigajtis at rosasonline dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.4pl1 OS: Linux 2.4.3
Private report: No CVE-ID: None
 [2001-04-27 11:37 UTC] mgrigajtis at rosasonline dot com
     Okay, I think I found a bug so please don't chew my 
head off if I'm wrong.
     I have written a short script to convert an excel 
spreadsheet into MySQL.  Text format of course.
     I try to create a table using these lines:

$query = "CREATE TABLE test3 (Sales_Number varchar(255), 
Sales_Name varchar(255), Location varchar(255), Amount 
varchar(255))";
$result = mysql_query ($query);

     It creates the table, but it stops the script with 
this error message:

Query was empty

     I have never seen this error message before, and I 
don't think the query is empty because it does create the 
table...

     If you want me to email you the script for further 
analysis, please let me know.

Matthew Grigajtis
  

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-29 22:23 UTC] cardinal@php.net
I can't locate any error message in PHP that says "Query was empty".  Is it an error being displayed by your script, or one that your script calls upon?

This can probably be closed.
 [2001-04-30 13:26 UTC] cardinal@php.net
User feedback:

Well, I'm not sure where the error message is comming from.  It is an error being generated by either PHP or MySQL.  I have figured out a way around the error, so it can be closed - but I never figured out what was causing the error.  It is definately something that should be looked into because someone else may have more problems in the future.                              

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Apr 19 04:01:28 2024 UTC