PDA

View Full Version : Solved Registration Problem



beaconsfield
05-10-10, 19:55
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
05-10-10, 20:53
When you used my .htaccess rewrite rules did you change the word forumz for your forum folder?

beaconsfield
05-10-10, 21:10
No I did not. I do not use forum folder. What should I do?

Simon Lloyd
05-10-10, 21:15
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
05-10-10, 21:19
Mine is www.mydomain.com

Simon Lloyd
05-10-10, 21:23
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
05-10-10, 21:27
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
05-10-10, 21:33
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
05-10-10, 21:34
Anyway thank you.:D I will wait Michal's reply.

kamilkurczak
06-10-10, 08:50
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?

vBET
06-10-10, 11:25
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.

If it still exists - please one more time import vBET product file. During installation vBET creates this column. You can find in product file:

$vbulletin->db->query_write('ALTER TABLE ' . TABLE_PREFIX . 'user ADD vbet_def_lang VARCHAR(5)');

It seems that something went wrong first time. Please check does it disappear after importing vBET product file again. If still not working - please PM access details to your FTP and Admin CP - we will check it.

beaconsfield
06-10-10, 18:46
I reinstalled plugin(overite) twice problem still exist. I sent you a PM.

vBET
06-10-10, 23:29
Got it. Please note that we have night on our time right now. Kamil will take care about it tomorrow :)

kamilkurczak
08-10-10, 12:09
Hello, I am still waiting for PM from you :)

beaconsfield
08-10-10, 19:00
Sorry for late reply. PM sent.

beaconsfield
08-10-10, 22:18
I unistalled and reinstalled again. The problem is solved.

kamilkurczak
08-10-10, 22:42
Hello,
Thanks for your confirmation.
:)

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Translations supported by vBET 4.9.2