[06:35] <mehdi2> apollo13: hi, are you around
[06:35] <mehdi2> ?
[07:02] <mehdi2> apollo13: zed, ping
[08:32] <TSA> Free pat downs for everybody!
[12:59] <mehdi2> apollo13: ping
[12:59] <mehdi2> zed: ping
[13:00] <mehdi2> anybody can help us?
[13:00] <mehdi2> I need some one look into our forum db
[13:00] <apollo13> mehdi2: guess so, so I have no idea what to do…
[13:00] <mehdi2> ...
[13:00] <apollo13> don't do that, how should I know stupid php scripts
[13:00] <apollo13> aside from that your db is fine
[13:01] <mehdi2> apollo13: ok, thanks
[13:01] <mehdi2> did you see the smf_messages table ?
[13:01] <apollo13> I ran optimize on session and user tables though
[13:01] <apollo13> there is one yes
[13:01] <mehdi2> anything there ?
[13:01] <apollo13> 125761 rows
[13:02] <mehdi2> the last rows? anything that can help?
[13:02] <apollo13> no idea, I can'T read iranian?!
[13:03] <mehdi2> can you paste it somewhere for me ?
[13:03] <mehdi2> any errors in db logs ?
[13:03] <apollo13> doubt that, there is sensitive data in there, gimme a email addr
[13:03] <mehdi2> mehdi@ubuntu.com
[13:03] <apollo13> why are you looking in the db for a software problem?
[13:04] <mehdi2> becaz I've seen same page before
[13:04] <mehdi2> and was able to login repaire and fix from db
[13:05] <apollo13> well I see no broken table, at least I don't know if mysql can tell me that without checking every table
[13:05] <mehdi2> no idea
[13:05] <mehdi2> zed could be useful if he had time...
[13:07] <apollo13> well checking all the tables, though I don't think that's the problenm
[13:08] <apollo13> status check on every table is okay
[13:08] <mehdi2> ok, thanks. can I have a dump of our db to test it on a local setup ?
[13:09] <apollo13> just sent you the last ten messages line
[13:09] <apollo13> do you have access to the slave at eshu?
[13:09] <apollo13> anyways I still suggest you check the code first before trying the db…
[13:10] <apollo13> gotta go now, university is waiting
[13:10] <mehdi2> I have access to checkout and yurugu
[13:10] <mehdi2> ok, thanks for help :)
[13:13] <zed> pong mehdi2
[13:13] <mehdi2> zed: hi, sorry we have a strage problem with our forum
[13:14] <mehdi2> I don't know what exactly it is and becaz I'm on a trip I can't connect to servers and check the db
[13:14] <zed> mh ok
[13:14] <mehdi2> we've had it before and you helped resolving it
[13:15] <mehdi2> I don't know maybe something useful in logs or...
[13:15] <zed> and what is the problem ? :)
[13:15] <mehdi2> I says to everybody that your user is blocked
[13:16] <mehdi2> I remember we had same when we blocked the balancer ip adress
[13:16] <mehdi2> and then we had to repair and fix db from inside SMF
[13:16] <mehdi2> but I've not blocked the load balancer ip this time...
[13:23] <zed> well, I can't remember what I did :)
[13:23] <mehdi2> it's great :)
[13:23] <mehdi2> but I'm not sure this is the same issue...
[13:25] <zed> what does the message exactly says on the homepage of the forum ?
[13:26] <mehdi2> it says guest user is not allowed to login
[13:26] <mehdi2> the guest user is disabled
[13:28] <zed> mmh ok
[13:33] <zed> +-------------------+-------+
[13:33] <zed> | variable          | value |
[13:33] <zed> +-------------------+-------+
[13:33] <zed> | allow_guestAccess | 1     |
[13:33] <zed> +-------------------+-------+
[13:33] <zed> too bad :(
[13:34] <mehdi2> is there any administrator user or group ?
[13:35] <mehdi2> smf_members id_group=1
[13:42] <zed> mehdi2: yes there's "Administrator"
[13:49] <mehdi2> what do you think is there any software crash ?
[14:02] <zed> everything else is running smoothly on the servers... :(
[14:08] <mehdi2> zed: sorry is it possible to rollback the db to 19 november ?
[19:35] <mehdi2> zed: can you please run REPAIR TABLE and OPTIMIZE TABLE on our forum tables