RevCMS Field List Issue

[Hashh]

Hi so on my RevCMS some pages come up with no images and saying :-


Unknown column 'country' in 'field list'
Table 'retro.profile_wall' doesn't exist


A query to run it would be great ty

 

[AusNGrant]

This code doesn't have the full data and fields needed to make profile_wall work but it will get your cms up for now. If you get any other of these problems post it

ALTER TABLE `users` ADD `country` VARCHAR(999)

DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news`

-- ----------------------------
-- Table structure for profile_wall
-- ----------------------------
DROP TABLE IF EXISTS `profile_wall`;
CREATE TABLE `profile_wall` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

 

[Hashh]

This code doesn't have the full data and fields needed to make profile_wall work but it will get your cms up for now. If you get any other of these problems post it

ALTER TABLE `users` ADD `country` VARCHAR(999)

DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news`

-- ----------------------------
-- Table structure for profile_wall
-- ----------------------------
DROP TABLE IF EXISTS `profile_wall`;
CREATE TABLE `profile_wall` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

Unknown column 'poster_id' in 'field list' also this I tried the top one edited but dont work

 

[iGlenn]

try these instead

ALTER TABLE `users` ADD `country` TEXT;

-- ----------------------------
-- Table structure for profile_wall
-- ----------------------------
DROP TABLE IF EXISTS `profile_wall`;
CREATE TABLE `profile_wall` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL,
  `poster_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `likes` int(11) NOT NULL DEFAULT '0',
  `owner_read` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1354 DEFAULT CHARSET=latin1;

 

[AusNGrant]

Unknown column 'poster_id' in 'field list' also this I tried the top one edited but dont work

***Deleted*** Run glenns second sql, it includes everything needed for that table.

Goodluck

 

[Hashh]

try these instead

ALTER TABLE `users` ADD `country` TEXT;

-- ----------------------------
-- Table structure for profile_wall
-- ----------------------------
DROP TABLE IF EXISTS `profile_wall`;
CREATE TABLE `profile_wall` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL,
  `poster_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `likes` int(11) NOT NULL DEFAULT '0',
  `owner_read` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1354 DEFAULT CHARSET=latin1;

Thank you, someone also help mme out with this :- Table 'retro.cms_housekeeping_logs' doesn't exist

 

[iGlenn]

grab the table?

-- ----------------------------
-- Table structure for `hk_logs`
-- ----------------------------
DROP TABLE IF EXISTS `hk_logs`;
CREATE TABLE `hk_logs` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`who_done` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
AULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

 

[Hashh]

grab the table?

-- ----------------------------
-- Table structure for `hk_logs`
-- ----------------------------
DROP TABLE IF EXISTS `hk_logs`;
CREATE TABLE `hk_logs` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`who_done` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
AULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

Table 'retro.cms_housekeeping_logs' doesn't exist, still comes up

[SQL]
AULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET' at line 1

 

[iGlenn]

rename the table to housekeeping_logs then try

 

[Hashh]

rename the table to housekeeping_logs then try

Getting this error


[SQL]
AULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET' at line 1


It does add it though

 

[iGlenn]

is that after you renamed the table?

 

[Hashh]

is that after you renamed the table?

I dont know I will PM you my teamviewer