Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Amazon
show cart or checkout0 items
Cart Value: 0.00

Forums » DragonflyCMS Projects » AccountPlus » [fixed] Admin - Add User
[fixed] Admin - Add User
Upgrade of Your Account module.
Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  Community » AccountPlus

View previous topic :: View next topic  
Author Message
Dizfunkshunal
Operator
Operator

Offline Offline
Joined: May 26, 2007
Posts: 69

PostPosted: Tue Dec 15, 2009 2:08 am
Post subject: [fixed] Admin - Add User

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 prefix_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: /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

Initiated by Bugger (Original Entry) - Comments Here Please.


Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
mulitple server setups/ DF9 and 10
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Tue Dec 15, 2009 6:43 am
Post subject: Re: Admin - Add User

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.


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Dizfunkshunal
Operator
Operator

Offline Offline
Joined: May 26, 2007
Posts: 69

PostPosted: Tue Dec 15, 2009 10:28 am
Post subject: Re: [fixed] Admin - Add User

Cool thanks

_________________
DizWebDesign

Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
mulitple server setups/ DF9 and 10
Back to top
View user's profile Visit poster's website
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  Community » AccountPlus
Page 1 of 1
All times are GMT + 9.5 Hours



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum