|
Page 4 of 4
|
 spirit22 
Joined: April 2013
Posts: 51
|
 Re: Problem Update To 2.0 Version
Please try running the suggested SQL insert query 
I Insert all that code here?
And wath table have I select?
|
#46 Sat 27 Apr, 2013 21:24 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location:  Earth, Europe, the Netherlands, Rotterdam
|
Re: Problem Update To 2.0 Version
You should be on the SQL tab, just like the previous Query, I can't reach my own phpmyadmin to compare and I don't read spannish (especially when it's text in an image  )
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)  
|
#47 Sat 27 Apr, 2013 21:38 |
|
spirit22
Joined: April 2013
Posts: 51
|
Re: Problem Update To 2.0 Version
Don't work.
|
#48 Sat 27 Apr, 2013 22:17 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
Re: Problem Update To 2.0 Version
That query in your last image is not the query in the image..
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
|
#49 Sat 27 Apr, 2013 22:46 |
|
spirit22
Joined: April 2013
Posts: 51
|
Re: Problem Update To 2.0 Version
|
#50 Sat 27 Apr, 2013 23:03 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
Re: Problem Update To 2.0 Version
Well since we are making a mess already ... try running this
DROP TABLE `ip_3sessions`;
CREATE TABLE `ip_3sessions` (
`session_id` VARCHAR(32) NOT NULL DEFAULT '',
`session_user_id` MEDIUMINT(8) NOT NULL DEFAULT '0',
`session_start` INT(11) NOT NULL DEFAULT '0',
`session_time` INT(11) NOT NULL DEFAULT '0',
`session_ip` VARCHAR(40) NOT NULL DEFAULT '0',
`session_browser` VARCHAR(255) DEFAULT '' NOT NULL,
`session_page` VARCHAR(255) NOT NULL DEFAULT '',
`session_logged_in` TINYINT(1) NOT NULL DEFAULT '0',
`session_forum_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
`session_topic_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
`session_last_visit` INT(11) UNSIGNED DEFAULT '0' NOT NULL,
`session_forwarded_for` VARCHAR(255) DEFAULT '' NOT NULL,
`session_viewonline` TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL,
`session_autologin` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL,
`session_admin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`session_id`),
KEY `session_user_id` (`session_user_id`),
KEY `session_fid` (`session_forum_id`)
);
DROP TABLE `ip_3sessions_keys`;
CREATE TABLE `ip_3sessions_keys` (
`key_id` VARCHAR(32) NOT NULL DEFAULT '0',
`user_id` MEDIUMINT(8) NOT NULL DEFAULT '0',
`last_ip` VARCHAR(40) NOT NULL DEFAULT '',
`last_login` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`key_id`,`user_id`),
KEY `last_login` (`last_login`)
);
## `ip_3sessions_keys`
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
|
#51 Sat 27 Apr, 2013 23:45 |
|
spirit22
Joined: April 2013
Posts: 51
|
Re: Problem Update To 2.0 Version
The query work without problems, but now I get this page after trying 20 times because it always appeared ?Resurce limit is reached:
EDIT: It seems that it works. if not for the problem of limit reached... I think my hosting has blocked access because in my cpanel say: Entry Processes 20 / 20 (in red).
Thanks Joshua203.
|
#52 Sat 27 Apr, 2013 23:58 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
Re: Problem Update To 2.0 Version
Well I would ask your hosting support first about the resource usage, eventhough a few could have been quering the DB to wrong info (creating resourse usage).
You should do some of the repairs mentioned in the last (by you) screenshot BTW.
If it is too late... these tools are also in ACP>>DB tools etc etc
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
|
#53 Sun 28 Apr, 2013 00:19 |
|
spirit22
Joined: April 2013
Posts: 51
|
Re: Problem Update To 2.0 Version
My cpanel show this error:
I think the error of 'Resource Limit Is Reached' is problem of my hosting. 20 times I try to go to my website just go one.
I'll talk to my hosting support. Thanks again
|
#54 Sun 28 Apr, 2013 00:35 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
Re: Problem Update To 2.0 Version
first try the ACP db tools ..just don't reset anything
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
|
#55 Sun 28 Apr, 2013 00:44 |
|
spirit22
Joined: April 2013
Posts: 51
|
Re: Problem Update To 2.0 Version
Is normal this?
Edit: I block that ip from cpanel, and now my web work fine
Problems solved, thanks guys 
Last edited by spirit22 on Sun 28 Apr, 2013 14:55; edited 1 time in total |
#56 Sun 28 Apr, 2013 03:39 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
Re: Problem Update To 2.0 Version
Is normal this?
No that looks like someone in Spain really missed your site alot or he's trying to do a "solo ddos attack".
You're welcome Spirit, it's not perfect yet but at least you have a workable situation now (personally I would start from scratch though)
PS..
If your thread is solved, please use the Title Edit button (right bottom of your page)
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
|
#57 Sun 28 Apr, 2013 12:04 |
|
|
|
Page 4 of 4
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
|
|
|
|
