Software erorr in upgrade 1.5 to 1.6

Powerfull XFileSharing version

Moderator: admin

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

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
Contact:

#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: 1784
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
Contact:

#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
Contact:

#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
Contact:

#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
Contact:

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

i wait , and i need Radical Solution

User avatar
PilgrimX182
Posts: 2181
Joined: Mar 22, 2006 1:39 pm
Location: UFO Lab
Contact:

#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.


Return to “XFileSharing Pro”

Who is online

Users browsing this forum: No registered users and 0 guests