Incentive Scripts Community
critical DB error - Printable Version

+- Incentive Scripts Community (http://www.incentivescripts.com/forum)
+-- Forum: General (/forumdisplay.php?fid=1)
+--- Forum: Support (/forumdisplay.php?fid=3)
+--- Thread: critical DB error (/showthread.php?tid=245)

critical DB error - piramida8 - 09-21-2012 02:25 AM

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

RE: critical DB error - admin - 09-21-2012 05:13 AM

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.

RE: critical DB error - piramida8 - 09-25-2012 12:13 PM

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]

RE: critical DB error - admin - 09-28-2012 03:54 PM

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