MySQL Issue

[mindrei]

So I installed the CORE CMS and everything was going good but when I logged in and configured everything I got all this:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mariusin/public_html/corething/core/admin/functions/show_statistics.php on line 27

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mariusin/public_html/corething/core/admin/functions/show_statistics.php on line 28

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mariusin/public_html/corething/core/admin/functions/show_statistics.php on line 29

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mariusin/public_html/corething/core/admin/functions/show_statistics.php on line 31

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mariusin/public_html/corething/core/admin/functions/show_statistics.php on line 39
—Database

Connection to database server is working


anyone have any Idea why?

[mindrei]

nevermind, fixed by running this in my PHP admin.

# Dump of table core_entries
# ------------------------------------------------------------

CREATE TABLE `core_entries` (
  `entry_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_position` int(11) NOT NULL DEFAULT '0',
  `entry_date` date NOT NULL DEFAULT '0000-00-00',
  `entry_title` varchar(255) NOT NULL DEFAULT '',
  `entry_text` text NOT NULL,
  `entry_client` varchar(255) NOT NULL DEFAULT '',
  `entry_extra1` text NOT NULL,
  `entry_extra2` text NOT NULL,
  `entry_new` smallint(6) NOT NULL DEFAULT '1',
  `entry_show` smallint(6) NOT NULL DEFAULT '1',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`entry_id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;



# Dump of table core_entry2tag
# ------------------------------------------------------------

CREATE TABLE `core_entry2tag` (
  `entry_id` int(10) unsigned NOT NULL DEFAULT '0',
  `tag_id` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table core_pages
# ------------------------------------------------------------

CREATE TABLE `core_pages` (
  `page_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `page_title` varchar(255) NOT NULL DEFAULT '',
  `page_url` varchar(30) NOT NULL DEFAULT '',
  `page_position` smallint(5) unsigned NOT NULL DEFAULT '0',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`page_id`),
  UNIQUE KEY `page_title` (`page_title`,`page_url`,`page_position`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;



# Dump of table core_tags
# ------------------------------------------------------------

CREATE TABLE `core_tags` (
  `tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tag_text` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `tag_position` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tag_id`),
  UNIQUE KEY `tag_text` (`tag_text`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

[ev4n]

This helped me too - thank you!