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.
XFileSharing Pro - Software erorr in upgrade 1.5 to 1.6
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.
This create statement taken from install.sql of 1.7 version
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;
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.
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.
When execute the previous query through phpMyAdmin
if i upgrade 1.5 to 1.6
Show Erorr
if i upgrade 1.6 to 1.7
If I Go To Home Page
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.
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.
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.
- PilgrimX182
- Posts: 2186
- Joined: Mar 22, 2006 1:39 pm
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.
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.