FreePgs.com Forum
September 22, 2021, 05:08:21 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: LVCS.NET offers low cost domain registration services.
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: database deletation  (Read 5591 times)
Dans34
Verified Account
Jr. Member
*

Karma: +0/-0
Offline Offline

Posts: 35

Blog entries (3)

View Profile
« on: April 20, 2006, 11:33:27 AM »

hi,

is there a problem with mysql  , i was on my forum i refreshed the page and it says
Quote
mySQL error: 1146
Table 'trionite_forum.mybb_users' doesn't exist
Query: SELECT u.*, f.*, COUNT(pms.pmid) AS pms_total, SUM(IF(pms.dateline>u.lastvisit AND pms.folder='1','1','0')) AS pms_new, SUM(IF(pms.status='0' AND pms.folder='1','1','0')) AS pms_unread, b.dateline AS bandate, b.lifted AS banlifted, b.oldgroup AS banoldgroup FROM mybb_users u LEFT JOIN mybb_privatemessages pms ON (pms.uid=u.uid) LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_banned b ON (b.uid=u.uid) WHERE u.uid='1' GROUP BY u.uid

its like the table has just been deleted  (also i didnt have a backup , do freepgs.com have a backup i could use ?)
Logged
Dans34
Verified Account
Jr. Member
*

Karma: +0/-0
Offline Offline

Posts: 35

Blog entries (3)

View Profile
« Reply #1 on: April 20, 2006, 12:29:10 PM »

my website url is freepgs.com/dans34

the affected forum  url is freepgs.com/dans34/trionite/forum
Logged
FreePgs.com Forum
« Reply #1 on: April 20, 2006, 12:29:10 PM »

 Logged
admin
Administrator
Hero Member
*****

Karma: +30/-2
Offline Offline

Posts: 1567

Blog entries (0)

View Profile
« Reply #2 on: April 20, 2006, 12:59:57 PM »

Please try to repair the table via phpMyAdmin (and/or check if the table exists there).
Logged
Dans34
Verified Account
Jr. Member
*

Karma: +0/-0
Offline Offline

Posts: 35

Blog entries (3)

View Profile
« Reply #3 on: April 20, 2006, 01:33:35 PM »

the table is missing from the database

how do i repair the table ?
Logged
FreePgs.com Forum
« Reply #3 on: April 20, 2006, 01:33:35 PM »

 Logged
webzone (archived)
Official Technical Support
Verified Account
Hero Member
*

Karma: +0/-0
Offline Offline

Posts: 508

Archived Account

Blog entries (0)

View Profile
« Reply #4 on: April 20, 2006, 06:25:13 PM »

Quote
the table is missing from the database

how do i repair the table ?

You can't repair a missing table. You need to restore it from a backup, if you have any.
Logged
Dans34
Verified Account
Jr. Member
*

Karma: +0/-0
Offline Offline

Posts: 35

Blog entries (3)

View Profile
« Reply #5 on: April 21, 2006, 03:30:16 AM »

thats the problem , i dont

do you know why a table just went missing ?
Logged
sixthcrusifix
Sage
Verified Account
Sr. Member
*

Karma: +0/-3
Offline Offline

Posts: 445


http://sixthcrusifix.com/home/

Blog entries (0)

View Profile WWW
« Reply #6 on: April 21, 2006, 07:21:29 AM »

thats the problem , i dont

do you know why a table just went missing ?

best I can say is, crap happens. you must have a basic back up didn't you install forum software?
Logged

Visite me website at http://www.sixthcrusifix.com
Dans34
Verified Account
Jr. Member
*

Karma: +0/-0
Offline Offline

Posts: 35

Blog entries (3)

View Profile
« Reply #7 on: April 21, 2006, 07:31:47 AM »

i have a backup of the forum  files but not the mysql

but it dosnt matter now as i have reinstalled anyway

thanks for all your help
Logged
admin
Administrator
Hero Member
*****

Karma: +30/-2
Offline Offline

Posts: 1567

Blog entries (0)

View Profile
« Reply #8 on: April 23, 2006, 02:39:10 AM »

Login to phpMyAdmin, see if the table is listed but has crashed.

If you see the table, click the checkbox and select "Repair Table" option and click "Go"

If you do not see the table listed, you must restore it as the other user had suggested.  Be sure your forum software is using the correct prefix for the tables that exist in your database.

Thank you,
FreePgs.com Admin
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!