| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> Hey, i just installed Apache 2.2 and reinstalled php4... now MySQL is giving me an error both from my PHPBB and from my terminal when i try to run it
<1> firewire: no that's not it ... you're right - it probably is 'too easy' for you
<0> it says it cannot connect to mysql through /tmp/mysql.sock
<2> hi guyes
<0> Any idea?
<2> guys
<3> Jaywalker, you probably forgot to start mysqld
<0> It's running
<2> what's the diff between Linux (x86, glibc-2.2, "standard" is static, gcc) and the glibc2.3 dynamically linked versions
<4> babo: enjoy figuring that out on your own. Enjoy being an intern this summer and next summer until you graduate and get a mediocre job for two years which won't even be enough to put a dent in your student loans before your jobs gets outsourced to arkansas
<5> INSERT INTO tiki_tracker_item_fields
<5> SELECT EventId AS itemId, '1' AS fieldId, EditionOrd AS value FROM datatransfer;
<3> Jaywalker, could be a permissions problem then perhaps?
<0> Oh, fires, sorry, you were right... It _was_ running
<0> but it quit
<4> rosenjon: so you're tyring to normalize a single table into multiple tables using insert ... select
<0> when i switched the server over or something
<3> Jaywalker, thought so ;)
<0> Thanks
<5> yes -- and based on a certain ID
<5> that should be in there too
<4> ok, all clear so far :)
<4> wait, why a certain id?
<5> SELECT EventId AS itemId, '1' AS fieldId, EditionOrd AS value FROM datatransfer WHERE DivisionId = 1000;
<1> firewire: enjoy being an *** for the rest of life. Enjoy it even more when your wife leaves you to find a real man who doesn't hide behind his job to project his masculinity
<4> hahaha
<4> that's great :)
<5> I want to group the data by DivisionID, which is really by state
<4> I don't have a wife or a job
<1> firewire: :-) figures
<4> rosenjon: why are you creating tables per state?
<3> haha
<3> beautifully constructed retort, firewire
<5> i have a wiki system where I am ***igning groups of people based on state
<3> i don't really know what you guys are arguing about, but that was just beautiful
<5> and i need them to be in different groups to seperate their activities
<5> so all data is in same place, but ***igned to different divisions
<1> firewire: I work as an English teacher ... :-)
<1> firewire: I give homework, I don't do it ...
<4> rosenjon: I have a feeling this is why your last attempt ended up in a big discussion. You're trying to create tables that aren't normalized
<4> babo: I work as a DBA
<4> actually an operations engineer/dba
<5> not sure what that means -- i am trying to adapt this to a current data entry system, so i dont really have that options
<5> i just want the data to conform to the current system
<4> rosenjon: you probably don't want to create separate tables per state
<5> umm.....they arent seperate tables
<4> ok, continue describing your issue
<5> maybe a quick table over view -- there is items table, which contains fieldid, trackerid, value of item
<5> scratch that
<1> firewire: that's great
<5> maybe a quick table over view -- there is items table, which contains fieldid, itemid, value of item
<1> firewire: good luck with everything
<5> there is item reference table -- which contains trackerid, itemid
<5> there is field reference table -- which contains fieldid, trackerid
<5> and there is trackers reference table, which contains trackerid,tracker details
<5> so values are arranged by their field id, and their tracker id, in order to dynamically build a table
<4> babo: sure.
<5> interface also allows you to change fields that can be entered, which is why this is kind of complicated
<5> does any of this make any sense
<4> "dynamically build a table" scares me
<4> that just screams bad design
<5> in other words, the data is stored one cell at a time, and then the php code groups the ids to build the interface
<1> firewire: apologies, if I was a little terse ... :-)
<4> babo no problem :)
<5> firewire: have you ever used tikiwiki?
<4> I have used twiki and mediawiki
<5> anyway -- tikiwiki has a data entry system called trackers
<4> k
<5> it is a metadata system that allows you to enter fields to be entered
<5> so you can describe the fields that users will fill data in
<5> therefore it is a metadata system
<5> make sense?
<4> yes
<5> ok
<5> so i want to create seperate groups in the system by state
<5> each group will need its own field ids
<5> but all data that describe fields stay the same
<5> data has divisionid, which describes its Geographic State
<5> so i want to create seperate field entries for each DivisionId
<6> hi everyone
<6> is ther a way to debug mysql by showing what queries are running on a db?
<6> not mtop info
<6> but actual queries
<5> so basically i have a table that has all the field description data, and just want to increment all the field ids for every division id
<6> like: INSERT x, y, z INTO.......
<4> mick_home: show processlist?
<6> i don't think that tells you exact sql statements
<4> uhh yes it does
<6> just Insery query - takes 5 seconds....
<6> i may by wrong
<4> how many indexes are on the table?
<6> let me check
<4> rosenjon: update with a join?
<4> but it still sounds like a normalization issue
<5> i think i can simplify this -- forget all the stuff i just said
<5> let me try another way
<5> INSERT INTO tiki_tracker_item_fields
<5> SELECT EventId AS itemId, '1' AS fieldId, EditionOrd AS value FROM datatransfer WHERE DivisionId = 1000;
<5> I want to run this query for every Division ID from 1000 to 1050
<5> I want fieldId to be a function of DivisionId, instead of being static
<5> there are 25 of these queries, so i want fieldid to increase by 25 for every +1 of DivisionId
<5> is there a way to loop through in this manner for every division id from 1000 to 1050?
<6> ty firewire
<5> does this make more sense firewire?
<4> rosenjon: why can't you do where divisionid between 1000 and 1050 and split it up programatically
<5> not sure what you mean by split it up programatically?
<5> i could replicate all statements for each value of divisionid, but i dont want to do this
<4> what are you doing with the results of that query?
<5> it is going into a wiki system, where it can be edited by a bunch of people as part of a complete record
<5> the results of that query just go into the database.......
<4> and you're creating a new table per id?
<5> no new tables are being created
<5> the database is fixed
<5> only new records for each table
<5> again...it is a metadata system, there is no need to create new tables
<4> ok
<6> firewire, is it possible to have that update in realtime?
<6> like top (or does mtop really do what i want)
<4> how real time?
<5> i suppose i can just write this as a php loop statement and print the output as a giant sql statement
<4> show processlist returns a snapshot of what is currently running
<4> rosenjon: what's wrong with using between?
<5> but i was hoping i could be more elegant with the sql
<6> well, as it happens
<5> firewire: between?
<5> not following you
<6> like top, but something that keeps it there]
<6> on screen
<4> where id between 1000 and 1050
<4> will return everything between those two values
<4> mick_home: run show processlist; from the mysql command prompt
<5> firewire, because new values have to be ***igned for every division id
<6> i did
<4> an new fieldid
<5> that would ***ign same values for every division id
<6> but it doesn't stay there, it just finishes
<2> how stable are the beta releases
<6> M3, don't use the beta in production
<2> i'm installing for the first time on my dev box
<6> dev box is ok
<5> firewire:can i write hybrid select statement with operators
<4> rosenjon: what about something like select @a := 1; SELECT EventId AS itemId, @a := @a + 1 AS fieldId, EditionOrd AS value FROM datatransfer WHERE DivisionId = 1000;
<2> why is 5.1.6 so much bigger than 5.0.19
<6> don't develop for mysql production though w/ beta
<2> that's a good point
<6> M3, check the changelog
<7> why not 5.1.7, 5.1.6 is alpha
<5> firewire @a -- what does this do?
<2> right, why didn't i think of that
<2> thanks mick_home
Return to
#mysql
or
Go to some related
logs:
Linux Apache MySQP PHP
ndiskwrapper
mysql err 150
#math
#javascript
ezbounce paltalk
ubuntu ath0 wifio
#xorg
xen-sources overlay
undrdawg
|
|