Author Topic: DB Error while adding user via admin panel  (Read 5832 times)

0 Members and 1 Guest are viewing this topic.

Offline MadeInUSSR

  • Newbie
  • *
  • Posts: 36
    • View Profile
DB Error while adding user via admin panel
« on: March 05, 2006, 06:07:02 AM »
when I am trying to add user via admin panel I got such error:
Quote
DB Error: Bad SQL Query: INSERT INTO 4images_users (user_id, user_level, user_name, user_password, user_email, user_showemail, user_allowemails, user_invisible, user_joindate, user_activationkey, user_lastaction, user_lastvisit, user_comments, user_homepage, user_icq, user_limit) VALUES (21, 2, 'user_test', 'd362465506c87bcda058ef3afbebd455', 'uesr_test@test.com', 1, 1, 0, 1141534889, '8eb68e17c81a6cb3627b00089e3b45c0', 1141534889, 1141534889, 0, '', '', )
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 ')' at line 4
User 1
    Error adding user: user_test

for example if I added such info:
User level   Registered
Username  user_test
Email         uesr_test@test.com
Password   uesr_test
Homepage   -----
ICQ            -------
Show Email   Yes
Receive emails from administrators:   Yes
Invisible   No
**MadeInUSSR**

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: DB Error while adding user via admin panel
« Reply #1 on: March 05, 2006, 08:08:08 AM »
Not related to 4images itself. its whatever mod that added user_limit field into database is causing this error.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline MadeInUSSR

  • Newbie
  • *
  • Posts: 36
    • View Profile
Re: DB Error while adding user via admin panel
« Reply #2 on: March 05, 2006, 08:26:30 AM »
а это можно как-нибудь исправить???
**MadeInUSSR**

Offline trez

  • Hero Member
  • *****
  • Posts: 613
    • View Profile
    • blog / photography
Re: DB Error while adding user via admin panel
« Reply #3 on: March 05, 2006, 02:00:38 PM »
you have to fill ALL fields, and it works. Had the same problem, too.

Offline MadeInUSSR

  • Newbie
  • *
  • Posts: 36
    • View Profile
Re: DB Error while adding user via admin panel
« Reply #4 on: March 05, 2006, 03:27:51 PM »
if to look at DB error I should fill such fields  (user_id, user_level, user_name, user_password, user_email, user_showemail, user_allowemails, user_invisible, user_joindate, user_activationkey, user_lastaction, user_lastvisit, user_comments, user_homepage, user_icq, user_limit)   but there are (in admin panel) just 9 fields for adding user.... :?
**MadeInUSSR**

Offline trez

  • Hero Member
  • *****
  • Posts: 613
    • View Profile
    • blog / photography
Re: DB Error while adding user via admin panel
« Reply #5 on: March 05, 2006, 04:07:46 PM »
no, some are automaticly filled (like last active, etc)
Just fill in the 9 fields - workin?

Offline MadeInUSSR

  • Newbie
  • *
  • Posts: 36
    • View Profile
Re: DB Error while adding user via admin panel
« Reply #6 on: March 05, 2006, 10:48:50 PM »
sad... but no it doesn't work....
**MadeInUSSR**