Author Topic: DB Error: Bad SQL Query:INSERT INTO 4images_users  (Read 2549 times)

0 Members and 1 Guest are viewing this topic.

Offline fgabriel

  • Newbie
  • *
  • Posts: 30
    • View Profile
DB Error: Bad SQL Query:INSERT INTO 4images_users
« on: January 04, 2007, 02:55:02 AM »
anyone? :( buaaaaa im confuse
i cant add user or modify settings for users, i made a mistake somewere  :(

error from admin panel:

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_limit, user_signature, userpic, user_description, user_msn, user_pm_inbox, user_pm_sentbox, user_pm_email, user_pm_popup) VALUES (3, 2, 'Pedro Gomes', '827ccb0eea8a706c4c34a16891f84e7b', 'volume@tvtel.pt', 1, 1, 0, 1167873988, 'd5b30348ac8ca1cef0b8c9070ce6d96a', 1167873988, 1167873988, 0, '', '', , 'pg', '', '', '', '', '', '1', '1')
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 ' 'pg', '', '', '', '', '', '1', '1')' at line 4


my sql users table:

   Field   Type   Collation   Attributes   Null   Default   Extra   Action
 
user_id   int(11)         No      auto_increment    
user_level   int(11)         No   1      
user_name   varchar(255)   latin1_swedish_ci      No         
user_password   varchar(255)   latin1_swedish_ci      No         
user_email   varchar(255)   latin1_swedish_ci      No         
user_showemail   tinyint(1)         No   0      
user_allowemails   tinyint(1)         No   1      
user_invisible   tinyint(1)         No   0      
user_joindate   int(11)       UNSIGNED   No   0      
user_activationkey   varchar(32)   latin1_swedish_ci      No         
user_lastaction   int(11)       UNSIGNED   No   0      
user_location   varchar(255)   latin1_swedish_ci      No         
user_lastvisit   int(11)       UNSIGNED   No   0      
user_comments   int(10)       UNSIGNED   No   0      
user_homepage   varchar(255)   latin1_swedish_ci      No         
user_icq   varchar(20)   latin1_swedish_ci      No         
user_t_images   smallint(6)         No   0      
userpic   varchar(255)   latin1_swedish_ci      No   noimage.jpg      
user_description   varchar(255)   latin1_swedish_ci      No         
user_msn   varchar(255)   latin1_swedish_ci      No         
user_pm_inbox   int(11)         No   0      
user_pm_sentbox   int(11)         No   0      
user_pm_email   tinyint(1)         No   1      
user_pm_popup   tinyint(1)         No   0      
user_limit   smallint(3)         No   5      
user_posts   int(8)         No   0      
user_signature   text   latin1_swedish_ci