Icy Phoenix

Old Support Topics - [SOLVED] Problem Update To 2.0 Version

spirit22 [ Sat 27 Apr, 2013 21:24 ]
Post subject: Re: Problem Update To 2.0 Version

Joshua203 wrote: [View Post]
Please try running the suggested SQL insert query

I Insert all that code here?

And wath table have I select?

Joshua203 [ Sat 27 Apr, 2013 21:38 ]
Post subject: 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

)

spirit22 [ Sat 27 Apr, 2013 22:17 ]
Post subject: Re: Problem Update To 2.0 Version

Don't work.

Joshua203 [ Sat 27 Apr, 2013 22:46 ]
Post subject: Re: Problem Update To 2.0 Version

That query in your last image is not the query in the image..

spirit22 [ Sat 27 Apr, 2013 23:03 ]
Post subject: Re: Problem Update To 2.0 Version

EDIT: I fin this:

http://www.icyphoenix.com/viewtopic.php?f=35&t=8580&p=55952

http://www.icyphoenix.com/viewtopic.php?p=52262#p52262

It's the same error?

Joshua203 [ Sat 27 Apr, 2013 23:45 ]
Post subject: Re: Problem Update To 2.0 Version

Well since we are making a mess already ... try running this

Code: [Hide] [Select]

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`

spirit22 [ Sat 27 Apr, 2013 23:58 ]
Post subject: 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.

Joshua203 [ Sun 28 Apr, 2013 00:19 ]
Post subject: 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

spirit22 [ Sun 28 Apr, 2013 00:35 ]
Post subject: 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

Joshua203 [ Sun 28 Apr, 2013 00:44 ]
Post subject: Re: Problem Update To 2.0 Version

first try the acp db tools ..just don't reset anything

spirit22 [ Sun 28 Apr, 2013 03:39 ]
Post subject: 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

Joshua203 [ Sun 28 Apr, 2013 12:04 ]
Post subject: Re: Problem Update To 2.0 Version

spirit22 wrote: [View Post]
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)