Fehlermeldung phoca guestbook

Submitted by abakus on 28. September 2009 - 18:15

Liebe Forumteilnehmer,

nach der "erfolgreichen Installation" des phoca guestbooks erhalte ich folgende Meldung:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\mtakuja\libraries\joomla\database\database\mysql.php on line 344

Wer kann mir behilflich sein?
 

‹ User Login OHNE Login-Modul suche Plugin für HTML-Editor (Template) mit Syntax highlight ›
»

Fehlermeldung Phoca Guestbook

Submitted by itcs on 29. September 2009 - 17:26.

Hallo,

der Fehlermeldung nach, tippe ich auf einen Fehler in der DB hin. Prüfe doch mal, ob beide Tabellen für das Gästebuch richtig angelegt sind:

Tabelle 1

 CREATE TABLE IF NOT EXISTS `jos_phocaguestbook_books` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `image` varchar(255) NOT NULL default '',
  `section` varchar(50) NOT NULL default '',
  `image_position` varchar(30) NOT NULL default '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `editor` varchar(50) default NULL,
  `ordering` int(11) NOT NULL default '0',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `count` int(11) NOT NULL default '0',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `cat_idx` (`section`,`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

Tabelle 2

CREATE TABLE IF NOT EXISTS `jos_phocaguestbook_items` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `userid` int(11) NOT NULL default '0',
  `email` varchar(50) NOT NULL default '',
  `homesite` varchar(50) NOT NULL default '',
  `ip` varchar(20) NOT NULL default '',
  `title` varchar(200) NOT NULL default '',
  `content` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL default '0',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `published` (`published`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;