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

Posted: Fri Nov 12, 2021 11:44 am

Hey guys. I am getting lots of errors from mysqli.php

ERRORS

Code:

November 4, 2021, 2:22 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 =2223 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2223 LIMIT 1


 remote addr: 114.119.128.xx


November 4, 2021, 2:26 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 =2490 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2490 LIMIT 1


 remote addr: 157.55.39.xx


November 4, 2021, 2:37 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 =2663 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2663 LIMIT 1


 remote addr: 114.119.128.xx


November 4, 2021, 2:41 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 =2749 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2749 LIMIT 1


 remote addr: 157.55.39.xx


November 4, 2021, 2:48 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 =2084 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2084 LIMIT 1


 remote addr: 114.119.128.xx

It is coming like 1MB from these errors.

Line 201

Code:

$this->backtrace();

Code:

         $error = $this->sql_error();


         if ($this->loglevel > 0) {


            $this->backtrace();


            $logvar = date('F j, Y, g:i a') . ' ' ;


            $logvar .= 'File: '. $this->file . ' - Line: ' . $this->line . "\n";


            $logvar .= 'Code: ' . $error['code'] . ' - Message: ' .  $error['message'] . "\n";


            $logvar .= 'SQL was: ' . preg_replace('/\s+/u', ' ', trim($query)) . "\n";


            $logvar .= ' remote addr: ' . $_SERVER['REMOTE_ADDR'];


            $fplog = fopen(NUKE_BASE_DIR . 'rnlogs/dblog', 'a');


            fwrite($fplog, $logvar . "\n");


            fclose($fplog);


         }


         //return ($transaction == END_TRANSACTION) ? true : false;


         return $this->query_result;

Site Admin Joined: Aug 22, 2007 Posts: 1772

Your pointed code is only the response of the issue, which is reporting the error. You have to identify the source. Check your php-logfile for more details.

Posted: Sat Nov 13, 2021 6:11 am

I just check php error on the server and I am getting these errors.

Code:

[Sat Nov 13 13:09:14 2021] [warn] (22)Invalid argument: - [ Only registered users can see links on this board! Get registered or login! ] - AH02027: Failed to release SSL session cache lock


[Sat Nov 13 13:09:14 2021] [warn] (22)Invalid argument: - [ Only registered users can see links on this board! Get registered or login! ] - AH02026: Failed to acquire SSL session cache lock


[Sat Nov 13 13:04:50 2021] [error] [client 62.149.188.xx:50500] - [ Only registered users can see links on this board! Get registered or login! ] - AH01797: client denied by server configuration: /web/htdocs/www.bestbuildpc.org/home/modules.php


[Sat Nov 13 13:04:50 2021] [error] [client 62.149.188.xx:50500] - [ Only registered users can see links on this board! Get registered or login! ] - AH01797: client denied by server configuration: /web/htdocs/www.bestbuildpc.org/home/ver.php


[Sat Nov 13 13:04:49 2021] [error] [client 62.149.188.xx:50500] - [ Only registered users can see links on this board! Get registered or login! ] - AH01797: client denied by server configuration: /web/htdocs/www.bestbuildpc.org/home/modules.php


[Sat Nov 13 13:04:49 2021] [error] [client 62.149.188.xx:50500] - [ Only registered users can see links on this board! Get registered or login! ] - AH01797: client denied by server configuration: /web/htdocs/www.bestbuildpc.org/home/ver.php

Posted: Sat Nov 13, 2021 12:35 pm

Ok, then you have somewhere a module, block or addon, which is shown in public with a incorrect sql-statement like 'WHERE =2749 LIMIT 1'. The issue is based on a missing free space and fieldname like id. The right way could be 'WHERE id = 2749 LIMIT 1' but I guess the number is generated dynamically. So I would do a full file-backup of your website and search in all files with a editor like notpad++ this phrase without the brackets " LIMIT 1".

Posted: Sat Nov 13, 2021 8:40 pm

I got this from shoutbox block.

Code:

      $sql = "select distinct image from ".$prefix."_shoutbox_emoticons";


      $nameresult1 = $db->sql_query($sql);


      $flag = 1;


      $second = 0;


      while ($return = $db->sql_fetchrow($nameresult1)){


         $sql = 'SELECT * FROM `' . $prefix . '_shoutbox_emoticons` WHERE `image` = \'' . $return[0] . '\' limit 1';


         $nameresult = $db->sql_query($sql);


         while ($emoticons = $db->sql_fetchrow($nameresult)){


            $emoticons[3] = str_replace('>', '', $emoticons['image']);


            $emoticons[3] = str_replace('src=', 'src="', $emoticons[3]);


            $bottom_content .= "<span style=\"cursor: hand;\" onclick=\"DoSmilie(' $emoticons[text] ','$messageDefinition');\">$emoticons[3]\" border=\"0\" alt=\"\" /></span>&nbsp;";


            if ($flag == $conf['smiliesPerRow']) {


               $bottom_content .="<br /><br />\n";


               $flag = 1;


               continue;


            }


            $flag++;


         }


      }


      $bottom_content .= "</div></div></td></tr>\n";





      $bottom_content .= "</table></form>\n";

but I don't think it is this one.

Posted: Sun Nov 14, 2021 4:07 am

Nope, it should typed as LIMIT 1. Your pasted code has lowercase letters.

Posted: Sun Nov 14, 2021 6:13 am

I got this error now.

Code:

November 14, 2021, 1:11 pm


File: /www.bestbuildpc.org/db/mysqli.php - Line: 185


SQL was: SELECT * FROM `nuke_nsnst_ip2country` WHERE (`ip_lo`<="1398095782" AND `ip_hi`>="1398095782") AND `c2c`="01"


querycount = 9

Try to look for the right TYPE SPACE but I can not find it yet. Is there a way to get that specific error without looking into all files? Rolling Eyes

Code:

function updateRegister() {


   global $db, $prefix, $admin_file;


   $date = $_POST['date'];


   $num = $_POST['num'];


   $name = $_POST['name'];


   $descr = $_POST['descr'];


   $amount = $_POST['amount'];


   $id = $_POST['id'];


   $updateRecordSet = 'UPDATE `' . $prefix . '_donations_financial` SET date=\''.$date.'\', num=\''.$num.'\', name=\''.$name.'\',


      descr=\''.$descr.'\', amount=\''.$amount.'\' WHERE id=\''.$id.'\' LIMIT 1';


   $db->sql_query($updateRecordSet);


   $_POST=''; $date=''; $num=''; $name=''; $desc=''; $amount=''; $id='';


   echo '<div class="success">Success! Record updated</div>';


   sleep(3);


   Header('Location: ' . $admin_file . '.php?op=DonationsFinanceRegister');


}





function FinancialRegDel($id){


   global $db, $prefix, $admin_file;


   if(isset($id) && $id>0) {


      $id = intval($id);


      $del_Record = 'DELETE FROM `' . $prefix . '_donations_financial` WHERE `id`=\''.$id.'\' LIMIT 1';


      $db->sql_query($del_Record);


      $id = '';


      Header('Location: ' . $admin_file . '.php?op=DonationsFinanceRegister');


   }


}

Posted: Sun Nov 14, 2021 11:36 am

I noticed there is also fieldname needed. The right way could be 'WHERE id = 2749 LIMIT 1'. You can clear the error-log and then reload single pages, which are shown in public. After each reload check the log again. But I would search through all files...

Posted: Sun Nov 14, 2021 5:01 pm

I get these bunch of errors again!

Code:

  November 14, 2021, 1:41 pm 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 =2248 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2248 LIMIT 1


 remote addr: 207.46.13.xx


November 14, 2021, 1:41 pm 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 =2406 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2406 LIMIT 1


 remote addr: 114.119.128.xx


November 14, 2021, 1:44 pm 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 =2066 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2066 LIMIT 1


 remote addr: 114.119.128.xx


November 14, 2021, 1:45 pm 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 =2332 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2332 LIMIT 1


 remote addr: 54.36.148.xx


November 14, 2021, 1:46 pm 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 =1925 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =1925 LIMIT 1


 remote addr: 207.46.13.xx


November 14, 2021, 1:52 pm 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 =2629 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2629 LIMIT 1


 remote addr: 207.46.13.xx


November 14, 2021, 1:53 pm 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 =2576 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2576 LIMIT 1


 remote addr: 114.119.128.xx


November 14, 2021, 1:55 pm 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 =2218 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2218 LIMIT 1


 remote addr: 207.46.13.31


November 14, 2021, 1:55 pm 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 =2650 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2650 LIMIT 1


 remote addr: 114.119.128.xx


November 14, 2021, 2:05 pm 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 =2255 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2255 LIMIT 1


 remote addr: 207.46.13.xx


November 14, 2021, 2:09 pm 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 =2501 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2501 LIMIT 1


 remote addr: 54.36.149.xx


November 14, 2021, 2:11 pm 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 =2462 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2462 LIMIT 1


 remote addr: 54.36.148.xx


November 14, 2021, 2:12 pm 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 =2 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2 LIMIT 1


 remote addr: 114.119.128.xx


November 14, 2021, 2:18 pm 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 =2596 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2596 LIMIT 1


 remote addr: 207.46.13.xx


November 14, 2021, 2:19 pm 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 =2052 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2052 LIMIT 1


 remote addr: 207.46.13.20


November 14, 2021, 2:19 pm 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 =2014 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =2014 LIMIT 1


 remote addr: 207.46.13.xx


November 14, 2021, 2:19 pm 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 =1880 LIMIT 1' at line 1


SQL was: SELECT * FROM WHERE =1880 LIMIT 1


 remote addr: 185.191.171.xx

I found this line

Code:

$t = $db->sql_query('SELECT * FROM `ca_helpdesk_tickets` WHERE `id` = \'' . $ticket . '\'');

is this correct or should be

Code:

$t = $db->sql_query('SELECT * FROM `ca_helpdesk_tickets` WHERE id = \'' . $ticket . '\'');

??

Posted: Mon Nov 15, 2021 2:51 am

Nope. Search this exact phrase in uppercase letters without the brackets " LIMIT 1".

Posted: Mon Nov 15, 2021 3:43 am

I got this

Code:




function updateRegister() {


   global $db, $prefix, $admin_file;


   $date = $_POST['date'];


   $num = $_POST['num'];


   $name = $_POST['name'];


   $descr = $_POST['descr'];


   $amount = $_POST['amount'];


   $id = $_POST['id'];


   $updateRecordSet = 'UPDATE `' . $prefix . '_donations_financial` SET date=\''.$date.'\', num=\''.$num.'\', name=\''.$name.'\',


      descr=\''.$descr.'\', amount=\''.$amount.'\' WHERE id=\''.$id.'\' LIMIT 1';


   $db->sql_query($updateRecordSet);


   $_POST=''; $date=''; $num=''; $name=''; $desc=''; $amount=''; $id='';


   echo '<div class="success">Success! Record updated</div>';


   sleep(3);


   Header('Location: ' . $admin_file . '.php?op=DonationsFinanceRegister');


}





function FinancialRegDel($id){


   global $db, $prefix, $admin_file;


   if(isset($id) && $id>0) {


      $id = intval($id);


      $del_Record = 'DELETE FROM `' . $prefix . '_donations_financial` WHERE `id`=\''.$id.'\' LIMIT 1';


      $db->sql_query($del_Record);


      $id = '';


      Header('Location: ' . $admin_file . '.php?op=DonationsFinanceRegister');


   }


}

Posted: Mon Nov 15, 2021 7:42 am

Long: This is an admin-file and the functions are only used when you are saving or deleting something. How it can flood your logfile in this case, when only you has access to this module? There is all fine.

Short: nope.

Hint: Do a backup of all files and then use Notepad++ or simular code-editor and search in all files with CTRL+F, which are located in the downloaded web-directory like this...

Posted: Thu Nov 18, 2021 7:09 pm

Code:

  C:\FTP252\includes\classes\class.config.php (4 hits)


   Line 237:                . 'AND ' . $this->config_key . ' = \'' . ($key) . '\' LIMIT 1';


   Line 240:           WHERE  ' . $this->config_key . ' = \'' . ($key) . '\' LIMIT 1';


   Line 349:                WHERE ' . $this->config_key . ' = \'' . $this->sqlValid($setting) . '\' AND  context= \'' . $this->context . '\' LIMIT 1';


   Line 352:                WHERE ' . $this->config_key . ' = \'' . $this->sqlValid($setting) . '\' LIMIT 1';


  C:\FTP252\includes\elfinder\php\elFinder.class.php (1 hit)


   Line 2605:                $cnt = 1200; // Time limit 120 sec


  C:\FTP252\includes\elfinder\php\elFinderVolumeDropbox.class.php (4 hits)


   Line 474:       if ($res = $this->query('select dat from '.$this->DB_TableName.' where path='.$this->DB->quote(strtolower($this->_dirname($path))).' and fname='.$this->DB->quote(strtolower($this->_basename($path))).' limit 1')) {


   Line 515:       if (! $refresh && $chk = $this->query('select dat from '.$this->DB_TableName.' where path=\'\' and fname=\'\' limit 1')) {


   Line 526:          if ($res = $this->query('select dat from '.$this->DB_TableName.' where path=\'\' and fname=\'\' limit 1')) {


   Line 569:                $sql = 'select path from '.$this->DB_TableName.' '.$where.' limit 1';


  C:\FTP252\includes\elfinder\php\elFinderVolumeMySQL.class.php (4 hits)


   Line 712:       $sql = 'UPDATE %s SET parent_id=%d, name=\'%s\' WHERE id=%d LIMIT 1';


   Line 725:       return $this->query(sprintf('DELETE FROM %s WHERE id=%d AND mime!=\'directory\' LIMIT 1', $this->tbf, $path)) && $this->db->affected_rows;


   Line 736:       return $this->query(sprintf('DELETE FROM %s WHERE id=%d AND mime=\'directory\' LIMIT 1', $this->tbf, $path)) && $this->db->affected_rows;


   Line 842:       return $this->query(sprintf('UPDATE %s SET content=\'%s\', size=%d, mtime=%d WHERE id=%d LIMIT 1', $this->tbf, $this->db->real_escape_string($content), strlen($content), time(), $path));


  C:\FTP252\includes\nukeSEO\content\Forums.php (1 hit)


   Line 66:    $res = $db->sql_query('SELECT username FROM '.$user_prefix.'_users WHERE user_id="'.$id.'" LIMIT 1;');


  C:\FTP252\includes\nukeSEO\dh\dh.class.php (2 hits)


   Line 319:          $sql =  'SELECT * FROM '. $this->subcat_table . ' WHERE ' . $this->subcat_id . ' = \'' . $this->getSubCatID() . '\' LIMIT 1';


   Line 332:       $sql =  'SELECT * FROM '. $table . $where . ' LIMIT 1';


  C:\FTP252\includes\nukeSEO\dh\dhForums.php (1 hit)


   Line 40:          $sql =  'SELECT topic_id FROM '. $prefix . '_bbposts WHERE post_id = \'' . $p . '\' LIMIT 1';


Search "LIMIT 1" (0 hits in 0 files of 417 searched)

Posted: Sun Nov 21, 2021 12:18 pm

Go with with browser to the Forums index, clear the error-log and back in the browser reload the index. Then check the error-log again. Do the same procedure with a single Forums post. if you aren't getting any errors, then we can close out the Forums module. Try the same way with the website index and other modules, which are showing in public.

Posted: Mon Nov 22, 2021 3:46 am

I did lots of test yesterday and I found out when i click on the most view gallery block I got the error. I remove error log from the file and I tried several times and the error comes back.

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 . '');


      $numrows_mostviewedblock = $db->sql_numrows($mostviewedblockqry);


         if ($numrows_mostviewedblock > 0) {


         $rngalmostviewed_padding = 4;


         if (!$rngalmostviewed_center) {


            $rngalmostviewed_autoscroll = $rngalconfig->value('mostviewedblock_scroll');


            if ($rngalmostviewed_autoscroll == 1) {


               define('rngalmostviewed_autoscroll', true);


               $rngalmostviewed_autoscroll_width = $rngalglobal->thumbwidth + ($rngalmostviewed_padding*2) + 2;


               $rngalmostviewed_autoscroll_height = $rngalconfig->value('mostviewedblock_scroll_height');


               $rngalmostviewed_autoscroll_speed = $rngalconfig->value('mostviewedblock_scroll_speed');


               if (!defined('rngaltopvotes_autoscroll') && !defined('rngallastimg_autoscroll') && !defined('rngallastcom_autoscroll')) {

I don't think it is the block but I get the error with my own ip. I never got this issue.

Posted: Thu Nov 25, 2021 2:58 pm

As usual I can't reproduce your issue because it is not clear what you have changed. I unarchieved the last backup of my old site media.soefm.de from the year 2018 and there is no sql-query like this in my old Gallery-module as you pointed. So I guess this issue is based on a other 3rd-party block or addon, which isn't working anymore.

Posted: Sun Dec 12, 2021 7:09 pm

I backed it up everything today this is what I got.

Code:

 D:\Recovered\www.bestbuildpc.org\admin\modules\nukesentinel\ABAuthScan.php (1 hit)


   Line 54:       $result = $db->sql_query("DELETE FROM `".$prefix."_nsnst_admins` WHERE `aid`='$a_aid' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\admin\modules\nukesentinel\ABTrackedAgentsIPs.php (1 hit)


   Line 39:     $newrow = $db->sql_fetchrow($db->sql_query("SELECT * FROM `".$prefix."_nsnst_tracked_ips` WHERE `user_agent`='$uname' AND `ip_addr`='$lipaddr' ORDER BY `date` DESC LIMIT 1"));


  D:\Recovered\www.bestbuildpc.org\admin\modules\nukesentinel\ABTrackedRefersIPs.php (1 hit)


   Line 39:     $newrow = $db->sql_fetchrow($db->sql_query("SELECT * FROM `".$prefix."_nsnst_tracked_ips` WHERE `refered_from`='$uname' AND `ip_addr`='$lipaddr' ORDER BY `date` DESC LIMIT 1"));


  D:\Recovered\www.bestbuildpc.org\admin\modules\nukesentinel\ABTrackedUsersIPs.php (1 hit)


   Line 40:     $newrow = $db->sql_fetchrow($db->sql_query("SELECT * FROM `".$prefix."_nsnst_tracked_ips` WHERE `user_id`='$tid' AND `ip_addr`='$lipaddr' ORDER BY `date` DESC LIMIT 1"));


  D:\Recovered\www.bestbuildpc.org\admin\modules\sommaire.php (2 hits)


   Line 1293: $sql="SELECT * FROM ".$prefix."_modules LIMIT 1";


   Line 1298:    $sql2="SELECT * FROM ".$user_prefix."_users LIMIT 1";


  D:\Recovered\www.bestbuildpc.org\admin.php (1 hit)


   Line 395:       list($pollID, $pollTitle) = $db->sql_fetchrow($db->sql_query('SELECT `pollID`, `pollTitle` FROM `' . $prefix . '_poll_desc` WHERE `artid`=0 ORDER BY `pollID` DESC LIMIT 1'), SQL_NUM);


  D:\Recovered\www.bestbuildpc.org\blocks\block-Categories.php (1 hit)


   Line 58:       $numrows = $db->sql_numrows($db->sql_query('SELECT * FROM `' . $prefix . '_stories` WHERE `catid`=' . $catid . ' ' . $querylang . ' LIMIT 1'));


  D:\Recovered\www.bestbuildpc.org\blocks\block-DLShop_Most_Downloaded.php (1 hit)


   Line 19: $row = $db->sql_fetchrow($db->sql_query("SELECT lid FROM ".$prefix."_dlshop_filedls GROUP BY lid ORDER BY count(*) DESC limit 1"));


  D:\Recovered\www.bestbuildpc.org\blocks\block-DLShop_Most_Purchased.php (1 hit)


   Line 19: $row = $db->sql_fetchrow($db->sql_query("SELECT item_nr FROM ".$prefix."_dlshop_purchases GROUP BY item_nr ORDER BY count(*) DESC limit 1"));


  D:\Recovered\www.bestbuildpc.org\blocks\block-DLShop_Newest_Item.php (1 hit)


   Line 19: $result = $db->sql_query("SELECT * FROM ".$prefix."_dlshop_items WHERE new='0' and active='1' ORDER BY dateadded DESC LIMIT 1"));


  D:\Recovered\www.bestbuildpc.org\blocks\block-Shout_Box.php (1 hit)


   Line 687:          $sql = 'SELECT * FROM `' . $prefix . '_shoutbox_emoticons` WHERE `image` = \'' . $return[0] . '\' limit 1';


  D:\Recovered\www.bestbuildpc.org\blocks\block-Sommaire.php (7 hits)


   Line 49: $sql="SELECT t1.invisible, t1.dynamic, t2.main_module FROM ".$prefix."_sommaire AS t1, ".$prefix."_main AS t2 WHERE t1.groupmenu=99 limit 1";


   Line 884:                $sqlimgnew="SELECT date FROM ".$prefix."_nsngd_downloads".$where." order by date desc limit 1";


   Line 898:                $sqlimgnew="SELECT date FROM ".$prefix."_links_links".$where." order by date desc limit 1";


   Line 912:                //$sqlimgnew="SELECT date FROM ".$prefix."_pages".$where." order by date desc limit 1";


   Line 926:                $sqlimgnew="SELECT date FROM ".$prefix."_reviews".$where." order by date desc limit 1";


   Line 940:                $sqlimgnew="SELECT mdate FROM ".$prefix."_journal".$where." order by mdate desc limit 1";


   Line 954:                $sqlimgnew="SELECT time FROM ".$prefix."_stories".$where." order by time desc limit 1";


  D:\Recovered\www.bestbuildpc.org\blocks\block-Survey.php (2 hits)


   Line 36: list($pollID) = $db->sql_fetchrow($db->sql_query('SELECT pollID FROM '.$prefix.'_poll_desc '.$querylang.' ORDER BY pollID DESC LIMIT 1'));


   Line 39:    list($pollID) = $db->sql_fetchrow($db->sql_query('SELECT pollID FROM '.$prefix.'_poll_desc WHERE artid=\'0\' ORDER BY pollID DESC LIMIT 1'));


  D:\Recovered\www.bestbuildpc.org\blocks\block-Survey_Result.php (1 hit)


   Line 9: list($pollID) = $db->sql_fetchrow($db->sql_query('SELECT pollID FROM '.$prefix.'_poll_desc ORDER BY pollID DESC LIMIT 1'));


  D:\Recovered\www.bestbuildpc.org\bugfiles\sommaire.txt (2 hits)


   Line 1286: $sql="SELECT * FROM ".$prefix."_modules LIMIT 1";


   Line 1291:    $sql2="SELECT * FROM ".$user_prefix."_users LIMIT 1";


  D:\Recovered\www.bestbuildpc.org\includes\classes\class.config.php (4 hits)


   Line 238:                . 'AND ' . $this->config_key . ' = \'' . ($key) . '\' LIMIT 1';


   Line 241:           WHERE  ' . $this->config_key . ' = \'' . ($key) . '\' LIMIT 1';


   Line 350:                WHERE ' . $this->config_key . ' = \'' . $this->sqlValid($setting) . '\' AND  context= \'' . $this->context . '\' LIMIT 1';


   Line 353:                WHERE ' . $this->config_key . ' = \'' . $this->sqlValid($setting) . '\' LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\includes\elfinder\php\elFinderVolumeDropbox.class.php (4 hits)


   Line 474:       if ($res = $this->query('select dat from '.$this->DB_TableName.' where path='.$this->DB->quote(strtolower($this->_dirname($path))).' and fname='.$this->DB->quote(strtolower($this->_basename($path))).' limit 1')) {


   Line 515:       if (! $refresh && $chk = $this->query('select dat from '.$this->DB_TableName.' where path=\'\' and fname=\'\' limit 1')) {


   Line 526:          if ($res = $this->query('select dat from '.$this->DB_TableName.' where path=\'\' and fname=\'\' limit 1')) {


   Line 569:                $sql = 'select path from '.$this->DB_TableName.' '.$where.' limit 1';


  D:\Recovered\www.bestbuildpc.org\includes\elfinder\php\elFinderVolumeMySQL.class.php (4 hits)


   Line 712:       $sql = 'UPDATE %s SET parent_id=%d, name=\'%s\' WHERE id=%d LIMIT 1';


   Line 725:       return $this->query(sprintf('DELETE FROM %s WHERE id=%d AND mime!=\'directory\' LIMIT 1', $this->tbf, $path)) && $this->db->affected_rows;


   Line 736:       return $this->query(sprintf('DELETE FROM %s WHERE id=%d AND mime=\'directory\' LIMIT 1', $this->tbf, $path)) && $this->db->affected_rows;


   Line 842:       return $this->query(sprintf('UPDATE %s SET content=\'%s\', size=%d, mtime=%d WHERE id=%d LIMIT 1', $this->tbf, $this->db->real_escape_string($content), strlen($content), time(), $path));


  D:\Recovered\www.bestbuildpc.org\includes\nukeSEO\content\Forums.php (1 hit)


   Line 66:    $res = $db->sql_query('SELECT username FROM '.$user_prefix.'_users WHERE user_id="'.$id.'" LIMIT 1;');


  D:\Recovered\www.bestbuildpc.org\includes\nukeSEO\dh\dh.class.php (2 hits)


   Line 319:          $sql =  'SELECT * FROM '. $this->subcat_table . ' WHERE ' . $this->subcat_id . ' = \'' . $this->getSubCatID() . '\' LIMIT 1';


   Line 332:       $sql =  'SELECT * FROM '. $table . $where . ' LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\includes\nukeSEO\dh\dhForums.php (1 hit)


   Line 40:          $sql =  'SELECT topic_id FROM '. $prefix . '_bbposts WHERE post_id = \'' . $p . '\' LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\control\classes\members.php (3 hits)


   Line 30:   LIMIT 1


   Line 185:   $QB                 = db::db_query("SELECT * FROM ".DB_PREFIX."packages WHERE id = '{$_POST['package']}' LIMIT 1");


   Line 208:        LIMIT 1


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\control\classes\packages.php (1 hit)


   Line 51:        LIMIT 1


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\control\classes\payment.php (5 hits)


   Line 24:   $QB                 = db::db_query("SELECT * FROM ".DB_PREFIX."packages WHERE `id` = '{$_POST['package']}' LIMIT 1");


   Line 27:   $QM                 = db::db_query("SELECT * FROM ".DB_PREFIX."members WHERE `username` = '{$_POST['member']}' LIMIT 1");


   Line 41:        LIMIT 1


   Line 116:        LIMIT 1


   Line 127:        LIMIT 1


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\control\classes\settings.php (10 hits)


   Line 42:   LIMIT 1


   Line 52:   db::db_query("DELETE FROM ".DB_PREFIX."statuses WHERE `id` = '{$_GET['id']}' LIMIT 1");


   Line 83:        LIMIT 1


   Line 212:      LIMIT 1


   Line 225:      LIMIT 1


   Line 248:     db::db_query("DELETE FROM ".DB_PREFIX."boxes WHERE `id` = '{$_GET['id']}' LIMIT 1");


   Line 265:     db::db_query("DELETE FROM ".DB_PREFIX."packages WHERE `id` = '{$_GET['id']}' LIMIT 1");


   Line 272:     db::db_query("DELETE FROM ".DB_PREFIX."members WHERE `id` = '{$_GET['id']}' LIMIT 1");


   Line 280:     db::db_query("DELETE FROM ".DB_PREFIX."members WHERE `id` = '{$_GET['id']}' LIMIT 1");


   Line 297:     db::db_query("DELETE FROM ".DB_PREFIX."payments WHERE `id` = '{$_GET['type']}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\control\system\ajax.php (7 hits)


   Line 229:     $Q        = $DB->db_query("SELECT * FROM ".DB_PREFIX."packages WHERE `id` = '$pID' LIMIT 1");


   Line 251:       $Q        = $DB->db_query("SELECT * FROM ".DB_PREFIX."packages WHERE `id` = '$pID' LIMIT 1");


   Line 260:     $Q2   = $DB->db_query("SELECT * FROM ".DB_PREFIX."boxes WHERE `id` = '{$PACKAGE->lockbox}' LIMIT 1");


   Line 410:       $Q3        = $DB->db_query("SELECT * FROM ".DB_PREFIX."members WHERE `id` = '{$_POST['id'][$i]}' AND `status` IN ('approve','rapprove') LIMIT 1");


   Line 419:         $Q        = $DB->db_query("SELECT * FROM ".DB_PREFIX."packages WHERE `id` = '{$M_INFO->package}' LIMIT 1");


   Line 421:         $Q2       = $DB->db_query("SELECT * FROM ".DB_PREFIX."boxes WHERE `id` = '{$PACKAGE->lockbox}' LIMIT 1");


   Line 659:   $Q2         = $DB->db_query("SELECT * FROM ".DB_PREFIX."boxes WHERE `id` = '{$_GET['id']}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\control\system\box-setup.php (1 hit)


   Line 40: $Q          = $DB->db_query("SELECT * FROM ".DB_PREFIX."boxes WHERE `id` = '{$_GET['id']}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\control\system\eventlog.php (2 hits)


   Line 24:   $Q           = $DB->db_query("SELECT * FROM ".DB_PREFIX."eventlog WHERE `id` = '{$_GET['log']}' LIMIT 1");


   Line 46: $Q       = $DB->db_query("SELECT * FROM ".DB_PREFIX."members WHERE `id` = '{$_GET['id']}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\control\system\gateway.php (1 hit)


   Line 25: $Q   = $DB->db_query("SELECT * FROM ".DB_PREFIX."gateways LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\control\system\mail-member.php (1 hit)


   Line 22: $Q          = $DB->db_query("SELECT * FROM ".DB_PREFIX."members WHERE `id` = '{$_GET['id']}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\templates\new-box.php (1 hit)


   Line 6:   $Q             = $DB->db_query("SELECT * FROM ".DB_PREFIX."boxes WHERE id = '{$_GET['edit']}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\templates\new-member.php (1 hit)


   Line 4:   $Q             = $DB->db_query("SELECT * FROM ".DB_PREFIX."members WHERE id = '{$_GET['edit']}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\templates\new-payment.php (1 hit)


   Line 4:   $Q             = $DB->db_query("SELECT * FROM ".DB_PREFIX."payments WHERE `id` = '{$_GET['edit']}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\admin\templates\new.php (1 hit)


   Line 4:   $Q             = $DB->db_query("SELECT * FROM ".DB_PREFIX."packages WHERE `id` = '{$_GET['edit']}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\control\classes\db.php (1 hit)


   Line 300:        LIMIT 1


  D:\Recovered\www.bestbuildpc.org\lockbox\control\classes\ht.php (3 hits)


   Line 48:     $Q2   = db::db_query("SELECT * FROM ".DB_PREFIX."boxes WHERE `id` = '$bx' LIMIT 1");


   Line 94:     $Q         = db::db_query("SELECT * FROM ".DB_PREFIX."packages WHERE `id` = '$old_package' LIMIT 1");


   Line 97:       $Q2        = db::db_query("SELECT * FROM ".DB_PREFIX."boxes WHERE `id` = '{$PACKAGE->lockbox}' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\control\classes\payments\paypal.php (1 hit)


   Line 65:       LIMIT 1


  D:\Recovered\www.bestbuildpc.org\lockbox\control\classes\payments\two-checkout.php (1 hit)


   Line 46:       LIMIT 1


  D:\Recovered\www.bestbuildpc.org\lockbox\control\classes\processor.php (18 hits)


   Line 23:   LIMIT 1


   Line 62:   LIMIT 1


   Line 71:   LIMIT 1


   Line 82:   LIMIT 1


   Line 91:   LIMIT 1


   Line 99:   LIMIT 1


   Line 168:   LIMIT 1


   Line 230:   LIMIT 1


   Line 257:   LIMIT 1


   Line 272:   LIMIT 1


   Line 307:     $QB  = db::db_query("SELECT * FROM ".DB_PREFIX."members WHERE `id` = '$id' AND `gencode` = '$code' LIMIT 1");


   Line 309:     $QB  = db::db_query("SELECT * FROM ".DB_PREFIX."members WHERE `id` = '$id' LIMIT 1");


   Line 320:   $QB    = db::db_query("SELECT * FROM ".DB_PREFIX."members WHERE `gencode` = '$code' AND `id` = '$id' AND `status` NOT IN ('pay','apay') LIMIT 1");


   Line 338:   $QB   = db::db_query("SELECT * FROM ".DB_PREFIX."statuses WHERE `id` = '{$id}' LIMIT 1");


   Line 345:     $QB   = db::db_query("SELECT * FROM ".DB_PREFIX."members WHERE `username` = '{$auth}' LIMIT 1");


   Line 348:     $QB   = db::db_query("SELECT * FROM ".DB_PREFIX."members WHERE `gencode` = '{$loader}' AND `id` = '$id' LIMIT 1");


   Line 355:   $QB   = db::db_query("SELECT * FROM ".DB_PREFIX."boxes WHERE `id` = '{$box}' LIMIT 1");


   Line 402:   $Q        = db::db_query("SELECT * FROM ".DB_PREFIX."packages WHERE `id` = '$pkg' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\control\controller.php (3 hits)


   Line 102:              LIMIT 1");


   Line 169:              LIMIT 1");


   Line 309:   $Q_K  = $DB->db_query("SELECT * FROM ".DB_PREFIX."packages WHERE `id` = '$ID' AND `enabled` = 'yes' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\lockbox\control\functions.php (1 hit)


   Line 62:     LIMIT 1


  D:\Recovered\www.bestbuildpc.org\lockbox\control\system\password-reset.php (1 hit)


   Line 22:            LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\mainfile.php (1 hit)


   Line 1443:          $result2 = $db->sql_query('SELECT mid, content, date, who FROM ' . $prefix . '_public_messages WHERE mid > ' . $c_mid . ' ORDER BY date ASC LIMIT 1');


  D:\Recovered\www.bestbuildpc.org\modules\Content\admin\index.php (4 hits)


   Line 91:    $row = $db->sql_fetchrow($db->sql_query('SELECT pid, title, counter FROM '.$prefix.'_pages ORDER BY counter DESC LIMIT 1'));


   Line 95:    $row = $db->sql_fetchrow($db->sql_query('SELECT pid, title, counter FROM '.$prefix.'_pages ORDER BY counter ASC LIMIT 1'));


   Line 99:    $row = $db->sql_fetchrow($db->sql_query('SELECT date FROM '.$prefix.'_pages ORDER BY date ASC LIMIT 1'));


   Line 109:    $row = $db->sql_fetchrow($db->sql_query('SELECT date FROM '.$prefix.'_pages ORDER BY date DESC LIMIT 1'));


  D:\Recovered\www.bestbuildpc.org\modules\Content\index.php (3 hits)


   Line 132:       $result = $db->sql_query('SELECT user_id FROM '.$user_prefix.'_users WHERE username=\''.$myuname.'\' LIMIT 1');


   Line 135:          $result = $db->sql_query('SELECT name FROM '.$user_prefix.'_users WHERE username=\''.$myuname.'\' LIMIT 1');


   Line 197:             $result = $db->sql_query('SELECT title FROM '.$prefix.'_pages_categories WHERE cid='.$mycategory.' LIMIT 1');


  D:\Recovered\www.bestbuildpc.org\modules\DLShop\admin\addcat.php (1 hit)


   Line 53:             $row = $db->sql_fetchrow($db->sql_query("SELECT position from ".$prefix."_dlshop_categories where parentid='0' ORDER BY position DESC LIMIT 1"));


  D:\Recovered\www.bestbuildpc.org\modules\DLShop\admin\delfile.php (1 hit)


   Line 29:             $db->sql_query("UPDATE ".$prefix."_dlshop_screens SET main='1' WHERE lid='$lid' LIMIT 1");


  D:\Recovered\www.bestbuildpc.org\modules\DLShop\admin\payments.php (2 hits)


   Line 223: $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_dlshop_purchases ORDER BY payment_date ASC LIMIT 1"));


   Line 225: $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_dlshop_purchases ORDER BY payment_date DESC LIMIT 1"));


  D:\Recovered\www.bestbuildpc.org\modules\DLShop\admin\savecat.php (1 hit)


   Line 21:       $row = $db->sql_fetchrow($db->sql_query("SELECT position from ".$prefix."_dlshop_categories where parentid='0' ORDER BY position DESC LIMIT 1"));


  D:\Recovered\www.bestbuildpc.org\modules\DLShop\public\yourpurchases.php (2 hits)


   Line 38:                      $row3 = $db->sql_fetchrow($db->sql_query("SELECT date FROM ".$prefix."_dlshop_filedls WHERE fid='$fid' and downloader='$uname' ORDER BY date DESC LIMIT 1"));


   Line 80:                   $row3 = $db->sql_fetchrow($db->sql_query("SELECT date FROM ".$prefix."_dlshop_filedls WHERE fid='$fid' and downloader='$uname' ORDER BY date DESC LIMIT 1"));


  D:\Recovered\www.bestbuildpc.org\modules\Donations\admin\private\DonationsErrorLog.php (1 hit)


   Line 87:       $del_Log = 'DELETE FROM `' . $prefix . '_donations_translog` WHERE id=\''.$id.'\' LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\modules\Donations\admin\private\DonationsFinanceRegister.php (2 hits)


   Line 136:       descr=\''.$descr.'\', amount=\''.$amount.'\' WHERE id=\''.$id.'\' LIMIT 1';


   Line 148:       $del_Record = 'DELETE FROM `' . $prefix . '_donations_financial` WHERE id=\''.$id.'\' LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\modules\Donations\admin\private\DonationsTransactions.php (3 hits)


   Line 104:    $query_Recordset1 = 'SELECT `date` AS recdate FROM `' . $prefix . '_donations_financial` WHERE `name` = \'PayPal IPN\' ORDER BY `date` DESC LIMIT 1';


   Line 109:    $query_Recordset1 = 'SELECT `payment_date` AS curdate FROM `' . $prefix . '_donations_transactions` WHERE `payment_status` = \'Completed\' AND ( `txn_type` = \'send_money\' OR `txn_type` = \'web_accept\' ) ORDER BY `payment_date` DESC LIMIT 1';


   Line 143:       $del_trans = 'DELETE FROM `' . $prefix . '_donations_transactions` WHERE id = \'' . $id . '\' LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\modules\Downloads\includes\nsngd_func.php (1 hit)


   Line 415:    $newresult = $db->sql_query('SELECT `date` FROM `' . $prefix . '_nsngd_downloads` WHERE `cid` = ' . $cat . ' ORDER BY `date` DESC LIMIT 1');


  D:\Recovered\www.bestbuildpc.org\modules\Forums\admin\admin_attachments.php (1 hit)


   Line 1359:    $sql = "SELECT * FROM " . QUOTA_LIMITS_TABLE . " WHERE quota_limit_id = " . (int) $quota_id . " LIMIT 1";


  D:\Recovered\www.bestbuildpc.org\modules\Forums\admin\admin_extensions.php (3 hits)


   Line 807:          LIMIT 1';


   Line 856:       LIMIT 1';


   Line 898:       LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\modules\Forums\attach_mod\includes\functions_attach.php (5 hits)


   Line 451:       LIMIT 1";


   Line 484:       LIMIT 1";


   Line 773:       LIMIT 1";


   Line 794:          LIMIT 1';


   Line 866:       LIMIT 1";


  D:\Recovered\www.bestbuildpc.org\modules\Forums\attach_mod\includes\functions_includes.php (2 hits)


   Line 390:          LIMIT 1';


   Line 419:                LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\modules\Forums\attach_mod\posting_attachments.php (4 hits)


   Line 152:                   LIMIT 1';


   Line 178:                LIMIT 1';


   Line 209:                LIMIT 1';


   Line 1110:             LIMIT 1";


  D:\Recovered\www.bestbuildpc.org\modules\Forums\includes\functions.php (1 hit)


   Line 97:         LIMIT 1";


  D:\Recovered\www.bestbuildpc.org\modules\Forums\reputation.php (5 hits)


   Line 120:                ORDER BY r.rep_time DESC LIMIT 1";


   Line 250:                ORDER BY r.rep_time DESC LIMIT 1";


   Line 331:             LIMIT 1";


   Line 344:             LIMIT 1";


   Line 357:             LIMIT 1";


  D:\Recovered\www.bestbuildpc.org\modules\Forums\viewtopic.php (2 hits)


   Line 93:                                         LIMIT 1";


   Line 126:                         LIMIT 1";


  D:\Recovered\www.bestbuildpc.org\modules\GCalendar\admin\index.php (1 hit)


   Line 676:          ' WHERE id = 1 LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\modules\HTML_Newsletter\admin\admin_make_nls.php (1 hit)


   Line 82:    $sql = 'SELECT `count` FROM `' . $prefix . '_counter` WHERE `type` = \'total\' AND `var` = \'hits\' LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\modules\News\admin\post.php (1 hit)


   Line 940:       $row = $db->sql_fetchrow($db->sql_query('SELECT `sid` FROM `' . $prefix . '_stories` ORDER BY `sid` DESC LIMIT 1'));


  D:\Recovered\www.bestbuildpc.org\modules\rwsMetAuthors\index.php (1 hit)


   Line 35:       $sql = 'UPDATE `' . $prefix . '_stories` SET `informant` = \'' . $author . '\', `aid` = \'' . $author . '\' WHERE `sid` = \''. $articleid .'\' LIMIT 1';


  D:\Recovered\www.bestbuildpc.org\modules\Shout_Box\shout.php (1 hit)


   Line 675:          $sql = "SELECT * FROM ".$prefix."_shoutbox_emoticons WHERE image='$return[0]' limit 1";


  D:\Recovered\www.bestbuildpc.org\modules\Surveys\index.php (2 hits)


   Line 48:    $result = $db->sql_query('SELECT pollID, pollTitle, voters FROM ' . $prefix . '_poll_desc where artid=\'0\' order by timeStamp DESC limit 1,5');


   Line 144:    $pollID = $db->sql_fetchrow($db->sql_query('SELECT pollID FROM ' . $prefix . '_poll_desc ' . $querylang . ' ORDER BY pollID DESC LIMIT 1'));


  D:\Recovered\www.bestbuildpc.org\modules\Web_Links\index.php (2 hits)


   Line 884:    $result = $db->sql_query('SELECT `lid`, `url` FROM `' . $prefix . '_links_links` ORDER BY RAND() LIMIT 1');


   Line 1137:    $row = $db->sql_fetchrow($db->sql_query('SELECT date FROM ' . $prefix . '_links_links WHERE cid=\'' . $cat . '\' ORDER BY date desc limit 1'));

Posted: Tue Dec 14, 2021 12:30 am

Something like this could cause it.

Code:

  D:\Recovered\www.bestbuildpc.org\includes\classes\class.config.php (4 hits)


   Line 241:           WHERE  ' . $this->config_key . ' = \'' . ($key) . '\' LIMIT 1';


   Line 353:                WHERE ' . $this->config_key . ' = \'' . $this->sqlValid($setting) . '\' LIMIT 1';

Code:

D:\Recovered\www.bestbuildpc.org\includes\nukeSEO\dh\dh.class.php (2 hits)


   Line 319:          $sql =  'SELECT * FROM '. $this->subcat_table . ' WHERE ' . $this->subcat_id . ' = \'' . $this->getSubCatID() . '\' LIMIT 1';

I don't know which version you are using of the old gallery-module or which changes you made on it but there was an issue in early dev-times with the nukeSEO dhClass. The IDs on your logs are existing in your gallery-database, so I guess it could caused by this module. Try to disable the whole module and also the block-file on your index. Then clear and re-check the logs. If the errors are gone, then we are a bit closer to this issue. Not more touched the old module since many years and I don't patched it for php7 but I could pick it up from a old media-soefm-de-backup.

Posted: Tue Dec 14, 2021 1:28 am

Yes I disable the Gallery module and the error is gone! Why is it happening that?

Posted: Tue Dec 14, 2021 1:31 am

This module was never patched for php7.

Posted: Tue Dec 14, 2021 1:41 am

How can we fix this issue? What is the modification to proceed. Did u made any mod? I need to get a koffie asap. speedtype

Posted: Wed Dec 15, 2021 4:16 am

neralex wrote:

Not more touched the old module since many years and I don't patched it for php7 ...

Posted: Wed Dec 15, 2021 5:53 am

Can u share the fix. I notice we are alone on this road. People do not care anymore I guess. . . Rolling Eyes

Posted: Wed Dec 15, 2021 6:25 am

In repeat: I will fix only issues in the core-package and not more in old modules like this. You are struggeling since many years with your own files without to get an overview where you made changes. Your website is overloaded with old stuff since you started your wild dance here on this forum - long before I patched RN for php7. Calm down and sort your things.

Posted: Sat Dec 18, 2021 5:10 am

Did u have the solution or not?