Important: This page is using cookies (cookies). Using this website without turning off cookies in browser, means that you agree for using it.
Buy Now! Features Downloads

Earn with us!

If you would like to start earning money with vBET join to Affiliate Program.
Results 1 to 6 of 6

Thread: Database Error When you update the language when I update the profile

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Database Error When you update the language when I update the profile

    Text automatically translated from: Portuguese to: English
    Translated text
    When I refresh the language in the User Control Panel, the following error appears:
    Code:
    Database error in vBulletin 4.2.3 Beta 3:  Invalid SQL: UPDATE user SET     parentemail = '',     icq = '',     msn = '',     aim = '',     yahoo = '',     skype = '',     homepage = '',     birthday_search = '',     birthday = '',     showbirthday = 0,     usertitle = 'Matador de Ursos',     customtitle = 1,     vbet_def_lang = 'pt',     membergroupids = '109' WHERE userid = 1;  MySQL Error   : Unknown column 'vbet_def_lang' in 'field list' Error Number  : 1054 Request Date  : Sunday, May 24th 2015 @ 04:02:35 PM Error Date    : Sunday, May 24th 2015 @ 04:02:35 PM Script        : http://www.mysite.com/profile.php?do=updateprofile Referrer      : http://www.mysite.com/profile/edit/ IP Address    : 201.6.82.103 Username      : Fabiano Classname     : vB_Database_MySQLi MySQL Version : 5.1.73
    Already followed this procedure, but the new version of vBET is already disabled this function. What can I do?
    Original text
    Last edited by Marcin Kalak; 25-05-15 at 08:57. Reason: repair bbcode

  2. #2
    Banned
    Join Date
    Aug 2012
    Posts
    481

    Default

    Please describe your problem more accurately. When appears a issue? Do vBET is enabled? Is the table user has a column vbet_def_lang?

  3. #3

    Default

    Text automatically translated from: Portuguese to: English
    Translated text
    Marcin,

    Every time that someone will update the native language in the User Control Panel gives error Database, as described above.

    I also realized that no one is able to register, and gives the error of the Database that states that do not have the column vbet_def_lang.

    In my database there is no column named vbet_def_lang
    Original text

  4. #4
    Banned
    Join Date
    Aug 2012
    Posts
    481

    Default

    Try to do this SQL query (NOTE: add table prefix if you use it before table name):
    Code:
    ALTER TABLE user ADD vbet_def_lang VARCHAR(5)

  5. #5

    Default

    Text automatically translated from: Portuguese to: English
    Translated text
    Thank you very much, it worked******
    Original text

  6. #6
    Banned
    Join Date
    Aug 2012
    Posts
    481

    Default

    I'm glad I could help you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •