blog documentation FAQ followers forum marketplace services youtube

solved CRI: Query Error: Table db-name.jr_jrcore_log' doesn't exist

The Jamroom Network » Forum » Installation and Configuration » Page » CRI: Query Error: Table db-name.jr_jrcore_log' doesn't exist
soaringeagle
@soaringeagle
9 years ago
3,304 posts
ive been fixing errors for 3 days trying to get sites moved to new server
this errors whats left

CRI: Query Error: Table 'db-name.jr_jrcore_log' doesn't exist
cant find it in db with
mysqldump db-name db-name.jr_jrcore_log | gzip > db-name.jr_jrcore_log.sql.gz
i get
mysqldump: Couldn't find table: "db-name.jr_jrcore_log"




--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
updated by @soaringeagle: 08/22/16 11:41:08AM
brian
@brian
9 years ago
10,148 posts
The jr_jrcore_log table is a "core" table - if you are seeing that not being installed, then the core is either not installed or you did not transfer all the tables.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
9 years ago
3,304 posts
I've done it a few times still tryin another way


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
9 years ago
3,304 posts
would it not dump that table if its real busy like can't get a lock on it


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
brian
@brian
9 years ago
10,148 posts
Here's the table create statement for that table:
CREATE TABLE `jr_jrcore_log` (
  `log_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `log_created` int(11) unsigned NOT NULL DEFAULT '0',
  `log_priority` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'inf',
  `log_ip` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `log_text` varchar(4096) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`log_id`),
  KEY `log_priority` (`log_priority`)
) ENGINE=MyISAM AUTO_INCREMENT=3026 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
9 years ago
10,148 posts
soaringeagle:
would it not dump that table if its real busy like can't get a lock on it

Unless you're using --lock-tables on your mysqldump command line I don't believe they are locked - you can always try --lock-tables=false.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Tags