Author |
Message |
Doulos
Life Cycles Becoming CPU Cycles
Joined: Jun 06, 2005
Posts: 732
|
Posted:
Sat Dec 18, 2021 7:53 pm |
|
It sounds like he does not, nor will he ever try to fix your old module. |
|
|
|
|
hicuxunicorniobestbuildpc
The Mouse Is Extension Of Arm
Joined: Aug 13, 2009
Posts: 1123
|
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. |
Last edited by hicuxunicorniobestbuildpc on Sat Mar 04, 2023 2:00 pm; edited 1 time in total |
|
|
|
neralex
Site Admin
Joined: Aug 22, 2007
Posts: 1774
|
Posted:
Sat Mar 04, 2023 4:36 am |
|
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 |
|
|
|
hicuxunicorniobestbuildpc
|
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 |
|
|
|
|
neralex
|
Posted:
Sat Mar 04, 2023 2:25 pm |
|
Looks good. Is the title builded correctly in the browser-tab (title)? |
|
|
|
|
hicuxunicorniobestbuildpc
|
Posted:
Sun Mar 05, 2023 5:52 am |
|
Yes it is working properly! |
|
|
|
|
neralex
|
Posted:
Sun Mar 05, 2023 1:42 pm |
|
|
|
|
|