phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Please help! [Major AP problem.]


 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
Acaria
Board Member



Joined: 20 Feb 2009

Posts: 238



PostPosted: Fri Feb 20, 2009 7:49 am 
Post subject: Please help! [Major AP problem.]

I just installed ADR on my forum, and now I'm getting an error in the Admin panel.

Screenshot.

I've looked at the code, and there's no comma in the 660th line. D:

I don't know what to do. I've attached a copy of the entire file.

Please help. D:



file code.txt
 Description:
Here's the full file.

Download
 Filename:  file code.txt
 Filesize:  47.6 KB
 Downloaded:  414 Time(s)

Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Fri Feb 20, 2009 8:08 am 
Post subject: Re: Please help! [Major AP problem.]

There are VERY MANY commas in line 660!
Code:
            SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank", user_adr_ban = $user_adr_ban . $avatar_sql . "


Could you please upload your UNMODDED file admin_users.php?
And the code-instructions for admin_users.php
Back to top
Acaria
Board Member



Joined: 20 Feb 2009

Posts: 238



PostPosted: Fri Feb 20, 2009 8:23 am 
Post subject: Re: Please help! [Major AP problem.]

D:

The stupid line finder thing was directing me to the wrong line. XD


Yeah, let me pull it out of my backup zip file.


It's attached, but it has a bunch of little boxes everywhere. >.<

The only difference between the two is at the very end, where the , user_adr_ban = $user_adr_ban was added to mod this file.



admin_users.txt
 Description:
This is it, but something's making those funky boxes appear.

Download
 Filename:  admin_users.txt
 Filesize:  45.57 KB
 Downloaded:  752 Time(s)

Back to top
Acaria
Board Member



Joined: 20 Feb 2009

Posts: 238



PostPosted: Fri Feb 20, 2009 8:26 am 
Post subject: Re: Please help! [Major AP problem.]

Hmm... Deleting that one little part of the code eliminated the problem, but I can still preform the ADR ban.

Very odd...
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Fri Feb 20, 2009 8:31 am 
Post subject: Re: Please help! [Major AP problem.]

Find
Quote:
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank", user_adr_ban = $user_adr_ban . $avatar_sql . "

Replace with
Quote:
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank, user_adr_ban = $user_adr_ban" . $avatar_sql . "


Try http://www.textpad.com
Back to top
Salvatos
Board Member



Joined: 19 Feb 2009

Posts: 416
Location: Québec


flag
PostPosted: Fri Feb 20, 2009 8:23 pm 
Post subject: Re: Please help! [Major AP problem.]

Holger, shouldn't your replace be this instead (check last line):
Code:
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank, user_adr_ban = $user_adr_ban . $avatar_sql . "

Or, in short, I doubt there should be a double quote between $user_adr_ban and $avatar_sql.
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Sat Feb 21, 2009 2:01 am 
Post subject: Re: Please help! [Major AP problem.]

I don't mean to be master of the obvious,.. but have you checked line 660 of your admin_users.php? The very kind error seams to be pointing itself out to you. I will be the first one to admit I am no genius at php but err... have you looked there?

To me this error seams to mean on line 660 there is an extra comma that is not supposed to be there. I could be wrong but that is where I would start.

I mean how many commas can there be on line 660? remove them one at a time and put them back if there is no effect and so the next one.. Its probably just a cut and paste error when installing the mod.

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
Acaria
Board Member



Joined: 20 Feb 2009

Posts: 238



PostPosted: Sat Feb 21, 2009 4:02 am 
Post subject: Re: Please help! [Major AP problem.]

[Cowboy]

That'd be a... monotonous process. >.>

There are so many commas there, and I don't think it was actually that which was causing the problem.

Plus, my program was directing me to a line that apparently wasn't line 660, so I was totally confused. XD


[Everyone else]

I fixed it. :3

It was what Salvatos was talking about. Once I removed that quote it started working again. icon_biggrin.gif

Thank you so much for the help. <3
Back to top
Salvatos
Board Member



Joined: 19 Feb 2009

Posts: 416
Location: Québec


flag
PostPosted: Sat Feb 21, 2009 4:04 am 
Post subject: Re: Please help! [Major AP problem.]

My pleasure, always glad to help with the little I know icon_smile.gif
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Sun Feb 22, 2009 2:31 pm 
Post subject: Re: Please help! [Major AP problem.]

Great Salvatos! icon_biggrin.gif

It was this part I reacted on:
Code:
user_rank = $user_rank",
Back to top
Salvatos
Board Member



Joined: 19 Feb 2009

Posts: 416
Location: Québec


flag
PostPosted: Sun Feb 22, 2009 7:52 pm 
Post subject: Re: Please help! [Major AP problem.]

Yea, it was just a matter of removing it instead of moving it icon_wink.gif
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0174 seconds using 17 queries. (SQL 0.0031 Parse 0.0026 Other 0.0117)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo