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

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


 [2008-01-04 10: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 17: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 17: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-04 19:11 UTC] cellog (Greg Beaver)
the account exists as "ppadron"