Announcement

Collapse
No announcement yet.

problem in threadviews please help

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

  • Trevor Hannant
    replied
    Code:
    CREATE TABLE threadviews (
     threadid INT UNSIGNED NOT NULL DEFAULT '0',
     KEY threadid (threadid)
    You could try the above but I haven't tested this to ensure it works OK. If your tables have a prefix then remember to add that in there also...

    Leave a comment:


  • Mofareq
    replied
    Originally posted by Trevster View Post
    Firstly I wouldn't use AdminCP to backup as it can produce only partial backups depending on the size of the table/database. See here for more information on better methods of backing up:

    http://www.vbulletin.com/docs/html/m...atabase_backup

    As far as best way to go - you could use either method really. Emptying will leave the table and it's structure intact whereas dropping the table and recreating will give you much the same result - IF you use the right query to set it up again.
    thanks very much

    put haw can i create this table after drop it ??

    Leave a comment:


  • Trevor Hannant
    replied
    Firstly I wouldn't use AdminCP to backup as it can produce only partial backups depending on the size of the table/database. See here for more information on better methods of backing up:

    http://www.vbulletin.com/docs/html/m...atabase_backup

    As far as best way to go - you could use either method really. Emptying will leave the table and it's structure intact whereas dropping the table and recreating will give you much the same result - IF you use the right query to set it up again.

    Leave a comment:


  • Mofareq
    replied
    Originally posted by Trevster View Post
    What are you using to backup? And if you want to drop and recreate the table, would you not be better simply emptying it?
    i useing admincp to backup and i want correctly solution of this erorr drop or empty

    what is the correctly solution ??

    thanks .

    Leave a comment:


  • Trevor Hannant
    replied
    What are you using to backup? And if you want to drop and recreate the table, would you not be better simply emptying it?

    Leave a comment:


  • Mofareq
    replied
    no any help :d

    Leave a comment:


  • Mofareq
    started a topic problem in threadviews please help

    problem in threadviews please help

    hi all

    i have problem when me try to take backup

    Database error in vBulletin 3.8.0:

    Invalid SQL:
    SHOW CREATE TABLE threadviews;

    MySQL Error : Got error 130 from storage engine
    Error Number : 1030
    Request Date : Monday, March 23rd 2009 @ 09:54:29 AM
    Error Date : Monday, March 23rd 2009 @ 09:58:05 AM
    Script : http://forums.tarae3o.com/admincp/backup.php?do=sqlfile
    Referrer : http://forums.tarae3o.com/admincp/backup.php?do=choose
    IP Address : 41.178.138.23
    Username :
    Classname : vB_Database
    MySQL Version : 4.1.22-standard

    ----

    TABLE threadviews in phpmyadmin ... in use

    i want to drob threadviews and recreat it

    my version 3.8.0 ..
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X