 | [Solved] problem with Hide Zero Posters hack |  |
 Posted: 05/25/2007 3:08 PM |
 |
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 6:15 AM
Location: Birmingham, UK.
|
|
|
|
|
 |
| Code:
|
SQL ERROR
SQL PROCESSING HALTED
An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.
The failed line was:
UPDATE phpbb_users AS u,phpbb_posts AS p1 LEFT OUTER JOIN phpbb_posts AS p2 ON p1.poster_id = p2.poster_id AND p2.post_time < p1.post_time INNER JOIN phpbb_posts AS p3 ON p3.post_time = p1.post_time SET u.user_firstpost=p3.post_time WHERE p2.post_time IS NULL AND p1.poster_id = u.user_id;;
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 '; p1.post_time INNER JOIN phpbb_posts AS p3 ON p3.post_time = p1.post_time SET u' at line 1
|
http://www.phpbbhacks.com/download/1570
any ideas please??  |
|
|
|
|
| Back to Top |
|
|
| Re: problem with Hide Zero Posters hack | |
| Posted: 05/25/2007 3:53 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:15 AM
Location: St Pete, FL
|
|
|
|
|
|
It looks like your text editor may have converted < to < in the SQL query. I have the same version of this MOD and it doesn't contain this error. So do this:
OPEN
zero_users/install.txt
FIND
| Code:
|
|
p2.post_time < p1.post_time
|
REPLACE WITH
| Code:
|
|
p2.post_time < p1.post_time
|
Save, upload, and try again using EM...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with Hide Zero Posters hack | |
| Posted: 05/25/2007 4:13 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 6:15 AM
Location: Birmingham, UK.
|
|
|
|
|
|
| Hmm, that's how it was already. I tried again though and come it up with a different error this time, with it just going about a duplicate error but as these aren't a problem I just processed the rest and it was fine |
|
|
|
|
| Back to Top |
|
|
| Re: problem with Hide Zero Posters hack | |
| Posted: 05/25/2007 4:49 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:15 AM
Location: St Pete, FL
|
|
|
|
|
|
Ok, that's strange. I can't even begin to guess what might have happened then. Luckily it seems to be a non-issue now...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with Hide Zero Posters hack | |
| Posted: 05/25/2007 4:57 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 6:15 AM
Location: Birmingham, UK.
|
|
|
|
|
|
yea everything seems ok ty  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with Hide Zero Posters hack | |
| Posted: 05/25/2007 5:02 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 6:15 AM
Location: Birmingham, UK.
|
|
|
|
|
|
| o hang on the settings in ACP don't seem to be doing anything... |
|
|
|
|
| Back to Top |
|
|
| Re: problem with Hide Zero Posters hack | |
| Posted: 05/25/2007 5:16 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:15 AM
Location: St Pete, FL
|
|
|
|
|
|
Try it now. Not all the SQL queries were successfully applied to your database. It's fixed now...
 |
|
|
|
|
| Back to Top |
|
|
| Re: problem with Hide Zero Posters hack | |
| Posted: 05/25/2007 7:27 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 6:15 AM
Location: Birmingham, UK.
|
|
|
|
|
|
I see they switch over in ACP now but I still don't think all 4 settings are working correctly, well the memberlist one works but the other 3 don't seem to be doing anything eg I can’t enable/disable the newest user setting for one...
Can’t try the group one just yet… I’d like the newest user one to work though as I’m not sure how to have that set at the moment
Can you take another look for me please NR? |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with Hide Zero Posters hack | |
| Posted: 05/25/2007 9:03 PM |
|
|
|
|
|
| Citation |
| Posts |
940 |
| Word Cnt. |
48,215 |
| BDay |
Mar 4 |
| Sign |
Pisces |
| Sex |
 |
|
|
|
Joined: Mar 20, 2006
Local time: 12:15 AM
|
|
|
|
|
|
There is settings in the ACP?
Wondering if this is the same one I just installed. zero_users-4563.zip?
I had a bot to sign up on my hobbies board didn't post so didn't show up on the memberlist but did show up in stastics as newest member. |
|
|
|
|
| Back to Top |
|
|
| Re: problem with Hide Zero Posters hack | |
| Posted: 05/26/2007 1:24 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:15 AM
Location: St Pete, FL
|
|
|
|
|
|
This is what I selected and everything seems to be working:
With these settings, there is only one person listed in the Memberlist and one person listed as the last to register on the Index page with only 1 regisered user:
With all settings disabled:
There are 8 registered members with the newest member being sinderel...
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
