#mysql
16 October 2007
Total 19 pages. You are browsing page 3/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
03:44 <****> dva Selima Cipar i Afriku.
03:44 <****> Svaki nesto, ne ostade nista;
03:45 <****> strasilo je slusat sto se radi!
03:45 <****> Malen svijet za adova zvala,
03:45 <****> ni najest ga, kamoli prejesti!
03:45 <****> Janko brani Vladislava mrtva;
03:45 <****> sto ga brani, kad ga ne odbrani?
03:45 <****> Skenderbeg je srca Obilica,
03:45 <****> al' umrije tuznim izgnanikom. -
03:45 <****> A ja sto cu, ali sa kime cu?
03:45 <****> Malo rukah, malena i snaga,
03:45 <****> jedna slamka me?u vihorove,
03:45 <****> sirak tuzni bez nig?e nikoga...
03:45 <****> Moje pleme snom mrtvijem spava,
03:45 <****> suza moja nema roditelja,
03:45 <****> nada mnom je nebo zatvoreno,
03:45 <****> ne prima mi ni placa ni molitve;
03:45 <****> u ad mi se svijet pretvorio,
03:45 <****> a svi ljudi pakleni duhovi.
03:45 <****> Crni dane, a crna sudbino!
03:45 <****> O kukavno Srpstvo ugaseno,
03:45 <****> zla nadzivjeh tvoja svakolika,
03:45 <****> a s najgorim hocu da se borim!
03:45 <****> Da, kad glavu razdrobis tijelu,
03:45 <****> u mucenju izdisu clenovi...
03:45 <****> Kugo ljudska, da te Bog ubije!
03:45 <****> Ali ti je malo po svijeta
03:45 <****> te si svojom zloscu otrovala,
03:48 <****> ebergen++ # kick msg
03:56 <****> i have a problem with mysql, i have a table named schema, and it is not being displayed properly by the php scripts
03:56 <****> it was working before, mysql version did not change
03:56 <****> define not displayed properly
03:56 <****> thumbs: there is signature_id , and signature_name field
03:56 <****> that does not define your issue.
03:56 <****> this is for snort, but base (the web front-end) was displaying ok
03:57 <****> define not displayed properly
03:57 <****> now it is not displaying sig_name, even though i see it populated
03:57 <****> i think this is the problem, i see a forum post, but it doesn't make sense to me
03:57 <****> print the query, and run it in the mysql console.
03:57 <****> For anyone else, the problem was the schema table. Somehow I had a value of "1" vice "106" and ended up getting no alert names displaying in the BASE output. Changing that one field caused everything to work great!
03:57 <****> see if the proper values are returned at that point.
03:57 <****> thumbs: i tried that i don't know how !
03:57 <****> i do use database snort;
03:58 <****> show tables;
03:58 <****> tablename is schema
03:58 <****> that's a poor name for a table.
03:58 <****> basically i don't know how to do the select query
03:58 <****> !man select
03:58 <****> (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/select.html
03:58 <****> !man query
03:58 <****> (Subquery Syntax) : http://dev.mysql.com/doc/mysql/en/subqueries.html
04:00 <****> select sig_name from schema;
04:00 <****> sig_name is the field
04:00 <****> dwxreaper: schema is a reserved word.
04:00 <****> dwxreaper: try from `schema`
04:01 <****> doesn't like that, this was working, it is some kind of bug, the code to populate the database changed
04:01 <****> but as i said, it seems to be appearing in phpmyadmin, but not the webfront-end
04:01 <****> dwxreaper: if you weren't all over the place, you might be able to fix your issue.
04:02 <****> thumbs: i am not a database guy, administrator, nor a programmer
04:02 <****> dwxreaper: what happens when you run select * from `schema`; ?
04:02 <****> so this is rather difficult
04:02 <****> dwxreaper: oh, we know.
04:02 <****> thumbs: select * from 'schema'; does not work, but show tables; shows schema
04:03 <****> you have the wrong sticks
04:03 <****> I said use `, not '.
04:03 <****> -`
04:03 <****> -`'-/_
04:03 <****> do not interpret what I thpe.
04:03 <****> type, rather.
04:03 <****> quote
04:04 <****> use backticks, back as in backhand
04:04 <****> darnit, no wench
04:04 <****> yeah, what the heck happened to archivist?
04:04 <****> thumbs: ha empty!
04:05 <****> dwxreaper: so the table has no data.
04:05 <****> this is the query phpmyadmin runs, where i see the data i like
04:05 <****> SELECT *
04:05 <****> FROM `signature`
04:05 <****> ORDER BY `signature`.`sig_name` ASC
04:05 <****> LIMIT 0 , 30
04:06 <****> dwxreaper: consider using pastebins when you have more than three lines.
04:06 <****> dwxreaper: what's wrong with that query?
04:06 <****> i don't understand what table it's pulling from (just trying to figure out the actual problem)
04:07 <****> and it works
04:07 <****> `signature`
04:08 <****> so it seems i have to look to the web front-ends source to resolve this issue?
04:08 <****> possibly.
04:08 <****> this started happening when i deleted the records, and repopulated the database with different software
04:08 <****> print the queries your software is running, and debug them.
04:09 <****> fuck
04:09 <****> dwxreaper: please watch your language.
04:09 <****> lol jesus
04:09 <****> any easy way to see how the front-end software is querying to populate it's display
04:09 <****> for the part that is missing
04:09 <****> that entirely depends on the nature of the front end.
04:10 <****> prolific: Just a guess but try... select round(datediff('recent_date', 'past_date')/7);
04:10 <****> dwxreaper: how you ask your question in #frontendname
04:12 <****> thumbs: don't think it's being developed anymore
04:12 <****> then I wouldn't use it.
04:12 <****> they are php scripts, i am looking at the php scripts now, i believe that what i'm supposed to be doing
Total 19 pages. You are browsing page 3/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last