Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    295
    Plugin Contributions
    2

    Default Install sql patch (bug?)

    zc 1.5.7c
    Server version: 10.3.29-MariaDB - MariaDB Server
    Database client version: libmysql - 5.6.43
    PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
    PHP version: 7.3.28

    If you use a to be depreciated feature in your sql. you are returned a blank screen as if the sql has failed. In the logs you get
    Code:
    [19-May-2021 07:15:15 UTC] PHP Recoverable fatal error: Object of class queryFactoryResult could not be converted to string in /ILSadmin/sqlpatch.php on line 753
    A simple test i used SELECT @mark:=1;

    If you put it into phpmyadmin you get the warning
    Code:
    Warning: #1287 Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: 'SET variable=expression, ...', or 'SELECT expression(s) INTO variables(s)'.
    Don't know if it is a bug but thought I would mention it as I have fallen foul of it in my code.
    Mark Brittain
    http:\\innerlightcrystals.co.uk\sales\

  2. #2
    Join Date
    Jan 2010
    Posts
    36
    Plugin Contributions
    0

    Default Re: Install sql patch (bug?)

    I've noticed that any SQL that produces output when executed will trip this error in ZC 1.5.7c.

    Noting that lines 753-759 of admin/sqlpatch.php in ZC 1.5.8 are commented out, quietly avoiding this error.

 

 

Similar Threads

  1. v139h Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch ????
    By shags38 in forum Customization from the Admin
    Replies: 11
    Last Post: 20 Aug 2012, 04:19 AM
  2. how do install a sql patch?
    By zmtak in forum General Questions
    Replies: 2
    Last Post: 9 Dec 2011, 10:36 AM
  3. how exactly do i install an sql patch?
    By humbll in forum General Questions
    Replies: 3
    Last Post: 26 May 2007, 10:16 AM
  4. How do i install sql patch?
    By humbll in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 26 May 2007, 06:54 AM
  5. install sql patch using phpMyAdmin
    By MeltDown in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 19 Feb 2007, 12:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR