Announcement

Collapse
No announcement yet.

SQL Statement for vb2.3.3

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Statement for vb2.3.3

    Hey, just looking for a SQL statemnt for vb 2.3.3 to erase users that havent posted in 60 days, cant do via admin CP coz the db is WAAAAAAY too big.

    Can anyone help me ?

    Thanks in advance!
    Sbastian M Juerges
    =======
    :cool: NoVa :cool:
    =======

  • #2
    Hi there, how big is your database and how many users does your forum count?
    Admin Control Panel > Users > Prune .. should be able to remove users based on conditions like postcount or inactivity. Does it return an error, and if so, which?

    Comment


    • #3
      Just gets a php timeout.

      Members: 89,373
      Threads: 106,027
      Posts: 804,926
      =======
      :cool: NoVa :cool:
      =======

      Comment


      • #4
        Thank you.

        I will point this out to one of the developers and see what their comment is on this.

        Comment


        • #5
          Thanks alot, much appreciated.
          =======
          :cool: NoVa :cool:
          =======

          Comment


          • #6
            You can increase the PHP timeout setting, or prune in smaller batches. Where batches would be the amount days inactive. 500 days , 400 days ..

            Comment


            • #7
              Yeah, but mysql console would be alot faster ...
              =======
              :cool: NoVa :cool:
              =======

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X