× Pleas keep in mind that SPAM will be deleted instantly

Error creating Database

  • mike.mikerees.com
  • Offline
More
9 years 6 months ago #3031 by mike.mikerees.com
Error creating Database was created by mike.mikerees.com
when I try to create a new database using an existing table I get

"1054 Unknown column 'name' in 'field list' SQL=INSERT INTO `3qh_joodb` (`name`,`table`,`tpl_list`,`tpl_single`,`tpl_print`,`tpl_form`,`fid`,`ftitle`,`fcontent`,`fabstract`,`fdate`,`published`) VALUES ('cattle','3qh_nadudana_beasts',

Any Advice ?

Please Log in to join the conversation.

More
9 years 6 months ago #3033 by Dirk
Replied by Dirk on topic Error creating Database
Your #__joodb table is corrupt or wrong.
Maybe you imported an excel spreadsheet with joodb as name. Joodb will overwrite its own table.

Compare it with the original table:
DROP TABLE IF EXISTS `ishpd_joodb`;
CREATE TABLE IF NOT EXISTS `ishpd_joodb` (
  `id` int(1) NOT NULL AUTO_INCREMENT,
  `name` varchar(125) NOT NULL,
  `table` varchar(255) NOT NULL,
  `tpl_list` text NOT NULL,
  `tpl_single` text NOT NULL,
  `tpl_print` text,
  `tpl_form` text,
  `fid` varchar(255) NOT NULL,
  `ftitle` varchar(255) NOT NULL,
  `fcontent` varchar(255) NOT NULL,
  `fabstract` varchar(255) DEFAULT NULL,
  `fdate` varchar(255) DEFAULT NULL,
  `fstate` varchar(255) DEFAULT NULL,
  `params` text,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Configuration table for JooDatabase' AUTO_INCREMENT=7 ;

--
-- Dumping data for table `ishpd_joodb`
--

INSERT INTO `ishpd_joodb` (`id`, `name`, `table`, `tpl_list`, `tpl_single`, `tpl_print`, `tpl_form`, `fid`, `ftitle`, `fcontent`, `fabstract`, `fdate`, `fstate`, `params`, `published`, `created`) VALUES
(1, 'My little DB', 'ishpd_joodb_sample', '<table style="width: 100%;">\r\n<tbody>\r\n<tr><!-- Search box -->\r\n<td>\r\n<div style="float: right;">select category {joodb groupselect|category}</div>\r\n{joodb searchbox|title,value,category}</td>\r\n</tr>\r\n<tr>\r\n<td align="center" valign="top">\r\n  <div class="box1">{joodb alphabox}</div></td>\r\n</tr>\r\n<tr>\r\n<td align="center" valign="top">{joodb pagecount}</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<table class="cat" style="width: 100%;" cellspacing="3">\r\n<tbody>\r\n<tr><th style="width: 15%;">{joodb orderlink|value|Value}</th><th>{joodb orderlink|title|Title}</th></tr>\r\n</tbody>\r\n</table>\r\n{joodb loop}\r\n<table class="cat" style="width: 100%;" cellspacing="3">\r\n<tbody>\r\n<tr class="{joodb loopclass}">\r\n<td style="font-weight: bold; text-shadow: 1px 1px 3px #aaa; width: 15%;">{joodb ifis|value}{joodb value} ${joodb endif}</td>\r\n<td style="width: 85%;"><img style="width: 46px; float: left; margin-right: 20px; padding: 10px; background-color: #c0c0c0; border: 1px solid #888;" src="components/com_joodb/sample-images/{joodb picture}" alt="*" />\r\n<div style="float: left; width: 650px;">\r\n<h3>{joodb title}</h3>\r\n<small>{joodb date}</small>\r\n<p>{joodb field|short_description}</p>\r\n<div class="readon">{joodb readon}</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n{joodb loop}\r\n<h3>{joodb nodata}</h3>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td class="alphabox" align="center" valign="top">\r\n  <div class="box1">\r\n  {joodb pagenav}<br />{joodb pagecount}<br />{joodb limitbox}\r\n  </div>\r\n  </td>\r\n</tr>\r\n</tbody>\r\n</table>', '<table class="single">\r\n<tbody>\r\n<tr><th>\r\n<div style="float: right; width: 100px; text-align: right;">{joodb printbutton}</div>\r\n<h2 style="color:#fff;">{joodb title}</h2>\r\n</th></tr>\r\n<tr class="even">\r\n<td><span class="small">Datum: {joodb date}</span> <img style="border: 1px solid #666666; margin: 5px 10px 5px 20px; padding: 10px; background-color: #c0c0c0; float: right; width: 100px;" src="components/com_joodb/sample-images/{joodb picture}" alt="*" />\r\n<p>{joodb description}</p>\r\n</td>\r\n</tr>\r\n<tr class="odd">\r\n<td>\r\n<ul>\r\n<li><strong>Usefull:</strong> {joodb usefull}</li>\r\n{joodb ifis|value}\r\n<li><strong>Value:</strong> {joodb value} $</li>\r\n{joodb endif}{joodb ifnot|value}\r\n<li><strong><span style="color: #d40000;">No Value</span></strong></li>\r\n{joodb endif}\r\n<li><strong>Category: </strong>{joodb category}</li>\r\n<li><a href="{joodb wikipedia}" target="_blank">Wikipedia link</a></li>\r\n</ul>\r\n</td>\r\n</tr>\r\n<tr class="even">\r\n<td>{joodb backbutton}</td>\r\n</tr>\r\n</tbody>\r\n</table>', '<!-- JooDatabase: initial template for new databases  -->\r\n<div style="margin: 10px;">\r\n<table class="single" style="width: 100%;" border="0" cellpadding="5" cellspacing="5">\r\n<tbody>\r\n<tr><th>\r\n<h2>{joodb title}</h2>\r\n</th></tr>\r\n<tr class="even">\r\n<td><span class="small">Datum: {joodb date}</span> <img style="border: 1px solid #444444; margin: 5px 10px 5px 20px; padding: 10px; background-color: #c0c0c0; float: right; width: 100px;" src="components/com_joodb/sample-images/{joodb picture}" alt="*" />\r\n<p>{joodb description}</p>\r\n</td>\r\n</tr>\r\n<tr class="odd">\r\n<td>\r\n<ul>\r\n<li><strong>Usefull:</strong> {joodb usefull}</li>\r\n{joodb ifis|value}\r\n<li><strong>Value:</strong> {joodb value} $</li>\r\n{joodb endif}{joodb ifnot|value}\r\n<li><strong><span style="color: #d40000;">No Value</span></strong></li>\r\n{joodb endif}\r\n<li><strong>Category: </strong>{joodb category}</li>\r\n<li><a href="{joodb wikipedia}" target="_blank">Wikipedia link</a></li>\r\n</ul>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /><br /></div>', '<!-- JooDatabase: initial template for new databases  -->\r\n<table class="contentpaneopen" style="width: 100%;" border="0" cellpadding="0" cellspacing="0">\r\n<tbody>\r\n<tr>\r\n<td><label id="titlemsg" for="title">Name</label><br /> {joodb form|title}<br /> <label id="descriptionmsg" for="description">Description</label><br /> {joodb form|description}<br /> <label id="valuemsg" for="value">Value</label><br /> {joodb form|value}<br /> <label id="usefullmsg" for="usefull">Usefull</label><br /> {joodb form|usefull}<br /> <label id="categorymsg" for="category">Category</label><br /> {joodb form|category}<br /> <label id="datemsg" for="category">Date</label><br /> {joodb form|date}</td>\r\n</tr>\r\n<tr>\r\n<td> </td>\r\n</tr>\r\n<tr>\r\n<td>{joodb captcha}</td>\r\n</tr>\r\n<tr>\r\n<td>{joodb submitbutton}</td>\r\n</tr>\r\n</tbody>\r\n</table>', 'myid', 'title', 'description', 'short_description', 'date', 'state', '{"accessd":"1","accessf":"2","accesse":"1","img_width":"480","img_height":"600","thumb_width":"120","thumb_height":"200","extdb":"","extdb_server":"","extdb_user":"","extdb_pass":""}', 1, '2009-10-27 14:33:52');

Please Log in to join the conversation.

Moderators: Dirkjoest