| 01:34.32 | *** join/#debian-bots TiMiDo (~Debian@timido.user) |
| 01:42.11 | *** part/#debian-bots TiMiDo (~Debian@timido.user) |
| 01:44.15 | *** join/#debian-bots TiMiDo (~Debian@timido.user) |
| 04:30.56 | TiMiDo | dondelelcaro, you there? |
| 04:31.04 | dondelelcaro | sort of |
| 04:31.08 | dondelelcaro | wassup? |
| 04:31.19 | TiMiDo | hey listen is this command wrong? gzip -dc apt_dump_052905_080501.gz|grep 'INSERT INTO `factoids`'|sed 's/INSERT/REPLACE/'|mysql -uroot -p blootbot |
| 04:31.29 | TiMiDo | i get this error |
| 04:31.36 | TiMiDo | ERROR 1048 at line 1: Column 'created_time' cannot be null |
| 04:32.02 | dondelelcaro | TiMiDo: oh, you've got a constraint on the table that I don't have |
| 04:32.14 | dondelelcaro | TiMiDo: pull the constraint, then try the insert again |
| 04:33.09 | dondelelcaro | I think I had that constraint originally, but one of the first databases I got didn't have created_time set for every factoid, so I pulled it |
| 04:33.26 | TiMiDo | oh, |
| 04:33.45 | TiMiDo | so what should i do i'm sorry i dind't understood |
| 04:34.10 | dondelelcaro | TiMiDo: just remove the not null constraint on the created_time factoid |
| 04:34.24 | TiMiDo | in all of them? |
| 04:34.52 | dondelelcaro | no, on the table. |
| 04:35.12 | TiMiDo | which table sorry (: |
| 04:35.20 | dondelelcaro | alter table factoids drop constraint not null; or whatever the mysql format is. |
| 04:36.12 | TiMiDo | gzip -dc apt_dump_052905_080501.gz|grep 'INSERT INTO `factoids`'|sed 's/INSERT/REPLACE/'|mysql -uroot -p blootbot |
| 04:36.18 | TiMiDo | so i changed that? |
| 04:36.30 | dondelelcaro | that's fine. You need to change the factoids table itself. |
| 04:37.04 | TiMiDo | oh and how do i changed the factoids that's the problem is there any manual to read about it? |
| 04:40.02 | TiMiDo | just asking (: that's why dondelelcaro |
| 04:40.31 | dondelelcaro | it's in the mysql manual. |
| 04:40.44 | TiMiDo | i need to changed the mysql time? |
| 04:40.49 | TiMiDo | or the factoid table? |
| 04:53.14 | dondelelcaro | the factoid table. |
| 05:00.09 | TiMiDo | oh ok |
| 05:22.00 | TiMiDo | damn i'm reading the manual and i'm so damn lost, =) |
| 05:27.57 | TiMiDo | dondelelcaro, is there another easy way to put the factoids? |
| 09:11.40 | *** join/#debian-bots X7 (~X7@69-174-80-136.chvlva.adelphia.net) |
| 09:11.40 | *** join/#debian-bots Cyber1 (~Cyber1@69-174-80-136.chvlva.adelphia.net) |
| 10:00.53 | *** join/#debian-bots RUFFIAN (~amanee20@220.227.46.36) |
| 10:18.14 | *** join/#debian-bots ChatterBob (~ChatterBo@69-174-80-136.chvlva.adelphia.net) |
| 10:59.25 | *** join/#debian-bots dpkg (~dpkg@dpkg.user) |
| 10:59.34 | cafuego | !find qlist.h |
| 10:59.46 | dpkg | Debian Search of 'qlist.h' (2): (/usr/share/qt3/doc/html/qlist.html) in doc/qt3-doc ;; (/usr/include/qt3/qlist.h) in devel/libqt3-compat-headers. |
| 11:04.27 | cafuego | !info dcplusplus |
| 11:08.26 | *** join/#debian-bots RUFFIAN (~amanee20@220.227.46.36) |
| 11:15.10 | *** part/#debian-bots RUFFIAN (~amanee20@220.227.46.36) |
| 13:20.02 | *** join/#debian-bots Mafalda (~blootbot@201.144.67.125) |
| 14:14.28 | *** join/#debian-bots streuner (foobar@p54A5EF78.dip.t-dialin.net) |
| 14:15.05 | *** part/#debian-bots streuner (foobar@p54A5EF78.dip.t-dialin.net) |
| 17:55.49 | *** join/#debian-bots ChatterBob (~ChatterBo@69-174-80-136.chvlva.adelphia.net) |
| 20:12.49 | *** join/#debian-bots rr72 (~ryno@c-24-15-232-96.hsd1.il.comcast.net) |
| 20:12.54 | rr72 | !lart apt |
| 20:13.10 | rr72 | !lart dpkg |
| 20:13.18 | rr72 | @lart dpkg |
| 20:13.21 | rr72 | ~lart dpkg |
| 20:13.27 | rr72 | *lart dpkg |
| 20:22.00 | rr72 | !ass |
| 20:22.00 | ubotu | I haven't a clue, rr72 |
| 20:22.01 | dpkg | rumour has it, ass is what you're sitting on, the thing that you're riding, possibly the thing you're admiring. |
| 20:22.14 | rr72 | !gg |
| 20:22.14 | ubotu | rr72: I don't know, could you explain it? |
| 20:22.15 | dpkg | somebody said gg was good game |
| 20:22.23 | rr72 | !g on g |
| 20:22.23 | ubotu | rr72: Wish i knew |
| 20:22.30 | rr72 | !gong |
| 20:22.30 | ubotu | rr72: Bugger all, i dunno |
| 20:22.47 | rr72 | !xmms |
| 20:22.48 | ubotu | rr72: No idea |
| 20:22.48 | dpkg | methinks xmms is X MultiMedia System. Obtain it from http://www.xmms.org/, or screwed up because it renices to -3 automatically on debian woody, and you can't de-automate it. |
| 20:22.58 | rr72 | !tell apt about xmms |
| 20:23.21 | rr72 | !tell bob2 about ass |
| 20:24.08 | rr72 | !tell bob2 about ass |
| 20:33.34 | rr72 | l8ra sses |
| 20:33.36 | *** part/#debian-bots rr72 (~ryno@c-24-15-232-96.hsd1.il.comcast.net) |