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