Registration Problem

[beaconsfield]

When unregistered member wants to register a new account he gets database failure after filing all tables at the end. Noone can register a new account now? I need your immediate help.

Invalid SQL:
INSERT INTO user
(options, parentemail, email, username, salt, passworddate, password, usergroupid, languageid, usertitle, customtitle, showbirthday, birthday_search, birthday, timezoneoffset, ****dress, vbet_def_lang, displaygroupid, joindate, lastvisit, lastactivity, autosubscribe, showvbcode, threadedmode, reputationlevelid, reputation, pmpopup, maxposts, daysprune, startofweek)
VALUES
(11537751, '', 'kardelen_ksk22**********com', 'kardelenksk22', '\\w(y4I5Tv.7}<98ky5Uwe,B=|)cFX\"', FROM_UNIXTIME(1286304455), '55e50d487aa19ca1367c67c5d0f31709', 3, 12, 'Yeni Üye', 0, 0, '1985-04-26', '04-26-1985', '2', '88.242.91.77', 'tr', '', 1286304455, 1286304455, 1286304455, -1, 1, 0, 5, 10, 1, -1, 0, -1);

MySQL Error : Unknown column 'vbet_def_lang' in 'field list'
Error Number : 1054
Request Date : Tuesday, October 5th 2010 @ 09:47:35 PM
Error Date : Tuesday, October 5th 2010 @ 09:47:35 PM
Script : http://www.mydomain.com/register.php?do=addmember
Referrer : http://www.mydomain.com/register.php?do=addmember
IP Address : 88.242.91.77
Username : kardelenksk22
Classname : vB_Database
MySQL Version :

[Simon Lloyd]

When you used my .htaccess rewrite rules did you change the word forumz for your forum folder?

[beaconsfield]

No I did not. I do not use forum folder. What should I do?

[Simon Lloyd]

That .htaccess has my folder extension, if your forum is like this www.mysite.com/forum then change the forumz to forum and you should be good (btw i only just bought and installed this today)

[beaconsfield]

Mine is www.mydomain.com

[Simon Lloyd]

Then i would be guessing but you could do no worse than change your.htacces from the one you copied from my solution to this and see how you go

RewriteRule ^/?(af|sq|ar|be|bg|ca|zh-CN|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|is|id|ga|it|ja|ko|lv|lt|mk|ms|mt|no|fa|pl|pt|ro|ru|sr|sk|sl|es|sw|sv|zh-TW|th|tr|uk|vi|cy|yi)/$ vbenterprisetranslator_seo.php?vbet_lang=$1&redirected=/ [L,QSA]
RewriteRule ^/?(af|sq|ar|be|bg|ca|zh-CN|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|is|id|ga|it|ja|ko|lv|lt|mk|ms|mt|no|fa|pl|pt|ro|ru|sr|sk|sl|es|sw|sv|zh-TW|th|tr|uk|vi|cy|yi)/(.*)?$ vbenterprisetranslator_seo.php?vbet_lang=$1&redirected=/$2 [L,QSA]

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|vbseo_sitemap/|cron)
RewriteRule ^((archive/)?(.*\.php(/.*)?))$ vbenterprisetranslator_seo.php [L,QSA]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !^(admincp|modcp|clientscript|cpstyles|images)/
RewriteRule $ vbenterprisetranslator_seo.php [L,QSA]

if that doesn't work set your rewrite back to how it was before you ever changed it today and wait for someone from here to get in touch with you, at least they will be able to use your forum

[beaconsfield]

Thanks for your help but it does not solve my database problem. The problem is noone can register a new account now. Because of default language table is not known. Any idea?

[Simon Lloyd]

change the default language in your admincp>vbet> MAIN>default language

Then for you to see your forum www.mydomain.com/en/ en if your default language is english.

Thats the best i can do as its not my mod and im no coder - sorry!

[beaconsfield]

Anyway thank you. I will wait Michal's reply.

[kamilkurczak]

hello
I was on your site and I can't find flags. are you sure that you imported a vBET product.xml file from do-not-uploadfolder by admincp->products and plugins->add/import product?