Announcement

Collapse
No announcement yet.

Database error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error

    Hello, I liked your product and had it installed previously, unfortunately due to and error in an upgrade of vBulletin which has been fixed,
    I cannot upgrade or un-install vBTube 4.0.5 using product-ytm_4.0.5.xml other mods do install without any problems.
    Any help on this issue would be appreciated, pls look at the database errors below.
    1. Can you help me with a method to remove this product from my Installed Products list or
    2. Help me with a way to install this product fully.

    thanks for any help
    Stefanus


    Database error in vBulletin 4.2.5: on install:

    Invalid SQL:
    UPDATE usergroup SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Administrators',
    `description` = '',
    `usertitle` = '<img src="https://www.mysite.com/forum/images/title/Admin.gif" alt="Admin" />',
    `opentag` = '',
    .........
    `downloaddelaygrp` = '0',
    `ytm` = '63'
    WHERE usergroupid=6; (WEIRD, Usergroup doing the install is either 1 or 3, never 6)

    MySQL Error : Unknown column 'ytm' in 'field list'
    Error Number : 1054
    Request Date : Tuesday, December 18th 2018 @ 11:54:57 PM
    Error Date : Tuesday, December 18th 2018 @ 11:54:57 PM
    Script : http://www.mysite.com/forum/admincp/....php?do=update
    Referrer : https://www.mysite.com/forum/admincp...&usergroupid=6
    IP Address : 82.8.186.230
    Username : Stefanus
    Classname : vB_Database_MySQLi
    MySQL Version : 10.0.37-MariaDB-1~jessie
    Server : 213.xxx.xxx.xxx
    User Agent :

    Stack Trace:

    #0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
    #1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 446
    #2 vB_Database->query_write() called in [path]/admincp/usergroup.php on line 358


    Database error in vBulletin 4.2.5: on un-install:

    Invalid SQL:
    ALTER TABLE usergroup DROP ytm;

    MySQL Error : Can't DROP 'ytm'; check that column/key exists
    Error Number : 1091
    Request Date : Wednesday, December 19th 2018 @ 02:44:40 AM
    Error Date : Wednesday, December 19th 2018 @ 02:44:40 AM
    Script : http://www.mysite.com/forum/admincp/...do=productkill
    Referrer : https://www.mysite.com/forum/admincp...oductid=ytm&s=
    IP Address : 82.8.186.230
    Username : Stefanus
    Classname : vB_Database_MySQLi
    MySQL Version : 10.0.37-MariaDB-1~jessie
    Server : 213.133.104.116
    User Agent :


    Stack Trace:

    #0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
    #1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 446
    #2 vB_Database->query_write() called in [path]/admincp/plugin.php(1562) : eval()'d code on line 1
    #3 eval() called in [path]/admincp/plugin.php on line 1562

  • #2
    In usergroup table there should be a column ytm

    It's not there. Try to add it manually. Get the code from the xml

    Comment


    • #3
      Thanks, colum created, product un-installed and installed, this time without any problems.

      Comment

      Working...
      X