php - Cannot execute queries while other unbuffered queries are active -

-

OK, so I used this website (amateur using PHP 5.4 (working 100%) using a local test server Manner) developed on Remote Host, I have encountered non-stop problems, possibly due to differences in all PHP versions. The remote server uses PHP 5.1 On this page, a value is passed from the previous page and this value is used to fill out a form.

I have detected this problem with trial and error, but he does not know what is happening due to this and what has been read so far there are at least 30 relevant SE questions. Immediate execution on the code generated statement on this page stops. I can not find any type of error message.

I know that the $ link connection is open because I have a query that works perfectly. 

  if (('POST' === $ _SERVER ['REQUEST_METHOD']) & amp; (isset ($ _ POST ['Description'])) {$ sql = 'From Select * where it is that: = ';'; per second $ sql; $$ query = $ link-> added for testing ($ sql); resonance "it never shows"; // Verified problem area $ query- & gt; Bind value (':', $ _POST ['description']); $ query-> executed (); $ line = $ query- & gt; bring (); // More things}

All help was appreciated!

Edit: Do not take proper care, error:

can not do Other unrestricted queries are active, while executing queries. Consider using PDOStatement :: fetchAll (). Alternatively, if your code is only running against mysql, then you can query the PDO :: MYSQL_ATTR_USE_BUFFERED_QUERY query by setting the The buffering can be enabled

A very uncomfortable error that goes away when I comment on the previous query. This is strange because the preceding query is on many pages and without problem. In addition, it only gives one result, so I'm not sure what this error really is. Here's the preceding query: 

  $ sql = 'Choose bgcolor from the setting' id = userid on the Inner Inner User Username = Username '; $ Query = $ link & gt; Ready ($ SQL); $ Query-> Bind value (': user', $ _SESSION ['username']); $ Query-> Executed (); $ Line = $ query- & gt; Bring (); $ Rgb = str_split ($ line ['bgcolor'], 3);

It runs on every page (because I'm new and inefficient and does not save session and cookies) and works fine before this. It only gives a result.

I did not have the $ query-> Closed cursor (I); , As mentioned in some linked SE queries, for each selected query executed on this page to reach the workplace position

It is less than ideal and I want to be a real cause and solution of this problem Unfortunately I do not have Server Config Access to check other solutions.

This has worked, but some comments show that it does not work for them: 

  $ Link-> Set Attribution (PDO: MYSQL_ATTR_USE_BUFFERED_QUERY, true);

Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

java - Gradle dependencies: compile project by relative path -

-
Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
Read more

ruby on rails - Object doesn't support #inspect when used with .include -

-
So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
Read more