| View previous topic :: View next topic |
| Author |
Message |
hornet
Joined: 20 Jul 2008
Posts: 52
|
 Posted: Feb 27, 2010 9:32 pm Post subject: Software erorr in upgrade 1.5 to 1.6 |
 |
|
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 (webmaster@arab-box.com), giving this error message and the time and date of the error. |
|
| Back to top |
|
 |
hornet
Joined: 20 Jul 2008
Posts: 52
|
| Posted: Feb 28, 2010 9:38 am Post subject: |
|
|
| Where technical support? Does not have a reply in the forum and e-mail |
|
| Back to top |
|
|
admin
Site Admin
Joined: 22 Mar 2006
Posts: 1129
|
| Posted: Mar 01, 2010 6:54 am Post subject: |
|
|
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: |
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 |
|
| Back to top |
|
|
hornet
Joined: 20 Jul 2008
Posts: 52
|
| Posted: Mar 01, 2010 8:21 am Post subject: |
|
|
Thanks
But is this the solution to upgrade from 1.5 to 1.7? |
|
| Back to top |
|
|
hornet
Joined: 20 Jul 2008
Posts: 52
|
| Posted: Mar 01, 2010 8:56 am Post subject: |
|
|
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 (webmaster@arab-box.com), giving this error message and the time and date of the error. |
|
| Back to top |
|
|
hornet
Joined: 20 Jul 2008
Posts: 52
|
| Posted: Mar 01, 2010 9:12 am Post subject: |
|
|
When execute the previous query through phpMyAdmin
if i upgrade 1.5 to 1.6
Show Erorr
| Code: | Software error:
Can't exec:
Duplicate column name 'owner_id' at Modules/DataBase.pm line 55.
For help, please send mail to the webmaster (webmaster@arab-box.com), giving this error message and the time and date of the error. |
if i upgrade 1.6 to 1.7
| Code: | Software error:
Can't exec:
Duplicate key name 'fs_key' at Modules/DataBase.pm line 55.
For help, please send mail to the webmaster (webmaster@arab-box.com), giving this error message and the time and date of the error. |
If I Go To Home Page
| Quote: | 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 (webmaster@arab-box.com), giving this error message and the time and date of the error. |
|
|
| Back to top |
|
|
hornet
Joined: 20 Jul 2008
Posts: 52
|
| Posted: Mar 01, 2010 9:06 pm Post subject: |
|
|
| i wait , and i need Radical Solution |
|
| Back to top |
|
|
PilgrimX182
Joined: 22 Mar 2006
Posts: 2109
Location: UFO Lab
|
| Posted: Mar 02, 2010 7:58 am Post subject: |
|
|
Contact support@sibsoft.net 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. |
|
| Back to top |
|
|
|
Register
Search
Profile
Log in to check your private messages
Log in
