Hello There, Guest! Register

Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
critical DB error
09-21-2012, 02:25 AM (This post was last modified: 09-21-2012 02:26 AM by piramida8.)
Post: #1
critical DB error
After i try to install new version , when i go to login , this show me :

Critical DB Error!
Date: [21-09-2012 05:24:28]
MySQL Error: [Unknown column 'proxy_check_pending_count' in 'field list']
Query: [/home/.../ClixScript_PHP_DOCS/login.php]
File: [/home/.../ClixScript_PHP_DOCS/classes/class.router.php]
Line: [95]

Any idea what i do wrong?

Best Regards
Find all posts by this user
Quote this message in a reply
09-21-2012, 05:13 AM (This post was last modified: 09-24-2012 09:44 AM by admin.)
Post: #2
RE: critical DB error
Hello,

Please open php my admin, copy/paste and run these queries one by one:

Code:
ALTER TABLE `tb_users` ADD `proxy_check_pending_count` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The higher count, the more failed (skipped proxy tets)' AFTER `login_count`

Code:
ALTER TABLE `tb_users` ADD `proxy_check_detected_count` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Total number of times that a proxy has been detected' AFTER `proxy_check_pending_count`

Code:
CREATE TABLE IF NOT EXISTS `proxy_detector_adv` (
                  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                  `username` varchar(15) NOT NULL COMMENT 'Username of user detected of proxy use',
                  `user_ip` varchar(15) NOT NULL COMMENT 'IP used at the time',
                  `user_agent` text NOT NULL COMMENT 'Full user agent',
                  `detected_by` varchar(255) NOT NULL COMMENT 'What detected user? Tor, mxpulse, header etc..',
                  `user_cc` char(2) NOT NULL COMMENT 'Country Code',
                  `header` text NOT NULL COMMENT 'Header info',
                  `datetime` datetime NOT NULL,
                  PRIMARY KEY (`id`)
                ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1

Code:
ALTER TABLE `tb_users` ADD `login_token` VARCHAR( 255 ) NOT NULL COMMENT 'Login Token (used by remember me), if empty, user may only login using login..'

Code:
ALTER TABLE `tb_users` ADD INDEX (`login_token`)
[/quote]

This should solve your problems, if not, let me know.
Find all posts by this user
Quote this message in a reply
09-25-2012, 12:13 PM
Post: #3
RE: critical DB error
THX i fixed, but now i finde 1 more problem:

The new problem are:
Critical DB Error!
Date: [25-09-2012 15:11:06]
MySQL Error: [Table 'gptclick_gpt.blocked_countries' doesn't exist]
Query: [SELECT * FROM blocked_countries WHERE country_code = 'HR']
File: [/home/gptclick/ClixScript_PHP_DOCS/register.php]
Line: [15]
Find all posts by this user
Quote this message in a reply
09-28-2012, 03:54 PM
Post: #4
RE: critical DB error
Code:
CREATE TABLE IF NOT EXISTS `blocked_countries` (
                          `country_code` char(2) NOT NULL COMMENT 'Country Code',
                          `date_blocked` datetime NOT NULL COMMENT 'Date when this block was added',
                          PRIMARY KEY (`country_code`)
                        ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

run this one too
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 3 Guest(s)