Amazon

DragonflyCMS Projects > AccountPlus > [fixed] Admin - Add User > Community Forums > Phoenix Netology
Forum Index > Community > AccountPlus

[fixed] Admin - Add User Reply to topic


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.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
mulitple server setups/ DF9 and 10


Yep - a pretty dumb (lack of) double quote issue.

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

Download updated.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Cool thanks

DizWebDesign

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
mulitple server setups/ DF9 and 10

All times are Australia/Adelaide


Jump to: