hugoroger
02-10-2017, 10:41 PM
Hi everyone!
I am trying to create users manually in the fourm but I am getting an error:
This is the error I get:
Database error in vBulletin 4.2.3:
Invalid SQL:
INSERT INTO userfield
(field1, field2, field3, field4, field5, field6, userid)
VALUES
('', '', '', '', 'Yes', 'Yes', 245);
MySQL Error : Unknown column 'field5' in 'field list'
Error Number : 1054
Request Date : Friday, February 10th 2017 @ 12:40:56 PM
Error Date : Friday, February 10th 2017 @ 12:40:56 PM
Script : http://www.iforumelite.com/admincp/user.php?do=update
Referrer : https://www.iforumelite.com/admincp/user.php?do=add
IP Address : 189.33.122.10
Username : admin
Classname : vB_Database_MySQLi
MySQL Version : 5.6.35
The user somehow is pushed to the DB but not fully as I can't edit their profiles. But I can log in and when I post using their IDs, the come out as guests. Check the last post on this page:
When I try to post using these user accounts they appear as guests. Please see last post on this page:
https://www.iforumelite.com/showthread.php/286-Pergunta-Como-posso-extender-a-vida-da-bateria-de-meu-telefone-Android?p=857&viewfull=1#post857
User registration does not work and I get a DB error. It seems I'm missing a column in my userfield table, but not sure how you have managed that.
I removed the last plug in I had installed, repaired tables, cleared cache, but no fix.
Anyone even saw this error before?
I am trying to create users manually in the fourm but I am getting an error:
This is the error I get:
Database error in vBulletin 4.2.3:
Invalid SQL:
INSERT INTO userfield
(field1, field2, field3, field4, field5, field6, userid)
VALUES
('', '', '', '', 'Yes', 'Yes', 245);
MySQL Error : Unknown column 'field5' in 'field list'
Error Number : 1054
Request Date : Friday, February 10th 2017 @ 12:40:56 PM
Error Date : Friday, February 10th 2017 @ 12:40:56 PM
Script : http://www.iforumelite.com/admincp/user.php?do=update
Referrer : https://www.iforumelite.com/admincp/user.php?do=add
IP Address : 189.33.122.10
Username : admin
Classname : vB_Database_MySQLi
MySQL Version : 5.6.35
The user somehow is pushed to the DB but not fully as I can't edit their profiles. But I can log in and when I post using their IDs, the come out as guests. Check the last post on this page:
When I try to post using these user accounts they appear as guests. Please see last post on this page:
https://www.iforumelite.com/showthread.php/286-Pergunta-Como-posso-extender-a-vida-da-bateria-de-meu-telefone-Android?p=857&viewfull=1#post857
User registration does not work and I get a DB error. It seems I'm missing a column in my userfield table, but not sure how you have managed that.
I removed the last plug in I had installed, repaired tables, cleared cache, but no fix.
Anyone even saw this error before?