critical error

Started by ɔɔɔɔɔɔuɥoɾ, July 28, 2009, 01:21:17 PM

Previous topic - Next topic

ɔɔɔɔɔɔuɥoɾ

Quotehttp://www.requestiso.com/index.php?action=search2
Wrong value type sent to the database. Integer expected. (timestamp_maximum_age)
Function: plushsearch2
File: /home/reque4/public_html/Sources/Search.php
                              Line: 396                            

I have no idea whats causing this, and how bad this error is and what security vulnerabilities it can cause. All I can see here is maybe it has something to do with searching, but I dont know, can anybody help me with this issue.

Thanks in Advanced.


SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

tyty1234

Have you recently installed any mods?
My Activity: Inactive
My Links: tyty1234's SMF Site | SMF Package Parser | SMF Helper | My Mods [5]
Subscribe to my SMF blog for updates
PMs for support will not be accepted, unless requested otherwise.

ɔɔɔɔɔɔuɥoɾ

Recently Installed Link checker mod from M-DVD, but its disabled at the moment, and that post has no checkable links in it, so I have ruled that out, its only happening on the "WAP" pages though, its all I can notice that may help figure this problem out


SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

tyty1234

Can you please attach your Search.php file?
My Activity: Inactive
My Links: tyty1234's SMF Site | SMF Package Parser | SMF Helper | My Mods [5]
Subscribe to my SMF blog for updates
PMs for support will not be accepted, unless requested otherwise.

ɔɔɔɔɔɔuɥoɾ

here is my search.php file from Sources directory.


SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

tyty1234

Honestly, there is nothing wrong with that error. It seems to be right, but I can't debug where it's coming from either... :(
My Activity: Inactive
My Links: tyty1234's SMF Site | SMF Package Parser | SMF Helper | My Mods [5]
Subscribe to my SMF blog for updates
PMs for support will not be accepted, unless requested otherwise.

ɔɔɔɔɔɔuɥoɾ

#6
Well, I guess it must be something else, Case open for some experts...

EDIT:
This is another error (database error) also currectly in support (mod). Maybe it can help.

Quote
http://www.requestiso.com/index.php?topic=663.10;wap2

Database Error: 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 ')
AND b.contributionsEnable
GROUP BY t.id_member_started' at line 5

File: /home/reque4/public_html/Sources/Display.php
Line: 1030

(currently in support for contributions mod as it seems like the culprit.)
http://www.simplemachines.org/community/index.php?topic=286299.msg2181079#msg2181079



SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

Sarge


Database Error: 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 ')
AND b.contributionsEnable
GROUP BY t.id_member_started' at line 5


What this means is that the query has a problem before the shown lines. Can you attach Display.php too?

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Sarge

#8
Quote from: johncccccc on July 28, 2009, 01:21:17 PM
Quotehttp://www.requestiso.com/index.php?action=search2
Wrong value type sent to the database. Integer expected. (timestamp_maximum_age)
Function: plushsearch2
File: /home/reque4/public_html/Sources/Search.php
                              Line: 396                            

I have no idea whats causing this, and how bad this error is and what security vulnerabilities it can cause. All I can see here is maybe it has something to do with searching, but I dont know, can anybody help me with this issue.

Thanks in Advanced.

This can happen when the maximum message age in the search page is a very large value higher than 9999 (four nines). I replicated the issue when I tried with 99999 (five nines):



What is the default value for the max age in the search page of your forum?

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Sarge

Reported to the SMF bugtracker: [3650] Maximum message age is not properly checked when searching

I proposed a solution in the report. Try it and let us know. :)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

ɔɔɔɔɔɔuɥoɾ

#10
attachments:

Display.PHP
Search.PHP

from SOURCES DIR.

Im still reading the above message and looking into the solution posted, there are the files :)


EDIT:
Im looking for the"Message Age" option, I dont see it, where is it?

Thanks in Advanced :D

EDIT 2:
tried solution, cleaned error log, lets wait and see :D


SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

Sarge

Let us know how it goes. :)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

ɔɔɔɔɔɔuɥoɾ

Got a Critical Error in Log:


hxxp://www.requestiso.com/index.php?action=search2
Wrong value type sent to the database. Integer expected. (timestamp_maximum_age)
Function: plushsearch2
File: /home/reque4/public_html/Sources/Search.php
Line: 396



This error occurred by the same user twice
SMF 2.0 RC1.2 SteelV theme (currently not in theme site).

Thanks in Advanced


SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

Kill Em All

I merged both your topics, please do not create multiple topics regarding the same issue.

Have you tried the above solutions? I also suggesting upgrading SMF to RC2 as that is currently the latest one.


My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

ɔɔɔɔɔɔuɥoɾ

#14
Oh yes, I forgot about that, its been so long... sorry...

Anyway, I have not changed any of the files nor installed any mods since then, So, yes all above suggestions have been tried from the last time.

Any ideas on something thats not actually critical that can cause this error, like a search term that was used maybe, or possibly something else similar ???


EDIT:

I just re-checked my search.php file and the error fix was not applied, I had changed it before, well I have changed it again, lets see what happens :)

Quote
Proposed solution:

Search.php, line 370:
    if (!empty($search_params['maxage']) || (!empty($_REQUEST['maxage']) && $_REQUEST['maxage'] != 9999))

Replace != 9999 with < 9999.


SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

Advertisement: