Menu
▾
▴
phpwebsite-developers
|
From: Eric W. <ecr...@ya...> - 2002-01-10 16:53:48
|
Since we are using a relational database in MySQL, why do we not take full advantage of its features? In both the stories (author, informant) and comment(name)tables we currently use a text field to story the data. Why use "admin" in stories instead of the admin id #? Same with the other columns. If I change "admin" to "eric" in the authors table, it does not update all the announcements already in stories. ===== Eric T. Wallace er...@ec... ecrosstexas::the texas blog <http://www.ecrosstexas.com/> __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ |
|
From: Alessandro P. (T. / J578) <al...@ti...> - 2002-01-10 18:41:14
|
On Thu, 2002-01-10 at 17:53, Eric Wallace wrote: > Since we are using a relational database in MySQL, why > do we not take full advantage of its features? > > In both the stories (author, informant) and > comment(name)tables we currently use a text field to > story the data. Why use "admin" in stories instead of > the admin id #? Same with the other columns. > > If I change "admin" to "eric" in the authors table, it > does not update all the announcements already in > stories. I'll take case of this. Thanks for pointing this out. Bye, Alessandro -- Alessandro "TXM" Pisani - al...@ti... - ICQ #2209087 phpWebSite Development Team http://phpwebsite.appstate.edu INWO Project coordinator http://inwoproject.sourceforge.net "I will carry you through, hicking and screaming, and in the end you will thank me" - Tyler Durden [from "Fight Club"] |
|
From: Alessandro P. (T. / J578) <al...@ti...> - 2002-01-10 19:55:38
|
On Thu, 2002-01-10 at 17:53, Eric Wallace wrote: > If I change "admin" to "eric" in the authors table, it > does not update all the announcements already in > stories. fixed: now it does :> I also fixed this to happen also for users and not only admins. Bye, Alessandro -- Alessandro "TXM" Pisani - al...@ti... - ICQ #2209087 phpWebSite Development Team http://phpwebsite.appstate.edu INWO Project coordinator http://inwoproject.sourceforge.net "I will carry you through, hicking and screaming, and in the end you will thank me" - Tyler Durden [from "Fight Club"] |
|
From: spiggy <th...@me...> - 2002-01-10 21:07:29
|
i made a brave move and upgraded to almost the latest cvs version. i did the upgrade manually because i wanted to see all the changes in database etc. there is only one problem: the users cannot 'completely' login. they seem to be logging in ok, the user options show up in the login box but when i click any of them i get: a problem occurred: your account is not registered. please logout and delete the cookie. but deleting cookies will not help. so the users can log in and see users only options but they cannot change their comment options/password/etc. if someone has an user account to my site (phpgirl.com) i invite you to try to login :) the server is still running php 4.0.6. paivi |
|
From: Alessandro P. (T. / J578) <al...@ti...> - 2002-01-10 21:20:57
|
On Thu, 2002-01-10 at 22:21, spiggy wrote: > i made a brave move and upgraded to almost the latest cvs version. i did > the upgrade manually because i wanted to see all the changes in database > etc. > > there is only one problem: the users cannot 'completely' login. they > seem to be logging in ok, the user options show up in the login box but > when i click any of them i get: a problem occurred: your account is not > registered. please logout and delete the cookie. but deleting cookies > will not help. > > so the users can log in and see users only options but they cannot > change their comment options/password/etc. if someone has an user > account to my site (phpgirl.com) i invite you to try to login :) > > the server is still running php 4.0.6. That's weird 'cos user login didn't change since a lot of time... can you please mail me more info about this? Alessandro -- Alessandro "TXM" Pisani - al...@ti... - ICQ #2209087 phpWebSite Development Team http://phpwebsite.appstate.edu INWO Project coordinator http://inwoproject.sourceforge.net "I will carry you through, hicking and screaming, and in the end you will thank me" - Tyler Durden [from "Fight Club"] |
|
From: spiggy <th...@me...> - 2002-01-10 21:26:05
|
id addition to the previous, i just noticed that user login seems to clear the password field in the database :) and then you can login with any password. but you still cannot get any further than that... so you cannot change any options. if i login with my other test user, it will log me in (with a wrong password), change the theme to the one i have chosen but will not let me any further. paivi |
|
From: Alessandro P. (T. / J578) <al...@ti...> - 2002-01-10 21:33:29
|
On Thu, 2002-01-10 at 22:40, spiggy wrote: > id addition to the previous, i just noticed that user login seems to > clear the password field in the database :) and then you can login with > any password. but you still cannot get any further than that... so you > cannot change any options. > > if i login with my other test user, it will log me in (with a wrong > password), change the theme to the one i have chosen but will not let me > any further. > > paivi Paivi, listen to me: I'm unable to reproduce this bug with latest CVS snapshot and Roswell. When you update from CVS to CVS, as stated clearly on my webpage, you're supposed to do a re-install (suggested) or an update; manual upgrades/incomplete upgrades only causes false alarms, as showed in latest weeks. Please test it with a fresh install of latest snapshot and then please notify me any eventual bug you find. Please note that, of course, you do not have to destroy your current site: you can test the CVS snapshot in a subdir referring to a new db or the samedb using a different table_prefix. Thank you I'm available for any further info/comment/help Regards, Alessandro -- Alessandro "TXM" Pisani - al...@ti... - ICQ #2209087 phpWebSite Development Team http://phpwebsite.appstate.edu INWO Project coordinator http://inwoproject.sourceforge.net "I will carry you through, hicking and screaming, and in the end you will thank me" - Tyler Durden [from "Fight Club"] |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X