Debug Admin_prune_users.php


Subject: Debug Admin_prune_users.php
Icy Phoenix version 1.1.7.22
Problem my site help pls.

Code: [Download] [Hide] [Select]
Error obtaining userdataS

DEBUG MODE

SQL Error : 1064 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 'S AND user_regdate<"1176246497" ORDER BY username LIMIT 800' at

S

Line : 124
File : admin_prune_users.php

Subject: Re: Debug Admin_prune_users.php
I'm having the same problem.

I've looked in official phpBB support about this mod, and have no 'looks like' errors, like this...

Please. Help?

Thanks and have a nice weekend!

Subject: Re: Debug Admin_prune_users.php
I think there is a bug.

In my opinion, it is needed a dot in php code somewhere.

Profile PM  
Subject: Re: Debug Admin_prune_users.php
Code: [Download] [Hide] [Select]
if(!($result = $db->sql_query('SELECT user_id , username, user_level FROM ' . USERS_TABLE . ' WHERE user_id<>"' . ANONYMOUS . '"' . $sql[$n] . ' AND user_regdate<"' . (time()-(86400 * $days [$n])) . '" ORDER BY username LIMIT 800')))
{
message_die(GENERAL_ERROR, 'Error obtaining userdata'.$sql[$n], '', __LINE__, __FILE__, $sql[$n]);
}


This is the complete line which is getting error. I've deleted part

Code: [Download] [Hide] [Select]
' . $sql[$n] . '


and stopped errors, but... in ACP, when you open link, shows a lot of tables, cloning correct last table a multiple times. And about this error, I didn't find how fix.

Thanks.

Subject: Re: Debug Admin_prune_users.php
mih bonatto, try this:

Code: [Download] [Hide]
  1. if(!($result = $db->sql_query('SELECT user_id , username, user_level FROM ' . USERS_TABLE . ' WHERE user_id<>"' . ANONYMOUS . '"' . $sql[$n] . ' AND user_regdate<"' . (time()-(86400 * $days [$n])) . '" ORDER BY username LIMIT 800')))'
  2. {
  3. message_die(GENERAL_ERROR, 'Error obtaining userdata'.$sql[$n], '', __LINE__, __FILE__, $sql[$n]);
  4. }


It could be a mis-understanding of the sql system...

Profile PM  
Subject: Re: Debug Admin_prune_users.php
novice programmer wrote: [View Post]
mih bonatto, try this:

Code: [Download] [Hide]
  1. if(!($result = $db->sql_query('SELECT user_id , username, user_level FROM ' . USERS_TABLE . ' WHERE user_id<>"' . ANONYMOUS . '"' . $sql[$n] . ' AND user_regdate<"' . (time()-(86400 * $days [$n])) . '" ORDER BY username LIMIT 800')))'
  2. {
  3. message_die(GENERAL_ERROR, 'Error obtaining userdata'.$sql[$n], '', __LINE__, __FILE__, $sql[$n]);
  4. }


It could be a mis-understanding of the sql system...


Thanks for your attention... I've tried your new code, but have another error:
Code: [Download] [Hide] [Select]
Error obtaining userdataS

DEBUG MODE

SQL Error : 1064 Você tem um erro de sintaxe no seu SQL próximo a '"-1"S AND user_regdate<"1177018799" ORDER BY username LIMIT 800' na linha 1

S

Line : 124
File : admin_prune_users.php


And I can't delete this item, 'cause there is no other prune users in the IP system, correctly? I'm getting insane with this bug (and yes, i've posted this in Bug Tracker already).

Thanks anyway =*

PS: there is an image about my IP, when I delete $sql [$n] from line 122.

Last edited by mih bonatto on Sat 15 Dec, 2007 23:07; edited 2 times in total

imagem.JPG
Description:  
Download
Filename: imagem.JPG
Filesize: 188.89 KB
Downloaded: 141 Time(s)


Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.4431s (PHP: 6% SQL: 94%)
SQL queries: 12 - Debug Off - GZIP Enabled