ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Error regarding pagination - 1064 mysql error

January 14, 2011 8:12am

Subscribe [2]
  • #1 / Jan 14, 2011 8:12am

    NetScouts

    1 posts

    Hello,

    From some time we are encountering strange error.
    When You are going through each page in pagination everything goes fine.

    for example in here:
    http://www.netscoutsbasketball.com/players-coaches/players/P20/

    But if You click on page number 4 then 1064 error is displayed.
    http://www.netscoutsbasketball.com/players-coaches/players/P30/

    What can be the reason?If this would be some kind of template tag problem it would occur somewhere else right? I have checked items from 30 to 40 and there is nothing strange.
    I played with URL and problem occurs from
    http://www.netscoutsbasketball.com/players-coaches/players/P26/
    to
    http://www.netscoutsbasketball.com/players-coaches/players/P35/

    I have checked all of other weblogs and they are working fine. This specific error occurs only on this one particular page for this weblog and only on page number 4.


    Do You have any idea what can be a reason of it? I have even made an upgrade from 1.6.9 to 1.7.0 but problem remains the same.

  • #2 / Jan 14, 2011 8:19am

    NetScouts

    1 posts

    Okay I have found the problem.

    I changed tempalte tag to show only 1 item per page, I clicked through all records and found a bug in one.  Not sure where it came from - because instead of data it was showing serialized data. But after setting status to closed everything got back to normal.

    Now I would try to find a source of an error

  • #3 / Jan 14, 2011 4:26pm

    Sue Crocker

    26054 posts

    Welcome to the ExpressionEngine forums, NetScounts.

    Since you’re new to the EE forums, have you seen EEWiki:// How to Post a Support Request?

    Good troubleshooting. It’s what I would have suggested. 😊 You may want to re-edit the entry and see what’s up with that.

    Does that help?

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases