Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 4 of 4
Goto page Previous  1, 2, 3, 4
 
Reply with quote Download Post 
Post 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?

 insertquery1


And wath table have I select?
 



 
spirit22Send private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Problem Update To 2.0 Version 
 
Don't work.


 phpmyadmin1
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Problem Update To 2.0 Version 
 
That query in your last image is not the query in the image..
install4
 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Problem Update To 2.0 Version 
 
insertquery2



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?
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Problem Update To 2.0 Version 
 
Well since we are making a mess already ... try running this

Code: [Download] [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`

 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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:

 insertquery3



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.
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Problem Update To 2.0 Version 
 
My cpanel show this error:

 acp_1367101867_967613

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.


 web1


I'll talk to my hosting support. Thanks again
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Problem Update To 2.0 Version 
 
Is normal this?


 web2



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 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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)
 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 4 of 4
Goto page Previous  1, 2, 3, 4


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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


  

 

  cron