wierd MySQL problems....

From: Date: Fri, 22 Dec 2000 00:10:53 +0000
Subject: wierd MySQL problems....
Groups: php.general 
Request: Send a blank email to php-general+get-31502@lists.php.net to get a copy of this message
I know this isn't a PHP problem, MySQL is giving wierd results all of a suddend, all query's except this one work. [root@portlee /root]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.28-gamma Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use cooldragons Database changed mysql> select * from community; +--------------------+-------------+-----------+-------+----------------+------------+----------+ | peopleID | dragon_name | descrip | image | title | color_font | color_bg | +--------------------+-------------+-----------+-------+----------------+------------+----------+ | 974806802083190501 | kriskringle | hey there | | Chris Web Page | | | | 974806802083190502 | kriskringle | hey there | | Chris Web Page | | | | 974806802083190503 | kriskringle | hey there | | Chris Web Page | | | | 974806802083190504 | kriskringle | hey there | | Chris Web Page | | | +--------------------+-------------+-----------+-------+----------------+------------+----------+ 4 rows in set (0.00 sec) mysql> SELECT * FROM community WHERE peopleID = '974806802083190501' ; +--------------------+-------------+-----------+-------+----------------+------------+----------+ | peopleID | dragon_name | descrip | image | title | color_font | color_bg | +--------------------+-------------+-----------+-------+----------------+------------+----------+ | 974806802083190501 | kriskringle | hey there | | Chris Web Page | | | | 974806802083190502 | kriskringle | hey there | | Chris Web Page | | | | 974806802083190503 | kriskringle | hey there | | Chris Web Page | | | | 974806802083190504 | kriskringle | hey there | | Chris Web Page | | | +--------------------+-------------+-----------+-------+----------------+------------+----------+ 4 rows in set (0.00 sec) mysql> describe community; +-------------+--------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +-------------+--------------+------+-----+---------+-------+---------------------------------+ | peopleID | bigint(20) | YES | | NULL | | select,insert,update,references | | dragon_name | varchar(255) | YES | | NULL | | select,insert,update,references | | descrip | varchar(255) | YES | | NULL | | select,insert,update,references | | image | varchar(255) | YES | | NULL | | select,insert,update,references | | title | varchar(255) | YES | | NULL | | select,insert,update,references | | color_font | varchar(255) | YES | | NULL | | select,insert,update,references | | color_bg | varchar(255) | YES | | NULL | | select,insert,update,references | +-------------+--------------+------+-----+---------+-------+---------------------------------+ 7 rows in set (0.00 sec) mysql> any idea's ? Chris Lee Mediawaveonline.com

« previous php.general (#31502) next »