Miscellaneous Hacks - vMail - Verify Mail before registration.

this product can be founded in this thread https://vborg.vbsupport.ru/showthread.php?t=201466

[mad@Max]

Originally Posted by apiasto

hi ,i installed it and when i click go after putting image verification i get data base error

nlp_vmail' doesn't exist

any idea thnx

Uninstall and install again

[apiasto]

Originally Posted by mad@Max

Uninstall and install again

tried that couple of times but same thing

[alessai2]

بارك الله فيك يالغالي ومنتج بالفعل رائع ,,

Thanx ..

[Almotmaiz.Net]

Originally Posted by apiasto

hi ,i installed it and when i click go after putting image verification i get data base error

nlp_vmail' doesn't exist

any idea thnx

u need to Uninstalled and re-install
till ,e result

Originally Posted by alessai2

بارك الله فيك يالغالي ومنتج بالفعل رائع ,,

Thanx ..

تسلم عزيزي ^^

[apiasto]

this what i am getting

Invalid SQL:
INSERT INTO `nlp_vmail` (`code`, `email`, `prefix`, `dateline`, `day`, `month`, `year`)
VALUES
(
'e80cdc1c897e70aff85cf6ed6b98ad6f',
'---------@----------',
'NLP',
'1195754841',
'0',
'0',
'0'
);

MySQL Error : Table '------------.nlp_vmail' doesn't exist

i am going crazy,is there a way around it ?

[Almotmaiz.Net]

Originally Posted by apiasto

this what i am getting

Invalid SQL:
INSERT INTO `nlp_vmail` (`code`, `email`, `prefix`, `dateline`, `day`, `month`, `year`)
VALUES
(
'e80cdc1c897e70aff85cf6ed6b98ad6f',
'---------@----------',
'NLP',
'1195754841',
'0',
'0',
'0'
 

MySQL Error : Table '------------.nlp_vmail' doesn't exist

i am going crazy,is there a way around it ?

do it manully .

do this query ..

CREATE TABLE nlp_vmail
				(
					`code` text NOT NULL,
					`email` text NOT NULL,
					`prefix` text NOT NULL,
					`dateline` int(10) unsigned NOT NULL default '0'
				)

[apiasto]

thanks i did that querry and i got this message now

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

[Almotmaiz.Net]

Originally Posted by apiasto

thanks i did that querry and i got this message now

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

sorry .

do this Query :

ALTER TABLE nlp_vmail 
		ADD `day` text NOT NULL,
		ADD `month` text NOT NULL,
		ADD `year` text NOT NULL

[apiasto]

ok thaNKS ALOT IT WORKS BUT WHEN I ENTER THE CODE IT IS SAYING
Sorry, your e-mail address is incorrect (does not match the verification code).

[Seiyaboy]

Validation code must match the email address where the validation was being sent to, otherwise the registration will be rejected.