Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.32.0

Bug #12823 Missing column in database table 'users'
Submitted: 2008-01-04 15:35 UTC
From: wiesemann Assigned:
Status: Bogus Package: pearweb (version 1.17.0)
PHP Version: 5.2.5 OS:
Roadmaps: 1.17.1    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 20 - 2 = ?

 
 [2008-01-04 15:35 UTC] wiesemann (Mark Wiesemann)
Description: ------------ The account request form uses the column 'from_site' in the 'users' table, but this column doesn't exist. The used query is: INSERT INTO users (handle, name, email, homepage, showemail, password, registered, userinfo, from_site) VALUES ([...]) The error message is: [nativecode=1054 ** Unknown column 'from_site' in 'field list']

Comments

 [2008-01-04 22:34 UTC] cellog (Greg Beaver)
You are incorrect - the field exists, and this is not the problem, in spite of what it says. Could there perhaps have been some weirdness? mysql> show columns from users; +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | handle | varchar(20) | | PRI | | | | password | varchar(64) | YES | | NULL | | | name | varchar(100) | YES | | NULL | | | email | varchar(100) | YES | MUL | NULL | | | homepage | varchar(255) | YES | | NULL | | | created | datetime | YES | | NULL | | | createdby | varchar(20) | YES | | NULL | | | lastlogin | datetime | YES | | NULL | | | showemail | tinyint(1) | YES | | NULL | | | registered | tinyint(1) | YES | | NULL | | | admin | tinyint(1) | YES | | NULL | | | userinfo | text | YES | | NULL | | | pgpkeyid | varchar(20) | YES | MUL | NULL | | | pgpkey | text | YES | | NULL | | | wishlist | varchar(255) | | | | | | longitude | varchar(25) | YES | | NULL | | | latitude | varchar(25) | YES | MUL | NULL | | | active | tinyint(1) | | | 1 | | | from_site | varchar(4) | | | pear | | +------------+--------------+------+-----+---------+-------+ 19 rows in set (0.00 sec)
 [2008-01-04 22:43 UTC] wiesemann (Mark Wiesemann)
Argh, my local database wasn't up-to-date. I must have mixed up the local and the online tests that I did. (But I could have noted that the SQL query and the error message is shown only locally usually ...) My test on the website worked, as Helgi pointed out via an email to me. => Let's mark this a bogus. If the account "pgpadron" (as reported on pear-dev) doesn't exist in the database, please re-open this bug.
 [2008-01-05 00:11 UTC] cellog (Greg Beaver)
the account exists as "ppadron"