|
Page 1 of 1
|
 ALTUN 
Muhammet Altun
Joined: November 2007
Posts: 15
Location:  Strasbourg
|
 Debug Admin_prune_users.php
Icy Phoenix version 1.1.7.22
Problem my site help pls.
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
|
#1 Fri 07 Dec, 2007 00:15 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
mih bonatto 
Joined: September 2006
Posts: 55
Location:  CascaHell - Parana
|
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!
|
#2 Fri 14 Dec, 2007 20:48 |
|
novice programmer
Joined: June 2007
Posts: 1030
Location: 
|
Re: Debug Admin_prune_users.php
I think there is a bug.
In my opinion, it is needed a dot in php code somewhere.
|
#3 Sat 15 Dec, 2007 13:10 |
|
mih bonatto
Joined: September 2006
Posts: 55
Location: CascaHell - Parana
|
Re: Debug Admin_prune_users.php
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
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.
|
#4 Sat 15 Dec, 2007 19:13 |
|
novice programmer
Joined: June 2007
Posts: 1030
Location:
|
Re: Debug Admin_prune_users.php
mih bonatto, try this:
-
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]);
-
}
It could be a mis-understanding of the sql system...
|
#5 Sat 15 Dec, 2007 20:57 |
|
mih bonatto
Joined: September 2006
Posts: 55
Location: CascaHell - Parana
|
Re: Debug Admin_prune_users.php
mih bonatto, try this:
-
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]);
-
}
It could be a mis-understanding of the sql system...
Thanks for your attention... I've tried your new code, but have another error:
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.
|
| Description: |
|
Download |
| Filename: |
imagem.JPG |
| Filesize: |
188.89 KB |
| Downloaded: |
132 Time(s) |
Last edited by mih bonatto on Sat 15 Dec, 2007 23:07; edited 2 times in total |
#6 Sat 15 Dec, 2007 22:44 |
|
|
|
Page 1 of 1
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
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
|
|
|
|
