XFileSharing Pro - Problem when Upgrade XFS Pro from 1.6 to 1.7

Message
Author
up70.net
Posts: 4
Joined: Feb 10, 2010 3:36 am

Problem when Upgrade XFS Pro from 1.6 to 1.7

#1 Postby up70.net » Feb 10, 2010 3:52 am

A problem when I work Upgrade XFS Pro from 1.6 to 1.7
Updated by when I do this link shows me this message
http://www.up70.net/cgi-bin/upgrade_16_17.cgi

Code: Select all

Software error:

Can't exec:
Table 'IP2Files' is marked as crashed and should be repaired at Modules/DataBase.pm line 55.

For help, please send mail to the webmaster ([email protected]), giving this error message and the time and date of the error. 

I hope to resolve this problem[/code]
Last edited by up70.net on Feb 10, 2010 6:30 am, edited 2 times in total.

OooLong
Posts: 18
Joined: Feb 10, 2010 2:33 am

#2 Postby OooLong » Feb 10, 2010 4:09 am

It mean table IP2iles is crashed you need to repair using PhpMyadmin or similar MySql administration software.

up70.net
Posts: 4
Joined: Feb 10, 2010 3:36 am

#3 Postby up70.net » Feb 10, 2010 6:23 am

I hope to resolve this problem

PowerChaos
Posts: 521
Joined: Dec 19, 2009 5:12 pm

#4 Postby PowerChaos » Feb 10, 2010 11:13 am

well , the best way to repair it is using navicat (navicat rules :D )

download navicat (use the light version if you dont find a pro version)

then be sure to disable the firewall , and on cpanel use whm to enable remote acces for root account

how to do it ??

well , go to whm (2086) and login as root
go to phpmyadmin (click that link)
then go to mysql table (there stands a database called mysql)

go to users
and by root you see this text

Code: Select all

localhost
change that to

Code: Select all

%
now you still cant acces it because you dont have the root pass of mysql (its a random generated password o.O)

so go to the button in whm that says , change mysql root pass

click it , fill in your nice pass and restart mysql (press that button)

now in meantime you downloaded navicat
open navicat and click new host
add your ip to it with those parameters

Code: Select all

ip = your host
username = root
password = your fresh password
if that is done and succesfull then you can see your complete database from all your users

then open your table of your user account (your user upload with table XFS for example)

so open upload_XFS

then select everything with the shift key
press right click
press repair
press extended repair

you see a popup with a progress bar and a lot of info that says what tables are corrupt and what are fine

normal if the damage isnt to bad then it repairs invalid tables

if that is done , upgrade again and lets do the mysql security again

repead above steps of how you gain conection and change it back to localhost

press reset mysql pass and your done

mysql is repaired on the easy way and your db is back secure

Greets From PowerChaos

up70.net
Posts: 4
Joined: Feb 10, 2010 3:36 am

#5 Postby up70.net » Feb 11, 2010 1:32 am

The same problem
I hope a simple and easy solution to the problem

PowerChaos
Posts: 521
Joined: Dec 19, 2009 5:12 pm

#6 Postby PowerChaos » Feb 11, 2010 1:58 am

well, there is 1 realy simple solution

but you dont going like it :S

the solution is to use a new database and a fresh install

i dont know how els we can fix it :s it is just a corrupt table by 1 of other way :S

Greets From PowerChaos

up70.net
Posts: 4
Joined: Feb 10, 2010 3:36 am

#7 Postby up70.net » Feb 23, 2010 5:31 pm

up up up up