RevCMS Field List Issue

Hashh

adam
Apr 17, 2015
799
169
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

Member
Jun 21, 2015
74
9
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

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

Code:
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;
 
Last edited:

Hashh

adam
Apr 17, 2015
799
169
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

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

Code:
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

:)
Jul 21, 2015
618
92
try these instead
Code:
ALTER TABLE `users` ADD `country` TEXT;
Code:
-- ----------------------------
-- 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;
 

Hashh

adam
Apr 17, 2015
799
169
try these instead
Code:
ALTER TABLE `users` ADD `country` TEXT;
Code:
-- ----------------------------
-- 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

:)
Jul 21, 2015
618
92
grab the table?
Code:
-- ----------------------------
-- 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

adam
Apr 17, 2015
799
169
grab the table?
Code:
-- ----------------------------
-- 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
 

Hashh

adam
Apr 17, 2015
799
169
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
 

Users who are viewing this thread

Top