| View previous topic :: View next topic |
| Author |
Message |
up70.net
Joined: 10 Feb 2010
Posts: 4
|
 Posted: Feb 10, 2010 3:52 am Post subject: Problem when Upgrade XFS Pro from 1.6 to 1.7 |
 |
|
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: | 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 (webmaster@up70.net), 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 |
|
| Back to top |
|
 |
OooLong
Joined: 10 Feb 2010
Posts: 3
|
| Posted: Feb 10, 2010 4:09 am Post subject: |
|
|
| It mean table IP2iles is crashed you need to repair using PhpMyadmin or similar MySql administration software. |
|
| Back to top |
|
|
up70.net
Joined: 10 Feb 2010
Posts: 4
|
| Posted: Feb 10, 2010 6:23 am Post subject: |
|
|
| I hope to resolve this problem |
|
| Back to top |
|
|
PowerChaos
Joined: 19 Dec 2009
Posts: 404
Location: belguim
|
| Posted: Feb 10, 2010 11:13 am Post subject: |
|
|
well , the best way to repair it is using navicat (navicat rules  )
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
change that to
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: |
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 |
|
| Back to top |
|
|
up70.net
Joined: 10 Feb 2010
Posts: 4
|
| Posted: Feb 11, 2010 1:32 am Post subject: |
|
|
The same problem
I hope a simple and easy solution to the problem |
|
| Back to top |
|
|
PowerChaos
Joined: 19 Dec 2009
Posts: 404
Location: belguim
|
| Posted: Feb 11, 2010 1:58 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
up70.net
Joined: 10 Feb 2010
Posts: 4
|
| Posted: Feb 23, 2010 5:31 pm Post subject: |
|
|
| up up up up |
|
| Back to top |
|
|
|
Register
Search
Profile
Log in to check your private messages
Log in
