Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x
Author Message
Doulos
Life Cycles Becoming CPU Cycles



Joined: Jun 06, 2005
Posts: 732

PostPosted: Sat Dec 18, 2021 7:53 pm Reply with quote

It sounds like he does not, nor will he ever try to fix your old module.
 
View user's profile Send private message
hicuxunicorniobestbuildpc
The Mouse Is Extension Of Arm



Joined: Aug 13, 2009
Posts: 1123

PostPosted: Fri Mar 03, 2023 3:28 am Reply with quote

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.


Last edited by hicuxunicorniobestbuildpc on Sat Mar 04, 2023 2:00 pm; edited 1 time in total 
View user's profile Send private message
neralex
Site Admin



Joined: Aug 22, 2007
Posts: 1774

PostPosted: Sat Mar 04, 2023 4:36 am Reply with quote

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.

_________________
Github: RavenNuke 
View user's profile Send private message
hicuxunicorniobestbuildpc







PostPosted: Sat Mar 04, 2023 1:52 pm Reply with quote

Cheers 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
 
neralex







PostPosted: Sat Mar 04, 2023 2:25 pm Reply with quote

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







PostPosted: Sun Mar 05, 2023 5:52 am Reply with quote

Yes it is working properly!
 
neralex







PostPosted: Sun Mar 05, 2023 1:42 pm Reply with quote

Finally solved.
 
Display posts from previous:       
Post new topic   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©