Hello There, Guest! Register

Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DB Error in referring tools and forum
10-07-2012, 01:10 PM (This post was last modified: 10-07-2012 01:20 PM by piramida8.)
Post: #1
DB Error in referring tools and forum
1. problem
Critical DB Error!
Date: [07-10-2012 16:01:07]
MySQL Error: [Table '..._gpt.ref_banners' doesn't exist]
Query: [/home/.../ClixScript_PHP_DOCS/members/referring_tools.php]
File: [/home/.../ClixScript_PHP_DOCS/classes/class.router.php]
Line: [95]

2. problem
In Forum:
Critical DB Error!
Date: [07-10-2012 16:18:27]
MySQL Error: [Unknown column 'u.clix_forum_signature' in 'field list']
File: [/home/gptclick/ClixScript_PHP_DOCS/classes/class.paginate.php]
Line: [237]
Find all posts by this user
Quote this message in a reply
10-07-2012, 07:21 PM
Post: #2
RE: DB Error in referring tools and forum
i have the same errors after updating.
Find all posts by this user
Quote this message in a reply
10-08-2012, 05:39 AM (This post was last modified: 10-08-2012 10:57 AM by admin.)
Post: #3
RE: DB Error in referring tools and forum
ONLY FOLLOW THESE INSTRUCTIONS IF YOU HAVE RAN upgrade.php TO UPGRADE! If you have not ran upgrade.php, then do it, and your issues will go away.

ref banner issue is solved by running this query in phpmyadmin:
Code:
CREATE TABLE IF NOT EXISTS `ref_banners` (
                          `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Banner ID',
                          `name` varchar(255) NOT NULL COMMENT 'Banner Name e.g Skyscraper 720x600, Leaderboard, Full Banner, Square etc',
                          `alt_title` varchar(255) NOT NULL COMMENT 'The alt attribute in img tag (text displayed when hovering banner)',
                          `ext` varchar(6) NOT NULL COMMENT 'File extension, e.g jpg,png,gif.',
                          `banner_url` text NOT NULL COMMENT 'If empty, it will open banner from folder. Use banner url to specify dynamic banner or external.',
                          `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1 = Active and displayed in referral tools page, 0 = Inactive (hidden from referral tools page, but visible in admin)',
                          PRIMARY KEY (`id`),
                          KEY `status` (`status`)
                        ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
and this one:
Code:
INSERT INTO `ref_banners` (`name` ,`alt_title` ,`ext` ,`banner_url` ,`status`) VALUES
                ('Full Banner (468x60) - Dynamic', '', '', '%HOST%b?i=%USER_ID%', '1'),
                ('Full Banner (468x60) - Animated', '', 'gif', '', '1');

for the signature problem, run:
Code:
INSERT INTO `configs` (`name` ,`type` ,`value` ,`comment`) VALUES
                            ('show_signature', 'clix_forum', '1', NULL),
                            ('signature_max_length', 'clix_forum', '300', NULL),
                            ('signature_max_lines', 'clix_forum', '8', NULL),
                            ('signature_bbcode', 'clix_forum', '1', NULL);
and
Code:
ALTER TABLE `tb_users` ADD `clix_forum_signature` TEXT NOT NULL COMMENT 'Forum signature BBCode'
and
Code:
ALTER TABLE `clix_forum_moderators` ADD `suspend_users_site` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1 = Allowed to suspend user from the entire site, 0 = Not allowed'
and
Code:
ALTER TABLE `clix_forum_moderators` ADD `edit_others_signature` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1 = Allowed to edit others signature, 0 = Not allowed'
Find all posts by this user
Quote this message in a reply
10-08-2012, 10:47 AM
Post: #4
RE: DB Error in referring tools and forum
I insert and it work

Thx

(10-08-2012 05:39 AM)admin Wrote:  []ONLY FOLLOW THESE INSTRUCTIONS IF YOU HAVE RUNNED upgrade.php to upgrade! [/b]If you did not run upgrade.php, do it, and issues will go away.

ref banner issue is solved by running this query in phpmyadmin:
Code:
CREATE TABLE IF NOT EXISTS `ref_banners` (
                          `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Banner ID',
                          `name` varchar(255) NOT NULL COMMENT 'Banner Name e.g Skyscraper 720x600, Leaderboard, Full Banner, Square etc',
                          `alt_title` varchar(255) NOT NULL COMMENT 'The alt attribute in img tag (text displayed when hovering banner)',
                          `ext` varchar(6) NOT NULL COMMENT 'File extension, e.g jpg,png,gif.',
                          `banner_url` text NOT NULL COMMENT 'If empty, it will open banner from folder. Use banner url to specify dynamic banner or external.',
                          `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1 = Active and displayed in referral tools page, 0 = Inactive (hidden from referral tools page, but visible in admin)',
                          PRIMARY KEY (`id`),
                          KEY `status` (`status`)
                        ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
and this one:
Code:
INSERT INTO `ref_banners` (`name` ,`alt_title` ,`ext` ,`banner_url` ,`status`) VALUES
                ('Full Banner (468x60) - Dynamic', '', '', '%HOST%b?i=%USER_ID%', '1'),
                ('Full Banner (468x60) - Animated', '', 'gif', '', '1');

for the signature problem, run:
Code:
INSERT INTO `configs` (`name` ,`type` ,`value` ,`comment`) VALUES
                            ('show_signature', 'clix_forum', '1', NULL),
                            ('signature_max_length', 'clix_forum', '300', NULL),
                            ('signature_max_lines', 'clix_forum', '8', NULL),
                            ('signature_bbcode', 'clix_forum', '1', NULL);
and
Code:
ALTER TABLE `tb_users` ADD `clix_forum_signature` TEXT NOT NULL COMMENT 'Forum signature BBCode'
and
Code:
ALTER TABLE `clix_forum_moderators` ADD `suspend_users_site` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1 = Allowed to suspend user from the entire site, 0 = Not allowed'
and
Code:
ALTER TABLE `clix_forum_moderators` ADD `edit_others_signature` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1 = Allowed to edit others signature, 0 = Not allowed'
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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