Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Bugger
 
of 6

 #108 » Admin - Add User
 Date Open: Dec 14, 2009 at 16:38:26    Last Update: Dec 14, 2009 at 21:17:11 Bugger Off: Dec 14, 2009 at 21:17:11 
 Description: when i tried adding a new user through the admin /add member i get this:

includes/db/db.php

* CMS Warning line 75: On /admin.php?op=users While executing query "INSERT INTO dwdu_users (username, user_email, user_password, user_regdate, user_avatar'., name, city_state, user_notify, user_notify_pm, user_popup_pm, phone, zip_code, street_addy.') VALUES ('Test', 'carlg@dizwebdesign.com', 'e10adc3949ba59abbe56e057f20f883e', '1260833516', 'gallery/blank.gif', '123', '456', '1', '1', '1', '789', '123', '987')" the following error occured: 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 ''., name, city_state, user_notify, user_notify_pm, user_popup_pm, phone, zip_cod' at line 2 In: /var/www/web1/web/admin/modules/users.php on line: 363

I tried on 2 different sites using default theme and a couple themes i done.
I set this for your_account module but not sure if that is right. Sad
 Request: Bug
 Application: Other
 Module: your_account
 Solution: completed
 Bugger From: Dizfunkshunal
 Debugger: Phoenix
 Group Access: All Visitors
 DiscussIt Forum: AccountPlus
 DiscussIt Topic: Admin - Add User
 Status: Done
 Priority: High
 Topic Replies:
 Phoenix
 Dec 14, 2009
 21:13:35
Yep - a pretty dumb (lack of) double quote issue.

Line 361 of admin/modules/users.php shoulod read
Code::
(username, user_email, user_password, user_regdate, user_avatar".$fieldlist.")

Download updated.
 Dizfunkshunal
 Dec 15, 2009
 00:58:51
Cool thanks
150 buggers listed, 109 buggered off, 31 declined, 8 on hold.