Code: 1064 - Message: You have an error in your SQL syntax

Posted: Sat Dec 18, 2021 7:53 pm

It sounds like he does not, nor will he ever try to fix your old module.

Posted: Fri Mar 03, 2023 3:28 am

morning neralex, I checked today every single code from the gallery module and this error should come from the database. When I click on the pictures from the block then I get the errors but inside the menu from the gallery I do not get any error. My question is. Can u send me the old files u have in your old website so I can compare?

I tested all the blocks and when I click on any photo then I reproduce the error but inside it does not show any error. I checked for any space mistake and I couldn't find any. I really wanna know when this error is coming from.

from here there should be something maybe. Please let me know. U made a very clean module and I would like to find this error.

Code:

March 3, 2023, 10:18 am File: /www.bestbuildpc.org/db/mysqli.php - Line: 201


Code: 1064 - Message: 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 'WHERE =2777 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2777 LIMIT 1

This is a line code from one the block.

Code:

      $mostviewedblockqry = $db->sql_query('SELECT `id`, `file`, `filethumb`, `filepath`, `title`, `desc`, `user`, `counter`, `savetime` FROM `' . $prefix . '_rngal` WHERE `approved` = 1 AND `file` != \'\' AND `filepath` != \'\' ORDER BY `counter` DESC LIMIT ' . $mostviewedblock_limit . '');

Is there a better way to get details from where erros are coming. Please let me know.

Site Admin Joined: Aug 22, 2007 Posts: 1774

This is not the correct query:

Code:

      $mostviewedblockqry = $db->sql_query('SELECT `id`, `file`, `filethumb`, `filepath`, `title`, `desc`, `user`, `counter`, `savetime` FROM `' . $prefix . '_rngal` WHERE `approved` = 1 AND `file` != \'\' AND `filepath` != \'\' ORDER BY `counter` DESC LIMIT ' . $mostviewedblock_limit . '');

...for this error:

Code:

March 3, 2023, 10:18 am File: /www.bestbuildpc.org/db/mysqli.php - Line: 201


Code: 1064 - Message: 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 'WHERE =2777 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2777 LIMIT 1

This is the not working query because there is no table-name inside the query:

Code:

SQL was: SELECT * FROM WHERE =2777 LIMIT 1

I sent you an download-link to the version 1.3 from 2018 via PM. Its untouched and not patched for php7. Do a backup of all affected files of the package inside your installation and overwrite at first the module- and block-files. Then overwrite the nukeSEO dh-file of the package. When the error is gone, then say "YEAH" and if not let me know, which block-files of the gallery you are using and post the target-link after you clicked on the image.

Posted: Sat Mar 04, 2023 1:52 pm

YEAH I solved the problem. Thanks a lot!

The only error I am getting is by line 9 in file dhGallery.php includes/nukeSEO/dh/

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP

Code:

class dhGallery extends dhclass {


   function dhGallery () {


      global $prefix;


      $this->content_id        = 'id';


      $this->content_table     = $prefix . '_rngal';


      $this->contentTitleArray = array('title');


      $this->contentDescArray  = array('desc');


      $this->contentKeysArray  = array('title','desc');


      $this->cat_id            = 'id';


      $this->cat_table         = $prefix . '_rngal_cat';


      $this->catTitleArray     = array('title');


      $this->catDescArray      = array('desc');


      $this->catKeysArray      = array('title','desc');


      $this->subcat_id         = 'id';


      $this->subcat_table      = $prefix . '_rngal_album';


      $this->subcatTitleArray  = array('title');


      $this->subcatDescArray   = array('desc');


      $this->subcatKeysArray   = array('title', 'desc');


      // If pending content is stored in the same table, inactive content, private content, etc.


      $this->activeWhere       = '';


   }

I wonder if I can replace this function for this one.

Code:

class dhGallery extends dhclass {


function __construct() {


      global $prefix;


      $this->content_id        = 'id';


      $this->content_table     = $prefix . '_rngal';


      $this->contentTitleArray = array('title');


      $this->contentDescArray  = array('desc');


      $this->contentKeysArray  = array('title','desc');


      $this->cat_id            = 'id';


      $this->cat_table         = $prefix . '_rngal_cat';


      $this->catTitleArray     = array('title');


      $this->catDescArray      = array('desc');


      $this->catKeysArray      = array('title','desc');


      $this->subcat_id         = 'id';


      $this->subcat_table      = $prefix . '_rngal_album';


      $this->subcatTitleArray  = array('title');


      $this->subcatDescArray   = array('desc');


      $this->subcatKeysArray   = array('title', 'desc');


      // If pending content is stored in the same table, inactive content, private content, etc.


      $this->activeWhere       = '';


   }

The error is gone but u can let me know if that is the right step to do. Vielen Dank

Posted: Sat Mar 04, 2023 2:25 pm

Looks good. Is the title builded correctly in the browser-tab (title)?

Posted: Sun Mar 05, 2023 5:52 am

Yes it is working properly!

Posted: Sun Mar 05, 2023 1:42 pm

Finally solved.