XFileSharing Pro - Software erorr in upgrade 1.5 to 1.6

Message
Author
hornet
Posts: 52
Joined: Jul 20, 2008 11:33 pm

Software erorr in upgrade 1.5 to 1.6

#1 Postby hornet » Feb 27, 2010 9:32 pm

Software error:

Can't exec:
Unknown column 'usr_id' in 'IP2Files' 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.

hornet
Posts: 52
Joined: Jul 20, 2008 11:33 pm

#2 Postby hornet » Feb 28, 2010 9:38 am

Where technical support? Does not have a reply in the forum and e-mail

admin
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#3 Postby admin » Mar 01, 2010 6:54 am

show us structure of your IP2Files database.

Also, if your goal is upgrading to 1.7. You can drop your current IP2Files table and create new.

Code: Select all

CREATE TABLE `IP2Files` (
  `file_id` int(10) unsigned NOT NULL default '0',
  `ip` int(20) unsigned NOT NULL default '0',
  `usr_id` mediumint(8) unsigned NOT NULL default '0',
  `owner_id` mediumint(8) unsigned NOT NULL default '0',
  `size` bigint(20) unsigned NOT NULL default '0',
  `referer` varchar(255) NOT NULL default '',
  `points` decimal(5,2) unsigned NOT NULL default '0.00',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`file_id`,`ip`,`usr_id`),
  KEY `owner` (`owner_id`),
  KEY `user` (`usr_id`),
  KEY `ip` (`ip`,`created`),
  KEY `date` (`created`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
This create statement taken from install.sql of 1.7 version

hornet
Posts: 52
Joined: Jul 20, 2008 11:33 pm

#4 Postby hornet » Mar 01, 2010 8:21 am

Thanks
But is this the solution to upgrade from 1.5 to 1.7?

hornet
Posts: 52
Joined: Jul 20, 2008 11:33 pm

#5 Postby hornet » Mar 01, 2010 8:56 am

erorr change to

Software error:

Can't exec:
Duplicate column name 'owner_id' 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.

hornet
Posts: 52
Joined: Jul 20, 2008 11:33 pm

#6 Postby hornet » Mar 01, 2010 9:12 am

When execute the previous query through phpMyAdmin

if i upgrade 1.5 to 1.6
Show Erorr

Code: Select all

Software error:

Can't exec:
Duplicate column name 'owner_id' 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. 
if i upgrade 1.6 to 1.7

Code: Select all

Software error:

Can't exec:
Duplicate key name 'fs_key' 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. 
If I Go To Home Page
Software error:

Can't execute select:
Unknown column 'srv_torrent' in 'where clause' at Modules/DataBase.pm line 72.

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

hornet
Posts: 52
Joined: Jul 20, 2008 11:33 pm

#7 Postby hornet » Mar 01, 2010 9:06 pm

i wait , and i need Radical Solution

User avatar
PilgrimX182
Posts: 2186
Joined: Mar 22, 2006 1:39 pm

#8 Postby PilgrimX182 » Mar 02, 2010 7:58 am

Contact [email protected] with FTP or SSH details - will fix sql upgrade ASAP.
Seems you've done something wrong since we faced no problems with this even when upgrading from 1.1 to 1.7 in multiple steps.