[Almotmaiz.Net]

Originally Posted by apiasto

this is what i am getting

MySQL Error : Unknown column 'userid' in 'field list'
Error Number : 1054

Invalid SQL:
INSERT INTO `nlp_vmail` (`userid`, `code`, `email`, `prefix`, `dateline`, `day`, `month`, `year`, location)
VALUES

do this in phpmyadmin

ALTER TABLE `nlp_vmail` ADD `location` ENUM( 'register', 'profile' ) NOT NULL, ADD `userid` INT( 10 ) NOT NULL FIRST

and this

UPDATE `nlp_vmail` SET `location` = 'register'

Originally Posted by mad@Max

Almotmaiz.Net
In this post: https://vborg.vbsupport.ru/showpost....9&postcount=69

DB error soruce shuld be like this mad

MySQL Error : Unknown column 'userid' in 'field list'
Error Number : 1054
 
Invalid SQL:
INSERT INTO `nlp_vmail` (`userid`, `code`, `email`, `prefix`, `dateline`, `day`, `month`, `year`, location) 
                        VALUES

OR give me a diect link to see this