| Author |
Message |
rmcvay
Posts: 4
Location: Texas, USA
|
|
New install - can't add users - Posted: February 16, 2007 - 3:32 PM
|
Quote and reply
|
We just installed the latest Sitellite (RHEL4, php-mysql-4.3.9, mysql 4.1.20) and it seems things that do updates work ok but when I try to add a user I get something like the following in reply and the user isn't added.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-end, username, lang, registered, modified) values ('', 'GA39XiH2gti6Y', 'Ray', ' at line 1
Anyone have any ideas about where to look to correct this?
|
|
Back to top
|
View user profile
Contact this member
|
lux
Posts: 634
Location: Manitoba, Canada
|
|
Re: New install - can't add users - Posted: February 17, 2007 - 3:46 PM
|
Quote and reply
|
rmcvay said:
We just installed the latest Sitellite (RHEL4, php-mysql-4.3.9, mysql 4.1.20) and it seems things that do updates work ok but when I try to add a user I get something like the following in reply and the user isn't added.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-end, username, lang, registered, modified) values ('', 'GA39XiH2gti6Y', 'Ray', ' at line 1
Anyone have any ideas about where to look to correct this?
Thanks for the bug report on this. The solution appears to be to add a couple lines to the files inc/app/usradm/boxes/add/user/index.php and inc/app/usradm/boxes/edit/user/index.php as follows: Where you see a series of unset() calls, add these to that list:
unset ($vals['tab1']);
unset ($vals['tab2']);
unset ($vals['tab3']);
unset ($vals['tab-end']);
That should fix it. The downloads of 4.2.12 have also been patched with this update, so existing 4.2.12 installations can patch using the above (or email us and we'll help you patch it) and new installations should be unaffected.
Lux
|
|
Back to top
|
View user profile
Contact this member
|
rmcvay
Posts: 4
Location: Texas, USA
|
Thanks for the quick reply, Lux. It did cross my mind that most existing users probably wouldn't be adding users so it could've been a real bug rather than a configuration problem on our part.
|
|
Back to top
|
View user profile
Contact this member
|
rmcvay
Posts: 4
Location: Texas, USA
|
|
Updated code, different problem - Posted: February 20, 2007 - 2:23 PM
|
Quote and reply
|
Our admin updated the PHP, which corrected the problem with adding a user. He also added the siteforge app. Now an existing user account can't be modified in any way although there is no error indication. Non-user objects can be modified fine.
More info. A user can modify his own info through his preferences form but the admin can't.
Should we just blow everything away and reinstall from scratch?
|
|
Back to top
|
View user profile
Contact this member
|
lux
Posts: 634
Location: Manitoba, Canada
|
|
Re: Updated code, different problem - Posted: February 21, 2007 - 3:46 PM
|
Quote and reply
|
rmcvay said:
Our admin updated the PHP, which corrected the problem with adding a user. He also added the siteforge app. Now an existing user account can't be modified in any way although there is no error indication. Non-user objects can be modified fine.
More info. A user can modify his own info through his preferences form but the admin can't.
Should we just blow everything away and reinstall from scratch?
After the fix, I'm now able to make changes to any field in the users and it saves them correctly for me. The only trouble I get is the auto-fill of the passwords from Firefox (to save a change without changing their password or hitting the password doesn't match message, I have to clear the field -- may be a good idea to rename that field in the form...).
I'm wondering if it's something conflicting with SiteForge, but I don't see how it would be. Are you still experiencing this if SiteForge isn't installed?
Lux
|
|
Back to top
|
View user profile
Contact this member
|
rmcvay
Posts: 4
Location: Texas, USA
|
|
Re: Updated code, different problem - Posted: February 21, 2007 - 5:41 PM
|
Quote and reply
|
lux said:
After the fix, I'm now able to make changes to any field in the users and it saves them correctly for me. The only trouble I get is the auto-fill of the passwords from Firefox (to save a change without changing their password or hitting the password doesn't match message, I have to clear the field -- may be a good idea to rename that field in the form...).
I'm wondering if it's something conflicting with SiteForge, but I don't see how it would be. Are you still experiencing this if SiteForge isn't installed?
Lux
Our admin just reinstalled from the latest version into a new database and everything is now working. There must have been some glitch in the way we updated it at first. Thanks for the double check.
Ray
|
|
Back to top
|
View user profile
Contact this member
|
lux
Posts: 634
Location: Manitoba, Canada
|
|
Re: Updated code, different problem - Posted: February 21, 2007 - 5:52 PM
|
Quote and reply
|
Sweet! I'm glad to hear it :)
Lux
|
|
Back to top
|
View user profile
Contact this member
|
